Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux

Error: When creating an Oracle database in Windows operating system: ORA-12546 TNS: permission denied ORA-12560 TNS protocol adpater error ORA-516 Permission denied From SQL * …

  Single Node Architecture: when we talk about Sybase IQ architecture , We should explain about the Three important IQ stores and three main files. which …

  Replication: Replication is a way of copying and distributing data and database objects from master to slave servers. These databases are synchronized to maintain …

  In a Master/Slave replication data consistency is a biggest concern and is very easy  to break your replication with  issues such as duplicate keys, missing …

– Requirements This topic assumes that you have user with sudo privileges and have MySQL installed on both server(Master & Slave). If you do not …

  Fragmentation on MongoDB databases When we removing a large amount of data from the collection and no plan to replace it, we generate a …

It will display current running processes: [crayon-67400791141a2115896307/]   It will display processes which is running by “dbmaint” user id: [crayon-67400791141a6747818451/]   It will display databases …

  It is the era of Data. Nobody would dare to disagree. People may have different opinion about the storage solutions and architecture, but no …

  Introduction : –  pg_rewind is a tool for synchronizing a PostgreSQL cluster with another copy of the same cluster, after the clusters’ timelines have diverged. …

  The following article is about the installation of MySQL Server on Linux Machine(RHEL) using RPM Packages. 1) Login to the OS using the root …