Monday, November 6, 2017

Manual Upgrade to 12cR2


Manual Upgrade from 12cR1 to 12cR2

Manual, Command-line Method for Upgrading Oracle Database
Manual upgrades provide benefits and risks.
A manual upgrade consists of running SQL scripts and utilities from a command line to upgrade a database to the new Oracle Database release.
Manual upgrades give you finer control over the upgrade process. However, manual upgrades are susceptible to error when upgrade or pre-upgrade steps either are not followed, or are performed out of order.
Before the Upgrade
  • Analyze the database using the Pre-Upgrade Information Tool.
The Pre-Upgrade Information Tool is a Java JAR file that is supplied with Oracle Database. When you start the tool, it self-extracts, and then executes SQL scripts.
The Pre-Upgrade Information Tool displays warnings about possible upgrade issues with the database, and generates fixup scripts for you to use to address any issues. It also displays information about required initialization parameters for the new release of Oracle Database.
  • Prepare the new Oracle home.
  • Perform a backup of the database.
Depending on the Oracle Database release you upgrade, you can be required to perform more pre-upgrade steps. These steps can include adjusting the parameter file for the upgrade, removing desupported initialization parameters, or adjusting initialization parameters that can cause upgrade problems also upgrade to the latest release of Oracle Database 12c release 2 (12.2) depends on the release number of your current database.

For Oracle Database release earlier than 11.2.0.3, then you cannot directly upgrade your Oracle Database to the latest release. In this case, you are required to upgrade to an intermediate release before upgrading to Oracle Database 12c release 2.

For any multi-step upgrade, if you must carry out two upgrades to upgrade to the current release, then you must run the preupgrade script twice: First, for the intermediate upgrade release, and second, for the target upgrade target release.
For example, if the database from which you are upgrading is running Oracle Database 10g, then follow these steps:
1.    Upgrade release 10.2.0.5 to release 12.1.0.2 using the instructions in Oracle Database Upgrade Guide 12c Release 1 (12.1), including running the pre-upgrade script for 12.1.0.2.

2.    Upgrade Oracle Database 12c release 1 (12.1.0.2) directly to Oracle Database 12c release 2 (12.2.0.1) using the instructions in this book, Oracle Database Upgrade Guide, including running the preupgrade script for 12.2.0.1.

Upgrade Paths for Oracle Database 12c
Current Release
Upgrade Options
12.1.0.1, 12.1.0.2
11.2.0.3 or later
Direct upgrade is supported. 
11.2.0.1, 11.2.0.2
11.1.0.6, 11.1.0.7
10.2.0.2, 10.2.0.3, 10.2.0.4 and 10.2.0.5
10.1.0.5
9.2.0.8 or earlier
Direct upgrade to Oracle Database 12c is not supported.
Solution: Upgrade to an intermediate Oracle Database release that can be directly upgraded to the current release. You must upgrade Oracle Database releases that are not supported for direct upgrade in this release to an intermediate Oracle Database release that is supported for direct upgrade. When upgrading to an intermediate Oracle Database release, follow the instructions in the intermediate release documentation. After you complete an upgrade to the intermediate release Oracle Database, you can upgrade the intermediate release database to the current Oracle Database 12c release.
This restriction does not apply if you use Oracle Data Pump export/import to migrate data to the new release.
For example:
  • If you are upgrading from release 11.2.0.2 or 11.1.0.7, then you must first upgrade to Oracle Database 11grelease 2 (11.2.0.4).
  • If you are upgrading from release 10.2.0.2, 10.2.0.3, 10.2.0.4,10.2.0.5 or 10.1.0.5, then you must first upgrade to release 11.2.0.4 or 12.1.0.2.
  • If you are upgrading from release 9.2.0.8, then you must first upgrade to a sequence of intermediate Oracle Database releases:
Upgrade from release 9.2.0.8 to release 11.2.0.3 or 11.2.0.4. Then upgrade from release 11.2.0.4 to 12.2


Apply below patch for your respective version to avoid SPM issue after upgrade.

Oracle Database SQL Tuning Guide for more information about SQL plan management
·         Document 1948958.1 Patches to Consider for 11.2.0.3 to Avoid Problems with SQL Plan Management (SPM)
·         Document 2034706.1 Patches to Consider for 11.2.0.4 to Avoid Problems with SQL Plan Management (SPM)
·         Document 2035897.1 Patches to Consider When Upgrading From 12.1.0.1 to Avoid Problems with SQL Plan Management (SPM)

Parallel Upgrade Utility (catctl.pl, and the dbupgrade script) enable you to upgrade simultaneously components that do not require upgrades to occur in a specific order.

Parallel Upgrade Utility, catctl.pl is introduced in 12cR1 and requiring you to run it from Perl.  But for dbupgrade we can directly run into shell.

PRE-UPGRADE STEPS:


Run the preupgrade tool

[oracle@vm217 ~]$ ls -l /u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/preupgrade.jar
-rw-r--r-- 1 oracle oinstall 547766 Oct 26  2017 /u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/preupgrade.jar


[oracle@vm217 ~]$ . oraenv
ORACLE_SID = [oracle] ? PROD
The Oracle base has been set to /u01/app/oracle


[oracle@vm217 ~]$ /u01/app/oracle/product/12.1.0.2/DB_1/jdk/bin/java -jar /u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/preupgrade.jar FILE DIR /tmp/
Preupgrade generated files:
    /tmp/preupgrade.log
    /tmp/preupgrade_fixups.sql
    /tmp/postupgrade_fixups.sql

Review the preupgraded generated logs as above and fixed as per recommendations.


[oracle@vm217 ~]$ more /tmp/preupgrade.log

Report generated by Oracle Database Pre-Upgrade Information Tool Version
12.2.0.1.0

Upgrade-To version: 12.2.0.1.0

