Saturday, November 21, 2020

How To Rename A Pluggable Database (PDB) in Oracle EBS R122 with 19c Database

Go through the following steps to rename the Pluggable Database (PDB) in Oracle EBS R122 with 19c database.

Here I am changing PDB name from "TESTHYD1" to "TESTBAN1".

Connect to the CDB and check the information about the PDB:

SQL> select name, open_mode, restricted from v$pdbs;

NAME       OPEN_MODE       RES
---------- --------------- ---
PDB$SEED   READ ONLY       NO
TESTHYD1   READ WRITE      NO

SQL> 

Close the PDB and check the status:

SQL> alter pluggable database "TESTHYD1" close;                

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO        
         3 TESTHYD1                       MOUNTED              
SQL>  

Unplug the "TESTHYD1" PDB database and Drop it:

SQL> alter pluggable database "TESTHYD1" unplug into '/u01/HYDSER01/19.0.0/dbs/TESTHYD1_unplug.xml';

Pluggable database altered.

SQL>
SQL> drop pluggable database "TESTHYD1";

Pluggable database dropped.

SQL> 

Create pluggable database using the <DBSID>_unplug.xml file

SQL> create pluggable database "TESTBAN1" using '/u01/HYDSER01/19.0.0/dbs/TESTHYD1_unplug.xml' NOCOPY SERVICE_NAME_CONVERT=('ebs_TESTHYD1','ebs_TESTBAN1','TESTHYD1_ebs_patch','TESTBAN1_ebs_patch');

Pluggable database created.

SQL>

Open "TESTBAN1" pluggable database in read write mode:

SQL> alter pluggable database "TESTBAN1" open read write;

Pluggable database altered.

SQL> 

Startup the PDB and save its state by executing the following commands

SQL> alter pluggable database all open;

Pluggable database altered.

SQL> alter pluggable database all save state instances=all;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME                       OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
         2 PDB$SEED                       READ ONLY  NO
         4 TESTBAN1                       READ WRITE NO
SQL> 

Note: The PDB should be renamed only using the above approach to retain the case of the PDB name in E-Business Suite.

That's it, hope this article will help you.

Thank you!!


Some Oracle EBS with database 19c based articles:

Oracle EBS R12 with Database 19c - Administration

UTL_FILE_DIR Desupported with Oracle Database 19c

Upgrade Oracle 11g/12c Database to 19c with EBS R12.1/R12.2

Oracle Database 19c Installation on Oracle Linux 7 (OL7)

Some Oracle RAC and ASM based articles:











Some Most Popular Articles