Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux
When querying the status of the configuration from broker, errors like below were seen. Warning: ORA-16664: unable to receive the result from a database [crayon-5f6d28bc01795031856605/] Standby databases also receive connection …
Read More »
PL/SQL Tutorial
This article is a PL/SQL Tutorial. You can find almost everything for beginners in one article about PL/SQL. In addition to this article, you may want to read below articles …
Read More »
How to Install PostGIS in PostgreSQL 12
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 object relational database. We use …
Read More »
How To Install PostgreSQL12 On Centos 8
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/ Let’s do these steps by …
Read More »
RFS[18]: Assigned to RFS process
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 2015 RFS[18]: Assigned to RFS …
Read More »
ORA-16198: LGWR received timedout error from KSR
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 (16198) LGWR: Destination LOG_ARCHIVE_DEST_2 network …
Read More »
REPMGR INSTALLATION AND CONFIGURATION FOR POSTGRESQL
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 others are our standbys Machine …
Read More »
How To Use Grafana with Prometheus
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 use grafana with prometheus. I …
Read More »
How to Drop Database in Oracle 19c and Uninstall the Oracle 19C Binaries in Windows Os
This article contains information about dropping database in Oracle 19c and unistalling Oracle 19C binaries in Windows. STEP1 : Connect As SYSDBA [crayon-5f6d28bc03fa6702396106/] STEP 2: Shut Down The Database [crayon-5f6d28bc03fab732654275/] …
Read More »
Oracle Snapshot Standby Database
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 Convert Physical Standby to Snapshot …
Read More »