ORACLE

Oracle Data Guard has a simple and easy operation logic. Moves the redo data in the primary database to the Standby database and applies the …

When importing with Data Pump, errors occur as follows due to the creation of the relevant dump file with the traditional export (exp) command. [crayon-67429cc9241eb957164289/] …

Automatically Run Configuration Scripts Before 19c in the oracle database software installation requires manual effort to run the root.sh scripts. But from 19c we can …

There are various methods and different tools for creating a pluggable database within a container database (CDB). The methods and tools to create a pluggable …

Introducing Oracle Net Services Oracle Net services are often used to enable network connections for applications or different clients to connect to databases. Allows connection …

Before 12c if one of the standby database goes out of sync with respect to the primary database we have to perform the below steps …

What is a Multitenant Database? As of version 12.1, you can design your databases as a multitenant database (CDB). It consists of a container database, …

When the Exadata database is upgraded to version 12.2, “gc cr request” and “gc buffer busy acquire” wait events occur in many operations in the …

During the index rebuild process, if some of the blocks belonging to the index are on a corrupted datafile, you receive the error “ORA-08102: index …

Due to an unknown situation in Oracle 11g databases, “ORA-00600: internal error code, arguments: [qcsprfro_tree: jrs present]” error is received during refresh of some materialized …