This error occurs due to problems during the upgrade process of databases from 11g to 12c. If the Upgrade is not completed and 11g continues …
Read More »ORACLE
ORA-12911: permanent tablespace cannot be temporary tablespace
After upgrading to 12.2 databases, the temporary temp tablespace of some users is set to SYSTEM due to bug number 23715518. In this case, when …
Read More »What is Archivelog Mode in Oracle and How Do I Enable and Disable Archivelog Mode
What is Archivelog Mode in Oracle? The following operations cannot be performed until archive log mode is enabled. RMAN Online Backup Flashback Database User Managed …
Read More »Read Oracle alert log From SQL
It is possible to query the contents of the alertSID.log file in Oracle databases, such as a table in the database. To do this, you …
Read More »Oracle Data Guard Architecture
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 …
Read More »ORA-39143: dump file may be an original export dump file
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-676c60231936e536304997/] …
Read More »ORACLE 19C NEW FEATURES AND HOW TO APPLY THEM
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 …
Read More »Pluggable Database Creation Methods and Tools
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 …
Read More »Oracle Net Services
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 »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 »