=======================================
Status of the database prior to upgrade
=======================================

      Database Name:  PROD
     Container Name:  CDB$ROOT
       Container ID:  1
            Version:  12.1.0.2.0
         Compatible:  12.1.0.2.0
          Blocksize:  8192
           Platform:  Linux x86 64-bit
      Timezone File:  18
  Database log mode:  NOARCHIVELOG
           Readonly:  FALSE
            Edition:  EE

  Oracle Component                       Upgrade Action    Current Status
  ----------------                       --------------    --------------
  Oracle Server                          [to be upgraded]  VALID
  JServer JAVA Virtual Machine           [to be upgraded]  VALID
  Oracle XDK for Java                    [to be upgraded]  VALID
  Real Application Clusters              [to be upgraded]  OPTION OFF
  Oracle Workspace Manager               [to be upgraded]  VALID
  OLAP Analytic Workspace                [to be upgraded]  VALID
  Oracle Label Security                  [to be upgraded]  VALID
  Oracle Database Vault                  [to be upgraded]  VALID
  Oracle Text                            [to be upgraded]  VALID
  Oracle XML Database                    [to be upgraded]  VALID
  Oracle Java Packages                   [to be upgraded]  VALID
  Oracle Multimedia                      [to be upgraded]  VALID
  Oracle Spatial                         [to be upgraded]  VALID
  Oracle Application Express             [to be upgraded]  VALID
  Oracle OLAP API                        [to be upgraded]  VALID


==============
BEFORE UPGRADE
==============

  Run <preupgradeLogDirPath>/preupgrade_fixups_CDB_ROOT.sql to complete all
  of the BEFORE UPGRADE action items below marked with '(AUTOFIXUP)'.

  REQUIRED ACTIONS
  ================
   + Adjust TABLESPACE SIZES as needed.
                                                Auto      12.2.0.1.0
     Tablespace                        Size     Extend    Min Size    Action
     ----------                     ----------  --------  ----------  ------

     SYSAUX                             740 MB  ENABLED      1638 MB  None
     SYSTEM                             800 MB  ENABLED      1307 MB  None
     TEMP                               197 MB  DISABLED      150 MB  None
     UNDOTBS1                           350 MB  ENABLED       400 MB  None

     Note that 12.2.0.1.0 minimum sizes are estimates.
     If you plan to upgrade multiple pluggable databases concurrently,
     then you must ensure that the UNDO tablespace size is equal to at least
     the number of pluggable databases that you upgrade concurrently,
     multiplied by that minimum.  Failing to allocate sufficient space can
     cause the upgrade to fail.


…..contd (output trimmed)


Login as sysdba and execute preupgrade fixup script with old Oracle Home

