Hello Friends,
PRECHECKS:
Backup the database before starting the activity
1.CHECK THE INVALID OBJECTS( ALL SHOULD BE VALID)
12.Copy Tnsnames.ora from 12c $ORACLE_HOME/network/admin to 19c $ORACLE_HOME/network/admin
In my case we have already upgraded grid so listener is in new upgraded grid home
13.Now connect to 19c Sqlplus and start the CDB and pdb in Upgrade mode
In this blog we will discuss about the database upgradation from 12cr2 to 19c Manual Mode
Steps to install software 19c for upgrade follow the below link:
Environment :
Hostname : dm10db11.database.com
Database Name : CDBISTDB
PDB : PDBISTDB
DB VERSION : 12.2.0.1
CDB : CDB, Single Instance
DB Home Path : /oracle/app/orawork/product/12.2.0.1/db_1
Datafile Location : +DATA/CDBISTDB/DATAFILE
Target DB VERSION : 19c (19.3.0.0.0)
Target DB Path : /oracle/app/orawork/product/19.0.0.0/db_1
Upgrade Method : Manual
PRECHECKS:
Backup the database before starting the activity
1.CHECK THE INVALID OBJECTS( ALL SHOULD BE VALID)
SQL> set pages 9999 lines 300
col OPEN_MODE for a10
col HOST_NAME for a30
select name DB_NAME,HOST_NAME,DATABASE_ROLE,OPEN_MODE,log_mode,version DB_VERSION,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME" from v$database,v$instance;
SQL> SQL> SQL>
DB_NAME HOST_NAME DATABASE_ROLE OPEN_MODE LOG_MODE DB_VERSION LOGINS DB UP TIME
--------- ------------------------------ ---------------- ---------- ------------ ----------------- ---------- -----------------------------
CDBISTDB dm10db11.database.com PRIMARY READ WRITE ARCHIVELOG 12.2.0.1.0 ALLOWED 30-MAY-2020 01:20:07
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB READ WRITE NO
SQL>
SQL> select comp_id,status from dba_registry;
COMP_ID STATUS
------------------------------ -----------------------
CATALOG VALID
CATPROC VALID
JAVAVM VALID
XML VALID
CATJAVA VALID
APS VALID
RAC OPTION OFF
XDB VALID
OWM VALID
CONTEXT VALID
ORDIM VALID
SDO VALID
XOQ VALID
OLS VALID
DV VALID
15 rows selected.
SQL> select object_name, object_type
from dba_objects
where object_name||object_type in
(select object_name||object_type
from dba_objects
where owner = 'SYS')
and owner = 'SYSTEM'; 2 3 4 5 6 7
OBJECT_NAME OBJECT_TYPE
--------------------------------------------------- -------------------
DBMS_REPCAT_AUTH PACKAGE BODY
AQ$_SCHEDULES_PRIMARY INDEX
AQ$_SCHEDULES TABLE
DBMS_REPCAT_AUTH PACKAGE
SQL> ---- If you found any other objects other than these four, then those need to be cleaned up. ----
[oracle@dm10db11 bin]$ pwd
/oracle/app/orawork/product/12.2.0.1/db_1/jdk/bin
[oracle@dm10db11 bin]$ java -jar /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/preupgrade
preupgrade.jar preupgrade_messages.properties preupgrade_package.sql
[oracle@dm10db11 bin]$ java -jar /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/preupgrade.jar TERMINAL TEXT - OR -
/oracle/app/orawork/product/12.2.0.1/db_1/jdk/bin/java -jar /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/preupgrade.jar FILE DIR /oracle/ISTDB/preupgrade
[oracle@dm10db11 bin]$ java -jar /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/preupgrade.jar TERMINAL TEXT
Report generated by Oracle Database Pre-Upgrade Information Tool Version
19.0.0.0.0 Build: 1 on 2020-05-30T06:28:51
Upgrade-To version: 19.0.0.0.0
=======================================
Status of the database prior to upgrade
=======================================
Database Name: CDBISTDB
Container Name: CDB$ROOT
Container ID: 1
Version: 12.2.0.1.0
DB Patch Level: No Patch Bundle applied
Compatible: 12.2.0
Blocksize: 8192
Platform: Linux x86 64-bit
Timezone File: 26
Database log mode: ARCHIVELOG
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 OLAP API [to be upgraded] VALID
==============
BEFORE UPGRADE
==============
REQUIRED ACTIONS
================
None
RECOMMENDED ACTIONS
===================
1. (AUTOFIXUP) Gather stale data dictionary statistics prior to database
upgrade in off-peak time using:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Dictionary statistics do not exist or are stale (not up-to-date).
Dictionary statistics help the Oracle optimizer find efficient SQL
execution plans and are essential for proper upgrade timing. Oracle
recommends gathering dictionary statistics in the last 24 hours before
database upgrade.
For information on managing optimizer statistics, refer to the 12.2.0.1
Oracle Database SQL Tuning Guide.
INFORMATION ONLY
================
2. To help you keep track of your tablespace allocations, the following
AUTOEXTEND tablespaces are expected to successfully EXTEND during the
upgrade process.
Min Size
Tablespace Size For Upgrade
---------- ---------- -----------
SYSAUX 500 MB 520 MB
SYSTEM 810 MB 925 MB
TEMP 33 MB 150 MB
UNDOTBS1 70 MB 439 MB
Minimum tablespace sizes for upgrade are estimates.
3. No action needed.
Using default parallel upgrade options, this CDB with 2 PDBs will first
upgrade the CDB$ROOT, and then upgrade at most 1 PDBs at a time using 2
parallel processes per PDB.
The number of PDBs upgraded in parallel and the number of parallel
processes per PDB can be adjusted as described in Database Upgrade Guide.
4. Check the Oracle Backup and Recovery User's Guide for information on how
to manage an RMAN recovery catalog schema.
If you are using a version of the recovery catalog schema that is older
than that required by the RMAN client version, then you must upgrade the
catalog schema.
It is good practice to have the catalog schema the same or higher version
than the RMAN client version you are using.
ORACLE GENERATED FIXUP SCRIPT
=============================
All of the issues in database CDBISTDB container CDB$ROOT
which are identified above as BEFORE UPGRADE "(AUTOFIXUP)" can be resolved by
executing the following from within the container
SQL>@/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/preupgrade_fixups.sql
=============
AFTER UPGRADE
=============
REQUIRED ACTIONS
================
None
RECOMMENDED ACTIONS
===================
5. Upgrade the database time zone file using the DBMS_DST package.
The database is using time zone file version 26 and the target 19 release
ships with time zone file version 32.
Oracle recommends upgrading to the desired (latest) version of the time
zone file. For more information, refer to "Upgrading the Time Zone File
and Timestamp with Time Zone Data" in the 19 Oracle Database
Globalization Support Guide.
6. To identify directory objects with symbolic links in the path name, run
$ORACLE_HOME/rdbms/admin/utldirsymlink.sql AS SYSDBA after upgrade.
Recreate any directory objects listed, using path names that contain no
symbolic links.
Some directory object path names may currently contain symbolic links.
Starting in Release 18c, symbolic links are not allowed in directory
object path names used with BFILE data types, the UTL_FILE package, or
external tables.
7. (AUTOFIXUP) Gather dictionary statistics after the upgrade using the
command:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Oracle recommends gathering dictionary statistics after upgrade.
Dictionary statistics provide essential information to the Oracle
optimizer to help it find efficient SQL execution plans. After a database
upgrade, statistics need to be re-gathered as there can now be tables
that have significantly changed during the upgrade or new tables that do
not have statistics gathered yet.
8. Gather statistics on fixed objects after the upgrade and when there is a
representative workload on the system using the command:
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
This recommendation is given for all preupgrade runs.
Fixed object statistics provide essential information to the Oracle
optimizer to help it find efficient SQL execution plans. Those
statistics are specific to the Oracle Database release that generates
them, and can be stale upon database upgrade.
For information on managing optimizer statistics, refer to the 12.2.0.1
Oracle Database SQL Tuning Guide.
ORACLE GENERATED FIXUP SCRIPT
=============================
All of the issues in database CDBISTDB container CDB$ROOT
which are identified above as AFTER UPGRADE "(AUTOFIXUP)" can be resolved by
executing the following from within the container
SQL>@/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/postupgrade_fixups.
sql
Report generated by Oracle Database Pre-Upgrade Information Tool Version
19.0.0.0.0 Build: 1 on 2020-05-30T06:29:32
Upgrade-To version: 19.0.0.0.0
=======================================
Status of the database prior to upgrade
=======================================
Database Name: CDBISTDB
Container Name: PDB$SEED
Container ID: 2
Version: 12.2.0.1.0
DB Patch Level: No Patch Bundle applied
Compatible: 12.2.0
Blocksize: 8192
Platform: Linux x86 64-bit
Timezone File: 26
Database log mode: ARCHIVELOG
Readonly: TRUE
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 OLAP API [to be upgraded] VALID
==============
BEFORE UPGRADE
==============
REQUIRED ACTIONS
================
None
RECOMMENDED ACTIONS
===================
1. (AUTOFIXUP) Gather stale data dictionary statistics prior to database
upgrade in off-peak time using:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Dictionary statistics do not exist or are stale (not up-to-date).
Dictionary statistics help the Oracle optimizer find efficient SQL
execution plans and are essential for proper upgrade timing. Oracle
recommends gathering dictionary statistics in the last 24 hours before
database upgrade.
For information on managing optimizer statistics, refer to the 12.2.0.1
Oracle Database SQL Tuning Guide.
2. (AUTOFIXUP) Gather statistics on fixed objects prior the upgrade.
None of the fixed object tables have had stats collected.
Gathering statistics on fixed objects, if none have been gathered yet, is
recommended prior to upgrading.
For information on managing optimizer statistics, refer to the 12.2.0.1
Oracle Database SQL Tuning Guide.
INFORMATION ONLY
================
3. To help you keep track of your tablespace allocations, the following
AUTOEXTEND tablespaces are expected to successfully EXTEND during the
upgrade process.
Min Size
Tablespace Size For Upgrade
---------- ---------- -----------
SYSAUX 350 MB 500 MB
SYSTEM 250 MB 360 MB
TEMP 64 MB 150 MB
UNDOTBS1 100 MB 439 MB
Minimum tablespace sizes for upgrade are estimates.
ORACLE GENERATED FIXUP SCRIPT
=============================
All of the issues in database CDBISTDB container PDB$SEED
which are identified above as BEFORE UPGRADE "(AUTOFIXUP)" can be resolved by
executing the following from within the container
SQL>@/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/preupgrade_fixups.sql
=============
AFTER UPGRADE
=============
REQUIRED ACTIONS
================
None
RECOMMENDED ACTIONS
===================
4. Upgrade the database time zone file using the DBMS_DST package.
The database is using time zone file version 26 and the target 19 release
ships with time zone file version 32.
Oracle recommends upgrading to the desired (latest) version of the time
zone file. For more information, refer to "Upgrading the Time Zone File
and Timestamp with Time Zone Data" in the 19 Oracle Database
Globalization Support Guide.
5. To identify directory objects with symbolic links in the path name, run
$ORACLE_HOME/rdbms/admin/utldirsymlink.sql AS SYSDBA after upgrade.
Recreate any directory objects listed, using path names that contain no
symbolic links.
Some directory object path names may currently contain symbolic links.
Starting in Release 18c, symbolic links are not allowed in directory
object path names used with BFILE data types, the UTL_FILE package, or
external tables.
6. (AUTOFIXUP) Gather dictionary statistics after the upgrade using the
command:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Oracle recommends gathering dictionary statistics after upgrade.
Dictionary statistics provide essential information to the Oracle
optimizer to help it find efficient SQL execution plans. After a database
upgrade, statistics need to be re-gathered as there can now be tables
that have significantly changed during the upgrade or new tables that do
not have statistics gathered yet.
7. Gather statistics on fixed objects after the upgrade and when there is a
representative workload on the system using the command:
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
This recommendation is given for all preupgrade runs.
Fixed object statistics provide essential information to the Oracle
optimizer to help it find efficient SQL execution plans. Those
statistics are specific to the Oracle Database release that generates
them, and can be stale upon database upgrade.
For information on managing optimizer statistics, refer to the 12.2.0.1
Oracle Database SQL Tuning Guide.
ORACLE GENERATED FIXUP SCRIPT
=============================
All of the issues in database CDBISTDB container PDB$SEED
which are identified above as AFTER UPGRADE "(AUTOFIXUP)" can be resolved by
executing the following from within the container
SQL>@/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/postupgrade_fixups.sql
Report generated by Oracle Database Pre-Upgrade Information Tool Version
19.0.0.0.0 Build: 1 on 2020-05-30T06:29:26
Upgrade-To version: 19.0.0.0.0
=======================================
Status of the database prior to upgrade
=======================================
Database Name: CDBISTDB
Container Name: PDBISTDB
Container ID: 3
Version: 12.2.0.1.0
DB Patch Level: No Patch Bundle applied
Compatible: 12.2.0
Blocksize: 8192
Platform: Linux x86 64-bit
Timezone File: 26
Database log mode: ARCHIVELOG
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 OLAP API [to be upgraded] VALID
==============
BEFORE UPGRADE
==============
REQUIRED ACTIONS
================
None
RECOMMENDED ACTIONS
===================
1. (AUTOFIXUP) Gather stale data dictionary statistics prior to database
upgrade in off-peak time using:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Dictionary statistics do not exist or are stale (not up-to-date).
Dictionary statistics help the Oracle optimizer find efficient SQL
execution plans and are essential for proper upgrade timing. Oracle
recommends gathering dictionary statistics in the last 24 hours before
database upgrade.
For information on managing optimizer statistics, refer to the 12.2.0.1
Oracle Database SQL Tuning Guide.
INFORMATION ONLY
================
2. To help you keep track of your tablespace allocations, the following
AUTOEXTEND tablespaces are expected to successfully EXTEND during the
upgrade process.
Min Size
Tablespace Size For Upgrade
---------- ---------- -----------
SYSAUX 360 MB 500 MB
SYSTEM 260 MB 367 MB
TEMP 64 MB 150 MB
UNDOTBS1 100 MB 439 MB
Minimum tablespace sizes for upgrade are estimates.
ORACLE GENERATED FIXUP SCRIPT
=============================
All of the issues in database CDBISTDB container PDBISTDB
which are identified above as BEFORE UPGRADE "(AUTOFIXUP)" can be resolved by
executing the following from within the container
SQL>@/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/preupgrade_fixups.s
ql
=============
AFTER UPGRADE
=============
REQUIRED ACTIONS
================
None
RECOMMENDED ACTIONS
===================
3. Upgrade the database time zone file using the DBMS_DST package.
The database is using time zone file version 26 and the target 19 release
ships with time zone file version 32.
Oracle recommends upgrading to the desired (latest) version of the time
zone file. For more information, refer to "Upgrading the Time Zone File
and Timestamp with Time Zone Data" in the 19 Oracle Database
Globalization Support Guide.
4. To identify directory objects with symbolic links in the path name, run
$ORACLE_HOME/rdbms/admin/utldirsymlink.sql AS SYSDBA after upgrade.
Recreate any directory objects listed, using path names that contain no
symbolic links.
Some directory object path names may currently contain symbolic links.
Starting in Release 18c, symbolic links are not allowed in directory
object path names used with BFILE data types, the UTL_FILE package, or
external tables.
5. (AUTOFIXUP) Gather dictionary statistics after the upgrade using the
command:
EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
Oracle recommends gathering dictionary statistics after upgrade.
Dictionary statistics provide essential information to the Oracle
optimizer to help it find efficient SQL execution plans. After a database
upgrade, statistics need to be re-gathered as there can now be tables
that have significantly changed during the upgrade or new tables that do
not have statistics gathered yet.
6. Gather statistics on fixed objects after the upgrade and when there is a
representative workload on the system using the command:
EXECUTE DBMS_STATS.GATHER_FIXED_OBJECTS_STATS;
This recommendation is given for all preupgrade runs.
Fixed object statistics provide essential information to the Oracle
optimizer to help it find efficient SQL execution plans. Those
statistics are specific to the Oracle Database release that generates
them, and can be stale upon database upgrade.
For information on managing optimizer statistics, refer to the 12.2.0.1
Oracle Database SQL Tuning Guide.
ORACLE GENERATED FIXUP SCRIPT
=============================
All of the issues in database CDBISTDB container PDBISTDB
which are identified above as AFTER UPGRADE "(AUTOFIXUP)" can be resolved by
executing the following from within the container
SQL>@/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/postupgrade_fixups.
sql
==================
PREUPGRADE SUMMARY
==================
/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/preupgrade.log
/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/preupgrade_fixups.sql
/oracle/app/orawork/cfgtoollogs/CDBISTDB/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 /oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/ -b preup_CDBISTDB /oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/preupgrade_fixups.sql
2. Review logs under /oracle/app/orawork/cfgtoollogs/CDBISTDB/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 /oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/ -b postup_CDBISTDB /oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/postupgrade_fixups.sql
2. Review logs under /oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/
Preupgrade complete: 2020-05-30T06:29:38
SQL> @/oracle/app/orawork/cfgtoollogs/CDBISTDB/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: 2020-05-30 06:28:45
For Source Database: CDBISTDB
Source Database Version: 12.2.0.1.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. dictionary_stats YES None.
2. tablespaces_info NO Informational only.
Further action is optional.
3. cycle_number NO Informational only.
Further action is optional.
4. 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.
-----------------------------------------------------------------OR-----------------------------------------------------------------------------------------
PDB preupgrade :
[oracle@dm10db11 bin]$ $ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib -I$ORACLE_HOME/rdbms/admin $ORACLE_HOME/rdbms/admin/catcon.pl -l /oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/ -b preup_CDBISTDB /oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/preupgrade_fixups.sql
catcon: ALL catcon-related output will be written to [/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade//preup_CDBISTDB_catcon_22834.lst]
catcon: See [/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade//preup_CDBISTDB*.log] files for output generated by scripts
catcon: See [/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade//preup_CDBISTDB_*.lst] files for spool files, if any
catcon.pl: completed successfully
--------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL> EXECUTE DBMS_STATS.GATHER_DICTIONARY_STATS;
PL/SQL procedure successfully completed.
SQL>
SQL> PURGE DBA_RECYCLEBIN;
DBA Recyclebin purged.
SQL>
SQL>
SQL> ---- Before upgrading Oracle Database, you must wait until all materialized views have completed refreshing.-----
SQL>
SQL> SELECT o.name FROM sys.obj$ o, sys.user$ u, sys.sum$ s WHERE o.type# = 42 AND bitand(s.mflags, 8) =8;
no rows selected
SQL>
SQL> declare
list_failures integer(3) :=0;
begin
DBMS_MVIEW.REFRESH_ALL_MVIEWS(list_failures,'C','', TRUE, FALSE);
end;
/ 2 3 4 5 6
PL/SQL procedure successfully completed.
SQL> select flashback_on from v$database;
FLASHBACK_ON
------------------
ON
SQL> show parameter compatible
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 12.2.0
noncdb_compatible boolean FALSE
SQL>
SQL>
SQL> show parameter recovery
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
db_recovery_file_dest string +FRA
db_recovery_file_dest_size big integer 12780M
recovery_parallelism integer 0
remote_recovery_file_dest string
SQL>
SQL>
SQL> select * from V$restore_point;
no rows selected
SQL>
SQL>
SQL> create restore point FB_UPGRADE guarantee flashback database;
Restore point created.
SQL>
SQL>
SQL> col name for a20
col GUARANTEE_FLASHBACK_DATABASE for a10
col TIME for a60
set lines 190
select NAME,GUARANTEE_FLASHBACK_DATABASE,TIME from V$restore_point;SQL> SQL> SQL> SQL>
NAME GUARANTEE_ TIME
-------------------- ---------- ------------------------------------------------------------
FB_UPGRADE YES 30-MAY-20 08.44.24.000000000 AM
SQL> startup force
SQL> SELECT version FROM v$timezone_file;
VERSION
----------
26
set pagesize 2000
set lines 2000
set long 99999
select owner,JOB_NAME,ENABLED,state from dba_scheduler_jobs;
OWNER JOB_NAME ENABL STATE
-------------------- ------------------------------ ----- ---------------
SYS PURGE_LOG TRUE SCHEDULED
SYS FILE_WATCHER FALSE DISABLED
SYS PMO_DEFERRED_GIDX_MAINT_JOB TRUE SCHEDULED
SYS CLEANUP_NON_EXIST_OBJ TRUE SCHEDULED
SYS CLEANUP_ONLINE_IND_BUILD TRUE SCHEDULED
SYS CLEANUP_TAB_IOT_PMO TRUE SCHEDULED
SYS CLEANUP_TRANSIENT_TYPE TRUE SCHEDULED
SYS CLEANUP_TRANSIENT_PKG TRUE SCHEDULED
SYS CLEANUP_ONLINE_PMO TRUE SCHEDULED
SYS FILE_SIZE_UPD TRUE SCHEDULED
SYS ORA$AUTOTASK_CLEAN TRUE SCHEDULED
SYS HM_CREATE_OFFLINE_DICTIONARY FALSE DISABLED
SYS DRA_REEVALUATE_OPEN_FAILURES TRUE SCHEDULED
SYS ORA$PREPLUGIN_BACKUP_JOB FALSE DISABLED
SYS BSLN_MAINTAIN_STATS_JOB TRUE SCHEDULED
SYS FGR$AUTOPURGE_JOB FALSE DISABLED
SYS RSE$CLEAN_RECOVERABLE_SCRIPT TRUE SCHEDULED
SYS SM$CLEAN_AUTO_SPLIT_MERGE TRUE SCHEDULED
SYS LOAD_OPATCH_INVENTORY FALSE DISABLED
SYS XMLDB_NFS_CLEANUP_JOB FALSE DISABLED
ORACLE_OCM MGMT_CONFIG_JOB TRUE SCHEDULED
ORACLE_OCM MGMT_STATS_CONFIG_JOB TRUE SCHEDULED
--- Disable the scheduled jobs by using below command
SQL> execute dbms_scheduler.disable('DRA_REEVALUATE_OPEN_FAILURES);
SQL> SELECT username, default_tablespace
FROM dba_users
WHERE username in ('SYS','SYSTEM'); 2 3
USERNAME DEFAULT_TABLESPACE
-----------------------------------------
SYS SYSTEM
SYSTEM SYSTEM
SQL> SELECT name FROM sys.user$
WHERE ext_username IS NOT NULL
AND password = 'GLOBAL'; 2 3
no rows selected
SQL> SELECT name, value from SYS.V$PARAMETER WHERE name LIKE '\_%' ESCAPE '\' order by name;
no rows selected
[oracle@dm10db11 admin]$ srvctl stop database -d CDBISTDB
[oracle@dm10db11 admin]$ srvctl remove database -d CDBISTDB -f
[oracle@dm10db11 admin]$ ps -ef |grep pmon
grid 3915 1 0 01:10 ? 00:00:01 asm_pmon_+ASM
oracle 18674 20088 0 08:58 pts/1 00:00:00 grep --color=auto pmon
[oracle@dm10db11 admin]$
-----------------------------------------19c Steps ENV Steps------------------------------------------
export ORACLE_BASE=/oracle/app/orawork
export ORALCE_HOME=/oracle/app/orawork/product/19.0.0.0/db_1
export PATH=/oracle/app/orawork/product/19.0.0.0/db_1:$PATH
12.Copy Tnsnames.ora from 12c $ORACLE_HOME/network/admin to 19c $ORACLE_HOME/network/admin
In my case we have already upgraded grid so listener is in new upgraded grid home
13.Now connect to 19c Sqlplus and start the CDB and pdb in Upgrade mode
[oracle@dm10db11 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 30 09:06:50 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to an idle instance.
SQL>
SQL>
SQL> startup upgrade
ORACLE instance started.
Total System Global Area 1157627856 bytes
Fixed Size 9134032 bytes
Variable Size 905969664 bytes
Database Buffers 234881024 bytes
Redo Buffers 7643136 bytes
Database mounted.
Database opened.
SQL> set pages 9999 lines 300
col OPEN_MODE for a10
col HOST_NAME for a30
select name DB_NAME,HOST_NAME,DATABASE_ROLE,OPEN_MODE,log_mode,version DB_VERSION,LOGINS,to_char(STARTUP_TIME,'DD-MON-YYYY HH24:MI:SS') "DB UP TIME" from v$database,v$instance;
SQL> SQL> SQL>
DB_NAME HOST_NAME DATABASE_ROLE OPEN_MODE LOG_MODE DB_VERSION LOGINS DB UP TIME
--------- ------------------------------ ---------------- ---------- ------------ ----------------- ---------- -----------------------------
CDBISTDB dm10db11.database.com PRIMARY READ WRITE ARCHIVELOG 19.0.0.0.0 RESTRICTED 30-MAY-2020 09:07:01
SQL>
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MIGRATE YES
3 PDBISTDB MOUNTED
SQL>
SQL> select name,open_mode,cdb,version,status from v$database,v$instance;
NAME OPEN_MODE CDB VERSION STATUS
--------- ---------- --- ----------------- ------------
CDBISTDB READ WRITE YES 19.0.0.0.0 OPEN MIGRATE
SQL>
SQL> ALTER PLUGGABLE DATABASE PDBISTDB OPEN UPGRADE;
Pluggable database altered.
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MIGRATE YES
3 PDBISTDB MIGRATE YES
SQL>
old methold with long command :)
nohup /oracle/app/orawork/product/19.0.0.0/db_1/perl/bin/perl catctl.pl -l /oracle/app/orawork/upgradelogs -n 4 catupgrd.sql &
--Or--
New Short method
./dbupgrade
In NONCDB script runs only once but IN CDB env it depends on No or pdbs including Seed pdb, In my case 1 has 1 PDB so the total executions are 3
1.CDB$ROOT
2.PDB$SEED
3.PDBISTDB
All things will be done automatically no manual intervention needed after running ./dbupgrade
[oracle@dm10db11 dbs]$ pwd
/oracle/app/orawork/product/19.0.0.0/db_1/dbs
[oracle@dm10db11 dbs]$ cd ..
[oracle@dm10db11 db_1]$ cd bin
[oracle@dm10db11 bin]$ ls -ltr dbupgrade
-rwxr-x---. 1 oracle oinstall 3136 Apr 17 2019 dbupgrade
[oracle@dm10db11 bin]$
[oracle@dm10db11 bin]$ ./dbupgrade
Argument list for [/oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = 0
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = 0
Child Process I = 0
Log Dir l = 0
Priority List Name L = 0
Upgrade Mode active M = 0
SQL Process Count n = 0
SQL PDB Process Count N = 0
Open Mode Normal o = 0
Start Phase p = 0
End Phase P = 0
Reverse Order r = 0
AutoUpgrade Resume R = 0
Script s = 0
Serial Run S = 0
RO User Tablespaces T = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
catctl.pl VERSION: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]
/oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/orahome = [/oracle/app/orawork/product/19.0.0.0/db_1]
/oracle/app/orawork/product/19.0.0.0/db_1/bin/orabasehome = [/oracle/app/orawork/product/19.0.0.0/db_1]
catctlGetOraBaseLogDir = [/oracle/app/orawork/product/19.0.0.0/db_1]
Analyzing file /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catupgrd.sql
Log file directory = [/tmp/cfgtoollogs/upgrade20200530092957]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/tmp/cfgtoollogs/upgrade20200530092957/catupgrd_catcon_25051.lst]
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20200530092957/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/tmp/cfgtoollogs/upgrade20200530092957/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 1
Database Name = CDBISTDB
DataBase Version = 12.2.0.1.0
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdcdbroot_catcon_25051.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdcdbroot*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdcdbroot_*.lst] files for spool files, if any
Log file directory = [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013]
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) = 2
Parallel SQL Process Count (CDB$ROOT) = 4
Concurrent PDB Upgrades = 1
Generated PDB Inclusion:[PDB$SEED PDBISTDB]
Components in [CDB$ROOT]
Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [APEX EM MGW ODM RAC WK]
------------------------------------------------------
Phases [0-107] Start Time:[2020_05_30 09:30:36]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [CDB$ROOT] Files:1 Time: 57s
*************** Catalog Core SQL ***************
Serial Phase #:1 [CDB$ROOT] Files:5 Time: 50s
Restart Phase #:2 [CDB$ROOT] Files:1 Time: 2s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [CDB$ROOT] Files:19 Time: 31s
Restart Phase #:4 [CDB$ROOT] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [CDB$ROOT] Files:7 Time: 21s
***************** Catproc Start ****************
Serial Phase #:6 [CDB$ROOT] Files:1 Time: 19s
***************** Catproc Types ****************
Serial Phase #:7 [CDB$ROOT] Files:2 Time: 20s
Restart Phase #:8 [CDB$ROOT] Files:1 Time: 1s
**************** Catproc Tables ****************
Parallel Phase #:9 [CDB$ROOT] Files:67 Time: 48s
Restart Phase #:10 [CDB$ROOT] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [CDB$ROOT] Files:1 Time: 86s
Restart Phase #:12 [CDB$ROOT] Files:1 Time: 4s
************** Catproc Procedures **************
Parallel Phase #:13 [CDB$ROOT] Files:94 Time: 21s
Restart Phase #:14 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:15 [CDB$ROOT] Files:120 Time: 32s
Restart Phase #:16 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:17 [CDB$ROOT] Files:22 Time: 13s
Restart Phase #:18 [CDB$ROOT] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [CDB$ROOT] Files:32 Time: 38s
Restart Phase #:20 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:21 [CDB$ROOT] Files:3 Time: 21s
Restart Phase #:22 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:23 [CDB$ROOT] Files:25 Time: 209s
Restart Phase #:24 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:25 [CDB$ROOT] Files:12 Time: 122s
Restart Phase #:26 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:27 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:28 [CDB$ROOT] Files:3 Time: 9s
Serial Phase #:29 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:30 [CDB$ROOT] Files:1 Time: 1s
*************** Catproc CDB Views **************
Serial Phase #:31 [CDB$ROOT] Files:1 Time: 7s
Restart Phase #:32 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:34 [CDB$ROOT] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [CDB$ROOT] Files:293 Time: 38s
Serial Phase #:36 [CDB$ROOT] Files:1 Time: 0s
Restart Phase #:37 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:38 [CDB$ROOT] Files:6 Time: 10s
Restart Phase #:39 [CDB$ROOT] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:40 [CDB$ROOT] Files:3 Time: 68s
Restart Phase #:41 [CDB$ROOT] Files:1 Time: 1s
****************** Catproc SQL *****************
Parallel Phase #:42 [CDB$ROOT] Files:13 Time: 132s
Restart Phase #:43 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:44 [CDB$ROOT] Files:11 Time: 21s
Restart Phase #:45 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:46 [CDB$ROOT] Files:3 Time: 9s
Restart Phase #:47 [CDB$ROOT] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:48 [CDB$ROOT] Files:1 Time: 11s
Restart Phase #:49 [CDB$ROOT] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:50 [CDB$ROOT] Files:1 Time: 10s
************ Upgrade Component Start ***********
Serial Phase #:51 [CDB$ROOT] Files:1 Time: 6s
Restart Phase #:52 [CDB$ROOT] Files:1 Time: 1s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [CDB$ROOT] Files:2 Time: 435s
***************** Upgrading XDB ****************
Restart Phase #:54 [CDB$ROOT] Files:1 Time: 3s
Serial Phase #:56 [CDB$ROOT] Files:3 Time: 15s
Serial Phase #:57 [CDB$ROOT] Files:3 Time: 11s
Parallel Phase #:58 [CDB$ROOT] Files:10 Time: 13s
Parallel Phase #:59 [CDB$ROOT] Files:25 Time: 15s
Serial Phase #:60 [CDB$ROOT] Files:4 Time: 14s
Serial Phase #:61 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:62 [CDB$ROOT] Files:32 Time: 11s
Serial Phase #:63 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:64 [CDB$ROOT] Files:6 Time: 14s
Serial Phase #:65 [CDB$ROOT] Files:2 Time: 25s
Serial Phase #:66 [CDB$ROOT] Files:3 Time: 32s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [CDB$ROOT] Files:1 Time: 4s
Serial Phase #:69 [CDB$ROOT] Files:1 Time: 8s
Parallel Phase #:70 [CDB$ROOT] Files:2 Time: 42s
Restart Phase #:71 [CDB$ROOT] Files:1 Time: 4s
Parallel Phase #:72 [CDB$ROOT] Files:2 Time: 10s
Serial Phase #:73 [CDB$ROOT] Files:2 Time: 9s
***************** Upgrading SDO ****************
Restart Phase #:74 [CDB$ROOT] Files:1 Time: 0s
Serial Phase #:76 [CDB$ROOT] Files:1 Time: 57s
Serial Phase #:77 [CDB$ROOT] Files:2 Time: 11s
Restart Phase #:78 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:79 [CDB$ROOT] Files:1 Time: 44s
Restart Phase #:80 [CDB$ROOT] Files:1 Time: 1s
Parallel Phase #:81 [CDB$ROOT] Files:3 Time: 86s
Restart Phase #:82 [CDB$ROOT] Files:1 Time: 2s
Serial Phase #:83 [CDB$ROOT] Files:1 Time: 14s
Restart Phase #:84 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:85 [CDB$ROOT] Files:1 Time: 17s
Restart Phase #:86 [CDB$ROOT] Files:1 Time: 0s
Parallel Phase #:87 [CDB$ROOT] Files:4 Time: 143s
Restart Phase #:88 [CDB$ROOT] Files:1 Time: 5s
Serial Phase #:89 [CDB$ROOT] Files:1 Time: 8s
Restart Phase #:90 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:91 [CDB$ROOT] Files:2 Time: 15s
Restart Phase #:92 [CDB$ROOT] Files:1 Time: 1s
Serial Phase #:93 [CDB$ROOT] Files:1 Time: 7s
Restart Phase #:94 [CDB$ROOT] Files:1 Time: 0s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [CDB$ROOT] Files:1 Time: 19s
Restart Phase #:96 [CDB$ROOT] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:97 [CDB$ROOT] Files:1 Time: 10s
************* Final Upgrade scripts ************
Serial Phase #:98 [CDB$ROOT] Files:1 Time: 231s
******************* Migration ******************
Serial Phase #:99 [CDB$ROOT] Files:1 Time: 8s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [CDB$ROOT] Files:1 Time: 26s
Serial Phase #:101 [CDB$ROOT] Files:1 Time: 5s
Serial Phase #:102 [CDB$ROOT] Files:1 Time: 55s
***************** Post Upgrade *****************
Serial Phase #:103 [CDB$ROOT] Files:1 Time: 30s
**************** Summary report ****************
Serial Phase #:104 [CDB$ROOT] Files:1 Time: 7s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [CDB$ROOT] Files:1 Time: 11s
Serial Phase #:106 [CDB$ROOT] Files:1 Time: 4s
Serial Phase #:107 [CDB$ROOT] Files:1 Time: 50s
------------------------------------------------------
Phases [0-107] End Time:[2020_05_30 10:15:04]
Container Lists Inclusion:[CDB$ROOT] Exclusion:[NONE]
------------------------------------------------------
Start processing of PDBs (PDB$SEED)
[/oracle/app/orawork/product/19.0.0.0/db_1/perl/bin/perl /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catctl.pl -I -i pdb_seed -n 2 -c 'PDB$SEED' -l /oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013 /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catupgrd.sql]
Argument list for [/oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
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 = /oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013
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: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]
/oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/orahome = [/oracle/app/orawork/product/19.0.0.0/db_1]
/oracle/app/orawork/product/19.0.0.0/db_1/bin/orabasehome = [/oracle/app/orawork/product/19.0.0.0/db_1]
catctlGetOraBaseLogDir = [/oracle/app/orawork/product/19.0.0.0/db_1]
Analyzing file /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catupgrd.sql
Log file directory = [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdpdb_seed_catcon_8466.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdpdb_seed*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdpdb_seed_*.lst] files for spool files, if any
Number of Cpus = 1
Database Name = CDBISTDB
DataBase Version = 19.0.0.0.0
PDB$SEED Open Mode = [MIGRATE]
Generated PDB Inclusion:[PDB$SEED]
CDB$ROOT Open Mode = [OPEN]
Components in [PDB$SEED]
Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [APEX EM MGW ODM RAC WK]
------------------------------------------------------
Phases [0-107] Start Time:[2020_05_30 10:15:51]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [PDB$SEED] Files:1 Time: 50s
*************** Catalog Core SQL ***************
Serial Phase #:1 [PDB$SEED] Files:5 Time: 52s
Restart Phase #:2 [PDB$SEED] Files:1 Time: 0s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [PDB$SEED] Files:19 Time: 29s
Restart Phase #:4 [PDB$SEED] Files:1 Time: 0s
************* Catalog Final Scripts ************
Serial Phase #:5 [PDB$SEED] Files:7 Time: 22s
***************** Catproc Start ****************
Serial Phase #:6 [PDB$SEED] Files:1 Time: 24s
***************** Catproc Types ****************
Serial Phase #:7 [PDB$SEED] Files:2 Time: 16s
Restart Phase #:8 [PDB$SEED] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [PDB$SEED] Files:67 Time: 49s
Restart Phase #:10 [PDB$SEED] Files:1 Time: 2s
************* Catproc Package Specs ************
Serial Phase #:11 [PDB$SEED] Files:1 Time: 75s
Restart Phase #:12 [PDB$SEED] Files:1 Time: 1s
************** Catproc Procedures **************
Parallel Phase #:13 [PDB$SEED] Files:94 Time: 19s
Restart Phase #:14 [PDB$SEED] Files:1 Time: 2s
Parallel Phase #:15 [PDB$SEED] Files:120 Time: 22s
Restart Phase #:16 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:17 [PDB$SEED] Files:22 Time: 9s
Restart Phase #:18 [PDB$SEED] Files:1 Time: 2s
***************** Catproc Views ****************
Parallel Phase #:19 [PDB$SEED] Files:32 Time: 30s
Restart Phase #:20 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:21 [PDB$SEED] Files:3 Time: 17s
Restart Phase #:22 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:23 [PDB$SEED] Files:25 Time: 430s
Restart Phase #:24 [PDB$SEED] Files:1 Time: 2s
Parallel Phase #:25 [PDB$SEED] Files:12 Time: 122s
Restart Phase #:26 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:27 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:28 [PDB$SEED] Files:3 Time: 19s
Serial Phase #:29 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:30 [PDB$SEED] Files:1 Time: 1s
*************** Catproc CDB Views **************
Serial Phase #:31 [PDB$SEED] Files:1 Time: 6s
Restart Phase #:32 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:34 [PDB$SEED] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [PDB$SEED] Files:293 Time: 109s
Serial Phase #:36 [PDB$SEED] Files:1 Time: 0s
Restart Phase #:37 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:38 [PDB$SEED] Files:6 Time: 10s
Restart Phase #:39 [PDB$SEED] Files:1 Time: 0s
*************** Catproc DataPump ***************
Serial Phase #:40 [PDB$SEED] Files:3 Time: 67s
Restart Phase #:41 [PDB$SEED] Files:1 Time: 2s
****************** Catproc SQL *****************
Parallel Phase #:42 [PDB$SEED] Files:13 Time: 133s
Restart Phase #:43 [PDB$SEED] Files:1 Time: 2s
Parallel Phase #:44 [PDB$SEED] Files:11 Time: 12s
Restart Phase #:45 [PDB$SEED] Files:1 Time: 1s
Parallel Phase #:46 [PDB$SEED] Files:3 Time: 8s
Restart Phase #:47 [PDB$SEED] Files:1 Time: 0s
************* Final Catproc scripts ************
Serial Phase #:48 [PDB$SEED] Files:1 Time: 13s
Restart Phase #:49 [PDB$SEED] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:50 [PDB$SEED] Files:1 Time: 11s
************ Upgrade Component Start ***********
Serial Phase #:51 [PDB$SEED] Files:1 Time: 6s
Restart Phase #:52 [PDB$SEED] Files:1 Time: 0s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [PDB$SEED] Files:2 Time: 242s
***************** Upgrading XDB ****************
Restart Phase #:54 [PDB$SEED] Files:1 Time: 2s
Serial Phase #:56 [PDB$SEED] Files:3 Time: 17s
Serial Phase #:57 [PDB$SEED] Files:3 Time: 11s
Parallel Phase #:58 [PDB$SEED] Files:10 Time: 12s
Parallel Phase #:59 [PDB$SEED] Files:25 Time: 13s
Serial Phase #:60 [PDB$SEED] Files:4 Time: 15s
Serial Phase #:61 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:62 [PDB$SEED] Files:32 Time: 14s
Serial Phase #:63 [PDB$SEED] Files:1 Time: 0s
Parallel Phase #:64 [PDB$SEED] Files:6 Time: 14s
Serial Phase #:65 [PDB$SEED] Files:2 Time: 22s
Serial Phase #:66 [PDB$SEED] Files:3 Time: 36s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:69 [PDB$SEED] Files:1 Time: 9s
Parallel Phase #:70 [PDB$SEED] Files:2 Time: 16s
Restart Phase #:71 [PDB$SEED] Files:1 Time: 2s
Parallel Phase #:72 [PDB$SEED] Files:2 Time: 9s
Serial Phase #:73 [PDB$SEED] Files:2 Time: 9s
***************** Upgrading SDO ****************
Restart Phase #:74 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:76 [PDB$SEED] Files:1 Time: 54s
Serial Phase #:77 [PDB$SEED] Files:2 Time: 9s
Restart Phase #:78 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:79 [PDB$SEED] Files:1 Time: 12s
Restart Phase #:80 [PDB$SEED] Files:1 Time: 1s
Parallel Phase #:81 [PDB$SEED] Files:3 Time: 75s
Restart Phase #:82 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:83 [PDB$SEED] Files:1 Time: 14s
Restart Phase #:84 [PDB$SEED] Files:1 Time: 0s
Serial Phase #:85 [PDB$SEED] Files:1 Time: 14s
Restart Phase #:86 [PDB$SEED] Files:1 Time: 1s
Parallel Phase #:87 [PDB$SEED] Files:4 Time: 132s
Restart Phase #:88 [PDB$SEED] Files:1 Time: 2s
Serial Phase #:89 [PDB$SEED] Files:1 Time: 8s
Restart Phase #:90 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:91 [PDB$SEED] Files:2 Time: 22s
Restart Phase #:92 [PDB$SEED] Files:1 Time: 1s
Serial Phase #:93 [PDB$SEED] Files:1 Time: 6s
Restart Phase #:94 [PDB$SEED] Files:1 Time: 1s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [PDB$SEED] Files:1 Time: 17s
Restart Phase #:96 [PDB$SEED] Files:1 Time: 2s
*********** Final Component scripts ***********
Serial Phase #:97 [PDB$SEED] Files:1 Time: 8s
************* Final Upgrade scripts ************
Serial Phase #:98 [PDB$SEED] Files:1 Time: 125s
******************* Migration ******************
Serial Phase #:99 [PDB$SEED] Files:1 Time: 6s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [PDB$SEED] Files:1 Time: 6s
Serial Phase #:101 [PDB$SEED] Files:1 Time: 7s
Serial Phase #:102 [PDB$SEED] Files:1 Time: 4s
***************** Post Upgrade *****************
Serial Phase #:103 [PDB$SEED] Files:1 Time: 396s
**************** Summary report ****************
Serial Phase #:104 [PDB$SEED] Files:1 Time: 6s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [PDB$SEED] Files:1 Time: 7s
Serial Phase #:106 [PDB$SEED] Files:1 Time: 4s
Serial Phase #:107 [PDB$SEED] Files:1 Time: 0s
------------------------------------------------------
Phases [0-107] End Time:[2020_05_30 11:02:01]
Container Lists Inclusion:[PDB$SEED] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 2775s [PDB$SEED]
LOG FILES: (/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdpdb_seed*.log)
Upgrade Summary Report Located in:
/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/upg_summary.log
Start processing of PDBs (PDBISTDB)
[/oracle/app/orawork/product/19.0.0.0/db_1/perl/bin/perl /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catctl.pl -I -i pdbistdb -n 2 -c 'PDBISTDB' -l /oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013 /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catupgrd.sql]
Argument list for [/oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = PDBISTDB
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = pdbistdb
Child Process I = 1
Log Dir l = /oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013
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: [19.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_19.3.0.0.0DBRU_LINUX.X64_190417]
/oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/orahome = [/oracle/app/orawork/product/19.0.0.0/db_1]
/oracle/app/orawork/product/19.0.0.0/db_1/bin/orabasehome = [/oracle/app/orawork/product/19.0.0.0/db_1]
catctlGetOraBaseLogDir = [/oracle/app/orawork/product/19.0.0.0/db_1]
Analyzing file /oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/catupgrd.sql
Log file directory = [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdpdbistdb_catcon_22595.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdpdbistdb*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdpdbistdb_*.lst] files for spool files, if any
Number of Cpus = 1
Database Name = CDBISTDB
DataBase Version = 19.0.0.0.0
PDBISTDB Open Mode = [MIGRATE]
Generated PDB Inclusion:[PDBISTDB]
CDB$ROOT Open Mode = [OPEN]
Components in [PDBISTDB]
Installed [APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [APEX EM MGW ODM RAC WK]
------------------------------------------------------
Phases [0-107] Start Time:[2020_05_30 11:02:48]
Container Lists Inclusion:[PDBISTDB] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [PDBISTDB] Files:1 Time: 49s
*************** Catalog Core SQL ***************
Serial Phase #:1 [PDBISTDB] Files:5 Time: 51s
Restart Phase #:2 [PDBISTDB] Files:1 Time: 2s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [PDBISTDB] Files:19 Time: 30s
Restart Phase #:4 [PDBISTDB] Files:1 Time: 2s
************* Catalog Final Scripts ************
Serial Phase #:5 [PDBISTDB] Files:7 Time: 21s
***************** Catproc Start ****************
Serial Phase #:6 [PDBISTDB] Files:1 Time: 17s
***************** Catproc Types ****************
Serial Phase #:7 [PDBISTDB] Files:2 Time: 14s
Restart Phase #:8 [PDBISTDB] Files:1 Time: 0s
**************** Catproc Tables ****************
Parallel Phase #:9 [PDBISTDB] Files:67 Time: 52s
Restart Phase #:10 [PDBISTDB] Files:1 Time: 2s
************* Catproc Package Specs ************
Serial Phase #:11 [PDBISTDB] Files:1 Time: 68s
Restart Phase #:12 [PDBISTDB] Files:1 Time: 1s
************** Catproc Procedures **************
Parallel Phase #:13 [PDBISTDB] Files:94 Time: 15s
Restart Phase #:14 [PDBISTDB] Files:1 Time: 1s
Parallel Phase #:15 [PDBISTDB] Files:120 Time: 18s
Restart Phase #:16 [PDBISTDB] Files:1 Time: 1s
Serial Phase #:17 [PDBISTDB] Files:22 Time: 9s
Restart Phase #:18 [PDBISTDB] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [PDBISTDB] Files:32 Time: 30s
Restart Phase #:20 [PDBISTDB] Files:1 Time: 1s
Serial Phase #:21 [PDBISTDB] Files:3 Time: 20s
Restart Phase #:22 [PDBISTDB] Files:1 Time: 2s
Parallel Phase #:23 [PDBISTDB] Files:25 Time: 206s
Restart Phase #:24 [PDBISTDB] Files:1 Time: 2s
Parallel Phase #:25 [PDBISTDB] Files:12 Time: 124s
Restart Phase #:26 [PDBISTDB] Files:1 Time: 2s
Serial Phase #:27 [PDBISTDB] Files:1 Time: 0s
Serial Phase #:28 [PDBISTDB] Files:3 Time: 8s
Serial Phase #:29 [PDBISTDB] Files:1 Time: 0s
Restart Phase #:30 [PDBISTDB] Files:1 Time: 0s
*************** Catproc CDB Views **************
Serial Phase #:31 [PDBISTDB] Files:1 Time: 6s
Restart Phase #:32 [PDBISTDB] Files:1 Time: 1s
Serial Phase #:34 [PDBISTDB] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [PDBISTDB] Files:293 Time: 19s
Serial Phase #:36 [PDBISTDB] Files:1 Time: 0s
Restart Phase #:37 [PDBISTDB] Files:1 Time: 2s
Serial Phase #:38 [PDBISTDB] Files:6 Time: 8s
Restart Phase #:39 [PDBISTDB] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:40 [PDBISTDB] Files:3 Time: 55s
Restart Phase #:41 [PDBISTDB] Files:1 Time: 1s
****************** Catproc SQL *****************
Parallel Phase #:42 [PDBISTDB] Files:13 Time: 138s
Restart Phase #:43 [PDBISTDB] Files:1 Time: 2s
Parallel Phase #:44 [PDBISTDB] Files:11 Time: 11s
Restart Phase #:45 [PDBISTDB] Files:1 Time: 2s
Parallel Phase #:46 [PDBISTDB] Files:3 Time: 7s
Restart Phase #:47 [PDBISTDB] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:48 [PDBISTDB] Files:1 Time: 13s
Restart Phase #:49 [PDBISTDB] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:50 [PDBISTDB] Files:1 Time: 9s
************ Upgrade Component Start ***********
Serial Phase #:51 [PDBISTDB] Files:1 Time: 7s
Restart Phase #:52 [PDBISTDB] Files:1 Time: 0s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [PDBISTDB] Files:2 Time: 206s
***************** Upgrading XDB ****************
Restart Phase #:54 [PDBISTDB] Files:1 Time: 1s
Serial Phase #:56 [PDBISTDB] Files:3 Time: 17s
Serial Phase #:57 [PDBISTDB] Files:3 Time: 9s
Parallel Phase #:58 [PDBISTDB] Files:10 Time: 11s
Parallel Phase #:59 [PDBISTDB] Files:25 Time: 12s
Serial Phase #:60 [PDBISTDB] Files:4 Time: 14s
Serial Phase #:61 [PDBISTDB] Files:1 Time: 0s
Serial Phase #:62 [PDBISTDB] Files:32 Time: 10s
Serial Phase #:63 [PDBISTDB] Files:1 Time: 0s
Parallel Phase #:64 [PDBISTDB] Files:6 Time: 14s
Serial Phase #:65 [PDBISTDB] Files:2 Time: 22s
Serial Phase #:66 [PDBISTDB] Files:3 Time: 28s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [PDBISTDB] Files:1 Time: 2s
Serial Phase #:69 [PDBISTDB] Files:1 Time: 8s
Parallel Phase #:70 [PDBISTDB] Files:2 Time: 15s
Restart Phase #:71 [PDBISTDB] Files:1 Time: 2s
Parallel Phase #:72 [PDBISTDB] Files:2 Time: 9s
Serial Phase #:73 [PDBISTDB] Files:2 Time: 9s
***************** Upgrading SDO ****************
Restart Phase #:74 [PDBISTDB] Files:1 Time: 2s
Serial Phase #:76 [PDBISTDB] Files:1 Time: 51s
Serial Phase #:77 [PDBISTDB] Files:2 Time: 9s
Restart Phase #:78 [PDBISTDB] Files:1 Time: 1s
Serial Phase #:79 [PDBISTDB] Files:1 Time: 16s
Restart Phase #:80 [PDBISTDB] Files:1 Time: 0s
Parallel Phase #:81 [PDBISTDB] Files:3 Time: 68s
Restart Phase #:82 [PDBISTDB] Files:1 Time: 2s
Serial Phase #:83 [PDBISTDB] Files:1 Time: 11s
Restart Phase #:84 [PDBISTDB] Files:1 Time: 2s
Serial Phase #:85 [PDBISTDB] Files:1 Time: 15s
Restart Phase #:86 [PDBISTDB] Files:1 Time: 0s
Parallel Phase #:87 [PDBISTDB] Files:4 Time: 96s
Restart Phase #:88 [PDBISTDB] Files:1 Time: 2s
Serial Phase #:89 [PDBISTDB] Files:1 Time: 8s
Restart Phase #:90 [PDBISTDB] Files:1 Time: 1s
Serial Phase #:91 [PDBISTDB] Files:2 Time: 22s
Restart Phase #:92 [PDBISTDB] Files:1 Time: 1s
Serial Phase #:93 [PDBISTDB] Files:1 Time: 6s
Restart Phase #:94 [PDBISTDB] Files:1 Time: 1s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [PDBISTDB] Files:1 Time: 15s
Restart Phase #:96 [PDBISTDB] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:97 [PDBISTDB] Files:1 Time: 8s
************* Final Upgrade scripts ************
Serial Phase #:98 [PDBISTDB] Files:1 Time: 125s
******************* Migration ******************
Serial Phase #:99 [PDBISTDB] Files:1 Time: 7s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [PDBISTDB] Files:1 Time: 6s
Serial Phase #:101 [PDBISTDB] Files:1 Time: 5s
Serial Phase #:102 [PDBISTDB] Files:1 Time: 6s
***************** Post Upgrade *****************
Serial Phase #:103 [PDBISTDB] Files:1 Time: 23s
**************** Summary report ****************
Serial Phase #:104 [PDBISTDB] Files:1 Time: 7s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [PDBISTDB] Files:1 Time: 6s
Serial Phase #:106 [PDBISTDB] Files:1 Time: 4s
Serial Phase #:107 [PDBISTDB] Files:1 Time: 0s
------------------------------------------------------
Phases [0-107] End Time:[2020_05_30 11:35:17]
Container Lists Inclusion:[PDBISTDB] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 1949s [PDBISTDB]
LOG FILES: (/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdpdbistdb*.log)
Upgrade Summary Report Located in:
/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/upg_summary.log
Time: 2667s For CDB$ROOT
Time: 4816s For PDB(s)
Grand Total Time: 7483s
LOG FILES: (/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/catupgrdcdbroot*.log)
Upgrade Summary Report Located in:
/oracle/app/orawork/product/19.0.0.0/db_1/cfgtoollogs/CDBISTDB/upgrade20200530093013/upg_summary.log
Grand Total Upgrade Time: [0d:2h:4m:43s]
15.Now Add database to 19c Oracle Restart
[oracle@dm10db11 dbs]$ srvctl add database -d CDBISTDB -o /oracle/app/orawork/product/19.0.0.0/db_1 -m database.com -p +DATA/CDBISTDB/PARAMETERFILE/spfile.270.1041127369 -s OPEN -t IMMEDIATE -y AUTOMATIC
[oracle@dm10db11 dbs]$
[oracle@dm10db11 dbs]$
[oracle@dm10db11 dbs]$ srvctl stop database -d CDBISTDB
PRCC-1016 : CDBISTDB was already stopped
[oracle@dm10db11 dbs]$
[oracle@dm10db11 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 30 12:05:55 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL>
SQL>
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@dm10db11 dbs]$
[oracle@dm10db11 dbs]$
[oracle@dm10db11 dbs]$
[oracle@dm10db11 dbs]$ srvctl start database -d CDBISTDB
[oracle@dm10db11 dbs]$
[oracle@dm10db11 dbs]$
[oracle@dm10db11 dbs]$ ps -ef |grep pmon
grid 3915 1 0 01:10 ? 00:00:01 asm_pmon_+ASM
oracle 9271 1 0 12:08 ? 00:00:00 ora_pmon_CDBISTDB
[oracle@dm10db11 dbs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 30 12:11:26 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> select name,open_mode,cdb,version,status from v$database,v$instance;
NAME OPEN_MODE CDB VERSION STATUS
--------- -------------------- --- ----------------- ------------
CDBISTDB READ WRITE YES 19.0.0.0.0 OPEN
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB MOUNTED
SQL> alter pluggable database PDBISTDB open read write;
Pluggable database altered.
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB READ WRITE NO
SQL>
SQL> show parameter spfile
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
spfile string +DATA/CDBISTDB/PARAMETERFILE/s
pfile.270.1041127369
select * from v$version;
BANNER BANNER_FULL BANNER_LEGACY CON_ID
-------------------------------------------------- -------------------------------------------------- -------------------------------------------------- ----------
Oracle Database 19c Enterprise Edition Release 19. Oracle Database 19c Enterprise Edition Release 19. Oracle Database 19c Enterprise Edition Release 19. 0
0.0.0.0 - Production 0.0.0.0 - Production 0.0.0.0 - Production
Version 19.3.0.0.0
SQL> col COMP_ID for a10
col COMP_NAME for a40
col VERSION for a15
set lines 180
set pages 999
select COMP_ID,COMP_NAME,VERSION,STATUS from dba_registry;SQL> SQL> SQL> SQL> SQL>
COMP_ID COMP_NAME VERSION STATUS
---------- ---------------------------------------- --------------- --------------------------------------------
CATALOG Oracle Database Catalog Views 19.0.0.0.0 UPGRADED
CATPROC Oracle Database Packages and Types 19.0.0.0.0 UPGRADED
JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 UPGRADED
XML Oracle XDK 19.0.0.0.0 UPGRADED
CATJAVA Oracle Database Java Packages 19.0.0.0.0 UPGRADED
APS OLAP Analytic Workspace 19.0.0.0.0 UPGRADED
RAC Oracle Real Application Clusters 19.0.0.0.0 UPGRADED
XDB Oracle XML Database 19.0.0.0.0 UPGRADED
OWM Oracle Workspace Manager 19.0.0.0.0 UPGRADED
CONTEXT Oracle Text 19.0.0.0.0 UPGRADED
ORDIM Oracle Multimedia 19.0.0.0.0 UPGRADED
SDO Spatial 19.0.0.0.0 UPGRADED
XOQ Oracle OLAP API 19.0.0.0.0 UPGRADED
OLS Oracle Label Security 19.0.0.0.0 UPGRADED
DV Oracle Database Vault 19.0.0.0.0 UPGRADED
15 rows selected.
It will run 2 times once for CDB$ROOT and then for PDBISTDB
@$ORACLE_HOME/rdbms/admin/catuppst.sql
------------postupgrade_fixups.sql-------------------
[oracle@dm10db11 admin]$ $ORACLE_HOME/perl/bin/perl -I$ORACLE_HOME/perl/lib -I$ORACLE_HOME/rdbms/admin $ORACLE_HOME/rdbms/admin/catcon.pl -l /oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/ -b postup_CDBISTDB /oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/postupgrade_fixups.sql
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/postup_CDBISTDB_catcon_12824.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/postup_CDBISTDB*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/cfgtoollogs/CDBISTDB/preupgrade/postup_CDBISTDB_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@dm10db11 admin]$
------------utlrp.sql-------------------
[oracle@dm10db11 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/utlrp_catcon_16851.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/utlrp*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/product/19.0.0.0/db_1/rdbms/admin/utlrp_*.lst] files for spool files, if any
catcon.pl: completed successfully
----INFO----Download DST for timezone upgrade : Doc ID 1585343.1
[oracle@dm10db11 oracle]$ unzip --q DBMS_DST_scriptsV1.9.zip
Archive: DBMS_DST_scriptsV1.9.zip
creating: DBMS_DST_scriptsV1.9/
inflating: DBMS_DST_scriptsV1.9/countstarTSTZ.sql
inflating: DBMS_DST_scriptsV1.9/countstatsTSTZ.sql
inflating: DBMS_DST_scriptsV1.9/upg_tzv_apply.sql
inflating: DBMS_DST_scriptsV1.9/upg_tzv_check.sql
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$ ls -lr
total 68
-rw-r--r--. 1 oracle oinstall 31010 Aug 22 2014 upg_tzv_check.sql
-rw-r--r--. 1 oracle oinstall 19502 Aug 22 2014 upg_tzv_apply.sql
-rw-r--r--. 1 oracle oinstall 7213 Mar 17 2018 countstatsTSTZ.sql
-rw-r--r--. 1 oracle oinstall 6294 Jan 8 2015 countstarTSTZ.sql
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 30 13:13:50 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> spool countstatsTSTZ.log
SQL> @countstatsTSTZ.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_rows
27/05/2020 - SYS.AQ$_ALERT_QT_S.CREATION_TIME - 4
27/05/2020 - SYS.AQ$_ALERT_QT_S.DELETION_TIME - 4
27/05/2020 - SYS.AQ$_ALERT_QT_S.MODIFICATION_TIME - 4
26/01/2017 - SYS.AQ$_AQ$_MEM_MC_S.CREATION_TIME - 3
26/01/2017 - SYS.AQ$_AQ$_MEM_MC_S.DELETION_TIME - 3
26/01/2017 - SYS.AQ$_AQ$_MEM_MC_S.MODIFICATION_TIME - 3
26/01/2017 - SYS.AQ$_AQ_PROP_TABLE_S.CREATION_TIME - 1
26/01/2017 - SYS.AQ$_AQ_PROP_TABLE_S.DELETION_TIME - 1
26/01/2017 - SYS.AQ$_AQ_PROP_TABLE_S.MODIFICATION_TIME - 1
26/01/2017 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.CREATION_TIME - 1
26/01/2017 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.DELETION_TIME - 1
26/01/2017 - SYS.AQ$_ORA$PREPLUGIN_BACKUP_QTB_S.MODIFICATION_TIME - 1
30/05/2020 - SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.CREATION_TIME - 1
30/05/2020 - SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.DELETION_TIME - 1
30/05/2020 - SYS.AQ$_PDB_MON_EVENT_QTABLE$_S.MODIFICATION_TIME - 1
27/05/2020 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.CREATION_TIME - 3
27/05/2020 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.DELETION_TIME - 3
27/05/2020 - SYS.AQ$_SCHEDULER$_EVENT_QTAB_S.MODIFICATION_TIME - 3
26/01/2017 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.CREATION_TIME - 1
26/01/2017 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.DELETION_TIME - 1
26/01/2017 - SYS.AQ$_SCHEDULER$_REMDB_JOBQTAB_S.MODIFICATION_TIME - 1
27/05/2020 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.CREATION_TIME - 1
27/05/2020 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.DELETION_TIME - 1
27/05/2020 - SYS.AQ$_SCHEDULER_FILEWATCHER_QT_S.MODIFICATION_TIME - 1
30/05/2020 - SYS.AQ$_SUBSCRIBER_TABLE.CREATION_TIME - 1
30/05/2020 - SYS.AQ$_SUBSCRIBER_TABLE.DELETION_TIME - 1
30/05/2020 - SYS.AQ$_SUBSCRIBER_TABLE.MODIFICATION_TIME - 1
26/01/2017 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.CREATION_TIME - 4
26/01/2017 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.DELETION_TIME - 4
26/01/2017 - SYS.AQ$_SYS$SERVICE_METRICS_TAB_S.MODIFICATION_TIME - 4
30/05/2020 - SYS.KET$_AUTOTASK_STATUS.ABA_START_TIME - 1
30/05/2020 - SYS.KET$_AUTOTASK_STATUS.ABA_STATE_TIME - 1
30/05/2020 - SYS.KET$_AUTOTASK_STATUS.MW_RECORD_TIME - 1
30/05/2020 - SYS.KET$_AUTOTASK_STATUS.MW_START_TIME - 1
30/05/2020 - SYS.KET$_AUTOTASK_STATUS.RECONCILE_TIME - 1
30/05/2020 - SYS.KET$_CLIENT_CONFIG.FIELD_2 - 7
30/05/2020 - SYS.KET$_CLIENT_CONFIG.LAST_CHANGE - 7
30/05/2020 - SYS.KET$_CLIENT_TASKS.CURR_WIN_START - 3
30/05/2020 - SYS.KET$_CLIENT_TASKS.LG_DATE - 3
30/05/2020 - SYS.KET$_CLIENT_TASKS.LT_DATE - 3
30/05/2020 - SYS.OPTSTAT_HIST_CONTROL$.SPARE6 - 45
30/05/2020 - SYS.OPTSTAT_HIST_CONTROL$.SVAL2 - 45
30/05/2020 - SYS.OPTSTAT_SNAPSHOT$.TIMESTAMP - 5289
30/05/2020 - SYS.OPTSTAT_USER_PREFS$.CHGTIME - 72
27/05/2020 - SYS.RADM_FPTM$.TSWTZ_COL - 1
27/05/2020 - SYS.REG$.NTFN_GROUPING_START_TIME - 2
27/05/2020 - SYS.REG$.REG_TIME - 2
30/05/2020 - SYS.SCHEDULER$_EVENT_LOG.LOG_DATE - 215
30/05/2020 - SYS.SCHEDULER$_GLOBAL_ATTRIBUTE.ATTR_TSTAMP - 11
30/05/2020 - SYS.SCHEDULER$_JOB.END_DATE - 21
30/05/2020 - SYS.SCHEDULER$_JOB.LAST_ENABLED_TIME - 21
30/05/2020 - SYS.SCHEDULER$_JOB.LAST_END_DATE - 21
30/05/2020 - SYS.SCHEDULER$_JOB.LAST_START_DATE - 21
30/05/2020 - SYS.SCHEDULER$_JOB.NEXT_RUN_DATE - 21
30/05/2020 - SYS.SCHEDULER$_JOB.START_DATE - 21
30/05/2020 - SYS.SCHEDULER$_JOB_RUN_DETAILS.LOG_DATE - 56
30/05/2020 - SYS.SCHEDULER$_JOB_RUN_DETAILS.REQ_START_DATE - 56
30/05/2020 - SYS.SCHEDULER$_JOB_RUN_DETAILS.START_DATE - 56
27/05/2020 - SYS.SCHEDULER$_SCHEDULE.END_DATE - 4
27/05/2020 - SYS.SCHEDULER$_SCHEDULE.REFERENCE_DATE - 4
30/05/2020 - SYS.SCHEDULER$_WINDOW.ACTUAL_START_DATE - 9
30/05/2020 - SYS.SCHEDULER$_WINDOW.END_DATE - 9
30/05/2020 - SYS.SCHEDULER$_WINDOW.LAST_START_DATE - 9
30/05/2020 - SYS.SCHEDULER$_WINDOW.MANUAL_OPEN_TIME - 9
30/05/2020 - SYS.SCHEDULER$_WINDOW.NEXT_START_DATE - 9
30/05/2020 - SYS.SCHEDULER$_WINDOW.START_DATE - 9
30/05/2020 - SYS.SCHEDULER$_WINDOW_DETAILS.LOG_DATE - 2
30/05/2020 - SYS.SCHEDULER$_WINDOW_DETAILS.REQ_START_DATE - 2
30/05/2020 - SYS.SCHEDULER$_WINDOW_DETAILS.START_DATE - 2
30/05/2020 - SYS.STATS_TARGET$.END_TIME - 563
30/05/2020 - SYS.STATS_TARGET$.START_TIME - 563
30/05/2020 - SYS.TAB_STATS$.SPARE6 - 1137
30/05/2020 - SYS.WRI$_ALERT_HISTORY.CREATION_TIME - 18
30/05/2020 - SYS.WRI$_ALERT_HISTORY.TIME_SUGGESTED - 18
30/05/2020 - SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SAVTIME - 98523
30/05/2020 - SYS.WRI$_OPTSTAT_HISTGRM_HISTORY.SPARE6 - 98523
30/05/2020 - SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SAVTIME - 41500
30/05/2020 - SYS.WRI$_OPTSTAT_HISTHEAD_HISTORY.SPARE6 - 41500
30/05/2020 - SYS.WRI$_OPTSTAT_IND_HISTORY.SAVTIME - 2465
30/05/2020 - SYS.WRI$_OPTSTAT_IND_HISTORY.SPARE6 - 2465
30/05/2020 - SYS.WRI$_OPTSTAT_OPR.END_TIME - 343
30/05/2020 - SYS.WRI$_OPTSTAT_OPR.SPARE6 - 343
30/05/2020 - SYS.WRI$_OPTSTAT_OPR.START_TIME - 343
30/05/2020 - SYS.WRI$_OPTSTAT_OPR_TASKS.END_TIME - 6100
30/05/2020 - SYS.WRI$_OPTSTAT_OPR_TASKS.SPARE6 - 6100
30/05/2020 - SYS.WRI$_OPTSTAT_OPR_TASKS.START_TIME - 6100
30/05/2020 - SYS.WRI$_OPTSTAT_TAB_HISTORY.SAVTIME - 2599
30/05/2020 - SYS.WRI$_OPTSTAT_TAB_HISTORY.SPARE6 - 2599
30/05/2020 - SYS.WRM$_DATABASE_INSTANCE.STARTUP_TIME_TZ - 9
30/05/2020 - SYS.WRM$_PDB_INSTANCE.OPEN_TIME_TZ - 10
30/05/2020 - SYS.WRM$_PDB_INSTANCE.STARTUP_TIME_TZ - 10
30/05/2020 - SYS.WRM$_PDB_IN_SNAP.OPEN_TIME_TZ - 9
30/05/2020 - SYS.WRM$_SNAPSHOT.BEGIN_INTERVAL_TIME_TZ - 18
30/05/2020 - SYS.WRM$_SNAPSHOT.END_INTERVAL_TIME_TZ - 18
26/01/2017 - SYS.XS$PRIN.END_DATE - 15
26/01/2017 - SYS.XS$PRIN.START_DATE - 15
Total numrow of SYS TSTZ columns is : 318038
There are in total 162 non-SYS TSTZ columns.
.
For non-SYS tables ...
Note: empty tables are not listed.
Stat date - Owner.Tablename.Columnname - num_rows
26/01/2017 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.CREATION_TIME - 1
26/01/2017 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.DELETION_TIME - 1
26/01/2017 - GSMADMIN_INTERNAL.AQ$_CHANGE_LOG_QUEUE_TABLE_S.MODIFICATION_TIME -
1
26/01/2017 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.CREATION_TIME - 1
26/01/2017 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.DELETION_TIME - 1
26/01/2017 - WMSYS.AQ$_WM$EVENT_QUEUE_TABLE_S.MODIFICATION_TIME - 1
26/01/2017 - WMSYS.WM$WORKSPACES_TABLE$.CREATETIME - 1
26/01/2017 - WMSYS.WM$WORKSPACES_TABLE$.LAST_CHANGE - 1
Total numrow of non-SYS TSTZ columns is : 8
There are in total 20 non-SYS TSTZ columns.
Total Minutes elapsed : 0
SQL>
SQL>
SQL> spool off
SQL>
SQL>
SQL> exec dbms_scheduler.purge_log;
PL/SQL procedure successfully completed.
SQL>
SQL> spool upg_tzv_check.log
SQL> @upg_tzv_check.sql
INFO: Starting with RDBMS DST update preparation.
INFO: NO actual RDBMS DST update will be done by this script.
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: Doing checks for known issues ...
INFO: Database version is 19.0.0.0 .
INFO: Database RDBMS DST version is DSTv26 .
INFO: No known issues detected.
INFO: Now detecting new RDBMS DST version.
A prepare window has been successfully started.
INFO: Newest RDBMS DST version detected is DSTv32 .
INFO: Next step is checking all TSTZ data.
INFO: It might take a while before any further output is seen ...
A prepare window has been successfully ended.
INFO: A newer RDBMS DST version than the one currently used is found.
INFO: Note that NO DST update was yet done.
INFO: Now run upg_tzv_apply.sql to do the actual RDBMS DST update.
INFO: Note that the upg_tzv_apply.sql script will
INFO: restart the database 2 times WITHOUT any confirmation or prompt.
SQL>
SQL>
SQL> spool off
SQL>
SQL> spool upg_tzv_apply.log
SQL>
SQL> ----Actual DST Upgrade----
SQL>
SQL> @upg_tzv_apply.sql
INFO: If an ERROR occurs the script will EXIT sqlplus.
INFO: The database RDBMS DST version will be updated to DSTv32 .
WARNING: This script will restart the database 2 times
WARNING: WITHOUT asking ANY confirmation.
WARNING: Hit control-c NOW if this is not intended.
INFO: Restarting the database in UPGRADE mode to start the DST upgrade.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1157627856 bytes
Fixed Size 9134032 bytes
Variable Size 1006632960 bytes
Database Buffers 134217728 bytes
Redo Buffers 7643136 bytes
Database mounted.
Database opened.
INFO: Starting the RDBMS DST upgrade.
INFO: Upgrading all SYS owned TSTZ data.
INFO: It might take time before any further output is seen ...
An upgrade window has been successfully started.
INFO: Restarting the database in NORMAL mode to upgrade non-SYS TSTZ data.
Database closed.
Database dismounted.
ORACLE instance shut down.
ORACLE instance started.
Total System Global Area 1157627856 bytes
Fixed Size 9134032 bytes
Variable Size 1006632960 bytes
Database Buffers 134217728 bytes
Redo Buffers 7643136 bytes
Database mounted.
Database opened.
INFO: Upgrading all non-SYS TSTZ data.
INFO: It might take time before any further output is seen ...
INFO: Do NOT start any application yet that uses TSTZ data!
INFO: Next is a list of all upgraded tables:
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_S"
Number of failures: 0
Table list: "GSMADMIN_INTERNAL"."AQ$_CHANGE_LOG_QUEUE_TABLE_L"
Number of failures: 0
Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"
Number of failures: 0
Table list: "DVSYS"."SIMULATION_LOG$"
Number of failures: 0
Table list: "DVSYS"."AUDIT_TRAIL$"
Number of failures: 0
INFO: Total failures during update of TSTZ data: 0 .
An upgrade window has been successfully ended.
INFO: Your new Server RDBMS DST version is DSTv32 .
INFO: The RDBMS DST update is successfully finished.
INFO: Make sure to exit this sqlplus session.
INFO: Do not use it for timezone related selects.
SQL>
SQL> SELECT version FROM v$timezone_file;
VERSION
----------
32
1 row selected.
Timezone upgraded :
SQL> @?/rdbms/admin/utlusts.sql TEXT
Oracle Database Release 19 Post-Upgrade Status Tool 05-30-2020 13:32:4
Container Database: CDBISTDB
[CON_ID: 1 => CDB$ROOT]
Component Current Full Elapsed Time
Name Status Version HH:MM:SS
Oracle Server VALID 19.3.0.0.0 00:18:44
JServer JAVA Virtual Machine VALID 19.3.0.0.0 00:03:14
Oracle XDK VALID 19.3.0.0.0 00:01:05
Oracle Database Java Packages VALID 19.3.0.0.0 00:00:14
OLAP Analytic Workspace VALID 19.3.0.0.0 00:00:20
Oracle Label Security VALID 19.3.0.0.0 00:00:10
Oracle Database Vault VALID 19.3.0.0.0 00:00:34
Oracle Text VALID 19.3.0.0.0 00:00:39
Oracle Workspace Manager VALID 19.3.0.0.0 00:00:44
Oracle Real Application Clusters OPTION OFF 19.3.0.0.0 00:00:00
Oracle XML Database VALID 19.3.0.0.0 00:02:20
Oracle Multimedia VALID 19.3.0.0.0 00:01:04
Spatial VALID 19.3.0.0.0 00:06:37
Oracle OLAP API VALID 19.3.0.0.0 00:00:11
Datapatch 00:03:33
Final Actions 00:03:59
Post Upgrade 00:00:00
Post Compile 00:00:06
Total Upgrade Time: 00:41:18 [CON_ID: 1 => CDB$ROOT]
Database time zone version is 32. It meets current release needs.
SQL> col name for a20
col GUARANTEE_FLASHBACK_DATABASE for a10
col TIME for a60
set lines 190
select NAME,GUARANTEE_FLASHBACK_DATABASE,TIME from V$restore_point;SQL> SQL> SQL> SQL>
NAME GUARANTEE_ TIME
-------------------- ---------- ------------------------------------------------------------
FB_UPGRADE YES 30-MAY-20 08.44.24.000000000 AM
SQL> drop restore point FB_UPGRADE;
Restore point dropped.
SQL> select NAME,GUARANTEE_FLASHBACK_DATABASE,TIME from V$restore_point;
no rows selected
we would not have any option other than export/import to downgrade the database.
If you can get downtime after a week or so , I would suggest you not to change compatible
for atleast a week to check database and performance after upgrade and by chance if you need to downgrade
that can be downgraded using the flashback.
If you change COMPATIBLE you can directly drop your restore points as they are useless.
You can’t use Flashback Database to restore point back across a compatibility change of your database.
22.Update the compatible parameter and restart database.
SQL> show parameter COMPATIBLE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 12.2.0
noncdb_compatible boolean FALSE
SQL>
SQL> ALTER SYSTEM SET COMPATIBLE = '19.0.0' SCOPE=SPFILE;
System altered.
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$ srvctl stop database -d CDBISTDB
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$ srvctl start database -d CDBISTDB
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$ ps -ef |grep pmon
grid 3915 1 0 01:10 ? 00:00:02 asm_pmon_+ASM
oracle 29591 1 0 13:41 ? 00:00:00 ora_pmon_CDBISTDB
oracle 29971 22684 0 13:41 pts/0 00:00:00 grep --color=auto pmon
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$
[oracle@dm10db11 DBMS_DST_scriptsV1.9]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat May 30 13:42:02 2020
Version 19.3.0.0.0
Copyright (c) 1982, 2019, Oracle. All rights reserved.
Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB MOUNTED
SQL>
SQL> alter pluggable database PDBISTDB open read write;
Pluggable database altered.
SQL>
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB READ WRITE NO
SQL>
SQL> show parameter COMPATIBLE
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 19.0.0
noncdb_compatible boolean FALSE
SQL>
SQL> SELECT version FROM v$timezone_file;
VERSION
----------
32
--------------------------------Upgrade completed ----------------------------------------
1. Shutdown immediate;
2. set ORACLE_HOME to 12.2
3. Start up mount ( with the 12c spfile)
4. select * from v$restore_point;
5. flashback database to restore point FB_UPGRADE. ( this restore point was created before upgrade)
6. alter database open resetlogs;
Follow the below link for Grid upgradation from 12cR2 to 19c :
3 comments
Click here for commentsGood steps nice article
ReplyGood steps , really helped me out in my upgrade process very useful document made
Replyvery good detailed article, thanks for sharing
ReplyConversionConversion EmoticonEmoticon