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

You may want to read the following articles about replication before reading this article. “How To Install PostgreSQL Replication By using archive_command On Centos“, “How …

First of all, we must install PostgreSQL on Primary Server and perform initdb operations. You can find out how to do this in the article …

What is pgBackRest pgBackRest is a backup/restore tool in postgresql. PostgreSQL Backup Types In Postgresql, we create backups in two ways: logical and physical. Logical …

If you have created and enabled a new service and then created a pluggable database, you may receive this error if you want to switch …

We can reset the ILOM SP of compute nodes and cell nodes as follows: You can connect to the Ilom IP via ssh and run …

Connect to Root Container The connection to the root container is the same as connecting to the database instance in previous versions. Connection can be …

Suppose that we created a table in the database by following the normalization rules for our application. However, we realized that the data type of …

Disk scrubbing exists on Exadata cell nodes to automatically repair the failed sector of the disk when the system is idle without compromising system performance. …

You may receive this error when there are multiple IPs on the same server that use the same port. In this case, you cannot run …

In some cases, sessions are blocked in databases. There are many reasons for blocking. In this article, I will not go into details of this …