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 …
Read More »ORACLE
RECOVER DATBASE USING SERVICE (Refresh standby database in Oracle 12c)
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 …
Read More »Multitenant Database in Oracle
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, …
Read More »“library cache lock, gc cr request and gc buffer busy acquire” Wait Events After Upgrade to Oracle 12.2
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 …
Read More »ORA-08102: index key not found
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 …
Read More »ORA-00600: internal error code, arguments: [qcsprfro_tree:jrs present]
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 …
Read More »How To Convert A Non-Partitioned Table To Partitioned Table Online in Oracle Using DBMS_REDEFINITION
With the DBMS_REDEFINITION package in the Oracle database, it is possible to modify the structure of the tables online. We can convert a non-partitioned table …
Read More »SQL Profiles and Baselines
Being a DBA we must know the difference between the SQL profile and the baselines. To start with we know that optimizer uses the information …
Read More »Oratab Configuration for RAC Databases
What is Oratab Oracle creates a record for each Oracle RAC database in the oratab configuration file. The oratab file is created by the root.sh …
Read More »ORA-00205: error in identifying control file
If there is a difference with the db_name parameter when opening the Oracle database, you receive an error as follows. “ORA-00205: error in identifying control …
Read More »