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

What is PostGIS in PostgreSQL? It would not be wrong to say that PostGIS is an open source software program that supports geometrical features for …

In this article, we will install PostgreSQL 12 On Centos 8. We choose the versions we will install by going to the link below. https://www.postgresql.org/download/linux/redhat/ …

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-67418729050a8056264077/] 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 …