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

12cr12

 

 

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

SEE ALSO:

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 12.1.0.2 version)  to 12.2.0.1

INSTALLATION STEPS:

 

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/12.2.0.1/dbhome-1

Now we will proceed with upgrade activity:

DBNAME  – TESTDB

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

NEW ORACLE_HOME – /oracle/app/oracle/product/12.2.0.1/dbhome-1

PRE-UPGRADE STEPS:

1. Run the preupgrade tool

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

ls -ltr /oracle/app/oracle/product/12.2.0.1/dbhome-1/rdbms/admin/preupgrade.jar

SYNTAX

$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/12.2.0.1/dbhome-1
export PATH=$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib

6. Run DBUA

cd $ORACLE_HOME/bin

./dbua

12cr2_12 12cr2_13

 

This screen has been changed, compare to previous dbua in 12.1.0.2.

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

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

12cr2_14

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.
12cr2_20

 

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.
12cr2_21

 

So upgrade continued  until the Database components Upgrade completed.

You can monitor the upgrade log at below location.

 

12cr2_22

 

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.

 

POST UPGRADE :

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