[oracle@vm217 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.1.0.2.0 Production on Sun Oct 29 20:06:37 2017

Copyright (c) 1982, 2014, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Advanced Analytics
and Real Application Testing options

SQL> @/tmp/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script

Auto-Generated by:       Oracle Preupgrade Script
                         Version: 12.2.0.1.0 Build: 1
Generated on:            2017-10-29 19:56:19

For Source Database:     PROD
Source Database Version: 12.1.0.2.0
For Upgrade to Version:  12.2.0.1.0

Executing in container:  CDB$ROOT

                          Fixup
Check Name                Status  Further DBA Action
----------                ------  ------------------
purge_recyclebin          Passed  None
hidden_params             Failed  Manual fixup recommended.
dictionary_stats          Passed  None
apex_upgrade_msg          Failed  Manual fixup recommended.

PL/SQL procedure successfully completed.


Session altered.

Validate the invalid objects before upgrade.

SQL> select owner,object_type,count(*)
from dba_objects
where status='INVALID'
group by owner,object_type
order by owner,object_type ;

no rows selected


Move parameter file , listener.ora, tnsnames.ora, sqlnet.ora and ldap.ora to new Oracle Home 12cR2, and shutdown the database and start the database with 12cR2 home in startup upgrade mode.


SQL> shut immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.



[oracle@vm217 ~]$ . oraenv
ORACLE_SID = [PROD] ?
The Oracle base remains unchanged with value /u01/app/oracle


[oracle@vm217 ~]$ cd $ORACLE_HOME/dbs/
[oracle@vm217 dbs]$ cd ../network/admin/
[oracle@vm217 admin]$ ls -l
total 16
drwxr-xr-x 2 oracle oinstall 4096 Oct 28 09:54 samples
-rw-r--r-- 1 oracle oinstall  373 Oct 31  2013 shrept.lst
-rw-r--r-- 1 oracle oinstall  193 Oct 28 10:52 sqlnet.ora
-rw-r----- 1 oracle oinstall  338 Oct 28 11:02 tnsnames.ora
[oracle@vm217 admin]$ cp *.ora /u01/app/oracle/product/12.2.0.2/DB_1/network/admin/

Edit /etc/oratab with new Oracle Home : /u01/app/oracle/product/12.2.0.2/DB_1

[oracle@vm217 ~]$ . oraenv
ORACLE_SID = [PROD] ?
The Oracle base remains unchanged with value /u01/app/oracle

[oracle@vm217 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Oct 29 20:20:38 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1140850688 bytes
Fixed Size                  8791960 bytes
Variable Size             754976872 bytes
Database Buffers          369098752 bytes
Redo Buffers                7983104 bytes
Database mounted.
Database opened.

 

UPGRADE STEPS to 12cR2:


[oracle@vm217 12.2.0.2]$ cd /u01/app/oracle/product/12.2.0.2/DB_1/bin
[oracle@vm217 bin]$ ls dbupgrade

dbupgrade



[oracle@vm217 bin]$ ./dbupgrade -n 4 -l /tmp/dbaocm

Argument list for [/u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/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 = /tmp/dbaocm
Priority List Name    L = 0
Upgrade Mode active   M = 0
SQL Process Count     n = 4
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

catctl.pl VERSION: [12.2.0.1.0]
           STATUS: [production]
            BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]


/u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/orahome = [/u01/app/oracle/product/12.2.0.2/DB_1]
/u01/app/oracle/product/12.2.0.2/DB_1/bin/orabasehome = [/u01/app/oracle/product/12.2.0.2/DB_1]
catctlGetOrabase = [/u01/app/oracle/product/12.2.0.2/DB_1]

Analyzing file /u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/catupgrd.sql

Log file directory = [/tmp/dbaocm]

catcon: ALL catcon-related output will be written to [/tmp/dbaocm/catupgrd_catcon_28202.lst]
catcon: See [/tmp/dbaocm/catupgrd*.log] files for output generated by scripts
catcon: See [/tmp/dbaocm/catupgrd_*.lst] files for spool files, if any

Number of Cpus        = 1
Database Name         = PROD
DataBase Version      = 12.1.0.2.0
Parallel SQL Process Count (PDB)      = 2
Parallel SQL Process Count (CDB$ROOT) = 4
Concurrent PDB Upgrades               = 2
PRODP Open Mode = [MOUNTED] NO UPGRADE WILL BE PERFORMED
Generated PDB Inclusion:[PDB$SEED]
Components in [CDB$ROOT]
    Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [EM MGW ODM RAC WK]

------------------------------------------------------
Phases [0-115]         Start Time:[2017_10_29 20:24:22]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------
***********   Executing Change Scripts   ***********
Serial   Phase #:0    [CDB$ROOT] Files:1    Time: 109s
***************   Catalog Core SQL   ***************
Serial   Phase #:1    [CDB$ROOT] Files:5    Time: 57s
Restart  Phase #:2    [CDB$ROOT] Files:1    Time: 0s
***********   Catalog Tables and Views   ***********
Parallel Phase #:3    [CDB$ROOT] Files:19   Time: 25s
Restart  Phase #:4    [CDB$ROOT] Files:1    Time: 0s
*************   Catalog Final Scripts   ************
Serial   Phase #:5    [CDB$ROOT] Files:6    Time: 19s
*****************   Catproc Start   ****************
Serial   Phase #:6    [CDB$ROOT] Files:1    Time: 17s
*****************   Catproc Types   ****************
Serial   Phase #:7    [CDB$ROOT] Files:2    Time: 15s
Restart  Phase #:8    [CDB$ROOT] Files:1    Time: 0s
****************   Catproc Tables   ****************
Parallel Phase #:9    [CDB$ROOT] Files:69   Time: 44s
Restart  Phase #:10   [CDB$ROOT] Files:1    Time: 0s
*************   Catproc Package Specs   ************
Serial   Phase #:11   [CDB$ROOT] Files:1    Time: 49s
Restart  Phase #:12   [CDB$ROOT] Files:1    Time: 0s
**************   Catproc Procedures   **************
Parallel Phase #:13   [CDB$ROOT] Files:97   Time: 15s
Restart  Phase #:14   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:15   [CDB$ROOT] Files:118  Time: 29s
Restart  Phase #:16   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:17   [CDB$ROOT] Files:13   Time: 3s
Restart  Phase #:18   [CDB$ROOT] Files:1    Time: 1s
*****************   Catproc Views   ****************
Parallel Phase #:19   [CDB$ROOT] Files:33   Time: 41s
Restart  Phase #:20   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:21   [CDB$ROOT] Files:3    Time: 9s
Restart  Phase #:22   [CDB$ROOT] Files:1    Time: 1s
Parallel Phase #:23   [CDB$ROOT] Files:24   Time: 110s
Restart  Phase #:24   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:25   [CDB$ROOT] Files:11   Time: 56s
Restart  Phase #:26   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:27   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:28   [CDB$ROOT] Files:3    Time: 6s
Serial   Phase #:29   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:30   [CDB$ROOT] Files:1    Time: 0s
***************   Catproc CDB Views   **************
Serial   Phase #:31   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:32   [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:34   [CDB$ROOT] Files:1    Time: 0s
*****************   Catproc PLBs   *****************
Serial   Phase #:35   [CDB$ROOT] Files:283  Time: 35s
Serial   Phase #:36   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:37   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:38   [CDB$ROOT] Files:1    Time: 5s
Restart  Phase #:39   [CDB$ROOT] Files:1    Time: 0s
***************   Catproc DataPump   ***************
Serial   Phase #:40   [CDB$ROOT] Files:3    Time: 60s
Restart  Phase #:41   [CDB$ROOT] Files:1    Time: 0s
******************   Catproc SQL   *****************
Parallel Phase #:42   [CDB$ROOT] Files:13   Time: 110s
Restart  Phase #:43   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:44   [CDB$ROOT] Files:12   Time: 21s
Restart  Phase #:45   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:46   [CDB$ROOT] Files:2    Time: 1s
Restart  Phase #:47   [CDB$ROOT] Files:1    Time: 0s
*************   Final Catproc scripts   ************
Serial   Phase #:48   [CDB$ROOT] Files:1    Time: 7s
Restart  Phase #:49   [CDB$ROOT] Files:1    Time: 0s
**************   Final RDBMS scripts   *************
Serial   Phase #:50   [CDB$ROOT] Files:1    Time: 36s
************   Upgrade Component Start   ***********
Serial   Phase #:51   [CDB$ROOT] Files:1    Time: 0s
Restart  Phase #:52   [CDB$ROOT] Files:1    Time: 0s
****************   Upgrading Java   ****************
Serial   Phase #:53   [CDB$ROOT] Files:1    Time: 499s
Restart  Phase #:54   [CDB$ROOT] Files:1    Time: 0s
*****************   Upgrading XDK   ****************
Serial   Phase #:55   [CDB$ROOT] Files:1    Time: 84s
Restart  Phase #:56   [CDB$ROOT] Files:1    Time: 0s
*********   Upgrading APS,OLS,DV,CONTEXT   *********
Serial   Phase #:57   [CDB$ROOT] Files:1    Time: 120s
*****************   Upgrading XDB   ****************
Restart  Phase #:58   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:60   [CDB$ROOT] Files:3    Time: 19s
Serial   Phase #:61   [CDB$ROOT] Files:3    Time: 8s
Parallel Phase #:62   [CDB$ROOT] Files:9    Time: 3s
Parallel Phase #:63   [CDB$ROOT] Files:24   Time: 6s
Serial   Phase #:64   [CDB$ROOT] Files:4    Time: 9s
Serial   Phase #:65   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:66   [CDB$ROOT] Files:30   Time: 5s
Serial   Phase #:67   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:68   [CDB$ROOT] Files:6    Time: 3s
Serial   Phase #:69   [CDB$ROOT] Files:2    Time: 25s
Serial   Phase #:70   [CDB$ROOT] Files:3    Time: 45s
Restart  Phase #:71   [CDB$ROOT] Files:1    Time: 0s
*********   Upgrading CATJAVA,OWM,MGW,RAC   ********
Serial   Phase #:72   [CDB$ROOT] Files:1    Time: 69s
****************   Upgrading ORDIM   ***************
Restart  Phase #:73   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:75   [CDB$ROOT] Files:1    Time: 1s
Parallel Phase #:76   [CDB$ROOT] Files:2    Time: 63s
Serial   Phase #:77   [CDB$ROOT] Files:1    Time: 80s
Restart  Phase #:78   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:79   [CDB$ROOT] Files:2    Time: 18s
Serial   Phase #:80   [CDB$ROOT] Files:2    Time: 2s
*****************   Upgrading SDO   ****************
Restart  Phase #:81   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:83   [CDB$ROOT] Files:1    Time: 221s
Serial   Phase #:84   [CDB$ROOT] Files:1    Time: 3s
Restart  Phase #:85   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:86   [CDB$ROOT] Files:1    Time: 31s
Restart  Phase #:87   [CDB$ROOT] Files:1    Time: 1s
Parallel Phase #:88   [CDB$ROOT] Files:3    Time: 159s
Restart  Phase #:89   [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:90   [CDB$ROOT] Files:1    Time: 5s
Restart  Phase #:91   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:92   [CDB$ROOT] Files:1    Time: 4s
Restart  Phase #:93   [CDB$ROOT] Files:1    Time: 0s
Parallel Phase #:94   [CDB$ROOT] Files:4    Time: 115s
Restart  Phase #:95   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:96   [CDB$ROOT] Files:1    Time: 1s
Restart  Phase #:97   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:98   [CDB$ROOT] Files:2    Time: 63s
Restart  Phase #:99   [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:100  [CDB$ROOT] Files:1    Time: 1s
Restart  Phase #:101  [CDB$ROOT] Files:1    Time: 0s
***********   Upgrading Misc. ODM, OLAP   **********
Serial   Phase #:102  [CDB$ROOT] Files:1    Time: 21s
****************   Upgrading APEX   ****************
Restart  Phase #:103  [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:104  [CDB$ROOT] Files:1
   Time: 1009s
Restart  Phase #:105  [CDB$ROOT] Files:1    Time: 0s
***********   Final Component scripts    ***********
Serial   Phase #:106  [CDB$ROOT] Files:1    Time: 0s
*************   Final Upgrade scripts   ************
Serial   Phase #:107  [CDB$ROOT] Files:1    Time: 95s
**********   End PDB Application Upgrade   *********
Serial   Phase #:108  [CDB$ROOT] Files:1    Time: 1s
*******************   Migration   ******************
Serial   Phase #:109  [CDB$ROOT] Files:1    Time: 60s
Serial   Phase #:110  [CDB$ROOT] Files:1    Time: 1s
Serial   Phase #:111  [CDB$ROOT] Files:1    Time: 86s
*****************   Post Upgrade   *****************
Serial   Phase #:112  [CDB$ROOT] Files:1    Time: 41s
****************   Summary report   ****************
Serial   Phase #:113  [CDB$ROOT] Files:1    Time: 2s
Serial   Phase #:114  [CDB$ROOT] Files:1    Time: 0s
Serial   Phase #:115  [CDB$ROOT] Files:1     Time: 0s

------------------------------------------------------
Phases [0-115]         End Time:[2017_10_29 21:28:45]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------

Start processing of PDB$SEED
[/u01/app/oracle/product/12.2.0.2/DB_1/perl/bin/perl /u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/catctl.pl -n 2 -l /tmp/dbaocm -I -i pdb_seed -c 'PDB$SEED' /u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/catupgrd.sql]

Argument list for [/u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/catctl.pl]
Run in                c = PDB$SEED
Do not run in         C = 0
Input Directory       d = 0
Echo OFF              e = 1
Simulate              E = 0
Forced cleanup        F = 0
Log Id                i = pdb_seed
Child Process         I = 1
Log Dir               l = /tmp/dbaocm
Priority List Name    L = 0
Upgrade Mode active   M = 0
SQL Process Count     n = 2
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

catctl.pl VERSION: [12.2.0.1.0]
           STATUS: [production]
            BUILD: [RDBMS_12.2.0.1.0_LINUX.X64_170125]


/u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/orahome = [/u01/app/oracle/product/12.2.0.2/DB_1]
/u01/app/oracle/product/12.2.0.2/DB_1/bin/orabasehome = [/u01/app/oracle/product/12.2.0.2/DB_1]
catctlGetOrabase = [/u01/app/oracle/product/12.2.0.2/DB_1]

Analyzing file /u01/app/oracle/product/12.2.0.2/DB_1/rdbms/admin/catupgrd.sql

Log file directory = [/tmp/dbaocm]

catcon: ALL catcon-related output will be written to [/tmp/dbaocm/catupgrdpdb_seed_catcon_12003.lst]
catcon: See [/tmp/dbaocm/catupgrdpdb_seed*.log] files for output generated by scripts
catcon: See [/tmp/dbaocm/catupgrdpdb_seed_*.lst] files for spool files, if any

Number of Cpus        = 1
Database Name         = PROD
DataBase Version      = 12.2.0.1.0
Generated PDB Inclusion:[PDB$SEED]
CDB$ROOT  Open Mode = [OPEN]
Components in [PDB$SEED]
    Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [EM MGW ODM RAC WK]

------------------------------------------------------
Phases [0-115]         Start Time:[2017_10_29 21:28:57]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------
***********   Executing Change Scripts   ***********
Serial   Phase #:0    [PDB$SEED] Files:1    Time: 52s
***************   Catalog Core SQL   ***************
Serial   Phase #:1    [PDB$SEED] Files:5    Time: 78s
Restart  Phase #:2    [PDB$SEED] Files:1    Time: 0s
***********   Catalog Tables and Views   ***********
Parallel Phase #:3    [PDB$SEED] Files:19   Time: 41s
Restart  Phase #:4    [PDB$SEED] Files:1    Time: 0s
*************   Catalog Final Scripts   ************
Serial   Phase #:5    [PDB$SEED] Files:6    Time: 27s
*****************   Catproc Start   ****************
Serial   Phase #:6    [PDB$SEED] Files:1    Time: 16s
*****************   Catproc Types   ****************
Serial   Phase #:7    [PDB$SEED] Files:2    Time: 14s
Restart  Phase #:8    [PDB$SEED] Files:1    Time: 0s
****************   Catproc Tables   ****************
Parallel Phase #:9    [PDB$SEED] Files:69   Time: 53s
Restart  Phase #:10   [PDB$SEED] Files:1    Time: 0s
*************   Catproc Package Specs   ************
Serial   Phase #:11   [PDB$SEED] Files:1    Time: 45s
Restart  Phase #:12   [PDB$SEED] Files:1    Time: 1s
**************   Catproc Procedures   **************
Parallel Phase #:13   [PDB$SEED] Files:97   Time: 10s
Restart  Phase #:14   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:15   [PDB$SEED] Files:118  Time: 16s
Restart  Phase #:16   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:17   [PDB$SEED] Files:13   Time: 3s
Restart  Phase #:18   [PDB$SEED] Files:1    Time: 0s
*****************   Catproc Views   ****************
Parallel Phase #:19   [PDB$SEED] Files:33   Time: 41s
Restart  Phase #:20   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:21   [PDB$SEED] Files:3    Time: 10s
Restart  Phase #:22   [PDB$SEED] Files:1    Time: 1s
Parallel Phase #:23   [PDB$SEED] Files:24   Time: 272s
Restart  Phase #:24   [PDB$SEED] Files:1    Time: 1s
Parallel Phase #:25   [PDB$SEED] Files:11   Time: 91s
Restart  Phase #:26   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:27   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:28   [PDB$SEED] Files:3    Time: 28s
Serial   Phase #:29   [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:30   [PDB$SEED] Files:1    Time: 0s
***************   Catproc CDB Views   **************
Serial   Phase #:31   [PDB$SEED] Files:1    Time: 1s
Restart  Phase #:32   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:34   [PDB$SEED] Files:1    Time: 0s
*****************   Catproc PLBs   *****************
Serial   Phase #:35   [PDB$SEED] Files:283  Time: 122s
Serial   Phase #:36   [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:37   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:38   [PDB$SEED] Files:1    Time: 6s
Restart  Phase #:39   [PDB$SEED] Files:1    Time: 0s
***************   Catproc DataPump   ***************
Serial   Phase #:40   [PDB$SEED] Files:3    Time: 49s
Restart  Phase #:41   [PDB$SEED] Files:1    Time: 0s
******************   Catproc SQL   *****************
Parallel Phase #:42   [PDB$SEED] Files:13   Time: 69s
Restart  Phase #:43   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:44   [PDB$SEED] Files:12   Time: 9s
Restart  Phase #:45   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:46   [PDB$SEED] Files:2    Time: 1s
Restart  Phase #:47   [PDB$SEED] Files:1    Time: 0s
*************   Final Catproc scripts   ************
Serial   Phase #:48   [PDB$SEED] Files:1    Time: 8s
Restart  Phase #:49   [PDB$SEED] Files:1    Time: 0s
**************   Final RDBMS scripts   *************
Serial   Phase #:50   [PDB$SEED] Files:1    Time: 20s
************   Upgrade Component Start   ***********
Serial   Phase #:51   [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:52   [PDB$SEED] Files:1    Time: 1s
****************   Upgrading Java   ****************
Serial   Phase #:53   [PDB$SEED] Files:1    Time: 412s
Restart  Phase #:54   [PDB$SEED] Files:1    Time: 0s
*****************   Upgrading XDK   ****************
Serial   Phase #:55   [PDB$SEED] Files:1    Time: 60s
Restart  Phase #:56   [PDB$SEED] Files:1    Time: 0s
*********   Upgrading APS,OLS,DV,CONTEXT   *********
Serial   Phase #:57   [PDB$SEED] Files:1    Time: 152s
*****************   Upgrading XDB   ****************
Restart  Phase #:58   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:60   [PDB$SEED] Files:3    Time: 16s
Serial   Phase #:61   [PDB$SEED] Files:3    Time: 3s
Parallel Phase #:62   [PDB$SEED] Files:9    Time: 2s
Parallel Phase #:63   [PDB$SEED] Files:24   Time: 7s
Serial   Phase #:64   [PDB$SEED] Files:4    Time: 13s
Serial   Phase #:65   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:66   [PDB$SEED] Files:30   Time: 11s
Serial   Phase #:67   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:68   [PDB$SEED] Files:6    Time: 2s
Serial   Phase #:69   [PDB$SEED] Files:2    Time: 22s
Serial   Phase #:70   [PDB$SEED] Files:3    Time: 40s
Restart  Phase #:71   [PDB$SEED] Files:1    Time: 0s
*********   Upgrading CATJAVA,OWM,MGW,RAC   ********
Serial   Phase #:72   [PDB$SEED] Files:1    Time: 52s
****************   Upgrading ORDIM   ***************
Restart  Phase #:73   [PDB$SEED] Files:1    Time: 1s
Serial   Phase #:75   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:76   [PDB$SEED] Files:2    Time: 58s
Serial   Phase #:77   [PDB$SEED] Files:1    Time: 39s
Restart  Phase #:78   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:79   [PDB$SEED] Files:2    Time: 16s
Serial   Phase #:80   [PDB$SEED] Files:2    Time: 1s
*****************   Upgrading SDO   ****************
Restart  Phase #:81   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:83   [PDB$SEED] Files:1    Time: 127s
Serial   Phase #:84   [PDB$SEED] Files:1    Time: 2s
Restart  Phase #:85   [PDB$SEED] Files:1    Time: 1s
Serial   Phase #:86   [PDB$SEED] Files:1    Time: 6s
Restart  Phase #:87   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:88   [PDB$SEED] Files:3    Time: 89s
Restart  Phase #:89   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:90   [PDB$SEED] Files:1    Time: 7s
Restart  Phase #:91   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:92   [PDB$SEED] Files:1    Time: 2s
Restart  Phase #:93   [PDB$SEED] Files:1    Time: 0s
Parallel Phase #:94   [PDB$SEED] Files:4    Time: 82s
Restart  Phase #:95   [PDB$SEED] Files:1    Time: 1s
Serial   Phase #:96   [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:97   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:98   [PDB$SEED] Files:2    Time: 37s
Restart  Phase #:99   [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:100  [PDB$SEED] Files:1    Time: 0s
Restart  Phase #:101  [PDB$SEED] Files:1    Time: 1s
***********   Upgrading Misc. ODM, OLAP   **********
Serial   Phase #:102  [PDB$SEED] Files:1    Time: 21s
****************   Upgrading APEX   ****************
Restart  Phase #:103  [PDB$SEED] Files:1    Time: 0s
Serial   Phase #:104  [PDB$SEED] Files:1    Time: 862s
Restart  Phase #:105  [PDB$SEED] Files:1    Time: 0s
***********   Final Component scripts    ***********
Serial   Phase #:106  [PDB$SEED] Files:1    Time: 1s
*************   Final Upgrade scripts   ************
Serial   Phase #:107  [PDB$SEED] Files:1    Time: 98s
**********   End PDB Application Upgrade   *********
Serial   Phase #:108  [PDB$SEED] Files:1    Time: 0s
*******************   Migration   ******************
Serial   Phase #:109  [PDB$SEED] Files:1    Time: 59s
Serial   Phase #:110  [PDB$SEED] Files:1    Time: 4s
Serial   Phase #:111  [PDB$SEED] Files:1    Time: 28s
*****************   Post Upgrade   *****************
Serial   Phase #:112  [PDB$SEED] Files:1    Time: 1016s
****************   Summary report   ****************
Serial   Phase #:113  [PDB$SEED] Files:1    Time: 2s
Serial   Phase #:114  [PDB$SEED] Files:1    Time: 4s
Serial   Phase #:115  [PDB$SEED] Files:1     Time: 0s

------------------------------------------------------
Phases [0-115]         End Time:[2017_10_29 22:43:00]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------

Grand Total Time: 4454s [PDB$SEED]

 LOG FILES: (/tmp/dbaocm/catupgrdpdb_seed*.log)

Upgrade Summary Report Located in:
/tmp/dbaocm/upg_summary.log

Total Upgrade Time:          [0d:1h:14m:14s]

     Time: 3863s For CDB$ROOT
     Time: 4470s For PDB(s)

Grand Total Time: 8333s

 LOG FILES: (/tmp/dbaocm/catupgrd*.log)

Upgrade Summary Report Located in:
/tmp/dbaocm/upg_summary.log

Grand Total Upgrade Time:    [0d:2h:18m:53s]

POST-UPGRADE STEPS:


Validate the Upgraded Summary Logs

[oracle@vm217 bin]$ more /tmp/dbaocm/upg_summary.log

Oracle Database 12.2 Post-Upgrade Status Tool           10-29-2017 21:28:44
                             [CDB$ROOT]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.2.0.1.0  00:14:35
JServer JAVA Virtual Machine           UPGRADED      12.2.0.1.0  00:08:17
Oracle Real Application Clusters       UPGRADED      12.2.0.1.0  00:00:00
Oracle Workspace Manager               UPGRADED      12.2.0.1.0  00:00:50
OLAP Analytic Workspace                UPGRADED      12.2.0.1.0  00:00:24
Oracle OLAP API                        UPGRADED      12.2.0.1.0  00:00:20
Oracle Label Security                  UPGRADED      12.2.0.1.0  00:00:11
Oracle XDK                             UPGRADED      12.2.0.1.0  00:01:23
Oracle Text                            UPGRADED      12.2.0.1.0  00:00:54
Oracle XML Database                    UPGRADED      12.2.0.1.0  00:02:01
Oracle Database Java Packages          UPGRADED      12.2.0.1.0  00:00:17
Oracle Multimedia                      UPGRADED      12.2.0.1.0  00:02:42
Spatial                                UPGRADED      12.2.0.1.0  00:10:03
Oracle Application Express             UPGRADED     5.0.4.00.12  00:16:48
Oracle Database Vault                  UPGRADED      12.2.0.1.0  00:00:28
Final Actions                                                    00:02:36
Post Upgrade                                                     00:00:39

Total Upgrade Time: 01:02:46 [CDB$ROOT]

Database time zone version is 18. It is older than current release time
zone version 26. Time zone upgrade is needed using the DBMS_DST package.


Oracle Database 12.2 Post-Upgrade Status Tool           10-29-2017 22:42:54
                             [PDB$SEED]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                             VALID      12.2.0.1.0  00:17:58
JServer JAVA Virtual Machine              VALID      12.2.0.1.0  00:06:51
Oracle Real Application Clusters     OPTION OFF      12.2.0.1.0  00:00:00
Oracle Workspace Manager                  VALID      12.2.0.1.0  00:00:40
OLAP Analytic Workspace                   VALID      12.2.0.1.0  00:00:29
Oracle OLAP API                           VALID      12.2.0.1.0  00:00:20
Oracle Label Security                     VALID      12.2.0.1.0  00:00:11
Oracle XDK                                VALID      12.2.0.1.0  00:00:59
Oracle Text                               VALID      12.2.0.1.0  00:00:37
Oracle XML Database                       VALID      12.2.0.1.0  00:01:54
Oracle Database Java Packages             VALID      12.2.0.1.0  00:00:10
Oracle Multimedia                         VALID      12.2.0.1.0  00:01:54
Spatial                                   VALID      12.2.0.1.0  00:05:53
Oracle Application Express                VALID     5.0.4.00.12  00:14:21
Oracle Database Vault                     VALID      12.2.0.1.0  00:01:12
Final Actions                                                    00:02:37
Post Upgrade                                                     00:01:41
Post Compile                                                     00:14:29

Total Upgrade Time: 01:12:31 [PDB$SEED]

Database time zone version is 18. It is older than current release time
zone version 26. Time zone upgrade is needed using the DBMS_DST package.


Upgrade Times Sorted In Descending Order

Total Upgrade Time: 01:12:31 [PDB$SEED]
Total Upgrade Time: 01:02:46 [CDB$ROOT]
Grand Total Upgrade Time:    [0d:2h:18m:53s]

In summary logs we find the timezone version is not upgrade to match version with current release.  Now we are going to manually fix to current release.

For this we need to shutdown the database and start the database in upgrade mode to update the timezone to current release.

[oracle@vm217 bin]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Oct 29 22:46:38 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select version from v$timezone_file ;

   VERSION
----------
        18
SQL>
SQL> shut immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup upgrade
ORACLE instance started.

Total System Global Area 1140850688 bytes
Fixed Size                  8791960 bytes
Variable Size             754976872 bytes
Database Buffers          369098752 bytes
Redo Buffers                7983104 bytes
Database mounted.
Database opened.


SQL> select version from v$timezone_file ;

   VERSION
----------
        18


SQL> exec dbms_dst.begin_upgrade(26) ;

PL/SQL procedure successfully completed.


SQL> shut immediate ;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1140850688 bytes
Fixed Size                  8791960 bytes
Variable Size             754976872 bytes
Database Buffers          369098752 bytes
Redo Buffers                7983104 bytes
Database mounted.
Database opened.
SQL>
SQL>
SQL>
SQL> select version from v$timezone_file ;

   VERSION
----------
        26

Go to the upgraded logs location and validate the logs for any error during upgradation.

[oracle@vm217 ~]$ cd  /tmp/dbaocm/
[oracle@vm217 dbaocm]$ ls -l
total 445092
-rw-r--r-- 1 oracle oinstall 206135012 Oct 29 22:43 catupgrd0.log
-rw-r--r-- 1 oracle oinstall   7880991 Oct 29 21:28 catupgrd1.log
-rw-r--r-- 1 oracle oinstall   7475890 Oct 29 21:28 catupgrd2.log
-rw-r--r-- 1 oracle oinstall   6894429 Oct 29 21:28 catupgrd3.log
-rw-r--r-- 1 oracle oinstall       381 Oct 29 20:24 catupgrd_catcon_28202.lst
-rw-r--r-- 1 oracle oinstall         0 Oct 29 21:27 catupgrd_datapatch_normal.err
-rw-r--r-- 1 oracle oinstall      1211 Oct 29 21:28 catupgrd_datapatch_normal.log
-rw-r--r-- 1 oracle oinstall         0 Oct 29 21:23 catupgrd_datapatch_upgrade.err
-rw-r--r-- 1 oracle oinstall       886 Oct 29 21:24 catupgrd_datapatch_upgrade.log
-rw-r--r-- 1 oracle oinstall 215279033 Oct 29 22:43 catupgrdpdb_seed0.log
-rw-r--r-- 1 oracle oinstall  12042434 Oct 29 22:43 catupgrdpdb_seed1.log
-rw-r--r-- 1 oracle oinstall       397 Oct 29 21:28 catupgrdpdb_seed_catcon_12003.lst
-rw-r--r-- 1 oracle oinstall         0 Oct 29 22:25 catupgrdpdb_seed_datapatch_normal.err
-rw-r--r-- 1 oracle oinstall       887 Oct 29 22:25 catupgrdpdb_seed_datapatch_normal.log
-rw-r--r-- 1 oracle oinstall         0 Oct 29 22:22 catupgrdpdb_seed_datapatch_upgrade.err
-rw-r--r-- 1 oracle oinstall       887 Oct 29 22:23 catupgrdpdb_seed_datapatch_upgrade.log
-rw-r--r-- 1 oracle oinstall      3676 Oct 29 22:43 upg_summary.log


Once done we need to run the post upgrade fixes as sysdba.

[oracle@vm217 tmp]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Sun Oct 29 23:01:41 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> @/tmp/postupgrade_fixups.sql

Session altered.


PL/SQL procedure successfully completed.


Session altered.


PL/SQL procedure successfully completed.


Package created.

No errors.

Package body created.

No errors.





Package created.

No errors.

Package body created.

No errors.
Executing Oracle POST-Upgrade Fixup Script

Auto-Generated by:       Oracle Preupgrade Script
                         Version: 12.2.0.1.0 Build: 1
Generated on:            2017-10-29 19:56:23

For Source Database:     PROD
Source Database Version: 12.1.0.2.0
For Upgrade to Version:  12.2.0.1.0

Executing in container:  CDB$ROOT

                          Fixup
Check Name                Status  Further DBA Action
----------                ------  ------------------
old_time_zones_exist      Passed  None
post_dictionary           Passed  None

PL/SQL procedure successfully completed.


Session altered.



[oracle@vm217 ~]$ sqlplus / as sysdba

SQL*Plus: Release 12.2.0.1.0 Production on Mon Oct 30 00:41:42 2017

Copyright (c) 1982, 2016, Oracle.  All rights reserved.


Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production

SQL> select name,open_mode from v$database ;

NAME      OPEN_MODE
--------- --------------------
PROD      READ WRITE


Execute the utlu122s.sql to validate the post upgraded components.

SQL> @$ORACLE_HOME/rdbms/admin/utlu122s.sql

Oracle Database 12.2 Post-Upgrade Status Tool           10-30-2017 00:42:08
                             [CDB$ROOT]

Component                               Current         Version  Elapsed Time
Name                                    Status          Number   HH:MM:SS

Oracle Server                          UPGRADED      12.2.0.1.0  00:14:35
JServer JAVA Virtual Machine           UPGRADED      12.2.0.1.0  00:08:17
Oracle Real Application Clusters       UPGRADED      12.2.0.1.0  00:00:00
Oracle Workspace Manager               UPGRADED      12.2.0.1.0  00:00:50
OLAP Analytic Workspace                UPGRADED      12.2.0.1.0  00:00:24
Oracle OLAP API                        UPGRADED      12.2.0.1.0  00:00:20
Oracle Label Security                  UPGRADED      12.2.0.1.0  00:00:11
Oracle XDK                             UPGRADED      12.2.0.1.0  00:01:23
Oracle Text                            UPGRADED      12.2.0.1.0  00:00:54
Oracle XML Database                    UPGRADED      12.2.0.1.0  00:02:01
Oracle Database Java Packages          UPGRADED      12.2.0.1.0  00:00:17
Oracle Multimedia                      UPGRADED      12.2.0.1.0  00:02:42
Spatial                                UPGRADED      12.2.0.1.0  00:10:03
Oracle Application Express             UPGRADED     5.0.4.00.12  00:16:48
Oracle Database Vault                  UPGRADED      12.2.0.1.0  00:00:28
Final Actions                                                    00:02:36
Post Upgrade                                                     00:00:39

Total Upgrade Time: 01:02:46 [CDB$ROOT]

Database time zone version is 26. It meets current release needs.

Summary Report File = /tmp/dbaocm/upg_summary.log



00:42:13 SQL> desc registry$history
 Name                                      Null?    Type
 ----------------------------------------- -------- ----------------------------
 ACTION_TIME                                        TIMESTAMP(6)
 ACTION                                             VARCHAR2(30)
 NAMESPACE                                          VARCHAR2(30)
 VERSION                                            VARCHAR2(30)
 ID                                                 NUMBER
 COMMENTS                                           VARCHAR2(255)
 BUNDLE_SERIES                                      VARCHAR2(30)

00:42:22 SQL> col comments for a20
00:42:29 SQL> col action_time for a28
00:42:35 SQL> col action for a20
00:42:42 SQL> col namespace for  a20
00:42:48 SQL> col bundle_series for a20
00:43:07 SQL> col version for a10
00:43:59 SQL> col action for a20
00:44:04 SQL> /
00:42:54 SQL> select * from registry$history ;

ACTION_TIME                  ACTION               NAMESPACE            VERSION            ID COMMENTS             BUNDLE_SERIES
---------------------------- -------------------- -------------------- ---------- ---------- -------------------- --------------------
                             BOOTSTRAP            DATAPATCH            12.2.0.1              RDBMS_12.2.0.1.0_LIN
                                                                                             UX.X64_170125

29-OCT-17 09.24.17.737267 PM VIEW INVALIDATE                                         8289601 view invalidation
29-OCT-17 09.26.35.616989 PM UPGRADE              SERVER               12.2.0.1.0            Upgraded from 12.1.0
                                                                                             .2.0
3 rows selected.

Elapsed: 00:00:00.01


Run the utlrp to recompile objects if any….

00:44:06 SQL> @?/rdbms/admin/utlrp
…..
===========================================================================
00:44:23 SQL> Rem BEGIN utlrp.sql
00:44:23 SQL> Rem ===========================================================================
00:44:23 SQL>
00:44:23 SQL> @@utlprp.sql 0
…….
00:44:23 SQL> DECLARE
00:44:23   2     threads pls_integer := &&1;
00:44:23   3  BEGIN
00:44:23   4     utl_recomp.recomp_parallel(threads);
00:44:23   5  END;
00:44:23   6  /

PL/SQL procedure successfully completed.

Elapsed: 00:00:18.86
00:44:42 SQL>
00:44:42 SQL> SELECT dbms_registry_sys.time_stamp('utlrp_end') as timestamp from dual;

TIMESTAMP
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
COMP_TIMESTAMP UTLRP_END              2017-10-30 00:44:42

1 row selected.

…..
00:44:42 SQL> select COUNT(*) "OBJECTS WITH ERRORS" from obj$ where status in (3,4,5,6);

OBJECTS WITH ERRORS
-------------------
                  0

1 row selected.

………..
:44:42 DOC>#
00:44:42 SQL> select COUNT(*) "ERRORS DURING RECOMPILATION" from utl_recomp_errors;

ERRORS DURING RECOMPILATION
---------------------------
                          0

1 row selected.

Elapsed: 00:00
………
00:44:42 SQL> SET serveroutput on
00:44:42 SQL> EXECUTE dbms_registry_sys.validate_components;
...Starting validation 00:44:56
...Database user "SYS", database schema "APEX_050000", user# "117" 00:44:56
...grant execute on "SYS"."DBMS_CRYPTO_INTERNAL" to APEX_050000 00:45:00
...272 packages
...265 package bodies
...465 tables
...8 functions
...16 procedures
...4 sequences
...497 triggers
...1582 indexes
...255 views
...0 libraries
...14 types
...5 type bodies
...0 operators
...0 index types
...Begin key object existence check 00:45:07
...Completed key object existence check 00:45:07
...Setting DBMS Registry 00:45:07
...Setting DBMS Registry Complete 00:45:07
...Exiting validate 00:45:07

PL/SQL procedure successfully completed.

Elapsed: 00:00:25.72
00:45:08 SQL> SET serveroutput off
00:45:08 SQL>
00:45:08 SQL>
00:45:08 SQL> Rem ===========================================================================
00:45:08 SQL> Rem END utlrp.sql
00:45:08 SQL> Rem ===========================================================================
Some output logs are trimmed.

Validate the upgraded component in registry$history views.

00:56:48 SQL> select * from registry$history ;

ACTION_TIME                  ACTION               NAMESPACE            VERSION            ID COMMENTS             BUNDLE_SERIES
  



Hope this help … :)

2 comments:

  1. I would like to thank you for the efforts you have made in writing this article. I am hoping the same best work from you in the future as well.

    Workday hcm Online Training

    ReplyDelete
  2. Thanks for sharing this great information I am impressed by the information that you have on this blog. Same as your blog i found another one Oracle Fusion Financials . Actually I was looking for the same information on internet for Oracle Fusion Financials and came across your blog. I am impressed by the information that you have on this blog. It shows how well you understand this subject, you can learn more aboutOracle Fusion Financials . By attending Oracle Fusion FinancialsTraining .


    ReplyDelete