While changing the password of internal oracle users in oracle 12c , after it got expired, you may get error as below.   ORA-600:[kpdbModAdminPasswdInRoot: Not CDB] SQL> connect system/oracle ERROR: ORA-28001: the password has expired Changing password for system New password: Retype […]

             While running datapatch tool in Oracle 12c, as part of post patching got ORA-20013 error. Use below steps to solve the issue. Problem: cd /oracle/app/oracle/product/12.1.0.2/dbhome_1/OPatch ./datapatch -verbose SQL Patching tool version 12.2.0.0.0 on Thu Feb 25 11:02:17 2016 Copyright (c) 2014, Oracle. All rights reserved. Connecting to database…OK catcon: […]

                  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 21555660_hxuz.zip cd 21555660 Steps 2 : check the conflict against ORACLE_HOME   cd 21555660 $ORACLE_HOME/OPatch/opatch prereq […]

           You can use this script to check tablespace space details in 12c Multitenant database. It will provide information of both root CDB and PDB. SET LINES 132 PAGES 100 COL con_name FORM A15 HEAD “Container|Name” COL tablespace_name FORM A15 COL fsm FORM 999,999,999,999 HEAD “Free|Space Meg.” COL apm FORM 999,999,999,999 […]

                         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 […]

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 […]

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 ) SQL> show pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ———- —————————— ———- ———- 2 PDB$SEED READ ONLY NO 3 ORCL READ WRITE NO 5 PROD_MN […]

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: SQL> show parameter enable_ddl_logging NAME TYPE VALUE ———————————— ———– —————————— enable_ddl_logging boolean FALSE SQL> […]

We can easily rename a pluggable database. Follow below steps. Start the PDB with restrict mode SQL> alter session set container=PROD_CL; Session altered. SQL> shutdown immediate; Pluggable Database closed. SQL> startup open restrict Pluggable Database opened. Rename the pdb SQL> alter pluggable database PROD_CL rename global_name to PROD_MN; Pluggable database altered. SQL> show con_name; CON_NAME […]

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. SQL> select name,open_mode from v$pdbs; NAME OPEN_MODE —————————— ———- PDB$SEED READ ONLY ORCL READ WRITE PROD READ WRITE SQL> alter session set container=PROD; […]