Hello Friend's,
In this post we will discuss remote clone of pdb from Source host: dm10db12 (12c) to Destination host: dm10db11 (19c) with upgrade process of pdb
Environment :
we need to create the database link to connect to source container database CDBFINDB (12c) which will be used in the CREATE PLUGGABLE DATABASE.
Thanks All
Sultan Khan
In this post we will discuss remote clone of pdb from Source host: dm10db12 (12c) to Destination host: dm10db11 (19c) with upgrade process of pdb
Source host: dm10db12 (12c)
Source PDB: PDBFINDB in container database CDBFINDB
Destination host: dm10db11 (19c)
Destination PDB: PDBFINDB in container database CDBISTDB
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB READ WRITE NO
4 PDBCLONE READ WRITE NO
[oracle@dm10db12 ~]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sat Jun 6 12:34:12 2020
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL>----Verify that the source pluggable database (PDBFINDB@CDBFINDB) that we want to clone is in READ WRITE mode.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBFINDB READ WRITE NO
SQL>
SQL>
SQL> CREATE USER c##link IDENTIFIED BY oracle DEFAULT TABLESPACE users TEMPORARY TABLESPACE temp CONTAINER=ALL;
User created.
SQL> GRANT CREATE SESSION, CREATE PLUGGABLE DATABASE, SYSOPER TO c##link CONTAINER = ALL;
Grant succeeded.
[oracle@dm10db11 admin]$ cat tnsnames.ora
# tnsnames.ora Network Configuration File: /oracle/app/orawork/product/12.2.0.1/db_1/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.
LISTENER_CDBISTDB =
(ADDRESS = (PROTOCOL = TCP)(HOST = dm10db11.database.com)(PORT = 1521))
CDBISTDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dm10db11.database.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CDBISTDB.database.com)
)
)
CDBFINDB =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = dm10db12.database.com)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CDBFINDB.database.com)
)
)
[oracle@dm10db11 admin]$
we need to create the database link to connect to source container database CDBFINDB (12c) which will be used in the CREATE PLUGGABLE DATABASE.
[oracle@dm10db11 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 6 12:48:52 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 READ WRITE NO
4 PDBCLONE READ WRITE NO
SQL>
SQL> CREATE public DATABASE link Finclone CONNECT TO c##link IDENTIFIED BY oracle USING 'CDBFINDB';
Database link created.
SQL> col DB_LINK for a15
SQL> col HOST for a35
SQL> col username for a15
SQL> col owner for a15
SQL> set lines 200
SQL> col DB_LINK for a30
SQL> select owner,DB_LINK,USERNAME,HOST,CREATED from dba_db_links;
OWNER DB_LINK USERNAME HOST CREATED
--------------- ----------------------------------- --------------- --------------- ---------
SYS SYS_HUB SEEDDATA 26-JAN-17
SYS SYS_HUB.DATABASE.COM CDBISTDB 30-MAY-20
PUBLIC FINCLONE.DATABASE.COM C##LINK CDBFINDB 06-JUN-20
check for the working of db_link.
SQL> select sysdate from dual@Finclone;
SYSDATE
---------
06-JUN-20
SQL> CREATE PLUGGABLE DATABASE PDBFINDB FROM PDBFINDB@Finclone;
Pluggable database created.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB READ WRITE NO
4 PDBCLONE READ WRITE NO
5 PDBFINDB MOUNTED
SQL>
SQL> ----Remote Hot Clone created it will be in mount state
SQL>
SQL> Alter pluggable database PDBFINDB open upgrade;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB READ WRITE NO
4 PDBCLONE READ WRITE NO
5 PDBFINDB MIGRATE YES
[oracle@dm10db11 upg_logs]$ dbupgrade -c PDBFINDB -l /oracle/app/orawork/upg_logs
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 = PDBFINDB
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 = /oracle/app/orawork/upg_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]
/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/upg_logs]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/oracle/app/orawork/upg_logs/catupgrd_catcon_32461.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/catupgrd*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/catupgrd_*.lst] files for spool files, if any
Number of Cpus = 1
Database Name = CDBISTDB
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:[PDBFINDB]
CDB$ROOT Open Mode = [OPEN]
Start processing of PDBs (PDBFINDB)
[/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 -c 'PDBFINDB' -l /oracle/app/orawork/upg_logs -I -i pdbfindb -n 2 /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 = PDBFINDB
Do not run in C = 0
Input Directory d = 0
Echo OFF e = 1
Simulate E = 0
Forced cleanup F = 0
Log Id i = pdbfindb
Child Process I = 1
Log Dir l = /oracle/app/orawork/upg_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]
/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/upg_logs]
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/oracle/app/orawork/upg_logs/catupgrdpdbfindb_catcon_343.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/catupgrdpdbfindb*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/catupgrdpdbfindb_*.lst] files for spool files, if any
Number of Cpus = 1
Database Name = CDBISTDB
DataBase Version = 19.0.0.0.0
PDBFINDB Open Mode = [MIGRATE]
Generated PDB Inclusion:[PDBFINDB]
CDB$ROOT Open Mode = [OPEN]
Components in [PDBFINDB]
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_06_06 13:17:25]
Container Lists Inclusion:[PDBFINDB] Exclusion:[NONE]
------------------------------------------------------
*********** Executing Change Scripts ***********
Serial Phase #:0 [PDBFINDB] Files:1 Time: 38s
*************** Catalog Core SQL ***************
Serial Phase #:1 [PDBFINDB] Files:5 Time: 48s
Restart Phase #:2 [PDBFINDB] Files:1 Time: 2s
*********** Catalog Tables and Views ***********
Parallel Phase #:3 [PDBFINDB] Files:19 Time: 28s
Restart Phase #:4 [PDBFINDB] Files:1 Time: 2s
************* Catalog Final Scripts ************
Serial Phase #:5 [PDBFINDB] Files:7 Time: 20s
***************** Catproc Start ****************
Serial Phase #:6 [PDBFINDB] Files:1 Time: 20s
***************** Catproc Types ****************
Serial Phase #:7 [PDBFINDB] Files:2 Time: 13s
Restart Phase #:8 [PDBFINDB] Files:1 Time: 1s
**************** Catproc Tables ****************
Parallel Phase #:9 [PDBFINDB] Files:67 Time: 71s
Restart Phase #:10 [PDBFINDB] Files:1 Time: 1s
************* Catproc Package Specs ************
Serial Phase #:11 [PDBFINDB] Files:1 Time: 64s
Restart Phase #:12 [PDBFINDB] Files:1 Time: 1s
************** Catproc Procedures **************
Parallel Phase #:13 [PDBFINDB] Files:94 Time: 19s
Restart Phase #:14 [PDBFINDB] Files:1 Time: 2s
Parallel Phase #:15 [PDBFINDB] Files:120 Time: 24s
Restart Phase #:16 [PDBFINDB] Files:1 Time: 2s
Serial Phase #:17 [PDBFINDB] Files:22 Time: 11s
Restart Phase #:18 [PDBFINDB] Files:1 Time: 1s
***************** Catproc Views ****************
Parallel Phase #:19 [PDBFINDB] Files:32 Time: 35s
Restart Phase #:20 [PDBFINDB] Files:1 Time: 1s
Serial Phase #:21 [PDBFINDB] Files:3 Time: 22s
Restart Phase #:22 [PDBFINDB] Files:1 Time: 2s
Parallel Phase #:23 [PDBFINDB] Files:25 Time: 250s
Restart Phase #:24 [PDBFINDB] Files:1 Time: 2s
Parallel Phase #:25 [PDBFINDB] Files:12 Time: 124s
Restart Phase #:26 [PDBFINDB] Files:1 Time: 0s
Serial Phase #:27 [PDBFINDB] Files:1 Time: 0s
Serial Phase #:28 [PDBFINDB] Files:3 Time: 12s
Serial Phase #:29 [PDBFINDB] Files:1 Time: 0s
Restart Phase #:30 [PDBFINDB] Files:1 Time: 1s
*************** Catproc CDB Views **************
Serial Phase #:31 [PDBFINDB] Files:1 Time: 7s
Restart Phase #:32 [PDBFINDB] Files:1 Time: 1s
Serial Phase #:34 [PDBFINDB] Files:1 Time: 0s
***************** Catproc PLBs *****************
Serial Phase #:35 [PDBFINDB] Files:293 Time: 33s
Serial Phase #:36 [PDBFINDB] Files:1 Time: 0s
Restart Phase #:37 [PDBFINDB] Files:1 Time: 1s
Serial Phase #:38 [PDBFINDB] Files:6 Time: 8s
Restart Phase #:39 [PDBFINDB] Files:1 Time: 1s
*************** Catproc DataPump ***************
Serial Phase #:40 [PDBFINDB] Files:3 Time: 58s
Restart Phase #:41 [PDBFINDB] Files:1 Time: 1s
****************** Catproc SQL *****************
Parallel Phase #:42 [PDBFINDB] Files:13 Time: 132s
Restart Phase #:43 [PDBFINDB] Files:1 Time: 2s
Parallel Phase #:44 [PDBFINDB] Files:11 Time: 12s
Restart Phase #:45 [PDBFINDB] Files:1 Time: 1s
Parallel Phase #:46 [PDBFINDB] Files:3 Time: 8s
Restart Phase #:47 [PDBFINDB] Files:1 Time: 1s
************* Final Catproc scripts ************
Serial Phase #:48 [PDBFINDB] Files:1 Time: 12s
Restart Phase #:49 [PDBFINDB] Files:1 Time: 1s
************** Final RDBMS scripts *************
Serial Phase #:50 [PDBFINDB] Files:1 Time: 9s
************ Upgrade Component Start ***********
Serial Phase #:51 [PDBFINDB] Files:1 Time: 7s
Restart Phase #:52 [PDBFINDB] Files:1 Time: 1s
********** Upgrading Java and non-Java *********
Serial Phase #:53 [PDBFINDB] Files:2 Time: 310s
***************** Upgrading XDB ****************
Restart Phase #:54 [PDBFINDB] Files:1 Time: 1s
Serial Phase #:56 [PDBFINDB] Files:3 Time: 14s
Serial Phase #:57 [PDBFINDB] Files:3 Time: 10s
Parallel Phase #:58 [PDBFINDB] Files:10 Time: 12s
Parallel Phase #:59 [PDBFINDB] Files:25 Time: 14s
Serial Phase #:60 [PDBFINDB] Files:4 Time: 16s
Serial Phase #:61 [PDBFINDB] Files:1 Time: 0s
Serial Phase #:62 [PDBFINDB] Files:32 Time: 11s
Serial Phase #:63 [PDBFINDB] Files:1 Time: 0s
Parallel Phase #:64 [PDBFINDB] Files:6 Time: 14s
Serial Phase #:65 [PDBFINDB] Files:2 Time: 22s
Serial Phase #:66 [PDBFINDB] Files:3 Time: 31s
**************** Upgrading ORDIM ***************
Restart Phase #:67 [PDBFINDB] Files:1 Time: 2s
Serial Phase #:69 [PDBFINDB] Files:1 Time: 8s
Parallel Phase #:70 [PDBFINDB] Files:2 Time: 17s
Restart Phase #:71 [PDBFINDB] Files:1 Time: 2s
Parallel Phase #:72 [PDBFINDB] Files:2 Time: 10s
Serial Phase #:73 [PDBFINDB] Files:2 Time: 9s
***************** Upgrading SDO ****************
Restart Phase #:74 [PDBFINDB] Files:1 Time: 1s
Serial Phase #:76 [PDBFINDB] Files:1 Time: 64s
Serial Phase #:77 [PDBFINDB] Files:2 Time: 12s
Restart Phase #:78 [PDBFINDB] Files:1 Time: 2s
Serial Phase #:79 [PDBFINDB] Files:1 Time: 14s
Restart Phase #:80 [PDBFINDB] Files:1 Time: 1s
Parallel Phase #:81 [PDBFINDB] Files:3 Time: 84s
Restart Phase #:82 [PDBFINDB] Files:1 Time: 1s
Serial Phase #:83 [PDBFINDB] Files:1 Time: 15s
Restart Phase #:84 [PDBFINDB] Files:1 Time: 1s
Serial Phase #:85 [PDBFINDB] Files:1 Time: 18s
Restart Phase #:86 [PDBFINDB] Files:1 Time: 0s
Parallel Phase #:87 [PDBFINDB] Files:4 Time: 102s
Restart Phase #:88 [PDBFINDB] Files:1 Time: 2s
Serial Phase #:89 [PDBFINDB] Files:1 Time: 9s
Restart Phase #:90 [PDBFINDB] Files:1 Time: 1s
Serial Phase #:91 [PDBFINDB] Files:2 Time: 27s
Restart Phase #:92 [PDBFINDB] Files:1 Time: 2s
Serial Phase #:93 [PDBFINDB] Files:1 Time: 6s
Restart Phase #:94 [PDBFINDB] Files:1 Time: 2s
******* Upgrading ODM, WK, EXF, RUL, XOQ *******
Serial Phase #:95 [PDBFINDB] Files:1 Time: 22s
Restart Phase #:96 [PDBFINDB] Files:1 Time: 1s
*********** Final Component scripts ***********
Serial Phase #:97 [PDBFINDB] Files:1 Time: 8s
************* Final Upgrade scripts ************
Serial Phase #:98 [PDBFINDB] Files:1 Time: 135s
******************* Migration ******************
Serial Phase #:99 [PDBFINDB] Files:1 Time: 6s
*** End PDB Application Upgrade Pre-Shutdown ***
Serial Phase #:100 [PDBFINDB] Files:1 Time: 8s
Serial Phase #:101 [PDBFINDB] Files:1 Time: 8s
Serial Phase #:102 [PDBFINDB] Files:1 Time: 7s
***************** Post Upgrade *****************
Serial Phase #:103 [PDBFINDB] Files:1 Time: 27s
**************** Summary report ****************
Serial Phase #:104 [PDBFINDB] Files:1 Time: 7s
*** End PDB Application Upgrade Post-Shutdown **
Serial Phase #:105 [PDBFINDB] Files:1 Time: 7s
Serial Phase #:106 [PDBFINDB] Files:1 Time: 3s
Serial Phase #:107 [PDBFINDB] Files:1 Time: 0s
------------------------------------------------------
Phases [0-107] End Time:[2020_06_06 13:54:26]
Container Lists Inclusion:[PDBFINDB] Exclusion:[NONE]
------------------------------------------------------
Grand Total Time: 2220s [PDBFINDB]
LOG FILES: (/oracle/app/orawork/upg_logs/catupgrdpdbfindb*.log)
Upgrade Summary Report Located in:
/oracle/app/orawork/upg_logs/upg_summary.log
Time: 2296s For PDB(s)
Grand Total Time: 2296s
LOG FILES: (/oracle/app/orawork/upg_logs/catupgrd*.log)
Grand Total Upgrade Time: [0d:0h:38m:16s]
====================Script Completed========================
[oracle@dm10db11 upg_logs]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 6 14:13:34 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> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB READ WRITE NO
4 PDBCLONE READ WRITE NO
5 PDBFINDB MOUNTED
SQL>
SQL> ----Database is in mounted state after the upgrade, now start the pdb
SQL>
SQL> alter pluggable database PDBFINDB open;
Pluggable database altered.
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 PDBISTDB READ WRITE NO
4 PDBCLONE READ WRITE NO
5 PDBFINDB READ WRITE NO
SQL>
SQL> alter pluggable database PDBFINDB save state;
Pluggable database altered.
SQL> col CON_NAME for a15
SQL> col INSTANCE_NAME for a15
SQL> set lines 200
SQL> select CON_ID,CON_NAME,INSTANCE_NAME,STATE,RESTRICTED from dba_pdb_saved_states;
CON_ID CON_NAME INSTANCE_NAME STATE RES
---------- --------------- --------------- -------------- ---
5 PDBFINDB CDBISTDB OPEN NO
[oracle@dm10db11 upg_logs]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'PDBFINDB' -e -b utlrp -d $ORACLE_HOME/rdbms/admin utlrp.sql
catcon::set_log_file_base_path: ALL catcon-related output will be written to [/oracle/app/orawork/upg_logs/utlrp_catcon_22587.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/utlrp*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/utlrp_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@dm10db11 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 6 15:10:38 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> col VALUE$ for a15
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
32 4
26 5
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@dm10db11 admin]$
[oracle@dm10db11 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'PDBFINDB' -l /oracle/app/orawork/upg_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 [/oracle/app/orawork/upg_logs/utltz_upg_check_catcon_29708.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/utltz_upg_check*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/utltz_upg_check_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@dm10db11 admin]$
[oracle@dm10db11 admin]$
[oracle@dm10db11 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'PDBFINDB' -l /oracle/app/orawork/upg_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 [/oracle/app/orawork/upg_logs/utltz_upg_apply_catcon_29914.lst]
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/utltz_upg_apply*.log] files for output generated by scripts
catcon::set_log_file_base_path: catcon: See [/oracle/app/orawork/upg_logs/utltz_upg_apply_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@dm10db11 admin]$
[oracle@dm10db11 admin]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Sat Jun 6 15:13:27 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> col VALUE$ for a15
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
32 4
32 5
Thanks All
Sultan Khan
5 comments
Click here for commentsExcellent post
ReplyGood post clear steps
ReplyGood post
ReplyGreate post it really helped me
ReplyNice post
ReplyConversionConversion EmoticonEmoticon