Upgrading a PDB to a New 19c CDB

Hello,

In this blog post, Iwill write about upgrading a PDB to a New 19c CDB

You can upgrade PDBs by unplugging a PDB from an earlier release CDB, plugging it
into a later release CDB, and then upgrading that PDB to the later release.

Let’s do it together:

Create a common user for the relocate operation and assign necessary privileges:

export ORACLE_SID=cdb12c

sqlplus / as sysdba
SHOW con_name;

CREATE USER c##talip IDENTIFIED BY oracle
DEFAULT TABLESPACE users
TEMPORARY TABLESPACE temp
CONTAINER=ALL;
GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE, SYSOPER TO c##talip CONTAINER = ALL;

2. Create the public database link in 19c for the relocate operation:
export ORACLE_SID=cdb

sqlplus / as sysdba
SHOW con_name;

CREATE public DATABASE link clonemypdb CONNECT TO c##talip IDENTIFIED BY “oracle” USING ‘cdb12c’;

–Write the necessary TNS entry

cdb12c=
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.5.3)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = cdb12c)
)
)

3. Initiate the relocation in 19c:
CREATE PLUGGABLE DATABASE DBM FROM DBM@clonemypdb RELOCATE file_name_convert=(‘/oradata/cdb12c/’,’/oradata/CDB/’);

4. Open the PDB database in 19c:
ALTER PLUGGABLE DATABASE DBM OPEN UPGRADE;

5. Now upgrade it using dbupgrade utility.

dbmaster /home/oracle> dbupgrade -c “DBM” -l /home/oracle

Argument list for [/u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = DBM
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
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]

/u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/orahome = [/u01/app/oracle/product/19.3.0/dbhome_1]
/u01/app/oracle/product/19.3.0/dbhome_1/bin/orabasehome = [/u01/app/oracle/product/19.3.0/dbhome_1]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.3.0/dbhome_1]

Analyzing file /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/catupgrd.sql

Log file directory = [/home/oracle]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/catupgrd_catcon_25571.lst]

catcon::set_log_file_base_path: catcon: See [/home/oracle/catupgrd*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/home/oracle/catupgrd_*.lst] files for spool files, if any

Number of Cpus = 1
Database Name = cdb
DataBase Version = 19.0.0.0.0
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:[DBM]
CDB$ROOT Open Mode = [OPEN]

Start processing of PDBs (DBM)
[/u01/app/oracle/product/19.3.0/dbhome_1/perl/bin/perl /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/catctl.pl -c ‘DBM’ -l /home/oracle -I -i dbm -n 2 /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/catupgrd.sql]

Argument list for [/u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = DBM
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = dbm
Child Process I = 1
Log Dir l = /home/oracle
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]

Analyzing file /u01/app/oracle/product/19.3.0/dbhome_1/rdbms/admin/catupgrd.sql

Log file directory = [/home/oracle]

catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/catupgrddbm_catcon_25834.lst]

catcon::set_log_file_base_path: catcon: See [/home/oracle/catupgrddbm*.log] files for output generated by scripts

catcon::set_log_file_base_path: catcon: See [/home/oracle/catupgrddbm_*.lst] files for spool files, if any

Number of Cpus = 1
Database Name = cdb
DataBase Version = 19.0.0.0.0
DBM Open Mode = [MIGRATE]
Generated PDB Inclusion:[DBM]
CDB$ROOT Open Mode = [OPEN]
Components in [DBM]
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:[2022_01_23 15:23:50]

Container Lists Inclusion:[DBM] Exclusion:[NONE]

