ORA-20013: DBMS_QOPATCH ran mostly in non install area

             While running datapatch tool in Oracle 12c, as part of post patching got ORA-20013 error. Use below steps to solve the issue. Problem:

  Solution: Check the patching related directories from dba_directories.  

  Check the ORACLE_HOME : echo $ORACLE_HOME /oracle/app/oracle/product/ We can see that directories are […]

How to apply JVM patch in oracle 12c database

                  Below are the steps for applying JVM patch in oracle 12c database.   Steps 1 : Download the respective patch from oracle support  and unzip it in the server. unzip cd 21555660 Steps 2 : check the conflict against ORACLE_HOME  

  Step 3: […]

Tablespace monitoring in oracle 12c multitenant database.

           You can use this script to check tablespace space details in 12c Multitenant database. It will provide information of both root CDB and PDB.


Oracle 12c multitenant architecture

                         The most prominent feature of oracle 12c is its multitenant feature. We can use oracle 12c as normal database as that of previous version. But if you want to use multitenant, you need to have separate license for this.   So, if you […]

How to unplug and plug in pluggable database in oracle 12c

We can unplug the pluggable database from existing CDB and Plug it in a different CDB or in the same CDB, depending upon the required. While plugging you can keep the pdb name same as before or can give a different name. DEMO: Here i will unplug ORCL pdb and then plug it into the […]

Rman backup in multitenant database oracle 12c

With multitenant feature introduced in oracle 12c, New commands are there for taking rman backup of pluggable database and root container database. Backup of complete container( ROOT + ALL PDBS )

Taking backup of particular pluggable database:(backup pluggable database ORCL;)

Backup of only root container:

Backup of tablespace of pluggable database(by connecting […]

ENABLE_DDL_LOGGING in oracle 12c

This  ENABLE_DDL_LOGGING parameter has been introduced in oracle 12c. If this ENABLE_DDL_LOGGING is enabled,then DDL records are written to the ADR. All DDL operations like alter/create/drop/truncate objects. Only drop user will be logged, But create user will not be. Enable the parameter:

Do some DDL operations:

    Check the log:   cd /u02/app/oracle/diag/rdbms/cdborcl/cdborcl/log/ddl […]

How to rename a pluggable database ( PDB)

We can easily rename a pluggable database. Follow below steps. Start the PDB with restrict mode

Rename the pdb

Restart the PDB

How to clone a pluggable database for existing PDB

In this article we will clone a pluggable database from existing PDB ( PROD), residing on the same container. First start the PDB in read only , which need to be cloned.

Connect to the container and clone the pluggable:

Now make the existing PDB ( PROD) from read only to read write: […]

How to create a pluggable database in oracle 12c

We can create a pluggable database in an existing multitenant database either using dbca or manually. Here we will show how to do it manually.   STEPS: Connect to the container database:(ROOT)  

While creating PDB if you don’t mention FILE_NAME_CONVERT paramter then below error will come

Create PDB:(correct command)

Page 5 of 6« First...23456
Skip to toolbar