Upgrade to Database 12.2 c

https://docs.oracle.com/database/122/UPGRD/upgrade-scenarios-non-cdb-oracle-databases.htm#UPGRD-GUID-D6F6D375-B021-47E0-B0C8-B2C0B191AC0D
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
http://www.oracle.com/technetwork/database/enterprise-edition/downloads/oracle12c-linux-12201-3608234.html

2.) Install the new Oracle Home with 12.2

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

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

4.) set the variables to 12.2 Oracle Home
ORACLE_SID
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:
/home/oracle/logs/upg_summary.log

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

13.) Start the instance

sqlplus / as sysdba
startup

14.) @utlu122s.sql

15.) @utlrp.sql

Advertisements

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s