In this post, we will see how we can upgrade the Pluggable database of Oracle 12c Release 1 to Oracle 12c Release 2.

Source Version
Upgrade Version
Pluggable Database Name PDB

Step 1: Check the version of the pluggable database

Step 2: Check pdb name using show pdbs command

Step 3: Run pre-upgrade script

Step 4: Login to pdb and run the preupgrade_fixup script

Note: As I am upgrading pdb using migrating pdb to empty container I need to remove apex from Source pdb .

Step 3 : Check after removing apex is there any invalid component exists

Step 4 : Compile them using utlrp.sql

Step 5 : Close pdb

Step 6 : Unplug pdb

Step 7 : Connect to an empty container of 12.2

Step 8 : Check the pluggable database

Step 9 : Open pdb in upgrade mode

Step 10 : Run catupgrd.sql

Step 11 : Monitor catupgrd.sql

Step 12 : Open pdb in normal mode

Step 13 : Check pdb state with show pdbs command

Thank you for giving your valuable time to read the above information.

If you want to be updated with all our articles send us an Invitation or Follow us:

Telegram Channel:

Skant Gupta’s LinkedIn:

Joel Perez’s LinkedIn: Joel Perez’s Profile

LinkedIn Group: Oracle Cloud DBAAS

Facebook Page: OracleHelp

About The Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.