Upgrade PDB 12.1 to 12.2 PDB(Pluggable database)

Source Version - 12.1.0.2.0 
Upgrade Version - 12.2.0.1.0 
Pluggable Database Name - PDB 

Steps:

1.Check the version of the pluggable database

2.Check pdb name using show pdbs command

3.Run pre-upgrade script

[oracle@localhost ~]$ /u01/oracle/product/12.1.0/db_1/jdk/bin/java -jar /u01/oracle/product/12.2.0/db_1/rdbms/admin/preupgrade.jar FILE DIR /u01/upgrade

Preupgrade generated files:

    /u01/upgrade/preupgrade.log

    /u01/upgrade/preupgrade_fixups.sql

    /u01/upgrade/postupgrade_fixups.sql

[oracle@localhost ~]$

4.Login to pdb and run the preupgrade_fixup script

SQL> @/u01/upgrade/preupgrade_fixups_PDB.sql

Executing Oracle PRE-Upgrade Fixup Script

Auto-Generated by:       Oracle Preupgrade Script

                         Version: 12.2.0.1.0 Build: 1

Generated on:            2018-08-29 07:33:31

For Source Database:     CDB1

Source Database Version: 12.1.0.2.0

For Upgrade to Version:  12.2.0.1.0

Executing in container:  PDB

                          Fixup

Check Name                Status  Further DBA Action

----------                ------  ------------------

dictionary_stats          Passed  None

apex_upgrade_msg          Failed  Manual fixup recommended.

PL/SQL procedure successfully completed.

5.run preupgrade_fixups_PDB.sql

SQL> @/u01/upgrade/preupgrade_fixups_PDB.sql

Executing Oracle PRE-Upgrade Fixup Script

Auto-Generated by:       Oracle Preupgrade Script

                         Version: 12.2.0.1.0 Build: 1

Generated on:            2018-08-29 07:33:31

 

For Source Database:     CDB1

Source Database Version: 12.1.0.2.0

For Upgrade to Version:  12.2.0.1.0

 

Executing in container:  PDB

                           Fixup

Check Name                Status  Further DBA Action

----------                ------  ------------------

dictionary_stats          Passed  None

apex_upgrade_msg          Failed  Manual fixup recommended.

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

6.Remove apex 

cd $ORACLE_HOME/apex

SQL> spool apexremove

SQL> @apxremov_con.sql

7.Check after removing apex is there any invalid component exists

SQL> select COMP_ID, STATUS from DBA_REGISTRY where COMP_ID='APEX';

Compile them using utlrp.sql

SQL> @?/rdbms/admin/utlrp.sql

8.Close pdb

SQL> alter pluggable database pdb close immediate;

9.Unplug pdb

SQL> alter pluggable database pdb unplug into '/u02/pdb_121.xml';

10.Connect to an empty container of 12.2 and create pdb using xml file

SQL> CREATE PLUGGABLE DATABASE PDB USING '/u02/pdb_121.xml';

11.Check the pluggable database

SQL> show pdbs

    CON_ID CON_NAME OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED   READ ONLY  NO

3 PDB   MOUNTED

12.Open pdb in upgrade mode

SQL>alter pluggable database pdb open upgrade;

13.Run catupgrd.sql

[oracle@localhost admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl -c 'PDB' catupgrd.sql

14.Monitor catupgrd.sql

15.Open pdb in normal mode and Check pdb state 

SQL> alter pluggable database pdb open;

SQL> show pdbs

    CON_ID CON_NAME   OPEN MODE  RESTRICTED

---------- ------------------------------ ---------- ----------

2 PDB$SEED   READ ONLY  NO

3 PDB   READ WRITE NO