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:
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.
·
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 ;
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 … :)
