Oracle database version is recently released.  I searched the database software for Solaris platform, Found it in oracle edelivery.




I downloaded the software from edelivery and did an installation and upgrade on a  test box.


Upgrade database from 11g to 12cR1 using manual method

Upgrade database from 11g to 12cR1 Using  DBUA method:

Upgrade database from 11g to 12cR1 from OEM 12c cloud control:

Here we will first Install  12.2. ORACLE_HOME and then upgrade the database TESTDB ( which is on version)  to



12cr2_1 12cr2_2 12cr2_3 12cr2_4 12cr2_5 12cr2_6 12cr2_7 12cr2_8 12cr2_9 12cr2_10 12cr2_11

NEW ORACLE_HOME – /oracle/app/oracle/product/

Now we will proceed with upgrade activity:


CURRENT ORACLE_HOME – /oracle/app/oracle/product/12.1.0/dbhome_1

NEW ORACLE_HOME – /oracle/app/oracle/product/


1. Run the preupgrade tool

Preupgrade tool is available under new $ORACLE_HOME/rdbms/admin.

ls -ltr /oracle/app/oracle/product/


$OLD_ORACLE_HOME/jdk/bin/java -jar $NEW_ORACLE_HOME/rdbms/admin/preupgrade.jar -FILE DIR $OS_DIRECTORY

Run the preupgrade_fixups.sql file.

Please take necessary again if any issues reported by the precheck script.

2. List down invalid objects present

3. Make sure source db in archivelog mode.

4. Enable flashback mode, to enable restore in case of any failure during upgrade.

5. Set environment variables to NEW ORACLE_HOME(12.2)

export ORACLE_HOME=/oracle/app/oracle/product/

6. Run DBUA



12cr2_12 12cr2_13


This screen has been changed, compare to previous dbua in

1. No option to control upgrade parallelism, DBUA pickup parallelism , according to system resource

2. No option to control utlrp.sql compliation parallelism thread.


Select FLASHBACK OPTION, It will create a guaranteed restore point.

12cr2_15 12cr2_16 12cr2_17 12cr2_18 12cr2_19


We  have a  PAUSE button here.  Let’s click and see if we can resume it later or not.


Message shows, Executions will pause after Database Components Upgrade is completed. I.e PAUSE will not stop the upgrade process instantly, It will wait for the current phase to complete.


So upgrade continued  until the Database components Upgrade completed.

You can monitor the upgrade log at below location.




As soon as database upgrade component completed upgrade  stopped due to PAUSE button we have used. Click on Continue to resume the upgrade .
12cr2_23 12cr2_24 12cr2_25 12cr2_26

Upgrade has been completed successfully.



1. Run postupgrade_fixups.sql script

2. Check the latest timezone version:

3. Check the component status:

4. Run the post upgrade validation script:

5. Upgrade tables depends on oracle maintained Type.

If above query returns any rows and run the below script.

6. Disable flashback and drop the restore point;

If there is no plan to rollback the upgrade, then disable flashback and drop restore point:

Now database is ready for use.

NOTE: Currently full version of oracle 12.2. is available in oracle support. 

ORACLE 12CR2 New features:

Conver non-partitioned table to partitioned table online using simple alter command:

Datapump new features in oracle 12cR2 release