Database Tutorials MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux 
Today we learn what Protection Mode Data Guard are and how to Change them. Data Guard protection modes are briefly described in the table below. …
Read More »
ORACLE
Client Connect
In today’s article, I will explain how the Clients are Automatically Connected to the New Primary in Role Changes(SINGLE NODE). In case of Switchover or …
Read More »
Oracle Cloud Database As A Service
In today’s article, we will create an Instance for Oracle Database 18C, which provides automatic recovery and automatic performance without any outside intervention. “Oracle Database”, …
Read More »
RMAN 06059 Expected Archived Log Not Found
Error Received: RMAN-06059: expected archived log not found, loss of archived log compromises recoverability ORA-19625: error identifying file /backup/archive/1_543823_156765345.arc ORA-27037: unable to obtain file status …
Read More »
Failover From Broker
In order to make Failover from the broker, we need to set the Listener and TNS settings correctly. Listener and TNS files of a SINGLE …
Read More »
Weblogic Server Is Too Slow
In Oracle Weblogic, sometimes our services open slower than expected, even if it is opened, the “7001/console” screen makes us wait. I did a little …
Read More »
Change The Server’s IP In The RAC Database
The IP change procedure in a database that works as a RAC and is then downloaded to a single node due to the necessity of …
Read More »
Innovation For ASMCA With Oracle Database 18c
ASM Configuration Assistant (ASMCA), which helps for Oracle disk configuration, is a tool we use to manage Oracle ASM management,disk groups and the volumes attached …
Read More »
Unable to contact any configured publishers. This is likely a network configuration problem. Framework error: code: 6 reason: Couldn’t resolve host ‘pkg.oracle.com’ URL: ‘http://pkg.oracle.com/solaris/release’ (happened 4 times)
I will share the solution of the following error during the installing package on Solaris 11. Error : root@testdb:~# pkg install pkg://system/dtrace pkg: 0/1 catalogs …
Read More »
Delayed Application of Redos on the Standby Side
It may not be required to apply Redos to the Standby side immediately. In this case, the DelayMins in the Broker and the Delay parameter …
Read More »