PDB Hot Clone | 12cR2 PDB to Remote 19c CDB | Upgrade PDB to Oracle 19c | Pluggable Database Clone!
Online Clone a PDB(12cR2) to Remote CDB (19c): High Level Steps:
I have an Oracle 12.2.0.1 CDB with a PDB, and another Oracle 19.3.0 CDB. I will do hot clone of the PDB from 12.2.0.1 to the higher version CDB (19.3.0.0), and then upgrade the PDB to 19c.
Hot Cloning:
-----------
You can use Hot Cloning since the introduction of Local Undo with Oracle 12.2.0.1. Hence, if my source is at least Oracle 12.2.0.1 and if I use the default, Local Undo, this works. As usual, I show the sequence of actions:
SRCDB1: 12.2.0.1:
-----------------
Create a common user for the relocate operation and assign necessary privileges:
--------------------------------------------------------------------------------
CREATE USER c##clone IDENTIFIED BY ora123 DEFAULT TABLESPACE USERS TEMPORARY TABLESPACE TEMP CONTAINER=ALL;
GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE, SYSOPER TO c##clone CONTAINER = ALL;
select name from dba_services;
select name from v$active_services;
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB1
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRDBPLUG READ WRITE NO
SQL>
SQL>
SQL> alter session set container=SRDBPLUG;
Session altered.
SQL>
SQL> select name from v$active_services;
NAME
----------------------------------------------------------------
srdbplug
SQL> show parameter local_listener
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
local_listener string LISTENER_SRCDB1
SQL>
SQL> col comp_id for a20
SQL> col comp_name for a40
SQL> col version for a20
SQL> col status for a10
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
-------------------- ---------------------------------------- -------------------- ----------
CATALOG Oracle Database Catalog Views 12.2.0.1.0 VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 VALID
XML Oracle XDK 12.2.0.1.0 VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 VALID
APS OLAP Analytic Workspace 12.2.0.1.0 VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 VALID
OWM Oracle Workspace Manager 12.2.0.1.0 VALID
CONTEXT Oracle Text 12.2.0.1.0 VALID
ORDIM Oracle Multimedia 12.2.0.1.0 VALID
SDO Spatial 12.2.0.1.0 VALID
XOQ Oracle OLAP API 12.2.0.1.0 VALID
OLS Oracle Label Security 12.2.0.1.0 VALID
DV Oracle Database Vault 12.2.0.1.0 VALID
15 rows selected.
SQL> col version for 999999
SQL> select version from v$timezone_file;
VERSION
-------
26
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> select count(*) from dba_recyclebin;
COUNT(*)
----------
0
SQL> select count(*) from dba_data_files;
COUNT(*)
----------
4
SQL> select name from v$datafile;
NAME
-----------------------------------------------------------------------
/u02/oradata/SRCDB1/SRDBPLUG/system01.dbf
/u02/oradata/SRCDB1/SRDBPLUG/sysaux01.dbf
/u02/oradata/SRCDB1/SRDBPLUG/undotbs01.dbf
/u02/oradata/SRCDB1/SRDBPLUG/users01.dbf
SQL> select sum(bytes/1024/1024/1024) from dba_data_files;
SUM(BYTES/1024/1024/1024)
-------------------------
.668945313
SRCDB2: 19.3.0.0:
-----------------
Update TNS entry on target server tnsnames.ora
SRDBPLUG =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = srlabd.localdomain)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = SRCDB1)
)
)
Create the public database link for the relocate operation:
CREATE PUBLIC DATABASE link clonepdb CONNECT TO c##clone IDENTIFIED BY ora123 USING 'SRDBPLUG';
select sysdate from dual@clonepdb;
Initiate the relocation (Clone):
--------------------------------
mkdir -p /u02/oradata/SRCDB2/SRDBPLUG
CREATE PLUGGABLE DATABASE SRDBPLUG FROM SRDBPLUG@clonepdb file_name_convert=('/u02/oradata/SRCDB1/SRDBPLUG','/u02/oradata/SRCDB2/SRDBPLUG');
Open the PDB:
-------------
ALTER PLUGGABLE DATABASE SRDBPLUG OPEN UPGRADE;
The PDB will open with errors in RESTRICTED mode only.
Then I need to open SRDBPLUG in SRCDB2 in UPGRADE mode because its dictionary is still an Oracle 12.2.0.1 dictionary whereas it operates now within a 19c database.
Upgrade of the PDB:
------------------
This time I am going with manual upgrade method. This step is simple as I just avoid the preupgrade step. In my environment there are no extra tasks necessary for SRDBPLUG before upgrading it.
Invoke the upgrade in the SRCDB2 environment:
$ dbupgrade -c "SRDBPLUG" -l /home/oracle/scripts/logs
Afterwards Recompile:
---------------------
sqlplus / as sysdba
alter pluggable database SRDBPLUG open;
alter pluggable database SRDBPLUG save state;
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'SRDBPLUG' -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql
Finally, I can adjust the time zone of my upgraded PDB. As catcon.pl does not give direct output, I will have to check the log files afterwards.
$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'SRDBPLUG' -l /home/oracle/scripts/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 'SRDBPLUG' -l /home/oracle/scripts/logs -b utltz_upg_apply -d $ORACLE_HOME/rdbms/admin utltz_upg_apply.sql
Final check:
------------
sqlplus / as sysdba
select * from global_name;
show pdbs
select value$, con_id from containers(SYS.PROPS$) where NAME='DST_PRIMARY_TT_VERSION' order by 2;
alter system set "_exclude_seed_cdb_view"=false scope=both;
alter session set container=SRDBPLUG;
select version from v$timezone_file;
select count(*) from dba_objects where status='INVALID';
select * from pdb_plug_in_violations;
select count(*) from v$datafile;
select name from v$datafile;
select count(*) from dba_recyclebin;
PDB Upgrade Logs:
==============
[oracle@srlab ~]$ . oraenv
ORACLE_SID = [SRCDB1] ? SRCDB2
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlab ~]$
[oracle@srlab ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 19 21:57:11 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 * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
SQL>
SQL> set lines 300 pages 2000
SQL>
SQL>
SQL> CREATE PLUGGABLE DATABASE SRDBPLUG FROM SRDBPLUG@clonepdb file_name_convert=('/u02/oradata/SRCDB1/SRDBPLUG','/u02/oradata/SRCDB2/SRDBPLUG');
Pluggable database created.
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRDBPLUG MOUNTED
SQL> ALTER PLUGGABLE DATABASE SRDBPLUG OPEN UPGRADE;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRDBPLUG MIGRATE YES
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab ~]$
[oracle@srlab ~]$
[oracle@srlab ~]$ mkdir -p /home/oracle/scripts/logs
[oracle@srlab ~]$
[oracle@srlab ~]$ ls -ld /home/oracle/scripts/logs
drwxr-xr-x. 2 oracle oinstall 4096 Jul 19 22:02 /home/oracle/scripts/logs
[oracle@srlab ~]$
[oracle@srlab ~]$ cd $ORACLE_HOME/dbs/bin
-bash: cd: /u01/app/oracle/product/19.0.0.0/db_3/dbs/bin: No such file or directory
[oracle@srlab ~]$ cd $ORACLE_HOME
[oracle@srlab db_3]$ cd dbs
[oracle@srlab dbs]$ cd bin
-bash: cd: bin: No such file or directory
[oracle@srlab dbs]$ cd ..
[oracle@srlab db_3]$ cd bin
[oracle@srlab bin]$ pwd
/u01/app/oracle/product/19.0.0.0/db_3/bin
[oracle@srlab bin]$
[oracle@srlab bin]$ ls -lrt dbupgrade*
-rwxr-x---. 1 oracle oinstall 3136 Apr 17 2019 dbupgrade
[oracle@srlab bin]$
[oracle@srlab bin]$ ./dbupgrade -c "SRDBPLUG" -l /home/oracle/scripts/logs
Argument list for [/u01/app/oracle/product/19.0.0.0/db_3/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = SRDBPLUG
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/scripts/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
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.0.0.0/db_3/rdbms/admin/orahome = [/u01/app/oracle/product/19.0.0.0/db_3]
/u01/app/oracle/product/19.0.0.0/db_3/bin/orabasehome = [/u01/app/oracle/product/19.0.0.0/db_3]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0.0.0/db_3]
Analyzing file /u01/app/oracle/product/19.0.0.0/db_3/rdbms/admin/catupgrd.sql
Log file directory = [/home/oracle/scripts/logs]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/scripts/logs/catupgrd_catcon_11426.lst]
catcon::set_log_file_base_path: catcon: See [/home/oracle/scripts/logs/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/home/oracle/scripts/logs/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 2
Database Name = SRCDB2
DataBase Version = 19.0.0.0.0
PDB Parallel SQL Process Count = [2] is higher or equal to CPU Count = [2]
Concurrent PDB Upgrades defaulting to CPU Count [2]
Parallel SQL Process Count (PDB) = 2
Parallel SQL Process Count (CDB$ROOT) = 4
Concurrent PDB Upgrades = 2
Generated PDB Inclusion:[SRDBPLUG]
CDB$ROOT Open Mode = [OPEN]
Concurrent PDB Upgrades Reset = 1
Start processing of PDBs (SRDBPLUG)
[/u01/app/oracle/product/19.0.0.0/db_3/perl/bin/perl /u01/app/oracle/product/19.0.0.0/db_3/rdbms/admin/catctl.pl -c 'SRDBPLUG' -l /home/oracle/scripts/logs -I -i srdbplug -n 2 /u01/app/oracle/product/19.0.0.0/db_3/rdbms/admin/catupgrd.sql]
Argument list for [/u01/app/oracle/product/19.0.0.0/db_3/rdbms/admin/catctl.pl]
For Oracle internal use only A = 0
Run in c = SRDBPLUG
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = srdbplug
Child Process I = 1
Log Dir l = /home/oracle/scripts/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
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.0.0.0/db_3/rdbms/admin/orahome = [/u01/app/oracle/product/19.0.0.0/db_3]
/u01/app/oracle/product/19.0.0.0/db_3/bin/orabasehome = [/u01/app/oracle/product/19.0.0.0/db_3]
catctlGetOraBaseLogDir = [/u01/app/oracle/product/19.0.0.0/db_3]
Analyzing file /u01/app/oracle/product/19.0.0.0/db_3/rdbms/admin/catupgrd.sql
Log file directory = [/home/oracle/scripts/logs]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/scripts/logs/catupgrdsrdbplug_catcon_11702.lst]
catcon::set_log_file_base_path: catcon: See [/home/oracle/scripts/logs/catupgrdsrdbplug*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/home/oracle/scripts/logs/catupgrdsrdbplug_*.lst] files for spool files, if any
Number of Cpus = 2
Database Name = SRCDB2
DataBase Version = 19.0.0.0.0
SRDBPLUG Open Mode = [MIGRATE]
Generated PDB Inclusion:[SRDBPLUG]
CDB$ROOT Open Mode = [OPEN]
Components in [SRDBPLUG]
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_07_19 22:05:56]
Container Lists Inclusion:[SRDBPLUG] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [SRDBPLUG] Files:1 Time: 82s
*************** Catalog Core SQL ***************
Serial Phase #:1 [SRDBPLUG] Files:5 Time: 246s
Restart Phase #:2 [SRDBPLUG] Files:1 Time: 2s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [SRDBPLUG] Files:19 Time: 102s
Restart Phase #:4 [SRDBPLUG] Files:1 Time: 1s
************* Catalog Final Scripts ************
Serial Phase #:5 [SRDBPLUG] Files:7 Time: 98s
***************** Catproc Start ****************
Serial Phase #:6 [SRDBPLUG] Files:1 Time: 51s
***************** Catproc Types ****************
Serial Phase #:7 [SRDBPLUG] Files:2 Time: 51s
Restart Phase #:8 [SRDBPLUG] Files:1 Time: 2s
**************** Catproc Tables ****************
Parallel Phase #:9 [SRDBPLUG] Files:67 Time: 153s
Restart Phase #:10 [SRDBPLUG] Files:1 Time: 2s
************* Catproc Package Specs ************
Serial Phase #:11 [SRDBPLUG] Files:1 Time: 266s
Restart Phase #:12 [SRDBPLUG] Files:1 Time: 1s
************** Catproc Procedures **************
Parallel Phase #:13 [SRDBPLUG] Files:94 Time: 34s
Restart Phase #:14 [SRDBPLUG] Files:1 Time: 2s
Parallel Phase #:15 [SRDBPLUG] Files:120 Time: 51s
Restart Phase #:16 [SRDBPLUG] Files:1 Time: 2s
Serial Phase #:17 [SRDBPLUG] Files:22 Time: 14s
Restart Phase #:18 [SRDBPLUG] Files:1 Time: 2s
***************** Catproc Views ****************
Parallel Phase #:19 [SRDBPLUG] Files:32 Time: 93s
Restart Phase #:20 [SRDBPLUG] Files:1 Time: 2s
Serial Phase #:21 [SRDBPLUG] Files:3 Time: 52s
Restart Phase #:22 [SRDBPLUG] Files:1 Time: 2s
Parallel Phase #:23 [SRDBPLUG] Files:25 Time: 489s
Restart Phase #:24 [SRDBPLUG] Files:1 Time: 2s
Parallel Phase #:25 [SRDBPLUG] Files:12 Time: 388s
Restart Phase #:26 [SRDBPLUG] Files:1 Time: 2s
Serial Phase #:27 [SRDBPLUG] Files:1 Time: 0s
Serial Phase #:28 [SRDBPLUG] Files:3 Time: 29s
Serial Phase #:29 [SRDBPLUG] Files:1 Time: 0s
Restart Phase #:30 [SRDBPLUG] Files:1 Time: 2s
*************** Catproc CDB Views **************
Serial Phase #:31 [SRDBPLUG] Files:1 Time: 8s
Restart Phase #:32 [SRDBPLUG] Files:1 Time: 1s
Serial Phase #:34 [SRDBPLUG] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [SRDBPLUG] Files:293 Time: 161s
Serial Phase #:36 [SRDBPLUG] Files:1 Time: 0s
Restart Phase #:37 [SRDBPLUG] Files:1 Time: 1s
Serial Phase #:38 [SRDBPLUG] Files:6 Time: 16s
Restart Phase #:39 [SRDBPLUG] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:40 [SRDBPLUG] Files:3 Time: 180s
Restart Phase #:41 [SRDBPLUG] Files:1 Time: 2s
****************** Catproc SQL *****************
Parallel Phase #:42 [SRDBPLUG] Files:13 Time: 358s
Restart Phase #:43 [SRDBPLUG] Files:1 Time: 2s
Parallel Phase #:44 [SRDBPLUG] Files:11 Time: 22s
Restart Phase #:45 [SRDBPLUG] Files:1 Time: 2s
Parallel Phase #:46 [SRDBPLUG] Files:3 Time: 14s
Restart Phase #:47 [SRDBPLUG] Files:1 Time: 2s
************* Final Catproc scripts ************
Serial Phase #:48 [SRDBPLUG] Files:1 Time: 34s
Restart Phase #:49 [SRDBPLUG] Files:1 Time: 2s
************** Final RDBMS scripts *************
Serial Phase #:50 [SRDBPLUG] Files:1 Time: 19s
************ Upgrade Component Start ***********
Serial Phase #:51 [SRDBPLUG] Files:1 Time: 8s
Restart Phase #:52 [SRDBPLUG] Files:1 Time: 2s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [SRDBPLUG] Files:2 Time: 929s
***************** Upgrading XDB ****************
Restart Phase #:54 [SRDBPLUG] Files:1 Time: 1s
Serial Phase #:56 [SRDBPLUG] Files:3 Time: 27s
Serial Phase #:57 [SRDBPLUG] Files:3 Time: 13s
Parallel Phase #:58 [SRDBPLUG] Files:10 Time: 14s
Parallel Phase #:59 [SRDBPLUG] Files:25 Time: 19s
Serial Phase #:60 [SRDBPLUG] Files:4 Time: 40s
Serial Phase #:61 [SRDBPLUG] Files:1 Time: 0s
Serial Phase #:62 [SRDBPLUG] Files:32 Time: 18s
Serial Phase #:63 [SRDBPLUG] Files:1 Time: 0s
Parallel Phase #:64 [SRDBPLUG] Files:6 Time: 18s
Serial Phase #:65 [SRDBPLUG] Files:2 Time: 78s
Serial Phase #:66 [SRDBPLUG] Files:3 Time: 87s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [SRDBPLUG] Files:1 Time: 2s
Serial Phase #:69 [SRDBPLUG] Files:1 Time: 10s
Parallel Phase #:70 [SRDBPLUG] Files:2 Time: 31s
Restart Phase #:71 [SRDBPLUG] Files:1 Time: 2s
Parallel Phase #:72 [SRDBPLUG] Files:2 Time: 10s
Serial Phase #:73 [SRDBPLUG] Files:2 Time: 10s
***************** Upgrading SDO ****************
Restart Phase #:74 [SRDBPLUG] Files:1 Time: 2s
Serial Phase #:76 [SRDBPLUG] Files:1 Time: 121s
Serial Phase #:77 [SRDBPLUG] Files:2 Time: 13s
Restart Phase #:78 [SRDBPLUG] Files:1 Time: 2s
Serial Phase #:79 [SRDBPLUG] Files:1 Time: 21s
Restart Phase #:80 [SRDBPLUG] Files:1 Time: 0s
Parallel Phase #:81 [SRDBPLUG] Files:3 Time: 167s
Restart Phase #:82 [SRDBPLUG] Files:1 Time: 3s
Serial Phase #:83 [SRDBPLUG] Files:1 Time: 22s
Restart Phase #:84 [SRDBPLUG] Files:1 Time: 2s
Serial Phase #:85 [SRDBPLUG] Files:1 Time: 40s
Restart Phase #:86 [SRDBPLUG] Files:1 Time: 1s
Parallel Phase #:87 [SRDBPLUG] Files:4 Time: 222s
Restart Phase #:88 [SRDBPLUG] Files:1 Time: 2s
Serial Phase #:89 [SRDBPLUG] Files:1 Time: 10s
Restart Phase #:90 [SRDBPLUG] Files:1 Time: 1s
Serial Phase #:91 [SRDBPLUG] Files:2 Time: 58s
Restart Phase #:92 [SRDBPLUG] Files:1 Time: 2s
Serial Phase #:93 [SRDBPLUG] Files:1 Time: 8s
Restart Phase #:94 [SRDBPLUG] Files:1 Time: 1s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [SRDBPLUG] Files:1 Time: 38s
Restart Phase #:96 [SRDBPLUG] Files:1 Time: 1s
*********** Final Component scripts ***********
Serial Phase #:97 [SRDBPLUG] Files:1 Time: 13s
************* Final Upgrade scripts ************
Serial Phase #:98 [SRDBPLUG] Files:1 Time: 415s
******************* Migration ******************
Serial Phase #:99 [SRDBPLUG] Files:1 Time: 8s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [SRDBPLUG] Files:1 Time: 8s
Serial Phase #:101 [SRDBPLUG] Files:1 Time: 26s
Serial Phase #:102 [SRDBPLUG] Files:1 Time: 13s
***************** Post Upgrade *****************
Serial Phase #:103 [SRDBPLUG] Files:1 Time: 156s
**************** Summary report ****************
Serial Phase #:104 [SRDBPLUG] Files:1 Time: 9s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [SRDBPLUG] Files:1 Time: 8s
Serial Phase #:106 [SRDBPLUG] Files:1 Time: 6s
Serial Phase #:107 [SRDBPLUG] Files:1 Time: 0s
------------------------------------------------------
Phases [0-107] End Time:[2020_07_19 23:42:03]
Container Lists Inclusion:[SRDBPLUG] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 5781s [SRDBPLUG]
LOG FILES: (/home/oracle/scripts/logs/catupgrdsrdbplug*.log)
Upgrade Summary Report Located in:
/home/oracle/scripts/logs/upg_summary.log
Time: 5868s For PDB(s)
Grand Total Time: 5868s
LOG FILES: (/home/oracle/scripts/logs/catupgrd*.log)
Grand Total Upgrade Time: [0d:1h:37m:48s]
[oracle@srlab bin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sun Jul 19 23:44:40 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 * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRDBPLUG MOUNTED
SQL> alter pluggable database SRDBPLUG open read write;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRDBPLUG READ WRITE NO
SQL>
SQL> alter pluggable database SRDBPLUG save state;
Pluggable database altered.
SQL>
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@srlab bin]$
[oracle@srlab bin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'SRDBPLUG' -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/19.0.0.0/db_3/bin/utlrp_catcon_23858.lst]
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0.0/db_3/bin/utlrp*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/u01/app/oracle/product/19.0.0.0/db_3/bin/utlrp_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlab bin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'SRDBPLUG' -l /home/oracle/logs -b utltz_upg_check -d $ORACLE_HOME/rdbms/admin utltz_upg_check.sql
Diagnostic output produced in conjunction with reporting an error message:
{
2020-07-20 00:05:27 DEBUG> /u01/app/oracle/product/19.0.0.0/db_3/rdbms/admin/catcon.pm:12372 catcon::catconInit2 - will retain last 1000 log messages by default
}
End of diagnostic output
catcon::valid_log_dir: Specified log file directory (/home/oracle/logs) does not exist or is not a directory
catcon::set_log_file_base_path: Unexpected error returned by valid_log_dir
catcon::catconInit2: Unexpected error returned by set_log_file_base_path
Unexpected error encountered in catconInit2; exiting
[oracle@srlab bin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'SRDBPLUG' -l /home/oracle/scripts/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/scripts/logs/utltz_upg_check_catcon_25368.lst]
catcon::set_log_file_base_path: catcon: See [/home/oracle/scripts/logs/utltz_upg_check*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/home/oracle/scripts/logs/utltz_upg_check_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlab bin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'SRDBPLUG' -l /home/oracle/scripts/logs -b utltz_upg_apply -d $ORACLE_HOME/rdbms/admin utltz_upg_apply.sql
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/home/oracle/scripts/logs/utltz_upg_apply_catcon_25513.lst]
catcon::set_log_file_base_path: catcon: See [/home/oracle/scripts/logs/utltz_upg_apply*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/home/oracle/scripts/logs/utltz_upg_apply_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlab bin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon Jul 20 00:09:14 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 * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB2
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRDBPLUG READ WRITE NO
SQL>
SQL> select value$, con_id from containers(SYS.PROPS$) where NAME='DST_PRIMARY_TT_VERSION' order by 2;
VALUE$
--------------------------------------------------------------------------------
CON_ID
----------
32
1
32
3
SQL> alter system set "_exclude_seed_cdb_view"=false scope=both;
System altered.
SQL> alter session set container=SRDBPLUG;
Session altered.
SQL> sho pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
3 SRDBPLUG READ WRITE NO
SQL>
SQL> select version from v$timezone_file;
VERSION
----------
32
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
SQL> select * from pdb_plug_in_violations;
TIME NAME CAUSE TYPE ERROR_NUMBER
--------------------------------------------------------------------------- -------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------- --------- ------------
LINE
----------
MESSAGE
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
STATUS
---------
ACTION
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
CON_ID
----------
19-JUL-20 11.38.52.900650 PM SRDBPLUG VSN not match ERROR 0
1
PDB's version does not match CDB's version: PDB's version 12.2.0.1.0. CDB's version 19.0.0.0.0.
RESOLVED
Either upgrade the PDB or reload the components in the PDB.
3
20-JUL-20 12.07.09.936886 AM SRDBPLUG missing XDB schema type WARNING 0
1
There are common XDB schema types missing from ROOT.
RESOLVED
Please execute xdb.DBMS_XMLSTORAGE_MANAGE.GetTypeDDL
3
20-JUL-20 12.07.09.936886 AM SRDBPLUG OPTION WARNING 0
15
Database option RAC mismatch: PDB installed version 19.0.0.0.0. CDB installed version NULL.
RESOLVED
Fix the database option in the PDB or the CDB
3
SQL> select count(*) from v$datafile;
COUNT(*)
----------
4
SQL> select name from v$datafile;
NAME
----------------------------------------------------
/u02/oradata/SRCDB2/SRDBPLUG/system01.dbf
/u02/oradata/SRCDB2/SRDBPLUG/sysaux01.dbf
/u02/oradata/SRCDB2/SRDBPLUG/undotbs01.dbf
/u02/oradata/SRCDB2/SRDBPLUG/users01.dbf
SQL>
select count(*) from dba_recyclebin;SQL>
COUNT(*)
----------
0
SQL> col comp_id for a20
SQL> col comp_name for a40
SQL> col version for a20
SQL> col status for a10
SQL> select comp_id,comp_name,version,status from dba_registry;
COMP_ID COMP_NAME VERSION STATUS
-------------------- ---------------------------------------- -------------------- ----------
CATALOG Oracle Database Catalog Views 19.0.0.0.0 VALID
CATPROC Oracle Database Packages and Types 19.0.0.0.0 VALID
JAVAVM JServer JAVA Virtual Machine 19.0.0.0.0 VALID
XML Oracle XDK 19.0.0.0.0 VALID
CATJAVA Oracle Database Java Packages 19.0.0.0.0 VALID
APS OLAP Analytic Workspace 19.0.0.0.0 VALID
RAC Oracle Real Application Clusters 19.0.0.0.0 OPTION OFF
XDB Oracle XML Database 19.0.0.0.0 VALID
OWM Oracle Workspace Manager 19.0.0.0.0 VALID
CONTEXT Oracle Text 19.0.0.0.0 VALID
ORDIM Oracle Multimedia 19.0.0.0.0 VALID
SDO Spatial 19.0.0.0.0 VALID
XOQ Oracle OLAP API 19.0.0.0.0 VALID
OLS Oracle Label Security 19.0.0.0.0 VALID
DV Oracle Database Vault 19.0.0.0.0 VALID
15 rows selected.
SQL> alter pluggable database SRDBPLUG save state;
Pluggable database altered.
SQL> alter session set container=cdb$root;
Session altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 SRDBPLUG READ WRITE NO
SQL> select name from v$active_services;
NAME
----------------------------------------------------------------
SRCDB2XDB
SYS$BACKGROUND
SYS$USERS
SRCDB2
srdbplug
SQL> select name from dba_services;
NAME
----------------------------------------------------------------
SYS$BACKGROUND
SYS$USERS
SRCDB2XDB
SRCDB2
Regards,
Ramesh.
Post a Comment: