- Download and install binary of 19c
- Copy listener.ora , tnsnames.ora to 19c network/admin location. (both primary and standby )
- Copy 12c spfile , pfile and password to new 19c dbs home location. (both primary and standby )
- Run preupgrade.jar and fix the requirements
- Create restore point before upgrade or take rman consistent backup
preupgrade.log
preupgrade_fixups.sql
postupgrade_fixups.sql
- Set oracle sid , home and start instance in upgrade mode
- Run dbupgrade at os level ( it will upgrade cbroot , pdseed and pdb database components )
- run utlusts.sql any time before or after you complete the upgrade
- Run utlrp.sql after upgrad for compling invalid objects
- Upgrade timezone from 18 to 32 run script below:
- Delete restore point created before upgrade
- change the compatible parameter 12c to 19c
[oracle@srv6 dbhome_1]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 17 14:07:43 2021
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, OLAP, Advanced Analytics and Real Application Testing options
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDB12C READ WRITE NO
Pluggable database altered.
SQL> SELECT ARCH.THREAD# "Thread", ARCH.SEQUENCE# "Last Sequence Received", APPL.SEQUENCE# "Last Sequence Applied", (ARCH.SEQUENCE# - APPL.SEQUENCE#) "Difference"
FROM
(SELECT THREAD# ,SEQUENCE# FROM V$ARCHIVED_LOG WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$ARCHIVED_LOG GROUP BY THREAD#)) ARCH,
(SELECT THREAD# ,SEQUENCE# FROM V$LOG_HISTORY WHERE (THREAD#,FIRST_TIME ) IN (SELECT THREAD#,MAX(FIRST_TIME) FROM V$LOG_HISTORY GROUP BY THREAD#)) APPL
WHERE
ARCH.THREAD# = APPL.THREAD#
; 2 3 4 5 6 7
Thread Last Sequence Received Last Sequence Applied Difference
---------- ---------------------- --------------------- ----------
1 45 45 0
1 45 45 0
SQL> exit
- Run preupgrade.jar for pre - upgrade stage
[oracle@srv6 bin]$ /u01/app/oracle/product/12.1.0/dbhome_1/jdk/bin/java -jar /u01/app/oracle/product/19.3/db_home/rdbms/admin/preupgrade.jar DIR /u01/preupgrade/
==================
PREUPGRADE SUMMARY
==================
/u01/preupgrade/preupgrade.log
/u01/preupgrade/preupgrade_fixups.sql
/u01/preupgrade/postupgrade_fixups.sql
Execute fixup scripts across the entire CDB:
Before upgrade:
1. Execute preupgrade fixups with the below command
$ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib -I$ORACLE_HOME/rdbms/admin $ORACLE_HOME/rdbms/admin/catcon.pl -l /u01/preupgrade/ -b preup_orcl12c /u01/preupgrade/preupgrade_fixups.sql
2. Review logs under /u01/preupgrade/
After the upgrade:
1. Execute postupgrade fixups with the below command
$ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib -I$ORACLE_HOME/rdbms/admin $ORACLE_HOME/rdbms/admin/catcon.pl -l /u01/preupgrade/ -b postup_orcl12c /u01/preupgrade/postupgrade_fixups.sql
2. Review logs under /u01/preupgrade/
Preupgrade complete: 2021-09-17T15:34:13
- pre upgrade log file and location
[oracle@srv6 preupgrade]$ lltotal 1032-rw-r--r-- 1 oracle oinstall 2 Sep 17 15:33 checksBuffer.tmp-rw-r--r-- 1 oracle oinstall 41134 Sep 17 15:33 components.properties-rw-r--r-- 1 oracle oinstall 15085 Sep 17 15:33 dbms_registry_extended.sql-rw-r--r-- 1 oracle oinstall 12342 Sep 17 15:33 dir_preUpgrade_catCon0.log-rw-r--r-- 1 oracle oinstall 6893 Sep 17 15:33 dir_preUpgrade_catCon1.log-rw-r--r-- 1 oracle oinstall 37451 Sep 17 15:29 dir_preUpgrade_catCon_catcon_6997.lst-rw-r--r-- 1 oracle oinstall 42234 Sep 17 15:33 dir_preUpgrade_catCon_catcon_7474.lst-rw-r--r-- 1 oracle oinstall 15419 Sep 17 15:34 execPreUpgrade_catCon0.log-rw-r--r-- 1 oracle oinstall 8790 Sep 17 15:34 execPreUpgrade_catCon1.log-rw-r--r-- 1 oracle oinstall 23471 Sep 17 15:29 execPreUpgrade_catCon_catcon_7086.lst-rw-r--r-- 1 oracle oinstall 42 Sep 17 15:29 execPreUpgrade_catCon_catcon_7114.done-rw-r--r-- 1 oracle oinstall 42 Sep 17 15:29 execPreUpgrade_catCon_catcon_7115.done-rw-r--r-- 1 oracle oinstall 43075 Sep 17 15:34 execPreUpgrade_catCon_catcon_7575.lstdrwxr-xr-x 3 oracle oinstall 4096 Sep 17 15:29 oracle-rw-r--r-- 1 oracle oinstall 14016 Sep 17 15:33 parameters.properties-rw-r--r-- 1 oracle oinstall 9255 Sep 17 15:33 postupgrade_fixups_CDB_ROOT.sql-rw-r--r-- 1 oracle oinstall 9245 Sep 17 15:33 postupgrade_fixups_PDB12C.sql-rw-r--r-- 1 oracle oinstall 9253 Sep 17 15:34 postupgrade_fixups_PDB_SEED.sql-rw-r--r-- 1 oracle oinstall 21402 Sep 17 15:34 postupgrade_fixups.sql-rw-r--r-- 1 oracle oinstall 8819 Sep 17 15:33 preupgrade_CDB_ROOT.log-rw-r--r-- 1 oracle oinstall 7884 Sep 17 15:33 preupgrade_driver.sql-rw-r--r-- 1 oracle oinstall 11231 Sep 17 15:33 preupgrade_fixups_CDB_ROOT.sql-rw-r--r-- 1 oracle oinstall 8770 Sep 17 15:33 preupgrade_fixups_PDB12C.sql-rw-r--r-- 1 oracle oinstall 8778 Sep 17 15:34 preupgrade_fixups_PDB_SEED.sql-rw-r--r-- 1 oracle oinstall 25302 Sep 17 15:34 preupgrade_fixups.sql-rw-r--r-- 1 oracle oinstall 23784 Sep 17 15:34 preupgrade.log-rw-r--r-- 1 oracle oinstall 100166 Sep 17 15:33 preupgrade_messages.properties-rw-r--r-- 1 oracle oinstall 455876 Sep 17 15:33 preupgrade_package.sql-rw-r--r-- 1 oracle oinstall 7480 Sep 17 15:34 preupgrade_PDB12C.log-rw-r--r-- 1 oracle oinstall 7485 Sep 17 15:34 preupgrade_PDB_SEED.logdrwxr-xr-x 3 oracle oinstall 4096 Sep 17 15:29 upgrade[oracle@srv6 preupgrade]$
- Fix preparade issue and proceed for further action .
[oracle@srv6 bin]$ sqlplus / as sysdba
SQL*Plus: Release 12.1.0.2.0 Production on Fri Sep 17 15:45:04 2021
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, OLAP, Advanced Analytics and Real Application Testing options
SQL> @/u01/preupgrade/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 19.0.0.0.0 Build: 1
Generated on: 2021-09-17 15:33:24
For Source Database: ORCL12C
Source Database Version: 12.1.0.2.0
For Upgrade to Version: 19.0.0.0.0
Executing in container: CDB$ROOT
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- --------------------------------
1. min_recovery_area_size NO Manual fixup required.
2. apex_manual_upgrade NO Manual fixup recommended.
3. dictionary_stats YES None.
4. pre_fixed_objects YES None.
5. tablespaces_info NO Informational only.
Further action is optional.
6. cycle_number NO Informational only.
Further action is optional.
7. rman_recovery_version NO Informational only.
Further action is optional.
The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database is not ready
for upgrade. To resolve the outstanding issues, start by reviewing
the preupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.
PL/SQL procedure successfully completed.
Session altered.
- Fix preparade requirements like increasing FRA size , Tablespace , statsgather , purge recyclebin
SQL> sho parameter db_reco
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string /u01/app/oracle/fast_recovery_
area
db_recovery_file_dest_size big integer 6560M
SQL> alter system set db_recovery_file_dest_size=15G scope=both;
System altered.
SQL> select name from v$datafile;
NAME
--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl12c/system01.dbf
/u01/app/oracle/oradata/orcl12c/sysaux01.dbf
/u01/app/oracle/oradata/orcl12c/undotbs01.dbf
/u01/app/oracle/oradata/orcl12c/pdbseed/system01.dbf
/u01/app/oracle/oradata/orcl12c/users01.dbf
/u01/app/oracle/oradata/orcl12c/pdbseed/sysaux01.dbf
/u01/app/oracle/oradata/orcl12c/pdb12c/system01.dbf
/u01/app/oracle/oradata/orcl12c/pdb12c/sysaux01.dbf
/u01/app/oracle/oradata/orcl12c/pdb12c/pdb12c_users01.dbf
9 rows selected.
SQL> !pwd
/u01/app/oracle/product/12.1.0/dbhome_1/jdk/bin
- Increase minimum tablespace datafile requirement in our case i have increase the size to 2GB autoextend in on
SQL> @/home/oracle/tablepsace.sql
NAME OPEN_MODE DATABASE_ROLE DB_UNIQUE_NAME
--------- -------------------- ---------------- ------------------------------
ORCL12C READ WRITE PRIMARY orcl12c
Tablespace Allocated Current Used Available %Used (vs)
Name Size(GB) Size(GB) Size(GB) Size(GB) (Allocated)
------------------------------ ------------ ------------ ------------ ------------ ------------
SYSAUX 32.00 .69 .65 31.35 2.04
SYSTEM 32.00 .78 .77 31.23 2.42
UNDOTBS1 32.00 .22 .07 31.93 .23
USERS 32.00 .00 .00 32.00 .00
SQL> alter database datafile '/u01/app/oracle/oradata/orcl12c/system01.dbf' resize 2g;
Database altered.
SQL> alter database datafile '/u01/app/oracle/oradata/orcl12c/sysaux01.dbf' resize 2g;
Database altered.
SQL> alter database datafile '/u01/app/oracle/oradata/orcl12c/undotbs01.dbf' resize 2g;
Database altered.
- Increase tempfile size
SQL> select name from v$tempfile;
NAME
---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
/u01/app/oracle/oradata/orcl12c/temp01.dbf
/u01/app/oracle/oradata/orcl12c/pdbseed/pdbseed_temp012021-08-27_02-19-18-PM.dbf
/u01/app/oracle/oradata/orcl12c/pdb12c/temp012021-08-27_02-19-18-PM.dbf
SQL> alter database tempfile '/u01/app/oracle/oradata/orcl12c/temp01.dbf' resize 1g;
Database altered.
- Stats gathering before upgrade
SQL> EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
PL/SQL procedure successfully completed.
SQL> EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
PL/SQL procedure successfully completed.
- Purge recyclebin
SQL> purge recyclebin;
Recyclebin purged.
- Again run to satisfy minimum requirements
SQL> @/u01/preupgrade/preupgrade_fixups.sql
Executing Oracle PRE-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script
Version: 19.0.0.0.0 Build: 1
Generated on: 2021-09-17 15:33:24
For Source Database: ORCL12C
Source Database Version: 12.1.0.2.0
For Upgrade to Version: 19.0.0.0.0
Executing in container: CDB$ROOT
Preup Preupgrade
Action Issue Is
Number Preupgrade Check Name Remedied Further DBA Action
------ ------------------------ ---------- --------------------------------
1. min_recovery_area_size NO Manual fixup required.
2. apex_manual_upgrade NO Manual fixup recommended.
3. dictionary_stats YES None.
4. pre_fixed_objects YES None.
5. tablespaces_info NO Informational only.
Further action is optional.
6. cycle_number NO Informational only.
Further action is optional.
7. rman_recovery_version NO Informational only.
Further action is optional.
The fixup scripts have been run and resolved what they can. However,
there are still issues originally identified by the preupgrade that
have not been remedied and are still present in the database.
Depending on the severity of the specific issue, and the nature of
the issue itself, that could mean that your database is not ready
for upgrade. To resolve the outstanding issues, start by reviewing
the preupgrade_fixups.sql and searching it for the name of
the failed CHECK NAME or Preupgrade Action Number listed above.
There you will find the original corresponding diagnostic message
from the preupgrade which explains in more detail what still needs
to be done.
PL/SQL procedure successfully completed.
Session altered.
- Create restore point or create consistent rman backup to save time ( if using DBUA restore point and backup option is mentioned )
SQL> SQL> create restore point before_upgrade_19c guarantee flashback database;
Restore point created.
SQL> select NAME,GUARANTEE_FLASHBACK_DATABASE,TIME from V$restore_point;
NAME GUA
-------------------------------------------------------------------------------------------------------------------------------- ---
TIME
---------------------------------------------------------------------------
BEFORE_UPGRADE_19C YES
17-SEP-21 04.33.58.000000000 PM
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
- Copy listener.ora and tnsnames.ora file in new into new oracle home from both primary and standby database.
[oracle@srv6 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/app/oracle/product/19.3/db_home/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
PDB =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv6.example.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = pdb.example.com)
)
)
TEST19C =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv6.example.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST19C)
)
)
TEST19CDR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv7.example.com)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST19CDR)
)
)
# Add 12c tnsnames.ora details into 19c tnsnames.ora file location
ORCL12C =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv6.example.com)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl12c)
)
)
ORCL12CDR =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv7.example.com)(PORT = 1523))
)
(CONNECT_DATA =
(SERVICE_NAME = orcl12cdr)
)
)
[oracle@srv6 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.3/db_home/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv6.example.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
# add LISTENER12C details into 19c listener.ora file
LISTENER12C =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv6.example.com)(PORT = 1523))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=TEST19C)
(SID_NAME=TEST19C)
(ORACLE_HOME=/u01/app/oracle/product/19.3/db_home)
)
)
- Set oracle 19c SID and Home for upgradation pre setup
[oracle@srv6 admin]$ export ORACLE_SID=orcl12c
[oracle@srv6 admin]$ export ORACLE_HOME=/u01/app/oracle/product/19.3/db_home
[oracle@srv6 admin]$ lsnrctl start listener12c
- Manual DB Upgrade
[oracle@srv6 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 17 18:02:50 2021Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup upgrade;ORACLE instance started.
Total System Global Area 1862269648 bytesFixed Size 9136848 bytesVariable Size 553648128 bytesDatabase Buffers 1291845632 bytesRedo Buffers 7639040 bytesDatabase mounted.Database opened.
SQL> select name,open_mode,status from v$database, v$instance;
NAME OPEN_MODE STATUS--------- -------------------- ------------ORCL12C READ WRITE OPEN MIGRATE
SQL> exit
- /u01/app/oracle/product/19.3/db_home/bin
[oracle@srv6 bin]$ ls -ltr dbupgrade-rwxr-x---. 1 oracle oinstall 3136 Apr 17 2019 dbupgrade[oracle@srv6 bin]$ pwd/u01/app/oracle/product/19.3/db_home/bin[oracle@srv6 bin]$ /u01/app/oracle/product/19.3/db_home/bin/dbupgrade
Argument list for [/u01/app/oracle/product/19.3/db_home/rdbms/admin/catctl.pl]For Oracle internal use only A = 0Run in c = 0Do not run in C = 0Input Directory d = 0Echo OFF e = 1Simulate E = 0Forced cleanup F = 0Log Id i = 0Child Process I = 0Log Dir l = 0Priority List Name L = 0Upgrade Mode active M = 0SQL Process Count n = 0SQL PDB Process Count N = 0Open Mode Normal o = 0Start Phase p = 0End Phase P = 0Reverse Order r = 0AutoUpgrade Resume R = 0Script s = 0Serial Run S = 0RO User Tablespaces T = 0Display Phases y = 0Debug catcon.pm z = 0Debug catctl.pl Z = 0
catctl.pl VERSION: [19.0.0.0.0] STATUS: [Production] BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]
/u01/app/oracle/product/19.3/db_home/rdbms/admin/orahome = [/u01/app/oracle/product/19.3/db_home]/u01/app/oracle/product/19.3/db_home/bin/orabasehome = [/u01/app/oracle/product/19.3/db_home]catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.3/db_home]
Analyzing file /u01/app/oracle/product/19.3/db_home/rdbms/admin/catupgrd.sql
Log file directory = [/tmp/cfgtoollogs/upgrade20210917180617]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20210917180617/catupgrd_catcon_17519.lst]
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20210917180617/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20210917180617/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 1Database Name = orcl12cDataBase Version = 12.1.0.2.0catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdcdbroot_catcon_17519.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdcdbroot*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdcdbroot_*.lst] files for spool files, if any
Log file directory = [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633]
PDB Parallel SQL Process Count = [2] is higher or equal to CPU Count = [1]Concurrent PDB Upgrades defaulting to CPU Count [1]Parallel SQL Process Count (PDB) = 2Parallel SQL Process Count (CDB$ROOT) = 4Concurrent PDB Upgrades = 1Generated PDB Inclusion:[PDB$SEED PDB12C]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-107] Start Time:[2021_09_17 18:06:53]Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]------------------------------------------------------*********** Executing Change Scripts ***********Serial Phase #:0 [CDB$ROOT] Files:1 Time: 104s*************** Catalog Core SQL ***************Serial Phase #:1 [CDB$ROOT] Files:5 Time: 83sRestart Phase #:2 [CDB$ROOT] Files:1 Time: 2s*********** Catalog Tables and Views ***********Parallel Phase #:3 [CDB$ROOT] Files:19 Time: 48sRestart Phase #:4 [CDB$ROOT] Files:1 Time: 1s************* Catalog Final Scripts ************Serial Phase #:5 [CDB$ROOT] Files:7 Time: 34s***************** Catproc Start ****************Serial Phase #:6 [CDB$ROOT] Files:1 Time: 30s***************** Catproc Types ****************Serial Phase #:7 [CDB$ROOT] Files:2 Time: 28sRestart Phase #:8 [CDB$ROOT] Files:1 Time: 1s**************** Catproc Tables ****************Parallel Phase #:9 [CDB$ROOT] Files:67 Time: 82sRestart Phase #:10 [CDB$ROOT] Files:1 Time: 2s************* Catproc Package Specs ************Serial Phase #:11 [CDB$ROOT] Files:1 Time: 141sRestart Phase #:12 [CDB$ROOT] Files:1 Time: 2s************** Catproc Procedures **************Parallel Phase #:13 [CDB$ROOT] Files:94 Time: 36sRestart Phase #:14 [CDB$ROOT] Files:1 Time: 2sParallel Phase #:15 [CDB$ROOT] Files:120 Time: 62sRestart Phase #:16 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:17 [CDB$ROOT] Files:22 Time: 11sRestart Phase #:18 [CDB$ROOT] Files:1 Time: 1s***************** Catproc Views ****************Parallel Phase #:19 [CDB$ROOT] Files:32 Time: 68sRestart Phase #:20 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:21 [CDB$ROOT] Files:3 Time: 32sRestart Phase #:22 [CDB$ROOT] Files:1 Time: 2sParallel Phase #:23 [CDB$ROOT] Files:25 Time: 227sRestart Phase #:24 [CDB$ROOT] Files:1 Time: 3sParallel Phase #:25 [CDB$ROOT] Files:12 Time: 134sRestart Phase #:26 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:27 [CDB$ROOT] Files:1 Time: 0sSerial Phase #:28 [CDB$ROOT] Files:3 Time: 14sSerial Phase #:29 [CDB$ROOT] Files:1 Time: 0sRestart Phase #:30 [CDB$ROOT] Files:1 Time: 1s*************** Catproc CDB Views **************Serial Phase #:31 [CDB$ROOT] Files:1 Time: 7sRestart Phase #:32 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:34 [CDB$ROOT] Files:1 Time: 0s***************** Catproc PLBs *****************Serial Phase #:35 [CDB$ROOT] Files:293 Time: 62sSerial Phase #:36 [CDB$ROOT] Files:1 Time: 0sRestart Phase #:37 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:38 [CDB$ROOT] Files:6 Time: 14sRestart Phase #:39 [CDB$ROOT] Files:1 Time: 1s*************** Catproc DataPump ***************Serial Phase #:40 [CDB$ROOT] Files:3 Time: 101sRestart Phase #:41 [CDB$ROOT] Files:1 Time: 1s****************** Catproc SQL *****************Parallel Phase #:42 [CDB$ROOT] Files:13 Time: 156sRestart Phase #:43 [CDB$ROOT] Files:1 Time: 1sParallel Phase #:44 [CDB$ROOT] Files:11 Time: 31sRestart Phase #:45 [CDB$ROOT] Files:1 Time: 1sParallel Phase #:46 [CDB$ROOT] Files:3 Time: 10sRestart Phase #:47 [CDB$ROOT] Files:1 Time: 2s************* Final Catproc scripts ************Serial Phase #:48 [CDB$ROOT] Files:1 Time: 17sRestart Phase #:49 [CDB$ROOT] Files:1 Time: 1s************** Final RDBMS scripts *************Serial Phase #:50 [CDB$ROOT] Files:1 Time: 44s************ Upgrade Component Start ***********Serial Phase #:51 [CDB$ROOT] Files:1 Time: 7sRestart Phase #:52 [CDB$ROOT] Files:1 Time: 0s********** Upgrading Java and non-Java *********Serial Phase #:53 [CDB$ROOT] Files:2 Time: 894s***************** Upgrading XDB ****************Restart Phase #:54 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:56 [CDB$ROOT] Files:3 Time: 27sSerial Phase #:57 [CDB$ROOT] Files:3 Time: 13sParallel Phase #:58 [CDB$ROOT] Files:10 Time: 15sParallel Phase #:59 [CDB$ROOT] Files:25 Time: 18sSerial Phase #:60 [CDB$ROOT] Files:4 Time: 20sSerial Phase #:61 [CDB$ROOT] Files:1 Time: 0sSerial Phase #:62 [CDB$ROOT] Files:32 Time: 13sSerial Phase #:63 [CDB$ROOT] Files:1 Time: 0sParallel Phase #:64 [CDB$ROOT] Files:6 Time: 14sSerial Phase #:65 [CDB$ROOT] Files:2 Time: 42sSerial Phase #:66 [CDB$ROOT] Files:3 Time: 75s**************** Upgrading ORDIM ***************Restart Phase #:67 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:69 [CDB$ROOT] Files:1 Time: 10sParallel Phase #:70 [CDB$ROOT] Files:2 Time: 82sRestart Phase #:71 [CDB$ROOT] Files:1 Time: 2sParallel Phase #:72 [CDB$ROOT] Files:2 Time: 10sSerial Phase #:73 [CDB$ROOT] Files:2 Time: 9s***************** Upgrading SDO ****************Restart Phase #:74 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:76 [CDB$ROOT] Files:1 Time: 69sSerial Phase #:77 [CDB$ROOT] Files:2 Time: 11sRestart Phase #:78 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:79 [CDB$ROOT] Files:1 Time: 37sRestart Phase #:80 [CDB$ROOT] Files:1 Time: 1sParallel Phase #:81 [CDB$ROOT] Files:3 Time: 140sRestart Phase #:82 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:83 [CDB$ROOT] Files:1 Time: 15sRestart Phase #:84 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:85 [CDB$ROOT] Files:1 Time: 22sRestart Phase #:86 [CDB$ROOT] Files:1 Time: 1sParallel Phase #:87 [CDB$ROOT] Files:4 Time: 209sRestart Phase #:88 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:89 [CDB$ROOT] Files:1 Time: 9sRestart Phase #:90 [CDB$ROOT] Files:1 Time: 2sSerial Phase #:91 [CDB$ROOT] Files:2 Time: 19sRestart Phase #:92 [CDB$ROOT] Files:1 Time: 1sSerial Phase #:93 [CDB$ROOT] Files:1 Time: 7sRestart Phase #:94 [CDB$ROOT] Files:1 Time: 0s******* Upgrading ODM, WK, EXF, RUL, XOQ *******Serial Phase #:95 [CDB$ROOT] Files:1 Time: 32sRestart Phase #:96 [CDB$ROOT] Files:1 Time: 0s*********** Final Component scripts ***********Serial Phase #:97 [CDB$ROOT] Files:1 Time: 9s************* Final Upgrade scripts ************Serial Phase #:98 [CDB$ROOT] Files:1 Time: 351s******************* Migration ******************Serial Phase #:99 [CDB$ROOT] Files:1 Time: 100s*** End PDB Application Upgrade Pre-Shutdown ***Serial Phase #:100 [CDB$ROOT] Files:1 Time: 10sSerial Phase #:101 [CDB$ROOT] Files:1 Time: 5sSerial Phase #:102 [CDB$ROOT] Files:1 Time: 167s***************** Post Upgrade *****************Serial Phase #:103 [CDB$ROOT] Files:1 Time: 63s**************** Summary report ****************Serial Phase #:104 [CDB$ROOT] Files:1 Time: 8s*** End PDB Application Upgrade Post-Shutdown **Serial Phase #:105 [CDB$ROOT] Files:1 Time: 7sSerial Phase #:106 [CDB$ROOT] Files:1 Time: 4sSerial Phase #:107 [CDB$ROOT] Files:1 Time: 85s
------------------------------------------------------Phases [0-107] End Time:[2021_09_17 19:17:41]Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]------------------------------------------------------
Start processing of PDBs (PDB$SEED)[/u01/app/oracle/product/19.3/db_home/perl/bin/perl /u01/app/oracle/product/19.3/db_home/rdbms/admin/catctl.pl -I -i pdb_seed -n 2 -c 'PDB$SEED' -l /u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633 /u01/app/oracle/product/19.3/db_home/rdbms/admin/catupgrd.sql]
Argument list for [/u01/app/oracle/product/19.3/db_home/rdbms/admin/catctl.pl]For Oracle internal use only A = 0Run in c = PDB$SEEDDo not run in C = 0Input Directory d = 0Echo OFF e = 1Simulate E = 0Forced cleanup F = 0Log Id i = pdb_seedChild Process I = 1Log Dir l = /u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633Priority List Name L = 0Upgrade Mode active M = 0SQL Process Count n = 2SQL PDB Process Count N = 0Open Mode Normal o = 0Start Phase p = 0End Phase P = 0Reverse Order r = 0AutoUpgrade Resume R = 0Script s = 0Serial Run S = 0RO User Tablespaces T = 0Display Phases y = 0Debug catcon.pm z = 0Debug catctl.pl Z = 0
catctl.pl VERSION: [19.0.0.0.0] STATUS: [Production] BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]
/u01/app/oracle/product/19.3/db_home/rdbms/admin/orahome = [/u01/app/oracle/product/19.3/db_home]/u01/app/oracle/product/19.3/db_home/bin/orabasehome = [/u01/app/oracle/product/19.3/db_home]catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.3/db_home]
Analyzing file /u01/app/oracle/product/19.3/db_home/rdbms/admin/catupgrd.sql
Log file directory = [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdpdb_seed_catcon_28084.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdpdb_seed*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdpdb_seed_*.lst] files for spool files, if any
Number of Cpus = 1Database Name = orcl12cDataBase Version = 19.0.0.0.0PDB$SEED Open Mode = [MIGRATE]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-107] Start Time:[2021_09_17 19:18:57]Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]------------------------------------------------------*********** Executing Change Scripts ***********Serial Phase #:0 [PDB$SEED] Files:1 Time: 82s*************** Catalog Core SQL ***************Serial Phase #:1 [PDB$SEED] Files:5 Time: 85sRestart Phase #:2 [PDB$SEED] Files:1 Time: 1s*********** Catalog Tables and Views ***********Parallel Phase #:3 [PDB$SEED] Files:19 Time: 60sRestart Phase #:4 [PDB$SEED] Files:1 Time: 1s************* Catalog Final Scripts ************Serial Phase #:5 [PDB$SEED] Files:7 Time: 43s***************** Catproc Start ****************Serial Phase #:6 [PDB$SEED] Files:1 Time: 24s***************** Catproc Types ****************Serial Phase #:7 [PDB$SEED] Files:2 Time: 16sRestart Phase #:8 [PDB$SEED] Files:1 Time: 2s**************** Catproc Tables ****************Parallel Phase #:9 [PDB$SEED] Files:67 Time: 67sRestart Phase #:10 [PDB$SEED] Files:1 Time: 1s************* Catproc Package Specs ************Serial Phase #:11 [PDB$SEED] Files:1 Time: 91sRestart Phase #:12 [PDB$SEED] Files:1 Time: 1s************** Catproc Procedures **************Parallel Phase #:13 [PDB$SEED] Files:94 Time: 19sRestart Phase #:14 [PDB$SEED] Files:1 Time: 1sParallel Phase #:15 [PDB$SEED] Files:120 Time: 26sRestart Phase #:16 [PDB$SEED] Files:1 Time: 2sSerial Phase #:17 [PDB$SEED] Files:22 Time: 9sRestart Phase #:18 [PDB$SEED] Files:1 Time: 1s***************** Catproc Views ****************Parallel Phase #:19 [PDB$SEED] Files:32 Time: 73sRestart Phase #:20 [PDB$SEED] Files:1 Time: 2sSerial Phase #:21 [PDB$SEED] Files:3 Time: 30sRestart Phase #:22 [PDB$SEED] Files:1 Time: 1sParallel Phase #:23 [PDB$SEED] Files:25
Time: 418sRestart Phase #:24 [PDB$SEED] Files:1 Time: 2sParallel Phase #:25 [PDB$SEED] Files:12 Time: 122sRestart Phase #:26 [PDB$SEED] Files:1 Time: 1sSerial Phase #:27 [PDB$SEED] Files:1 Time: 0sSerial Phase #:28 [PDB$SEED] Files:3 Time: 32sSerial Phase #:29 [PDB$SEED] Files:1 Time: 0sRestart Phase #:30 [PDB$SEED] Files:1 Time: 1s*************** Catproc CDB Views **************Serial Phase #:31 [PDB$SEED] Files:1 Time: 7sRestart Phase #:32 [PDB$SEED] Files:1 Time: 1sSerial Phase #:34 [PDB$SEED] Files:1 Time: 0s***************** Catproc PLBs *****************Serial Phase #:35 [PDB$SEED] Files:293 Time: 173sSerial Phase #:36 [PDB$SEED] Files:1 Time: 0sRestart Phase #:37 [PDB$SEED] Files:1 Time: 1sSerial Phase #:38 [PDB$SEED] Files:6 Time: 11sRestart Phase #:39 [PDB$SEED] Files:1 Time: 1s*************** Catproc DataPump ***************Serial Phase #:40 [PDB$SEED] Files:3 Time: 65sRestart Phase #:41 [PDB$SEED] Files:1 Time: 1s****************** Catproc SQL *****************Parallel Phase #:42 [PDB$SEED] Files:13 Time: 136sRestart Phase #:43 [PDB$SEED] Files:1 Time: 1sParallel Phase #:44 [PDB$SEED] Files:11 Time: 17sRestart Phase #:45 [PDB$SEED] Files:1 Time: 1sParallel Phase #:46 [PDB$SEED] Files:3 Time: 9sRestart Phase #:47 [PDB$SEED] Files:1 Time: 1s************* Final Catproc scripts ************Serial Phase #:48 [PDB$SEED] Files:1 Time: 17sRestart Phase #:49 [PDB$SEED] Files:1 Time: 2s************** Final RDBMS scripts *************Serial Phase #:50 [PDB$SEED] Files:1 Time: 29s************ Upgrade Component Start ***********Serial Phase #:51 [PDB$SEED] Files:1 Time: 7sRestart Phase #:52 [PDB$SEED] Files:1 Time: 2s********** Upgrading Java and non-Java *********Serial Phase #:53 [PDB$SEED] Files:2 Time: 521s***************** Upgrading XDB ****************Restart Phase #:54 [PDB$SEED] Files:1 Time: 1sSerial Phase #:56 [PDB$SEED] Files:3 Time: 24sSerial Phase #:57 [PDB$SEED] Files:3 Time: 11sParallel Phase #:58 [PDB$SEED] Files:10 Time: 12sParallel Phase #:59 [PDB$SEED] Files:25 Time: 15sSerial Phase #:60 [PDB$SEED] Files:4 Time: 32sSerial Phase #:61 [PDB$SEED] Files:1 Time: 0sSerial Phase #:62 [PDB$SEED] Files:32 Time: 20sSerial Phase #:63 [PDB$SEED] Files:1 Time: 0sParallel Phase #:64 [PDB$SEED] Files:6 Time: 15sSerial Phase #:65 [PDB$SEED] Files:2 Time: 34sSerial Phase #:66 [PDB$SEED] Files:3 Time: 53s**************** Upgrading ORDIM ***************Restart Phase #:67 [PDB$SEED] Files:1 Time: 1sSerial Phase #:69 [PDB$SEED] Files:1 Time: 9sParallel Phase #:70 [PDB$SEED] Files:2 Time: 45sRestart Phase #:71 [PDB$SEED] Files:1 Time: 3sParallel Phase #:72 [PDB$SEED] Files:2 Time: 9sSerial Phase #:73 [PDB$SEED] Files:2 Time: 9s***************** Upgrading SDO ****************Restart Phase #:74 [PDB$SEED] Files:1 Time: 2sSerial Phase #:76 [PDB$SEED] Files:1 Time: 51sSerial Phase #:77 [PDB$SEED] Files:2 Time: 10sRestart Phase #:78 [PDB$SEED] Files:1 Time: 2sSerial Phase #:79 [PDB$SEED] Files:1 Time: 12sRestart Phase #:80 [PDB$SEED] Files:1 Time: 2sParallel Phase #:81 [PDB$SEED] Files:3 Time: 95sRestart Phase #:82 [PDB$SEED] Files:1 Time: 2sSerial Phase #:83 [PDB$SEED] Files:1 Time: 16sRestart Phase #:84 [PDB$SEED] Files:1 Time: 2sSerial Phase #:85 [PDB$SEED] Files:1 Time: 20sRestart Phase #:86 [PDB$SEED] Files:1 Time: 2sParallel Phase #:87 [PDB$SEED] Files:4 Time: 177sRestart Phase #:88 [PDB$SEED] Files:1 Time: 2sSerial Phase #:89 [PDB$SEED] Files:1 Time: 8sRestart Phase #:90 [PDB$SEED] Files:1 Time: 1sSerial Phase #:91 [PDB$SEED] Files:2 Time: 23sRestart Phase #:92 [PDB$SEED] Files:1 Time: 2sSerial Phase #:93 [PDB$SEED] Files:1 Time: 6sRestart Phase #:94 [PDB$SEED] Files:1 Time: 2s******* Upgrading ODM, WK, EXF, RUL, XOQ *******Serial Phase #:95 [PDB$SEED] Files:1 Time: 21sRestart Phase #:96 [PDB$SEED] Files:1 Time: 2s*********** Final Component scripts ***********Serial Phase #:97 [PDB$SEED] Files:1 Time: 9s************* Final Upgrade scripts ************Serial Phase #:98 [PDB$SEED] Files:1 Time: 169s******************* Migration ******************Serial Phase #:99 [PDB$SEED] Files:1 Time: 60s*** End PDB Application Upgrade Pre-Shutdown ***Serial Phase #:100 [PDB$SEED] Files:1 Time: 7sSerial Phase #:101 [PDB$SEED] Files:1 Time: 8sSerial Phase #:102 [PDB$SEED] Files:1 Time: 9s***************** Post Upgrade *****************Serial Phase #:103 [PDB$SEED] Files:1 Time: 1083s**************** Summary report ****************Serial Phase #:104 [PDB$SEED] Files:1 Time: 7s*** End PDB Application Upgrade Post-Shutdown **Serial Phase #:105 [PDB$SEED] Files:1 Time: 7sSerial Phase #:106 [PDB$SEED] Files:1 Time: 5sSerial Phase #:107 [PDB$SEED] Files:1 Time: 0s
------------------------------------------------------Phases [0-107] End Time:[2021_09_17 20:31:12]Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]------------------------------------------------------
Grand Total Time: 4347s [PDB$SEED]
LOG FILES: (/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdpdb_seed*.log)
Upgrade Summary Report Located in:/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/upg_summary.log
Start processing of PDBs (PDB12C)[/u01/app/oracle/product/19.3/db_home/perl/bin/perl /u01/app/oracle/product/19.3/db_home/rdbms/admin/catctl.pl -I -i pdb12c -n 2 -c 'PDB12C' -l /u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633 /u01/app/oracle/product/19.3/db_home/rdbms/admin/catupgrd.sql]
Argument list for [/u01/app/oracle/product/19.3/db_home/rdbms/admin/catctl.pl]For Oracle internal use only A = 0Run in c = PDB12CDo not run in C = 0Input Directory d = 0Echo OFF e = 1Simulate E = 0Forced cleanup F = 0Log Id i = pdb12cChild Process I = 1Log Dir l = /u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633Priority List Name L = 0Upgrade Mode active M = 0SQL Process Count n = 2SQL PDB Process Count N = 0Open Mode Normal o = 0Start Phase p = 0End Phase P = 0Reverse Order r = 0AutoUpgrade Resume R = 0Script s = 0Serial Run S = 0RO User Tablespaces T = 0Display Phases y = 0Debug catcon.pm z = 0Debug catctl.pl Z = 0
catctl.pl VERSION: [19.0.0.0.0] STATUS: [Production] BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]
/u01/app/oracle/product/19.3/db_home/rdbms/admin/orahome = [/u01/app/oracle/product/19.3/db_home]/u01/app/oracle/product/19.3/db_home/bin/orabasehome = [/u01/app/oracle/product/19.3/db_home]catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.3/db_home]
Analyzing file /u01/app/oracle/product/19.3/db_home/rdbms/admin/catupgrd.sql
Log file directory = [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdpdb12c_catcon_5400.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdpdb12c*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdpdb12c_*.lst] files for spool files, if any
Number of Cpus = 1Database Name = orcl12cDataBase Version = 19.0.0.0.0PDB12C Open Mode = [MIGRATE]Generated PDB Inclusion:[PDB12C]CDB$ROOT Open Mode = [OPEN]Components in [PDB12C] 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-107] Start Time:[2021_09_17 20:32:08]Container Lists Inclusion:[PDB12C] Exclusion:[NONE]------------------------------------------------------*********** Executing Change Scripts ***********Serial Phase #:0 [PDB12C] Files:1 Time: 71s*************** Catalog Core SQL ***************Serial Phase #:1 [PDB12C] Files:5 Time: 64sRestart Phase #:2 [PDB12C] Files:1 Time: 1s*********** Catalog Tables and Views ***********Parallel Phase #:3 [PDB12C] Files:19 Time: 39sRestart Phase #:4 [PDB12C] Files:1 Time: 1s************* Catalog Final Scripts ************Serial Phase #:5 [PDB12C] Files:7 Time: 30s***************** Catproc Start ****************Serial Phase #:6 [PDB12C] Files:1 Time: 19s***************** Catproc Types ****************Serial Phase #:7 [PDB12C] Files:2 Time: 16sRestart Phase #:8 [PDB12C] Files:1 Time: 1s**************** Catproc Tables ****************Parallel Phase #:9 [PDB12C] Files:67 Time: 56sRestart Phase #:10 [PDB12C] Files:1 Time: 2s************* Catproc Package Specs ************Serial Phase #:11 [PDB12C] Files:1 Time: 85sRestart Phase #:12 [PDB12C] Files:1 Time: 1s************** Catproc Procedures **************Parallel Phase #:13 [PDB12C] Files:94 Time: 21sRestart Phase #:14 [PDB12C] Files:1 Time: 1sParallel Phase #:15 [PDB12C] Files:120 Time: 26sRestart Phase #:16 [PDB12C] Files:1 Time: 2sSerial Phase #:17 [PDB12C] Files:22 Time: 9sRestart Phase #:18 [PDB12C] Files:1 Time: 0s***************** Catproc Views ****************Parallel Phase #:19 [PDB12C] Files:32 Time: 44sRestart Phase #:20 [PDB12C] Files:1 Time: 2sSerial Phase #:21 [PDB12C] Files:3 Time: 28sRestart Phase #:22 [PDB12C] Files:1 Time: 2sParallel Phase #:23 [PDB12C] Files:25 Time: 203sRestart Phase #:24 [PDB12C] Files:1 Time: 2sParallel Phase #:25 [PDB12C] Files:12 Time: 116sRestart Phase #:26 [PDB12C] Files:1 Time: 2sSerial Phase #:27 [PDB12C] Files:1 Time: 0sSerial Phase #:28 [PDB12C] Files:3 Time: 10sSerial Phase #:29 [PDB12C] Files:1 Time: 0sRestart Phase #:30 [PDB12C] Files:1 Time: 2s*************** Catproc CDB Views **************Serial Phase #:31 [PDB12C] Files:1 Time: 7sRestart Phase #:32 [PDB12C] Files:1 Time: 0sSerial Phase #:34 [PDB12C] Files:1 Time: 0s***************** Catproc PLBs *****************Serial Phase #:35 [PDB12C] Files:293 Time: 35sSerial Phase #:36 [PDB12C] Files:1 Time: 0sRestart Phase #:37 [PDB12C] Files:1 Time: 1sSerial Phase #:38 [PDB12C] Files:6 Time: 9sRestart Phase #:39 [PDB12C] Files:1 Time: 0s*************** Catproc DataPump ***************Serial Phase #:40 [PDB12C] Files:3 Time: 66sRestart Phase #:41 [PDB12C] Files:1 Time: 2s****************** Catproc SQL *****************Parallel Phase #:42 [PDB12C] Files:13 Time: 147sRestart Phase #:43 [PDB12C] Files:1 Time: 2sParallel Phase #:44 [PDB12C] Files:11 Time: 14sRestart Phase #:45 [PDB12C] Files:1 Time: 1sParallel Phase #:46 [PDB12C] Files:3 Time: 8sRestart Phase #:47 [PDB12C] Files:1 Time: 2s************* Final Catproc scripts ************Serial Phase #:48 [PDB12C] Files:1 Time: 16sRestart Phase #:49 [PDB12C] Files:1 Time: 2s************** Final RDBMS scripts *************Serial Phase #:50 [PDB12C] Files:1 Time: 31s************ Upgrade Component Start ***********Serial Phase #:51 [PDB12C] Files:1 Time: 7sRestart Phase #:52 [PDB12C] Files:1 Time: 1s********** Upgrading Java and non-Java *********Serial Phase #:53 [PDB12C] Files:2 Time: 432s***************** Upgrading XDB ****************Restart Phase #:54 [PDB12C] Files:1 Time: 1sSerial Phase #:56 [PDB12C] Files:3 Time: 23sSerial Phase #:57 [PDB12C] Files:3 Time: 10sParallel Phase #:58 [PDB12C] Files:10 Time: 12sParallel Phase #:59 [PDB12C] Files:25 Time: 14sSerial Phase #:60 [PDB12C] Files:4 Time: 20sSerial Phase #:61 [PDB12C] Files:1 Time: 0sSerial Phase #:62 [PDB12C] Files:32 Time: 11sSerial Phase #:63 [PDB12C] Files:1 Time: 0sParallel Phase #:64 [PDB12C] Files:6 Time: 14sSerial Phase #:65 [PDB12C] Files:2 Time: 34sSerial Phase #:66 [PDB12C] Files:3 Time: 45s**************** Upgrading ORDIM ***************Restart Phase #:67 [PDB12C] Files:1 Time: 1sSerial Phase #:69 [PDB12C] Files:1 Time: 8sParallel Phase #:70 [PDB12C] Files:2 Time: 36sRestart Phase #:71 [PDB12C] Files:1 Time: 2sParallel Phase #:72 [PDB12C] Files:2 Time: 9sSerial Phase #:73 [PDB12C] Files:2 Time: 9s***************** Upgrading SDO ****************Restart Phase #:74 [PDB12C] Files:1 Time: 1sSerial Phase #:76 [PDB12C] Files:1 Time: 46sSerial Phase #:77 [PDB12C] Files:2 Time: 10sRestart Phase #:78 [PDB12C] Files:1 Time: 0sSerial Phase #:79 [PDB12C] Files:1 Time: 12sRestart Phase #:80 [PDB12C] Files:1 Time: 1sParallel Phase #:81 [PDB12C] Files:3 Time: 82sRestart Phase #:82 [PDB12C] Files:1 Time: 2sSerial Phase #:83 [PDB12C] Files:1 Time: 10sRestart Phase #:84 [PDB12C] Files:1 Time: 1sSerial Phase #:85 [PDB12C] Files:1 Time: 19sRestart Phase #:86 [PDB12C] Files:1 Time: 0sParallel Phase #:87 [PDB12C] Files:4 Time: 95sRestart Phase #:88 [PDB12C] Files:1 Time: 1sSerial Phase #:89 [PDB12C] Files:1 Time: 9sRestart Phase #:90 [PDB12C] Files:1 Time: 1sSerial Phase #:91 [PDB12C] Files:2 Time: 25sRestart Phase #:92 [PDB12C] Files:1 Time: 2sSerial Phase #:93 [PDB12C] Files:1 Time: 6sRestart Phase #:94 [PDB12C] Files:1 Time: 2s******* Upgrading ODM, WK, EXF, RUL, XOQ *******Serial Phase #:95 [PDB12C] Files:1 Time: 18sRestart Phase #:96 [PDB12C] Files:1 Time: 1s*********** Final Component scripts ***********Serial Phase #:97 [PDB12C] Files:1 Time: 7s************* Final Upgrade scripts ************Serial Phase #:98 [PDB12C] Files:1 Time: 168s******************* Migration ******************Serial Phase #:99 [PDB12C] Files:1 Time: 65s*** End PDB Application Upgrade Pre-Shutdown ***Serial Phase #:100 [PDB12C] Files:1 Time: 7sSerial Phase #:101 [PDB12C] Files:1 Time: 16sSerial Phase #:102 [PDB12C] Files:1 Time: 11s***************** Post Upgrade *****************Serial Phase #:103 [PDB12C] Files:1 Time: 73s**************** Summary report ****************Serial Phase #:104 [PDB12C] Files:1 Time: 8s*** End PDB Application Upgrade Post-Shutdown **Serial Phase #:105 [PDB12C] Files:1 Time: 6sSerial Phase #:106 [PDB12C] Files:1 Time: 6sSerial Phase #:107 [PDB12C] Files:1 Time: 0s
------------------------------------------------------Phases [0-107] End Time:[2021_09_17 21:15:28]Container Lists Inclusion:[PDB12C] Exclusion:[NONE]------------------------------------------------------
Grand Total Time: 2605s [PDB12C]
LOG FILES: (/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdpdb12c*.log)
Upgrade Summary Report Located in:/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/upg_summary.log
Time: 4247s For CDB$ROOT Time: 7079s For PDB(s)
Grand Total Time: 11326s
LOG FILES: (/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/catupgrdcdbroot*.log)
Upgrade Summary Report Located in:/u01/app/oracle/product/19.3/db_home/cfgtoollogs/orcl12c/upgrade20210917180633/upg_summary.log
Grand Total Upgrade Time: [0d:3h:8m:46s]
- Set oracle home
- Run utlusts.sql any time before or after you complete the upgrade ( The script verifies that all issues are fixed.)
SQL> @/u01/app/oracle/product/19.3/db_home/rdbms/admin/utlusts.sqlEnter value for 1:
Oracle Database Release 19 Post-Upgrade Status Tool 09-17-2021 22:13:3Container Database: ORCL12C[CON_ID: 1 => CDB$ROOT]
Component Current Full Elapsed TimeName Status Version HH:MM:SS
Oracle Server UPGRADED 19.3.0.0.0 00:26:42JServer JAVA Virtual Machine UPGRADED 19.3.0.0.0 00:08:19Oracle XDK UPGRADED 19.3.0.0.0 00:01:56Oracle Database Java Packages UPGRADED 19.3.0.0.0 00:00:34OLAP Analytic Workspace UPGRADED 19.3.0.0.0 00:00:37Oracle Label Security UPGRADED 19.3.0.0.0 00:00:13Oracle Database Vault UPGRADED 19.3.0.0.0 00:00:33Oracle Text UPGRADED 19.3.0.0.0 00:01:17Oracle Workspace Manager UPGRADED 19.3.0.0.0 00:01:12Oracle Real Application Clusters UPGRADED 19.3.0.0.0 00:00:00Oracle XML Database UPGRADED 19.3.0.0.0 00:03:46Oracle Multimedia UPGRADED 19.3.0.0.0 00:01:43Spatial UPGRADED 19.3.0.0.0 00:08:49Oracle OLAP API UPGRADED 19.3.0.0.0 00:00:24Datapatch 00:05:21Final Actions 00:07:30Post Upgrade 00:00:49
Total Upgrade Time: 01:05:37 [CON_ID: 1 => CDB$ROOT]
Database time zone version is 18. It is older than current release timezone version 32. Time zone upgrade is needed using the DBMS_DST package.- recompile invalid objects
SQL> @/u01/app/oracle/product/19.3/db_home/rdbms/admin/utlrp.sql
TIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMP UTLRP_BGN 2021-09-17 22:16:34DOC> The following PL/SQL block invokes UTL_RECOMP to recompile invalidDOC> objects in the database. Recompilation time is proportional to theDOC> number of invalid objects in the database, so this command may takeDOC> a long time to execute on a database with a large number of invalidDOC> objects.DOC>DOC> Use the following queries to track recompilation progress:DOC>DOC> 1. Query returning the number of invalid objects remaining. ThisDOC> number should decrease with time.DOC> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);DOC>DOC> 2. Query returning the number of objects compiled so far. This numberDOC> should increase with time.DOC> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;DOC>DOC> This script automatically chooses serial or parallel recompilationDOC> based on the number of CPUs available (parameter cpu_count) multipliedDOC> by the number of threads per CPU (parameter parallel_threads_per_cpu).DOC> On RAC, this number is added across all RAC nodes.DOC>DOC> UTL_RECOMP uses DBMS_SCHEDULER to create jobs for parallelDOC> recompilation. Jobs are created without instance affinity so that theyDOC> can migrate across RAC nodes. Use the following queries to verifyDOC> whether UTL_RECOMP jobs are being created and run correctly:DOC>DOC> 1. Query showing jobs created by UTL_RECOMPDOC> SELECT job_name FROM dba_scheduler_jobsDOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';DOC>DOC> 2. Query showing UTL_RECOMP jobs that are runningDOC> SELECT job_name FROM dba_scheduler_running_jobsDOC> WHERE job_name like 'UTL_RECOMP_SLAVE_%';DOC>#
TIMESTAMP--------------------------------------------------------------------------------COMP_TIMESTAMP UTLRP_END 2021-09-17 22:17:00DOC> The following query reports the number of invalid objects.DOC>DOC> If the number is higher than expected, please examine the errorDOC> messages reported with each object (using SHOW ERRORS) to see if theyDOC> point to system misconfiguration or resource constraints that must beDOC> fixed before attempting to recompile these objects.DOC>#
OBJECTS WITH ERRORS------------------- 0DOC> The following query reports the number of exceptions caught duringDOC> recompilation. If this number is non-zero, please query the errorDOC> messages in the table UTL_RECOMP_ERRORS to see if any of these errorsDOC> are due to misconfiguration or resource constraints that must beDOC> fixed before objects can compile successfully.DOC> Note: Typical compilation errors (due to coding errors) are notDOC> logged into this table: they go into DBA_ERRORS instead.DOC>#
ERRORS DURING RECOMPILATION--------------------------- 0SQL> SELECT COUNT(*) FROM UTL_RECOMP_COMPILED;
COUNT(*)---------- 550SQL> SELECT COUNT(*) FROM obj$ WHERE status IN (4, 5, 6);
COUNT(*)---------- 0SQL> SELECT job_name FROM dba_scheduler_jobs WHERE job_name like 'UTL_RECOMP_SLAVE_%';SQL> SELECT job_name FROM dba_scheduler_running_jobs WHERE job_name like 'UTL_RECOMP_SLAVE_%';
- Run postupgrade_fixups.sql
SQL> @/u01/preupgrade/postupgrade_fixups.sqlNo errors.No errors.
No errors.No errors.
Executing Oracle POST-Upgrade Fixup Script
Auto-Generated by: Oracle Preupgrade Script Version: 19.0.0.0.0 Build: 1Generated on: 2021-09-17 15:33:34
For Source Database: ORCL12CSource Database Version: 12.1.0.2.0For Upgrade to Version: 19.0.0.0.0
Executing in container: CDB$ROOT
Preup PreupgradeAction Issue IsNumber Preupgrade Check Name Remedied Further DBA Action------ ------------------------ ---------- -------------------------------- 8. old_time_zones_exist NO Manual fixup recommended. 9. dir_symlinks YES None. 10. post_dictionary YES None. 11. post_fixed_objects NO Informational only. Further action is optional.
The fixup scripts have been run and resolved what they can. However,there are still issues originally identified by the preupgrade thathave not been remedied and are still present in the database.Depending on the severity of the specific issue, and the nature ofthe issue itself, that could mean that your database upgrade is notfully complete. To resolve the outstanding issues, start by reviewingthe postupgrade_fixups.sql and searching it for the name ofthe failed CHECK NAME or Preupgrade Action Number listed above.There you will find the original corresponding diagnostic messagefrom the preupgrade which explains in more detail what still needsto be done.SQL> SQL> SELECT version FROM v$timezone_file;
VERSION---------- 18
- Upgrade timeszone from 18 to 32 run script below:
SQL> @/u01/app/oracle/product/19.3/db_home/rdbms/admin/utltz_countstats.sql;.Amount of TSTZ data using num_rows stats info in DBA_TABLES..For SYS tables first ...Note: empty tables are not listed.Stat date - Owner.TableName.ColumnName - num_rows07/07/2014 - SYS.AQ$_ALERT_QT_S.CREATION_TIME - 307/07/2014 - SYS.AQ$_ALERT_QT_S.DELETION_TIME - 307/07/2014 - SYS.AQ$_ALERT_QT_S.MODIFICATION_TIME - 307/07/2014 - SYS.AQ$_AQ$_MEM_MC_S.CREATION_TIME - 307/07/2014 - SYS.AQ$_AQ$_MEM_MC_S.DELETION_TIME - 307/07/2014 - SYS.AQ$_AQ$_MEM_MC_S.MODIFICATION_TIME - 307/07/2014 - SYS.AQ$_AQ_PROP_TABLE_S.CREATION_TIME - 107/07/2014 - SYS.AQ$_AQ_PROP_TABLE_S.DELETION_TIME - 107/07/2014 - SYS.AQ$_AQ_PROP_TABLE_S.MODIFICATION_TIME - 117/09/2021 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.CREATION_TIME - 117/09/2021 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.DELETION_TIME - 117/09/2021 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.MODIFICATION_TIME - 117/09/2021 - SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.CREATION_TIME - 117/09/2021 - SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.DELETION_TIME - 117/09/2021 - SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.MODIFICATION_TIME - 107/07/2014 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.CREATION_TIME - 307/07/2014 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.DELETION_TIME - 307/07/2014 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.MODIFICATION_TIME - 317/09/2021 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.CREATION_TIME - 117/09/2021 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.DELETION_TIME - 117/09/2021 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.MODIFICATION_TIME - 117/09/2021 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.CREATION_TIME - 117/09/2021 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.DELETION_TIME - 117/09/2021 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.MODIFICATION_TIME - 117/09/2021 - SYS.AQ$_SUBSCRIBER_TABLE.CREATION_TIME - 117/09/2021 - SYS.AQ$_SUBSCRIBER_TABLE.DELETION_TIME - 117/09/2021 - SYS.AQ$_SUBSCRIBER_TABLE.MODIFICATION_TIME - 117/09/2021 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.CREATION_TIME - 417/09/2021 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.DELETION_TIME - 417/09/2021 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.MODIFICATION_TIME - 417/09/2021 - SYS.KET$_AUTOTASK_STATUS.ABA_START_TIME - 117/09/2021 - SYS.KET$_AUTOTASK_STATUS.ABA_STATE_TIME - 117/09/2021 - SYS.KET$_AUTOTASK_STATUS.MW_RECORD_TIME - 117/09/2021 - SYS.KET$_AUTOTASK_STATUS.MW_START_TIME - 117/09/2021 - SYS.KET$_AUTOTASK_STATUS.RECONCILE_TIME - 117/09/2021 - SYS.KET$_CLIENT_CONFIG.FIELD_2 - 717/09/2021 - SYS.KET$_CLIENT_CONFIG.LAST_CHANGE - 717/09/2021 - SYS.KET$_CLIENT_TASKS.CURR_WIN_START - 317/09/2021 - SYS.KET$_CLIENT_TASKS.LG_DATE - 317/09/2021 - SYS.KET$_CLIENT_TASKS.LT_DATE - 317/09/2021 - SYS.OPTSTAT_HIST_CONTROL$.SPARE6 - 4517/09/2021 - SYS.OPTSTAT_HIST_CONTROL$.SVAL2 - 4517/09/2021 - SYS.OPTSTAT_SNAPSHOT$.TIMESTAMP - 204917/09/2021 - SYS.OPTSTAT_USER_PREFS$.CHGTIME - 7217/09/2021 - SYS.RADM_FPTM$.TSWTZ_COL - 117/09/2021 - SYS.REG$.NTFN_GROUPING_START_TIME - 217/09/2021 - SYS.REG$.REG_TIME - 217/09/2021 - SYS.SCHEDULER$_EVENT_LOG.LOG_DATE - 53417/09/2021 - SYS.SCHEDULER$_GLOBAL_ATTRIBUTE.ATTR_TSTAMP - 1117/09/2021 - SYS.SCHEDULER$_JOB.END_DATE - 2517/09/2021 - SYS.SCHEDULER$_JOB.LAST_ENABLED_TIME - 2517/09/2021 - SYS.SCHEDULER$_JOB.LAST_END_DATE - 2517/09/2021 - SYS.SCHEDULER$_JOB.LAST_START_DATE - 2517/09/2021 - SYS.SCHEDULER$_JOB.NEXT_RUN_DATE - 2517/09/2021 - SYS.SCHEDULER$_JOB.START_DATE - 2517/09/2021 - SYS.SCHEDULER$_JOB_RUN_DETAILS.LOG_DATE - 49217/09/2021 - SYS.SCHEDULER$_JOB_RUN_DETAILS.REQ_START_DATE - 49217/09/2021 - SYS.SCHEDULER$_JOB_RUN_DETAILS.START_DATE - 49217/09/2021 - SYS.SCHEDULER$_SCHEDULE.END_DATE - 417/09/2021 - SYS.SCHEDULER$_SCHEDULE.REFERENCE_DATE - 417/09/2021 - SYS.SCHEDULER$_WINDOW.ACTUAL_START_DATE - 917/09/2021 - SYS.SCHEDULER$_WINDOW.END_DATE - 917/09/2021 - SYS.SCHEDULER$_WINDOW.LAST_START_DATE - 917/09/2021 - SYS.SCHEDULER$_WINDOW.MANUAL_OPEN_TIME - 917/09/2021 - SYS.SCHEDULER$_WINDOW.NEXT_START_DATE - 917/09/2021 - SYS.SCHEDULER$_WINDOW.START_DATE - 917/09/2021 - SYS.STATS_TARGET$.END_TIME - 129317/09/2021 - SYS.STATS_TARGET$.START_TIME - 129317/09/2021 - SYS.TAB_STATS$.SPARE6 - 118517/09/2021 - SYS.WRI$_ALERT_HISTORY.CREATION_TIME - 917/09/2021 - SYS.WRI$_ALERT_HISTORY.TIME_SUGGESTED - 917/09/2021 - SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SAVTIME - 7167617/09/2021 - SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SPARE6 - 7167617/09/2021 - SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SAVTIME - 6252417/09/2021 - SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SPARE6 - 6252417/09/2021 - SYS.WRI$_OPTSTAT_IND_HISTORY.SAVTIME - 196517/09/2021 - SYS.WRI$_OPTSTAT_IND_HISTORY.SPARE6 - 196517/09/2021 - SYS.WRI$_OPTSTAT_OPR.END_TIME - 37317/09/2021 - SYS.WRI$_OPTSTAT_OPR.SPARE6 - 37317/09/2021 - SYS.WRI$_OPTSTAT_OPR.START_TIME - 37317/09/2021 - SYS.WRI$_OPTSTAT_OPR_TASKS.END_TIME - 641517/09/2021 - SYS.WRI$_OPTSTAT_OPR_TASKS.SPARE6 - 641517/09/2021 - SYS.WRI$_OPTSTAT_OPR_TASKS.START_TIME - 641517/09/2021 - SYS.WRI$_OPTSTAT_TAB_HISTORY.SAVTIME - 426717/09/2021 - SYS.WRI$_OPTSTAT_TAB_HISTORY.SPARE6 - 426717/09/2021 - SYS.WRM$_DATABASE_INSTANCE.STARTUP_TIME_TZ - 917/09/2021 - SYS.WRM$_PDB_INSTANCE.OPEN_TIME_TZ - 417/09/2021 - SYS.WRM$_PDB_INSTANCE.STARTUP_TIME_TZ - 417/09/2021 - SYS.WRM$_PDB_IN_SNAP.OPEN_TIME_TZ - 417/09/2021 - SYS.WRM$_SNAPSHOT.BEGIN_INTERVAL_TIME_TZ - 1617/09/2021 - SYS.WRM$_SNAPSHOT.END_INTERVAL_TIME_TZ - 1617/09/2021 - SYS.XS$PRIN.END_DATE - 1517/09/2021 - SYS.XS$PRIN.START_DATE - 15Total numrows of SYS TSTZ columns is : 309634There are in total 162 SYS TSTZ columns..For non-SYS tables ...Note: empty tables are not listed.Stat date - Owner.Tablename.Columnname - num_rows17/09/2021 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.CREATION_TIME - 117/09/2021 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.DELETION_TIME - 117/09/2021 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.MODIFICATION_TIME - 107/07/2014 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.CREATION_TIME - 107/07/2014 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.DELETION_TIME - 107/07/2014 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.MODIFICATION_TIME - 117/09/2021 - WMSYS.WM$WORKSPACES_TABLE$.CREATETIME - 117/09/2021 - WMSYS.WM$WORKSPACES_TABLE$.LAST_CHANGE - 1Total numrows of non-SYS TSTZ columns is : 8There are in total 27 non-SYS TSTZ columns.Total Minutes elapsed : 0Session altered.
- Run postupgrade_fixups.sql
SQL> @/u01/preupgrade/postupgrade_fixups.sqlSession altered.PL/SQL procedure successfully completed.Commit complete.Session altered.PL/SQL procedure successfully completed.PL/SQL procedure successfully completed.Package created.No errors.Package body created.PL/SQL procedure successfully completed.No errors.1 row selected.Package created.No errors.Package body created.No errors.Executing Oracle POST-Upgrade Fixup ScriptAuto-Generated by: Oracle Preupgrade ScriptVersion: 19.0.0.0.0 Build: 1Generated on: 2021-09-17 15:33:34For Source Database: ORCL12CSource Database Version: 12.1.0.2.0For Upgrade to Version: 19.0.0.0.0Executing in container: CDB$ROOTPreup PreupgradeAction Issue IsNumber Preupgrade Check Name Remedied Further DBA Action------ ------------------------ ---------- --------------------------------8. old_time_zones_exist YES None.9. dir_symlinks YES None.10. post_dictionary YES None.11. post_fixed_objects NO Informational only.Further action is optional.The fixup scripts have been run and resolved what they can. However,there are still issues originally identified by the preupgrade thathave not been remedied and are still present in the database.Depending on the severity of the specific issue, and the nature ofthe issue itself, that could mean that your database upgrade is notfully complete. To resolve the outstanding issues, start by reviewingthe postupgrade_fixups.sql and searching it for the name ofthe failed CHECK NAME or Preupgrade Action Number listed above.There you will find the original corresponding diagnostic messagefrom the preupgrade which explains in more detail what still needsto be done.PL/SQL procedure successfully completed.Session altered.
- Delete restore point created before upgrade
SQL> select name from v$restore_point;NAME--------------------------------------------------------------------------------------------------------------------------------BEFORE_UPGRADE_19C1 row selected.SQL> select name from v$restore_point;NAME--------------------------------------------------------------------------------------------------------------------------------BEFORE_UPGRADE_19C1 row selected.SQL> drop restore point BEFORE_UPGRADE_19C;
Restore point dropped.
SQL> sho parameter compatibleNAME TYPE VALUE------------------------------------ ----------- ------------------------------compatible string 12.1.0.2.0noncdb_compatible boolean FALSESQL> alter system set compatible='19.0.0' scope=spfile;System altered.SQL> alter system set compatible='19.0.0' scope=spfile;System altered.
- Shutdown database and startup the database
SQL> shut immediate;Database closed.Database dismounted.ORACLE instance shut down.SQL> startupORACLE instance started.Total System Global Area 1862269648 bytesFixed Size 9136848 bytesVariable Size 637534208 bytesDatabase Buffers 1207959552 bytesRedo Buffers 7639040 bytesDatabase mounted.Database opened.SQL> SQL> sho parameter compatibleNAME TYPE VALUE------------------------------------ ----------- ------------------------------compatible string 19.0.0noncdb_compatible boolean FALSESQL>
- Start listener on both primary and standby database
- open database in mount stage and change the compatible parameter
[oracle@srv7 admin]$ lsnrctl start LISTENER12C
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-SEP-2021 17:46:26
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Starting /u01/app/oracle/product/19.3/db_home/bin/tnslsnr: please wait...
TNSLSNR for Linux: Version 19.0.0.0.0 - Production
System parameter file is /u01/app/oracle/product/19.3/db_home/network/admin/listener.ora
Log messages written to /u01/app/oracle/diag/tnslsnr/srv7/listener12c/alert/log.xml
TNS-01151: Missing listener name, LISTENER12C, in LISTENER.ORA
Listener failed to start. See the error message(s) above...
- Add 12c listener entry on 19c listener or tns_admin
[oracle@srv7 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.3/db_home/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv7.example.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=TESTDR)
(SID_NAME=TESTDR)
(ORACLE_HOME=/u01/app/oracle/product/19.3/db_home)
)
)
[oracle@srv7 admin]$ vi listener.ora
[oracle@srv7 admin]$ cat listener.ora
# listener.ora Network Configuration File: /u01/app/oracle/product/19.3/db_home/network/admin/listener.ora
# Generated by Oracle configuration tools.
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv7.example.com)(PORT = 1521))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)
LISTENER12C =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srv7)(PORT = 1523))
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
)
)
SID_LIST_LISTENER=
(SID_LIST=
(SID_DESC=
(GLOBAL_DBNAME=TESTDR)
(SID_NAME=TESTDR)
(ORACLE_HOME=/u01/app/oracle/product/19.3/db_home)
)
)
[oracle@srv7 admin]$ . oranenv
-bash: oranenv: No such file or directory
[oracle@srv7 admin]$ cat /etc/oratab
#
# This file is used by ORACLE utilities. It is created by root.sh
# and updated by either Database Configuration Assistant while creating
# a database or ASM Configuration Assistant while creating ASM instance.
# A colon, ':', is used as the field terminator. A new line terminates
# the entry. Lines beginning with a pound sign, '#', are comments.
#
# Entries are of the form:
# $ORACLE_SID:$ORACLE_HOME:<N|Y>:
#
# The first and second fields are the system identifier and home
# directory of the database respectively. The third field indicates
# to the dbstart utility that the database should , "Y", or should not,
# "N", be brought up at system boot time.
#
# Multiple entries with the same $ORACLE_SID are not allowed.
#
#
TESTDR:/u01/app/oracle/product/19.3/db_home:N
orcl12cdr:/u01/app/oracle/product/12.1.0/dbhome_1:N
[oracle@srv7 admin]$ . oraenv
ORACLE_SID = [CDB] ? TESTDR
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srv7 admin]$ lsnrctl start LISTENER12C
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-SEP-2021 17:47:50
Copyright (c) 1991, 2019, Oracle. All rights reserved.
TNS-01106: Listener using listener name LISTENER12C has already been started
[oracle@srv7 admin]$ lsnrctl status LISTENER12C
LSNRCTL for Linux: Version 19.0.0.0.0 - Production on 17-SEP-2021 17:48:00
Copyright (c) 1991, 2019, Oracle. All rights reserved.
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=srv7)(PORT=1523)))
STATUS of the LISTENER
------------------------
Alias LISTENER12C
Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production
Start Date 17-SEP-2021 13:49:51
Uptime 0 days 3 hr. 58 min. 8 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /u01/app/oracle/product/12.1.0/dbhome_1/network/admin/listener.ora
Listener Log File /u01/app/oracle/diag/tnslsnr/srv7/listener12c/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=srv7)(PORT=1523)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1523)))
Services Summary...
Service "orcl12cdr" has 1 instance(s).
Instance "orcl12cdr", status READY, has 1 handler(s) for this service...
The command completed successfully
[oracle@srv7 admin]$
(change compatible parameter in standby to 19c )
[oracle@srv7 admin]$ . oraenv
ORACLE_SID = [orcl12cdr] ? TESTDR
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srv7 admin]$ export ORACLE_SID=orcl12cdr
[oracle@srv7 admin]$ export ORACLE_HOME=/u01/app/oracle/product/19.3/db_home
[oracle@srv7 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Fri Sep 17 17:58:48 2021
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL> startup mount; ORACLE instance started. Total System Global Area 2919233192 bytes Fixed Size 9139880 bytes Variable Size 603979776 bytes Database Buffers 2298478592 bytes Redo Buffers 7634944 bytes Database mounted. SQL> "d SP2-0042: unknown command ""d" - rest of line ignored. SQL> @d NAME INSTANCE_NAME DB_UNIQUE_NAME OPEN_MODE DATABASE_ROLE CURRENT_SCN FAILOVER_SCN --------- ---------------- ------------------------------ -------------------- ---------------- ------------------ ---------------------------------------- TEST19C TESTDR TESTDR MOUNTED PHYSICAL STANDBY YES 0 SQL> sho parameter compatible NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ compatible string 19.0.0 noncdb_compatible boolean FALSE SQL>
SQL> sho pdbs CON_ID CON_NAME OPEN MODE RESTRICTED ---------- ------------------------------ ---------- ---------- 2 PDB$SEED MOUNTED 3 PDB MOUNTED SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srv7 admin]$