Upgrade to Database 12.2 c

Complete Checklist for Manual Upgrades to Non-CDB Oracle Database 12c Release 2 (12.2) (Doc ID 2173141.1)

NOTE: Please check your backups before start the upgrade procedure.
NOTE: This is a lab environment, if you are going to upgrade the production database, 
      please follow all steps in the Official documents above.

1.) Download Database Release 12.2

2.) Install the new Oracle Home with 12.2

3.) Set the variables to 12.1 Oracle Home and execute :

- create a init.ora "create pfile=initCheck.ora from spfile;"
- purge dba_recyclebin;

4.) set the variables to 12.2 Oracle Home

5.) Copy the password file and the initCheck.ora to the new ORACLE_HOME/dbs

6.) Rename the initCheck.ora to init<DBNAME>.ora

7.) Check the parameters to see if something needs to be changed

8.) sqlplus / as sysdba

9.) startup upgrade

10.) exit;

11.) cd $ORACLE_HOME/bin

Starting with Oracle Database 12c release 2 (12.2), you can run the Parallel Upgrade Utility 
as a command-line shell command by using the dbupgrade shell command

12.) Run the Parallel Upgrade Utility (catctl.pl) script, 
using the upgrade options that you require for your upgrade.

./dbupgrade -l /home/oracle/logs

When the process finish you should receive a message like below

Phases [0-115]         End Time:[2017_03_23 19:42:12]

Grand Total Time: 3360s

 LOG FILES: (/home/oracle/logs/catupgrd*.log)

Upgrade Summary Report Located in:

Grand Total Upgrade Time:    [0d:0h:56m:0s]

13.) Start the instance

sqlplus / as sysdba

14.) @utlu122s.sql

15.) @utlrp.sql

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s