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

The following errors were seen in the ALERTLOG file of the STANDBY Database if the PRODUCTION Database suddenly shuts down. (STANDBYDB) Mon Dec 21 17:53:29 …

Redo Transport to the standby has stopped after the ORA-16198 error. ERROR ORA-16198: LGWR received timedout error from KSR LGWR: Attempting destination LOG_ARCHIVE_DEST_2 network reconnect …

We will perform REPMGR installation and configuration for postgresql in this article. You can see our environments. pg is our primary postgresql cluster and the …

In this article, we will build our own monitoring systems and build a structure to monitor all your systems on an open-source infrastructure. We will …

This article contains information about dropping database in Oracle 19c and unistalling Oracle 19C binaries in Windows. STEP1 : Connect As SYSDBA [crayon-676b98861894a482633858/] STEP 2: …

You can find the below informations about Snapshot Standby Database in this article. What is Oracle Snapshot Standby Database? Convert Physical Standby to Snapshot Standby …

What is Read Only Tables in Oracle? It is possible to use read only tables in Oracle databases starting from 11.1. You can not update …

When trying to send an e-mail with the UTL_MAIL package, the error “ORA-06502: PL / SQL: numeric or value error” is received when the smtp_out_server …

Far SYNC is a feature introduced with 12c. It is the dummy instance that sends the Redos from the Primary Database to other Standby Databases …

This article contains information about Oracle Database Authentication Methods such as External Authentication, Database Authentication, Operation System Authentication, Global Authentication. Oracle Database Authentication Methods EXTERNAL …