*** Executing Change Scripts ***
Serial Phase #:0 [DBM] Files:1 Time: 32s
* Catalog Core SQL *
Serial Phase #:1 [DBM] Files:5 Time: 50s
Restart Phase #:2 [DBM] Files:1 Time: 1s
*** Catalog Tables and Views ***
Parallel Phase #:3 [DBM] Files:19 Time: 40s
Restart Phase #:4 [DBM] Files:1 Time: 2s
* Catalog Final Scripts
Serial Phase #:5 [DBM] Files:7 Time: 25s
* Catproc Start
Serial Phase #:6 [DBM] Files:1 Time: 17s
* Catproc Types
Serial Phase #:7 [DBM] Files:2 Time: 15s
Restart Phase #:8 [DBM] Files:1 Time: 2s
** Catproc Tables **
Parallel Phase #:9 [DBM] Files:67 Time: 63s
Restart Phase #:10 [DBM] Files:1 Time: 1s
* Catproc Package Specs
Serial Phase #:11 [DBM] Files:1 Time: 69s
Restart Phase #:12 [DBM] Files:1 Time: 1s
Catproc Procedures
Parallel Phase #:13 [DBM] Files:94 Time: 17s
Restart Phase #:14 [DBM] Files:1 Time: 1s
Parallel Phase #:15 [DBM] Files:120 Time: 22s
Restart Phase #:16 [DBM] Files:1 Time: 2s
Serial Phase #:17 [DBM] Files:22 Time: 8s
Restart Phase #:18 [DBM] Files:1 Time: 2s
* Catproc Views
Parallel Phase #:19 [DBM] Files:32 Time: 37s
Restart Phase #:20 [DBM] Files:1 Time: 1s
Serial Phase #:21 [DBM] Files:3 Time: 18s
Restart Phase #:22 [DBM] Files:1 Time: 2s
Parallel Phase #:23 [DBM] Files:25 Time: 371s
Restart Phase #:24 [DBM] Files:1 Time: 1s
Parallel Phase #:25 [DBM] Files:12 Time: 193s
Restart Phase #:26 [DBM] Files:1 Time: 2s
Serial Phase #:27 [DBM] Files:1 Time: 0s
Serial Phase #:28 [DBM] Files:3 Time: 9s
Serial Phase #:29 [DBM] Files:1 Time: 0s
Restart Phase #:30 [DBM] Files:1 Time: 2s
* Catproc CDB Views
Serial Phase #:31 [DBM] Files:1 Time: 6s
Restart Phase #:32 [DBM] Files:1 Time: 1s
Serial Phase #:34 [DBM] Files:1 Time: 0s
* Catproc PLBs *
Serial Phase #:35 [DBM] Files:293 Time: 21s
Serial Phase #:36 [DBM] Files:1 Time: 0s
Restart Phase #:37 [DBM] Files:1 Time: 1s
Serial Phase #:38 [DBM] Files:6 Time: 8s
Restart Phase #:39 [DBM] Files:1 Time: 0s
* Catproc DataPump *
Serial Phase #:40 [DBM] Files:3 Time: 53s
Restart Phase #:41 [DBM] Files:1 Time: 2s
**** Catproc SQL **
Parallel Phase #:42 [DBM] Files:13 Time: 220s
Restart Phase #:43 [DBM] Files:1 Time: 2s
Parallel Phase #:44 [DBM] Files:11 Time: 14s
Restart Phase #:45 [DBM] Files:1 Time: 2s
Parallel Phase #:46 [DBM] Files:3 Time: 9s
Restart Phase #:47 [DBM] Files:1 Time: 1s
Final Catproc scripts
Serial Phase #:48 [DBM] Files:1 Time: 15s
Restart Phase #:49 [DBM] Files:1 Time: 2s
Final RDBMS scripts *
Serial Phase #:50 [DBM] Files:1 Time: 10s
Upgrade Component Start ***
Serial Phase #:51 [DBM] Files:1 Time: 7s
Restart Phase #:52 [DBM] Files:1 Time: 2s
** Upgrading Java and non-Java *
Serial Phase #:53 [DBM] Files:2 Time: 231s
* Upgrading XDB
Restart Phase #:54 [DBM] Files:1 Time: 2s
Serial Phase #:56 [DBM] Files:3 Time: 15s
Serial Phase #:57 [DBM] Files:3 Time: 11s
Parallel Phase #:58 [DBM] Files:10 Time: 13s
Parallel Phase #:59 [DBM] Files:25 Time: 13s
Serial Phase #:60 [DBM] Files:4 Time: 17s
Serial Phase #:61 [DBM] Files:1 Time: 0s
Serial Phase #:62 [DBM] Files:32 Time: 11s
Serial Phase #:63 [DBM] Files:1 Time: 0s
Parallel Phase #:64 [DBM] Files:6 Time: 14s
Serial Phase #:65 [DBM] Files:2 Time: 37s
Serial Phase #:66 [DBM] Files:3 Time: 43s
** Upgrading ORDIM *
Restart Phase #:67 [DBM] Files:1 Time: 2s
Serial Phase #:69 [DBM] Files:1 Time: 10s
Parallel Phase #:70 [DBM] Files:2 Time: 22s
Restart Phase #:71 [DBM] Files:1 Time: 2s
Parallel Phase #:72 [DBM] Files:2 Time: 11s
Serial Phase #:73 [DBM] Files:2 Time: 9s
* Upgrading SDO
Restart Phase #:74 [DBM] Files:1 Time: 1s
Serial Phase #:76 [DBM] Files:1 Time: 73s
Serial Phase #:77 [DBM] Files:2 Time: 11s
Restart Phase #:78 [DBM] Files:1 Time: 1s
Serial Phase #:79 [DBM] Files:1 Time: 13s
Restart Phase #:80 [DBM] Files:1 Time: 2s
Parallel Phase #:81 [DBM] Files:3 Time: 79s
Restart Phase #:82 [DBM] Files:1 Time: 2s
Serial Phase #:83 [DBM] Files:1 Time: 12s
Restart Phase #:84 [DBM] Files:1 Time: 1s
Serial Phase #:85 [DBM] Files:1 Time: 19s
Restart Phase #:86 [DBM] Files:1 Time: 2s
Parallel Phase #:87 [DBM] Files:4 Time: 135s
Restart Phase #:88 [DBM] Files:1 Time: 2s
Serial Phase #:89 [DBM] Files:1 Time: 9s
Restart Phase #:90 [DBM] Files:1 Time: 1s
Serial Phase #:91 [DBM] Files:2 Time: 33s
Restart Phase #:92 [DBM] Files:1 Time: 2s
Serial Phase #:93 [DBM] Files:1 Time: 7s
Restart Phase #:94 [DBM] Files:1 Time: 0s
Upgrading ODM, WK, EXF, RUL, XOQ
Serial Phase #:95 [DBM] Files:1 Time: 17s
Restart Phase #:96 [DBM] Files:1 Time: 2s
*** Final Component scripts ***
Serial Phase #:97 [DBM] Files:1 Time: 10s
* Final Upgrade scripts
Serial Phase #:98 [DBM] Files:1 Time: 147s
* Migration **
Serial Phase #:99 [DBM] Files:1 Time: 8s
*** End PDB Application Upgrade Pre-Shutdown * Serial Phase #:100 [DBM] Files:1 Time: 7s Serial Phase #:101 [DBM] Files:1 Time: 7s Serial Phase #:102 [DBM] Files:1 Time: 6s * Post Upgrade * Serial Phase #:103 [DBM] Files:1 Time: 23s Summary report **
Serial Phase #:104 [DBM] Files:1 Time: 7s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [DBM] Files:1 Time: 7s
Serial Phase #:106 [DBM] Files:1 Time: 4s
Serial Phase #:107 [DBM] Files:1 Time: 0s