Posted in 2017

12.2 SE2 Upgrade

Hi all,

after long time I am finally back with something very interresting.

Upgrade to 12c(12.1 /12.2) through RMAN Duplicate using BACKUP LOCATION with NOOPEN clause (Doc ID 2022820.1)

If you check this note, you get a pretty simple upgrade scenario. The funny thing is, as described here or in the docs, it simply does not work. with -l or -n it simply failed.

oracle@orcl [ ORCL ] admin]$ $ORACLE_HOME/perl/bin/perl catctl.pl –l /u01/app/oracle/admin/upgrade catupgrd.sql

Argument list for [catctl.pl]
Run in c = 0
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = 0
Child Process I = 0
Log Dir l = 0
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 0
SQL PDB Process Count N = 0
Open Mode Normal o = 0
Start Phase p = 0
End Phase P = 0
Reverse Order r = 0
AutoUpgrade Resume R = 0
Script s = 0
Serial Run S = 0
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0

Invalid command line syntax in the vicinity of '–l' or '/u01/app/oracle/admin/upgrade'. Exiting.

So after being nervous I decided to call it simply from sqlplus, who cares, I can restore the db in 2 Minutes.

 SQL> @catupgrd.sql
DOC>######################################################################
DOC>######################################################################
DOC> ERROR
DOC>
DOC>
DOC> As of 12.2, customers must use the parallel upgrade utility, catctl.pl,
DOC> to invoke catupgrd.sql when upgrading the database dictionary.
DOC> Running catupgrd.sql directly from SQL*Plus is no longer supported.
DOC>
DOC> For Example:
DOC>
DOC> cd $ORACLE_HOME/rdbms/admin
DOC> catctl
DOC>
DOC> or
DOC>
DOC> cd $ORACLE_HOME/rdbms/admin
DOC> $ORACLE_HOME/perl/bin/perl catctl.pl catupgrd.sql
DOC>
DOC> Refer to the Oracle Database Upgrade Guide for more information.
DOC>
DOC>
DOC>######################################################################
DOC>######################################################################
DOC>#

And with the second defined command it works (I haven’t started the first). Interresting is, that the default value 4 was automatically set and the log location is by default $ORACLE_HOME/cfgtoollogs.

Now after waiting some time with these components to be upgraded

Components in [ORCL]
 Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT JAVAVM ORDIM OWM SDO XDB XML XOQ]
Not Installed [DV EM MGW ODM OLS RAC WK]

I am finishing after

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

 

 

Advertisements