upgrade database from 19c to 26ai !!!
oracle 26ai 192.168.1.148
on 19c
CREATE USER c##uprgd IDENTIFIED BY oracle DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp CONTAINER=ALL;
GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE, SYSOPER TO c##uprgd CONTAINER = ALL;
on 19c
cat tnsnames.ora
orclcdb2 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.109)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orclcdb)
)
)
orclcdb1 =(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.1.109)(PORT=1521))(CONNECT_DATA=(SERVER=dedicated)(SERVICE_NAME=orclcdb)))
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB MOUNTED
SQL>
on 26ai
SQL> CREATE public DATABASE link clonedb CONNECT TO c##uprgd IDENTIFIED BY oracle USING 'orclcdb1';
Database link created.
orclcdb1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.109)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl19)
)
)
===========
19c
ILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_ LOST_WR
------- -------
/u01/app/oracle/oradata/ORCLCDB/orcl/undotbs2.dbf
15 UNDOTBS2 209715200 25600 AVAILABLE
15 YES 3.4360E+10 4194302 6400 208666624 25472
ONLINE OFF
26ai
FILE_NAME
--------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS STATUS
---------- ------------------------------ ---------- ---------- ---------
RELATIVE_FNO AUT MAXBYTES MAXBLOCKS INCREMENT_BY USER_BYTES USER_BLOCKS
------------ --- ---------- ---------- ------------ ---------- -----------
ONLINE_ LOST_WR
------- -------
/u01/app/oracle/oradata/ORCL/orclpdb/users01.dbf
15 USERS 7340032 896 AVAILABLE
1024 YES 3.5184E+13 4294967293 160 1015808 124
ONLINE OFF
=============
orclcdb1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.109)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl19)
)
)
SQL> SELECT sys_context('USERENV','CON_NAME') FROM dual@clonedb;
SYS_CONTEXT('USERENV','CON_NAME')
--------------------------------------------------------------------------------
CDB$ROOT
on 26ai!!!
SQL> CREATE PLUGGABLE DATABASE ORCL19 FROM ORCL19@clonedb file_name_convert=('orcl','PDBU');
Pluggable database created.
or
CREATE PLUGGABLE DATABASE PDB19
FROM ORCL19@clonedb
FILE_NAME_CONVERT = (
'/u01/app/oracle/oradata/ORCLCDB/orcl/',
'/u01/app/oracle/oradata/ORCLCDB/PDB19/'
);
show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDB READ WRITE NO
4 ORCL19 MOUNTED
SQL>
ALTER PLUGGABLE DATABASE ORCL19 OPEN UPGRADE;
dbupgrade -c "ORCL19" -l /home/oracle/logs
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 ORCLPDB MOUNTED
4 ORCL19 MOUNTED
SQL> ALTER PLUGGABLE DATABASE ORCL19 OPEN UPGRADE;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 ORCLPDB MOUNTED
4 ORCL19 MIGRATE YES
SQL> Disconnected from Oracle AI Database 26ai Enterprise Edition Release 23.26.1.0.0 - Production
Version 23.26.1.0.0
[oracle@centos9 admin]$ locate dbupgrade
/u01/app/oracle/product/23.26.0/db_1/bin/dbupgrade
[oracle@centos9 admin]$ dbupgrade -c "ORCL19" -l /home/oracle/logs
Manual upgrade using dbupgrade is desupported as of Oracle Database 23.4. Oracle recommends using AutoUpgrade to upgrade your database. Refer to My Oracle Support Note 2485457.1 for details on AutoUpgrade.
Argument list for [/u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = ORCL19
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 = /home/oracle/logs
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
Classic Upgrade t = 0
RO User Tablespaces T = 0
Zip Logs w = 0
Upgrade PDBs in Upgrade mode x = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
Manual upgrade using catctl.pl is desupported as of Oracle Database 23.4. Oracle recommends using AutoUpgrade to upgrade your database.
catctl.pl VERSION: [23.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_23.26.1.0.0DBRU_LINUX.X64_260116.1]
/u01/app/oracle/product/23.26.0/db_1/rdbms/admin/orahome = [/u01/app/oracle/product/23.26.0/db_1]
/u01/app/oracle/product/23.26.0/db_1/bin/orabasehome = [/u01/app/oracle/product/23.26.0/db_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/23.26.0/db_1]
Analyzing file /u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catupgrd.sql
Log file directory = [/home/oracle/logs]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/logs/catupgrd_catcon_5752.lst]
catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 9
Database Name = orcl
DataBase Version = 23.0.0.0.0
Parallel SQL Process Count (PDB) = 2
Parallel SQL Process Count (CDB$ROOT) = 8
Generated PDB Inclusion:[ORCL19]
CDB$ROOT Open Mode = [OPEN]
DataBase Version = 23.0.0.0.0
** Must upgrade either a CDB$ROOT or a Pdb **
Concurrent PDB Upgrades Reset = 1
Concurrent PDB Upgrades = 1
Start processing of PDBs (ORCL19)
[/u01/app/oracle/product/23.26.0/db_1/perl/bin/perl /u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catctl.pl -c 'ORCL19' -l /home/oracle/logs -I -i orcl19 -n 2 /u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catupgrd.sql]
Argument list for [/u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = ORCL19
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = orcl19
Child Process I = 1
Log Dir l = /home/oracle/logs
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
Classic Upgrade t = 0
RO User Tablespaces T = 0
Zip Logs w = 0
Upgrade PDBs in Upgrade mode x = 0
Display Phases y = 0
Debug catcon.pm z = 0
Debug catctl.pl Z = 0
Manual upgrade using catctl.pl is desupported as of Oracle Database 23.4. Oracle recommends using AutoUpgrade to upgrade your database.
catctl.pl VERSION: [23.0.0.0.0]
STATUS: [Production]
BUILD: [RDBMS_23.26.1.0.0DBRU_LINUX.X64_260116.1]
/u01/app/oracle/product/23.26.0/db_1/rdbms/admin/orahome = [/u01/app/oracle/product/23.26.0/db_1]
/u01/app/oracle/product/23.26.0/db_1/bin/orabasehome = [/u01/app/oracle/product/23.26.0/db_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/23.26.0/db_1]
Analyzing file /u01/app/oracle/product/23.26.0/db_1/rdbms/admin/catupgrd.sql
Log file directory = [/home/oracle/logs]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/logs/catupgrdorcl19_catcon_5951.lst]
catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/catupgrdorcl19*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/catupgrdorcl19_*.lst] files for spool files, if any
Number of Cpus = 9
Database Name = orcl
DataBase Version = 23.0.0.0.0
ORCL19 Open Mode = [MIGRATE]
Generated PDB Inclusion:[ORCL19]
CDB$ROOT Open Mode = [OPEN]
Components in [ORCL19]
Installed [APEX APS CATALOG CATJAVA CATPROC CONTEXT DV JAVAVM OLS ORDIM OWM SDO XDB XML XOQ]
Not Installed [EM LCTR MGW ODM RAC WK]
DataBase Version = 23.0.0.0.0
------------------------------------------------------
Start Time:[2026_03_02 14:04:09]
Container Lists Inclusion:[ORCL19] Exclusion:[]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [ORCL19] Files:1 Time: 29s
*************** Catalog Core SQL ***************
Serial Phase #:1 [ORCL19] Files:5 Time: 12s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [ORCL19] Files:21 Time: 11s
************* Catalog Final Scripts ************
Serial Phase #:5 [ORCL19] Files:7 Time: 2s
***************** Catproc Start ****************
Serial Phase #:6 [ORCL19] Files:1 Time: 2s
***************** Catproc Types ****************
Serial Phase #:7 [ORCL19] Files:2 Time: 3s
**************** Catproc Tables ****************
Parallel Phase #:9 [ORCL19] Files:89 Time: 12s
************* Catproc Package Specs ************
Serial Phase #:11 [ORCL19] Files:1 Time: 19s
************** Catproc Procedures **************
Parallel Phase #:13 [ORCL19] Files:103 Time: 2s
Parallel Phase #:15 [ORCL19] Files:129 Time: 3s
Serial Phase #:17 [ORCL19] Files:12 Time: 0s
Parallel Phase #:19 [ORCL19] Files:51 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:21 [ORCL19] Files:32 Time: 6s
Serial Phase #:23 [ORCL19] Files:2 Time: 3s
Parallel Phase #:25 [ORCL19] Files:15 Time: 190s
***************** Catpdeps PLBs ****************
Serial Phase #:28 [ORCL19] Files:14 Time: 0s
Parallel Phase #:31 [ORCL19] Files:12 Time: 24s
Serial Phase #:33 [ORCL19] Files:13 Time: 3s
*************** Catproc CDB Views **************
Serial Phase #:35 [ORCL19] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:39 [ORCL19] Files:321 Time: 3s
Serial Phase #:42 [ORCL19] Files:44 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:44 [ORCL19] Files:3 Time: 10s
****************** Catproc SQL *****************
Parallel Phase #:46 [ORCL19] Files:12 Time: 16s
Parallel Phase #:48 [ORCL19] Files:11 Time: 5s
Parallel Phase #:50 [ORCL19] Files:8 Time: 3s
************* Final Catproc scripts ************
Serial Phase #:52 [ORCL19] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:54 [ORCL19] Files:1 Time: 24s
************ Upgrade Component Start ***********
Serial Phase #:55 [ORCL19] Files:1 Time: 0s
********** Upgrading Java and non-Java *********
Parallel Phase #:57 [ORCL19] Files:2 Time: 197s
Serial Phase #:59 [ORCL19] Files:1 Time: 1s
***************** Upgrading XDB ****************
Serial Phase #:62 [ORCL19] Files:3 Time: 2s
Serial Phase #:63 [ORCL19] Files:3 Time: 0s
Parallel Phase #:64 [ORCL19] Files:10 Time: 1s
Parallel Phase #:65 [ORCL19] Files:25 Time: 3s
Serial Phase #:66 [ORCL19] Files:4 Time: 2s
Serial Phase #:68 [ORCL19] Files:33 Time: 1s
Parallel Phase #:70 [ORCL19] Files:5 Time: 0s
Serial Phase #:71 [ORCL19] Files:2 Time: 2s
Serial Phase #:72 [ORCL19] Files:3 Time: 9s
**************** Upgrading ORDIM ***************
Serial Phase #:74 [ORCL19] Files:1 Time: 6s
***************** Upgrading SDO ****************
Serial Phase #:77 [ORCL19] Files:1 Time: 15s
Serial Phase #:78 [ORCL19] Files:2 Time: 1s
Serial Phase #:80 [ORCL19] Files:1 Time: 3s
Parallel Phase #:82 [ORCL19] Files:3 Time: 26s
Serial Phase #:84 [ORCL19] Files:1 Time: 2s
Serial Phase #:86 [ORCL19] Files:1 Time: 4s
Parallel Phase #:88 [ORCL19] Files:4 Time: 57s
Serial Phase #:90 [ORCL19] Files:1 Time: 0s
Serial Phase #:92 [ORCL19] Files:2 Time: 25s
**** Upgrading ODM, WK, EXF, RUL, XOQ, LCTR ****
Serial Phase #:94 [ORCL19] Files:1 Time: 0s
*********** Final Component scripts ***********
Serial Phase #:96 [ORCL19] Files:1 Time: 1s
************* Final Upgrade scripts ************
Serial Phase #:97 [ORCL19] Files:1 Time: 1s
******************* Migration ******************
Serial Phase #:98 [ORCL19] Files:1 Time: 0s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:99 [ORCL19] Files:1 Time: 0s
****** Bounce the database post-migration ******
***************** Post Upgrade *****************
**************** Summary report ****************
Serial Phase #:103 [ORCL19] Files:1 Time: 1s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:104 [ORCL19] Files:2 Time: 0s
Grand Total Time: 797s [ORCL19]
LOG FILES: (/home/oracle/logs/catupgrdorcl19*.log)
Upgrade Summary Report Located in:
/home/oracle/logs/upg_summary.log
Time: 802s For PDB(s)
Grand Total Time: 802s
LOG FILES: (/home/oracle/logs/catupgrd*.log)
Grand Total Upgrade Time: [0d:0h:13m:22s]
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 ORCLPDB MOUNTED
4 ORCL19 MOUNTED
SQL> alter pluggable database ORCL19 open ;
Pluggable database altered.
SQL> show pdbs;
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED MOUNTED
3 ORCLPDB MOUNTED
4 ORCL19 READ WRITE NO
SQL>
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCL19' -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql
$ORACLE_HOME/rdbms/admin utlrp.sql
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCL19' -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/u01/app/oracle/product/23.26.0/db_1/network/admin/utlrp_catcon_6792.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/23.26.0/db_1/network/admin/utlrp*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/23.26.0/db_1/network/admin/utlrp_*.lst] files for spool files, if any
catcon.pl: completed successfully
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCL19' -l /home/oracle/logs -b utltz_upg_check -d $ORACLE_HOME/rdbms/admin utltz_upg_check.sql
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCL19' -l /home/oracle/logs -b utltz_upg_check -d $ORACLE_HOME/rdbms/admin utltz_upg_check.sql
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/logs/utltz_upg_check_catcon_6962.lst]
catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/utltz_upg_check*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/home/oracle/logs/utltz_upg_check_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@centos9 admin]$
alter system set "_exclude_seed_cdb_view"=false scope=both;
select value$, con_id from containers(SYS.PROPS$) where NAME='DST_PRIMARY_TT_VERSION' order by 2;
SQL> alter session set container=ORCL19 ;
Session altered.
SQL> SET SERVEROUTPUT ON
DECLARE
l_failures PLS_INTEGER;
BEGIN
DBMS_DST.upgrade_database(l_failures);
DBMS_OUTPUT.put_line('DBMS_DST.upgrade_database : l_failures=' || l_failures);
DBMS_DST.end_upgrade(l_failures);
SQL> 2 3 4 5 6 7 DBMS_OUTPUT.put_line('DBMS_DST.end_upgrade : l_failures=' || l_failures);
8 END;
9 /
DECLARE
*
ERROR at line 1:
ORA-56928: upgrade window does not exist
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DST", line 927
ORA-06512: at "SYS.DBMS_DST", line 1254
ORA-06512: at line 4
Help: https://docs.oracle.com/error-help/db/ora-56928/
SQL> shutdown immediate ;
Pluggable Database closed.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
4 ORCL19 MOUNTED
SQL> STARTUP UPGRADE;
Pluggable Database opened.
SQL> SET SERVEROUTPUT ON
DECLARE
l_tz_version PLS_INTEGER;
BEGIN
SELECT DBMS_DST.get_latest_timezone_version
INTO l_tz_version
FROM dual;
DBMS_OUTPUT.put_line('l_tz_version=' || l_tz_version);
DBMS_DST.begin_upgrade(l_tz_version);
END;
/SQL> 2 3 4 5 6 7 8 9 10 11
l_tz_version=43
An upgrade window has been successfully started.
PL/SQL procedure successfully completed.
SQL> SET SERVEROUTPUT ON
DECLARE
l_failures PLS_INTEGER;
BEGIN
DBMS_DST.upgrade_database(l_failures);
DBMS_OUTPUT.put_line('DBMS_DST.upgrade_database : l_failures=' || l_failures);
DBMS_DST.end_upgrade(l_failures);
DBMS_OUTPUT.put_line('DBMS_DST.end_upgrade : l_failures=' || l_failures);
END;
/SQL> 2 3 4 5 6 7 8 9
DECLARE
*
ERROR at line 1:
ORA-56930: database must be restarted before performing upgrade of user tables
ORA-06512: at "SYS.DBMS_SYS_ERROR", line 79
ORA-06512: at "SYS.DBMS_DST", line 933
ORA-06512: at "SYS.DBMS_DST", line 1254
ORA-06512: at line 4
Help: https://docs.oracle.com/error-help/db/ora-56930/
SQL> SHUTDOWN IMMEDIATE;
Pluggable Database closed.
SQL> STARTUP;
Pluggable Database opened.
SQL> SET SERVEROUTPUT ON
DECLARE
l_failures PLS_INTEGER;
BEGIN
DBMS_DST.upgrade_database(l_failures);
DBMS_OUTPUT.put_line('DBMS_DST.upgrade_database : l_failures=' || l_failures);
DBMS_DST.end_upgrade(l_failures);
DBMS_OUTPUT.put_line('DBMS_DST.end_upgrade : l_failures=' || l_failures);
END;
/SQL> 2 3 4 5 6 7 8 9
Table list: "MDSYS"."SDO_DIAG_MESSAGES_TABLE"
Number of failures: 0
Table list: "CTXSYS"."DR$EVENT_STATS"
Number of failures: 0
Table list: "DBSNMP"."MGMT_DB_FEATURE_LOG"
Number of failures: 0
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: "WMSYS"."WM$MP_PARENT_WORKSPACES_TABLE$"
Number of failures: 0
Table list: "WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_S"
Number of failures: 0
Table list: "WMSYS"."AQ$_WM$EVENT_QUEUE_TABLE_L"
Number of failures: 0
Table list: "WMSYS"."WM$WORKSPACES_TABLE$"
Number of failures: 0
Table list: "WMSYS"."WM$WORKSPACE_SAVEPOINTS_TABLE$"
Number of failures: 0
Table list: "WMSYS"."WM$METADATA_MAP_TBL"
Number of failures: 0
Table list: "DVSYS"."AUDIT_TRAIL$"
Number of failures: 0
Table list: "DVSYS"."SIMULATION_LOG$"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_WORKSHEET_NOTIFY"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_FEEDBACK"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_FEEDBACK_FOLLOWUP"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_ACTIVITY_LOG1$"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_ACTIVITY_LOG2$"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_DEBUG_MESSAGES"
Number of failures: 0
Table list: "APEX_190100"."WWV_FLOW_DEBUG_MESSAGES2"
Number of failures: 0
Table list: "APEX_190100"."WWV_QS_RANDOM_NAMES"
Number of failures: 0
Table list: "IX"."AQ$_ORDERS_QUEUETABLE_S"
Number of failures: 0
Table list: "IX"."AQ$_ORDERS_QUEUETABLE_L"
Number of failures: 0
Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_S"
Number of failures: 0
Table list: "IX"."AQ$_STREAMS_QUEUE_TABLE_L"
Number of failures: 0
Table list: "XFILES"."XFILES_RESULT_CACHE"
Number of failures: 0
Table list: "VECSYS"."VECTOR_TABLE_METADATA"
Number of failures: 0
DBMS_DST.upgrade_database : l_failures=0
An upgrade window has been successfully ended.
DBMS_DST.end_upgrade : l_failures=0
PL/SQL procedure successfully completed.
SQL> COLUMN owner FORMAT A30
SQL> COLUMN table_name FORMAT A30
SELECT con_id,
owner,
table_name,
upgrade_in_progress
FROM cdb_tstz_tables
ORDER BY 1,2,3;
-- Non-CDB
COLUMN owner FORMAT A30
COLUMN table_name FORMAT A30
SELECT owner,
table_name,
upgrade_in_progress
FROM dba_tstz_tables
ORDER BY 1,2;SQL> SQL> 2 3 4 5 6
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 APEX_190100 WWV_FLOW_ACTIVITY_LOG1$ NO
4 APEX_190100 WWV_FLOW_ACTIVITY_LOG2$ NO
4 APEX_190100 WWV_FLOW_DEBUG_MESSAGES NO
4 APEX_190100 WWV_FLOW_DEBUG_MESSAGES2 NO
4 APEX_190100 WWV_FLOW_FEEDBACK NO
4 APEX_190100 WWV_FLOW_FEEDBACK_FOLLOWUP NO
4 APEX_190100 WWV_FLOW_WORKSHEET_NOTIFY NO
4 APEX_190100 WWV_QS_RANDOM_NAMES NO
4 CTXSYS DR$EVENT_STATS NO
4 DBSNMP MGMT_DB_FEATURE_LOG NO
4 DVSYS AUDIT_TRAIL$ NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 DVSYS SIMULATION_LOG$ NO
4 GSMADMIN_INTERNAL AQ$_CHANGE_LOG_QUEUE_TABLE_L NO
4 GSMADMIN_INTERNAL AQ$_CHANGE_LOG_QUEUE_TABLE_S NO
4 IX AQ$_ORDERS_QUEUETABLE_L NO
4 IX AQ$_ORDERS_QUEUETABLE_S NO
4 IX AQ$_STREAMS_QUEUE_TABLE_L NO
4 IX AQ$_STREAMS_QUEUE_TABLE_S NO
4 MDSYS SDO_DIAG_MESSAGES_TABLE NO
4 SYS AC$CONFIG_PARAMS NO
4 SYS ACCHK_EVENTS NO
4 SYS ACCHK_METADATA NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS ACCHK_SESSION NO
4 SYS ACCHK_STATISTICS NO
4 SYS ACLMVREFSTAT$ NO
4 SYS AC_AUTOTASK_STATUS$ NO
4 SYS AC_JOURNAL$ NO
4 SYS ALERT_QT NO
4 SYS AQ$_ALERT_QT_L NO
4 SYS AQ$_ALERT_QT_S NO
4 SYS AQ$_AQ$_MEM_MC_L NO
4 SYS AQ$_AQ$_MEM_MC_S NO
4 SYS AQ$_AQ_PROP_TABLE_L NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS AQ$_AQ_PROP_TABLE_S NO
4 SYS AQ$_DEQUEUE_LOG_PARTITION_MAP NO
4 SYS AQ$_DURABLE_SUBS NO
4 SYS AQ$_MIGRATION_STATUS NO
4 SYS AQ$_ORA$PREPLUGIN_BACKUP_QTB_L NO
4 SYS AQ$_ORA$PREPLUGIN_BACKUP_QTB_S NO
4 SYS AQ$_PDB_MON_EVENT_QTABLE$_L NO
4 SYS AQ$_PDB_MON_EVENT_QTABLE$_S NO
4 SYS AQ$_QUEUE_PARTITION_ASSIGNMENT NO
_TABLE
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS AQ$_QUEUE_PARTITION_MAP NO
4 SYS AQ$_SCHEDULER$_EVENT_QTAB_L NO
4 SYS AQ$_SCHEDULER$_EVENT_QTAB_S NO
4 SYS AQ$_SCHEDULER$_REMDB_JOBQTAB_L NO
4 SYS AQ$_SCHEDULER$_REMDB_JOBQTAB_S NO
4 SYS AQ$_SCHEDULER_FILEWATCHER_QT_L NO
4 SYS AQ$_SCHEDULER_FILEWATCHER_QT_S NO
4 SYS AQ$_SUBSCRIBER_LWM NO
4 SYS AQ$_SUBSCRIBER_TABLE NO
4 SYS AQ$_SYS$SERVICE_METRICS_TAB_L NO
4 SYS AQ$_SYS$SERVICE_METRICS_TAB_S NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS ATSK$_SCHEDULE_CONTROL NO
4 SYS AUTOCL_TASK_STATUS$ NO
4 SYS AUTOCL_VER_STATE$ NO
4 SYS AVTUNE_AV_ARCHIVE_INST$ NO
4 SYS AVTUNE_AV_CACHES$ NO
4 SYS AVTUNE_AV_TUNING$ NO
4 SYS AVTUNE_DIM_CACHES$ NO
4 SYS AVTUNE_QUERY_LOG_ARCHIVE$ NO
4 SYS BLOCKCHAIN_TABLE$ NO
4 SYS BLOCKCHAIN_TABLE_CHAIN$ NO
4 SYS BLOCKCHAIN_TABLE_DROPPED$ NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS BLOCKCHAIN_TABLE_EPOCH$ NO
4 SYS BLOCKCHAIN_TABLE_ROW_VERSION_V NO
ALUES$
4 SYS DBMS_KAFKA_LOAD_METRICS NO
4 SYS DIAG$_SQL_ERROR NO
4 SYS DIAG$_SQL_ERROR_MITIGATION NO
4 SYS EXTERNAL_TAB_CACHE$ NO
4 SYS EXTERNAL_TAB_CACHE_LOCATION$ NO
4 SYS EXTERNAL_TAB_CACHE_USAGE$ NO
4 SYS FGR$_FILE_GROUPS NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS FGR$_FILE_GROUP_FILES NO
4 SYS FGR$_FILE_GROUP_VERSIONS NO
4 SYS FW_ALLOW_LIST$ NO
4 SYS FW_CAPTURE$ NO
4 SYS FW_STATUS$ NO
4 SYS GV_$UNIFIED_AUDIT_TRAIL_TBL NO
4 SYS IMPDP_STATS NO
4 SYS KET$_AUTOTASK_STATUS NO
4 SYS KET$_CLIENT_CONFIG NO
4 SYS KET$_CLIENT_TASKS NO
4 SYS LTXID_TRANS NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS NOTIFICATION$ NO
4 SYS NOTIFICATIONS$ NO
4 SYS OPTSTAT_HIST_CONTROL$ NO
4 SYS OPTSTAT_SNAPSHOT$ NO
4 SYS OPTSTAT_USER_PREFS$ NO
4 SYS RADM_FPTM$ NO
4 SYS REG$ NO
4 SYS REGISTRY$LOG NO
4 SYS SAGA$ NO
4 SYS SAGA_DETAILS$ NO
4 SYS SAGA_ERRORS$ NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS SAGA_PARTICIPANT_SET$ NO
4 SYS SAGA_SECRETS$ NO
4 SYS SCHEDULER$_CONSTRAINTS_STATS NO
4 SYS SCHEDULER$_EVENT_LOG NO
4 SYS SCHEDULER$_EVENT_QTAB NO
4 SYS SCHEDULER$_FILEWATCHER_HISTORY NO
4 SYS SCHEDULER$_FILEWATCHER_RESEND NO
4 SYS SCHEDULER$_FILE_WATCHER NO
4 SYS SCHEDULER$_GLOBAL_ATTRIBUTE NO
4 SYS SCHEDULER$_JOB NO
4 SYS SCHEDULER$_JOB_DESTINATIONS NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS SCHEDULER$_JOB_OUT_ARGS NO
4 SYS SCHEDULER$_JOB_RUN_DETAILS NO
4 SYS SCHEDULER$_LIGHTWEIGHT_JOB NO
4 SYS SCHEDULER$_REMDB_JOBQTAB NO
4 SYS SCHEDULER$_REMOTE_JOB_STATE NO
4 SYS SCHEDULER$_SCHEDULE NO
4 SYS SCHEDULER$_STEP_STATE NO
4 SYS SCHEDULER$_WINDOW NO
4 SYS SCHEDULER$_WINDOW_DETAILS NO
4 SYS SCHEDULER_FILEWATCHER_QT NO
4 SYS SESSION_LOG$ NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS STATS_TARGET$ NO
4 SYS TAB_STATS$ NO
4 SYS TSM_DST$ NO
4 SYS TSM_SRC$ NO
4 SYS UMF$_ATSK_HIST NO
4 SYS UMF$_EVENTLOG NO
4 SYS UMF$_HUB_FBS_HIST NO
4 SYS UMF$_HUB_MPK_HIST NO
4 SYS VIOLATION_LOG$ NO
4 SYS WRI$_ADV_AI_COL_USAGE NO
4 SYS WRI$_ADV_AUTOCL_RECOMMENDATION NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
S
4 SYS WRI$_ALERT_HISTORY NO
4 SYS WRI$_ALERT_OUTSTANDING NO
4 SYS WRI$_OPTSTAT_AUX_HISTORY NO
4 SYS WRI$_OPTSTAT_HISTGRM_HISTORY NO
4 SYS WRI$_OPTSTAT_HISTHEAD_HISTORY NO
4 SYS WRI$_OPTSTAT_IND_HISTORY NO
4 SYS WRI$_OPTSTAT_OPR NO
4 SYS WRI$_OPTSTAT_OPR_TASKS NO
4 SYS WRI$_OPTSTAT_TAB_HISTORY NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS WRI$_OPTSTAT_TAB_MODEL NO
4 SYS WRM$_DATABASE_INSTANCE NO
4 SYS WRM$_PDB_INSTANCE NO
4 SYS WRM$_PDB_IN_SNAP NO
4 SYS WRM$_PDB_IN_SNAP_BL NO
4 SYS WRM$_SNAPSHOT NO
4 SYS WRM$_SNAPSHOT_BL NO
4 SYS WRMS$_SNAPSHOT NO
4 SYS WRR$_REPLAY_DIVERGENCE NO
4 SYS WRW$_AHUB_EXP_HIST NO
4 SYS WRW$_AHUB_IMP_HIST NO
CON_ID OWNER TABLE_NAME UPG
---------- ------------------------------ ------------------------------ ---
4 SYS XS$PRIN NO
4 SYS XS$ROLE_GRANT NO
4 VECSYS VECTOR_TABLE_METADATA NO
4 WMSYS AQ$_WM$EVENT_QUEUE_TABLE_L NO
4 WMSYS AQ$_WM$EVENT_QUEUE_TABLE_S NO
4 WMSYS WM$METADATA_MAP_TBL NO
4 WMSYS WM$MP_PARENT_WORKSPACES_TABLE$ NO
4 WMSYS WM$WORKSPACES_TABLE$ NO
4 WMSYS WM$WORKSPACE_SAVEPOINTS_TABLE$ NO
4 XFILES XFILES_RESULT_CACHE NO
158 rows selected.
SQL> alter system set "_exclude_seed_cdb_view"=false scope=both;
System altered.
col value$ for a15
select value$, con_id from containers(SYS.PROPS$) where NAME='DST_PRIMARY_TT_VERSION' order by 2
VALUE$ CON_ID
--------------- ----------
43 1
43 4
$ORACLE_HOME/perl/bin/perl \
-I$ORACLE_HOME/perl/lib \
-I$ORACLE_HOME/rdbms/admin \
$ORACLE_HOME/rdbms/admin/catcon.pl \
-l /tmp/ \
-b upgrade_tzf \
-C 'CDB$ROOT' \
/tmp/upgrade_tzf.sql
From Oracle 21c onward we can issue to the following command to allow time zone files to be updated without switching the database to upgrade mode. This allows the time zone file to be upgraded without any downtime.
alter system set timezone_version_upgrade_online=true;
Monday, 2 March 2026
upgrade database from 19c to 26ai !!!
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment