12cR2 CDB Database Components Clean Up - Oracle 12.2.0.1 - CDB Database Registry Components Removal!
Recompile in a Multitenant environment:
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
You must set _exclude_seed_cdb_view to FALSE to see also objects belonging to the PDB$SEED
SQL> alter system set "_exclude_seed_cdb_view"=false scope=both;
Check_Components.sql
set line 200
set pages 1000
col COMP_ID format a8
col COMP_NAME format a34
col SCHEMA format a12
col STATUS format a10
col VERSION format a12
col CON_ID format 99
select CON_ID, COMP_ID, comp_name, schema, status, version from CDB_REGISTRY order by 1,2;
Check_Invalid_Objects.sql
set line 200
set pages 1000
col owner format a12
col object_type format a12
col object_name format a30
col STATUS format a8
col CON_ID format 9
select con_id, owner, object_type, object_name, status from CDB_OBJECTS where status='INVALID' order by 1,2,3;
Oracle Workspace Manager (OWM) Clean Up in Oracle Database 12.2:
CDB
In contrast the OWM removal from a CDB is a bit more complicated. If all is done in one pass then you’ll receive this error sequence:
ERROR at line 1:ORA-06598: insufficient INHERIT PRIVILEGES privilege
ORA-06512: at "WMSYS.LT", line 1
ORA-06512: at line 1
ORA-06512: at line 54ORA-06512: at line 54
ORA-06512: at line 91
Hence to complete the removal successfully and without errors it must be split up in two phases:
removal from all PDBs including the PDB$SEED:
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b owm_clean_pdbs -d '''.''' owmuinst.plb
Removal from the CDB$ROOT
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b owm_clean_cdb -d '''.''' owmuinst.plb
Oracle Label Security (OLS) Clean Up in Oracle Database 12.2:
CDB:
$ cp $OH12102/rdbms/admin/catnools.sql $ORACLE_HOME/rdbms/admin
PDB$SEED:
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b catnools_pdbs -d '''.''' catnools.sql
In addition remove OLS now from CDB$ROOT:
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b catnools_cdb -d '''.''' catnools.sql
$ vi clean_ols.sql
drop package LBAC_EXP;
drop package OLS_ENFORCEMENT;
Finally execute clean_ols.sql with catcon.pl.
$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b clean_ols -d '''.''' clean_ols.sql
Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-12.2:
CDB:
$ cp $OH12102/rdbms/admin/catnools.sql $ORACLE_HOME/rdbms/admin
PDB$SEED:
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b catnools_pdbs -d '''.''' catnools.sql
In addition remove OLS now from CDB$ROOT:
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b catnools_cdb -d '''.''' catnools.sql
$ vi clean_ols.sql
drop package LBAC_EXP;
drop package OLS_ENFORCEMENT;
Finally execute clean_ols.sql with catcon.pl.
$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b clean_ols -d '''.''' clean_ols.sql
Oracle Spatial (SDO) Clean Up in Oracle Database 11.2-12.2
CDB:
At first I start with dropping the user MDSYS from all PDBs:
cd $ORACLE_HOME/rdbms/admin
vi drop_MDSYS.sql
drop user MDSYS cascade;
set pagesize 0
set feed off
set linesize 200
set termout off
set serverout on
spool dropsyn.sql
exec DBMS_OUTPUT.PUT_LINE('alter session set "_ORACLE_SCRIPT"=TRUE;');
select 'drop public synonym "' || synonym_name || '";' from dba_synonyms where table_owner='MDSYS';
spool off;
exit
In addition I will prepare a script for later to remove the leftover Spatial users:
vi drop_others.sql
drop user mddata cascade;
drop user spatial_csw_admin_usr cascade;
Remove MDSYS and leftover-synonyms from PDBs
Now I can drop MDSYS from the PDBs and the PDB$SEED at first, then I clean up the leftover synonyms:
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -C 'CDB$ROOT' -e -b drop_MDSYS_pdbs -d '''.''' drop_MDSYS.sql
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -C 'CDB$ROOT' -e -b dropsyn_pdbs -d '''.''' dropsyn.sql
Remove MDSYS and leftover-synonyms from CDB$ROOT
Before I can remove MDSYS from the CDB$ROOT container I will have to shutdown all PDBs including the PDB$SEED as otherwise the drop statement fails with ORA-604 and ORA-14452: attempt to create, alter or drop an index on temporary table already in use.
sqlplus / as sysdba
SQL> alter pluggable database all close immediate;
SQL> alter pluggable database pdb$seed close;
SQL> exit
cd $ORACLE_HOME/rdbms/admin
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'CDB$ROOT' -e -b drop_MDSYS_cdb -d '''.''' drop_MDSYS.sql
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'CDB$ROOT' -e -b dropsyn_cdb -d '''.''' dropsyn.sql
Afterwards I’m opening all PDBs again:
sqlplus / as sysdba
SQL> alter pluggable database all open;
SQL> alter pluggable database pdb$seed open read only;
SQL> exit
In the next step I drop the remaining Spatial users:
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -C 'CDB$ROOT' -e -b drop_others_pdbs -d '''.''' drop_others.sql
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'CDB$ROOT' -e -b drop_others_cdb -d '''.''' drop_others.sql
Finally I remove a leftover package from all containers:
$ vi drop_leftovers.sql
drop package sys.SDO_RDF_EXP_IMP;
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b drop_leftovers -d '''.''' drop_leftovers.sql
Oracle Text (CONTEXT) Clean Up in Oracle Database 12.2:
CDB
At first I start the removal process from the PDBs:
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b catnoctx_pdbs -d $ORACLE_HOME/ctx/admin catnoctx.sql
As this step has some leftovers I will clean them up with a short script:
$ vi ctx_leftovers.sql
drop procedure sys.validate_context;
drop package XDB.dbms_xdbt;
drop procedure xdb.xdb_datastore_proc;
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b ctx_leftovers_pdbs -d '''.''' ctx_leftovers.sql
Additionally I will repeat the same steps within the CDB$ROOT container:
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b catnoctx_cdb -d $ORACLE_HOME/ctx/admin catnoctx.sql
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b ctx_leftovers_cdb -d '''.''' ctx_leftovers.sql
And finally I will have to remove a leftover public synonym from all containers:
$ vi ctx_rmsyn.sql
drop public synonym DBMS_XDBT;
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b ctx_rmsys -d '''.''' ctx_rmsyn.sql
Oracle Multimedia (ORDIM) Clean Up in Oracle Database 12.2:
CDB
At first you’ll run an optional check for ORDIM usage:
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b imremchk -d $ORACLE_HOME/ord/im/admin imremchk.sql
Please check the log file imremchk0.log.
Afterwards you’ll remove ORDIM from all PDBs first followed by a mandatory recompilation:
$ cd $ORACLE_HOME/rdbms/admin
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b imremdo_pdbs -d $ORACLE_HOME/ord/im/admin imremdo.sql
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
In the next phase you will remove ORDIM now from the CDB$ROOT and recompile again:
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b imremdo_cdb -d $ORACLE_HOME/ord/im/admin imremdo.sql
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
And finally you have to cleanup leftovers from all container:
$ vi dropim.sql
drop package SYS.ORD_ADMIN;
drop package SYS.ORDIMDPCALLOUTS;
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b dropim -d '''.''' dropim.sql
Oracle OLAP (XOQ, APS, AMD) Clean Up in Oracle Database 12.2:
CDB:
chopt disable olap
If you want to remove APS you will have to do this PDB after PDB as during the removal of XOQ as otherwise you’ll receive an ORA-65023: active transaction exists in container PDBn. A recompilation afterwards is mandatory:
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'ORCLPDBPLUG' -e -b catnoaps_pdb2 -d $ORACLE_HOME/olap/admin/ catnoaps.sql
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'ORCLPDBPLUG' -e -b catnoaps_pdb1 -d $ORACLE_HOME/olap/admin/ catnoaps.sql
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'PDB$SEED' -e -b catnoaps_pdbseed -d $ORACLE_HOME/olap/admin/ catnoaps.sql
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
Then you can approach the removal from CDB$ROOT, again followed by a recompilation:
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b catnoaps_cdb -d $ORACLE_HOME/olap/admin/ catnoaps.sql
$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b dv_cdb -d dvremov.sql
$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b dvremove_cdb -d '''.''' dvremov.sql
$ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b dvremove_pdbs -d '''.''' dvremov.sql
SELECT 'DROP VIEW "' || VIEW_NAME || '";'
FROM DBA_VIEWS
WHERE OWNER='DVSYS';
SQL> set lines 300 pages 2000
SQL>
SQL> col comp_name for a40
SQL>
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> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlabgg3 ~]$
[oracle@srlabgg3 ~]$
[oracle@srlabgg3 ~]$ clear
[oracle@srlabgg3 ~]$ ps -ef |grep pmon
oracle 11207 1 0 08:38 ? 00:00:03 ora_pmon_srlab
oracle 13878 1 0 03:55 ? 00:00:05 ora_pmon_srcdb
oracle 17594 16303 0 16:19 pts/1 00:00:00 grep --color=auto pmon
[oracle@srlabgg3 ~]$ ps -ef |grep tns
root 22 2 0 03:42 ? 00:00:00 [netns]
oracle 11227 1 0 03:53 ? 00:00:03 /u03/app/oracle/product/12.1.0.2/db_3/bin/tnslsnr SRLAB121 -inherit
oracle 17596 16303 0 16:19 pts/1 00:00:00 grep --color=auto tns
oracle 22556 1 0 04:07 ? 00:00:03 /u03/app/oracle/product/12.2.0.1/db_2/bin/tnslsnr SRCDB122 -inherit
[oracle@srlabgg3 ~]$
[oracle@srlabgg3 ~]$ . oraenv
ORACLE_SID = [srcdb] ?
The Oracle base remains unchanged with value /u01/app/oracle
[oracle@srlabgg3 ~]$
[oracle@srlabgg3 ~]$
[oracle@srlabgg3 ~]$ cd $ORACLE_HOME
[oracle@srlabgg3 db_2]$ pwd
/u03/app/oracle/product/12.2.0.1/db_2
[oracle@srlabgg3 db_2]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 4 16:19:42 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to:
Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
SQL> select * from global_name;
GLOBAL_NAME
--------------------------------------------------------------------------------
SRCDB
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDBPLUG READ WRITE NO
SQL>
SQL> set lines 300 pages 20000
SQL> set time on timing on
16:20:00 SQL>
16:20:00 SQL> col comp_name for a40
16:20:11 SQL> col schema for a20
16:20:16 SQL>
16:20:16 SQL> select comp_id,comp_name,version,schema,status from cdb_registry;
COMP_ID COMP_NAME VERSION SCHEMA STATUS
------------------------------ ---------------------------------------- ------------------------------ -------------------- -----------
CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
XML Oracle XDK 12.2.0.1.0 SYS VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 XDB VALID
OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
SDO Spatial 12.2.0.1.0 MDSYS VALID
XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
XML Oracle XDK 12.2.0.1.0 SYS VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 XDB VALID
OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
SDO Spatial 12.2.0.1.0 MDSYS VALID
XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
30 rows selected.
Elapsed: 00:00:00.18
16:20:33 SQL> col schema for a10
16:20:46 SQL> /
COMP_ID COMP_NAME VERSION SCHEMA STATUS
------------------------------ ---------------------------------------- ------------------------------ ---------- -----------
CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
XML Oracle XDK 12.2.0.1.0 SYS VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 XDB VALID
OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
SDO Spatial 12.2.0.1.0 MDSYS VALID
XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
XML Oracle XDK 12.2.0.1.0 SYS VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 XDB VALID
OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
SDO Spatial 12.2.0.1.0 MDSYS VALID
XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
30 rows selected.
Elapsed: 00:00:00.04
16:20:47 SQL> col comp_id for a10
16:21:01 SQL> /
COMP_ID COMP_NAME VERSION SCHEMA STATUS
---------- ---------------------------------------- ------------------------------ ---------- -----------
CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
XML Oracle XDK 12.2.0.1.0 SYS VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 XDB VALID
OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
SDO Spatial 12.2.0.1.0 MDSYS VALID
XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
XML Oracle XDK 12.2.0.1.0 SYS VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 XDB VALID
OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
SDO Spatial 12.2.0.1.0 MDSYS VALID
XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
30 rows selected.
Elapsed: 00:00:00.06
16:21:02 SQL> ;
1* select comp_id,comp_name,version,schema,status from cdb_registry
16:21:13 SQL>
16:21:13 SQL> select con_id,comp_id,comp_name,version,schema,status from cdb_registry;
CON_ID COMP_ID COMP_NAME VERSION SCHEMA STATUS
---------- ---------- ---------------------------------------- ------------------------------ ---------- -----------
1 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
1 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
1 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
1 XML Oracle XDK 12.2.0.1.0 SYS VALID
1 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
1 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
1 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
1 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
1 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
1 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
1 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
1 SDO Spatial 12.2.0.1.0 MDSYS VALID
1 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
1 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
1 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
3 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
3 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
3 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
3 XML Oracle XDK 12.2.0.1.0 SYS VALID
3 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
3 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
3 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
3 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
3 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
3 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
3 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
3 SDO Spatial 12.2.0.1.0 MDSYS VALID
3 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
3 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
3 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
30 rows selected.
Elapsed: 00:00:00.04
16:21:23 SQL> alter session set "_oracle_script"=true;
Session altered.
Elapsed: 00:00:00.01
16:22:00 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ ONLY NO
3 ORCLPDBPLUG READ WRITE NO
16:22:02 SQL>
16:22:02 SQL> alter pluggable database PDB$SEED close immediate;
Pluggable database altered.
Elapsed: 00:00:01.51
16:22:15 SQL> alter pluggable database PDB$SEED open read write;
Pluggable database altered.
Elapsed: 00:00:06.12
16:22:30 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ WRITE NO
3 ORCLPDBPLUG READ WRITE NO
16:22:33 SQL> select con_id,comp_id,comp_name,version,schema,status from cdb_registry;
CON_ID COMP_ID COMP_NAME VERSION SCHEMA STATUS
---------- ---------- ---------------------------------------- ------------------------------ ---------- -----------
3 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
3 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
3 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
3 XML Oracle XDK 12.2.0.1.0 SYS VALID
3 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
3 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
3 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
3 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
3 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
3 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
3 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
3 SDO Spatial 12.2.0.1.0 MDSYS VALID
3 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
3 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
3 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
1 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
1 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
1 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
1 XML Oracle XDK 12.2.0.1.0 SYS VALID
1 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
1 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
1 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
1 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
1 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
1 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
1 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
1 SDO Spatial 12.2.0.1.0 MDSYS VALID
1 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
1 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
1 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
30 rows selected.
Elapsed: 00:00:00.05
16:22:43 SQL> select con_id,comp_id,comp_name,version,schema,status from pdb_registry;
select con_id,comp_id,comp_name,version,schema,status from pdb_registry
*
ERROR at line 1:
ORA-00942: table or view does not exist
Elapsed: 00:00:00.06
16:23:04 SQL> select con_id,comp_id,comp_name,version,schema,status from dba_registry;
select con_id,comp_id,comp_name,version,schema,status from dba_registry
*
ERROR at line 1:
ORA-00904: "CON_ID": invalid identifier
Elapsed: 00:00:00.04
16:23:14 SQL> alter session set container=PDB$SEED;
Session altered.
Elapsed: 00:00:00.46
16:23:35 SQL>
16:23:36 SQL> select comp_id,comp_name,version,schema,status from dba_registry;
COMP_ID COMP_NAME VERSION SCHEMA STATUS
---------- ---------------------------------------- ------------------------------ ---------- --------------------------------------------
CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
XML Oracle XDK 12.2.0.1.0 SYS VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 XDB VALID
OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
SDO Spatial 12.2.0.1.0 MDSYS VALID
XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
15 rows selected.
Elapsed: 00:00:00.44
16:23:47 SQL> col status for a10
16:23:55 SQL> l
1* select comp_id,comp_name,version,schema,status from dba_registry
16:23:57 SQL> /
COMP_ID COMP_NAME VERSION SCHEMA STATUS
---------- ---------------------------------------- ------------------------------ ---------- ----------
CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
XML Oracle XDK 12.2.0.1.0 SYS VALID
CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
XDB Oracle XML Database 12.2.0.1.0 XDB VALID
OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
SDO Spatial 12.2.0.1.0 MDSYS VALID
XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
15 rows selected.
Elapsed: 00:00:00.01
16:23:57 SQL> alter session set container=cdb$root;
Session altered.
Elapsed: 00:00:00.00
16:24:52 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ WRITE NO
3 ORCLPDBPLUG READ WRITE NO
16:24:55 SQL>
16:24:55 SQL> alter session set _exclude_seed_cdb_view=true;
alter session set _exclude_seed_cdb_view=true
*
ERROR at line 1:
ORA-00911: invalid character
Elapsed: 00:00:00.00
16:25:08 SQL>
16:25:09 SQL> alter system set "_exclude_seed_cdb_view"=false scope=both;
System altered.
Elapsed: 00:00:00.02
16:25:20 SQL>
16:25:22 SQL> select con_id,comp_id,comp_name,version,schema,status from cdb_registry;
CON_ID COMP_ID COMP_NAME VERSION SCHEMA STATUS
---------- ---------- ---------------------------------------- ------------------------------ ---------- ----------
1 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
1 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
1 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
1 XML Oracle XDK 12.2.0.1.0 SYS VALID
1 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
1 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
1 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
1 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
1 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
1 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
1 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
1 SDO Spatial 12.2.0.1.0 MDSYS VALID
1 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
1 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
1 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
3 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
3 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
3 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
3 XML Oracle XDK 12.2.0.1.0 SYS VALID
3 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
3 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
3 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
3 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
3 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
3 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
3 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
3 SDO Spatial 12.2.0.1.0 MDSYS VALID
3 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
3 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
3 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
2 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
2 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
2 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
2 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
2 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
2 XML Oracle XDK 12.2.0.1.0 SYS VALID
2 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
2 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
2 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
2 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
2 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
2 SDO Spatial 12.2.0.1.0 MDSYS VALID
2 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
2 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
2 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
45 rows selected.
Elapsed: 00:00:00.07
16:25:33 SQL> select con_id,comp_id,comp_name,version,schema,status from cdb_registry order by con_id;
CON_ID COMP_ID COMP_NAME VERSION SCHEMA STATUS
---------- ---------- ---------------------------------------- ------------------------------ ---------- ----------
1 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
1 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
1 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
1 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
1 XML Oracle XDK 12.2.0.1.0 SYS VALID
1 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
1 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
1 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
1 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
1 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
1 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
1 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
1 SDO Spatial 12.2.0.1.0 MDSYS VALID
1 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
1 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
2 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
2 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
2 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
2 SDO Spatial 12.2.0.1.0 MDSYS VALID
2 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
2 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
2 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
2 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
2 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
2 XML Oracle XDK 12.2.0.1.0 SYS VALID
2 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
2 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
2 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
2 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
2 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
3 CATALOG Oracle Database Catalog Views 12.2.0.1.0 SYS VALID
3 OLS Oracle Label Security 12.2.0.1.0 LBACSYS VALID
3 JAVAVM JServer JAVA Virtual Machine 12.2.0.1.0 SYS VALID
3 XML Oracle XDK 12.2.0.1.0 SYS VALID
3 CATJAVA Oracle Database Java Packages 12.2.0.1.0 SYS VALID
3 APS OLAP Analytic Workspace 12.2.0.1.0 SYS VALID
3 RAC Oracle Real Application Clusters 12.2.0.1.0 SYS OPTION OFF
3 XDB Oracle XML Database 12.2.0.1.0 XDB VALID
3 OWM Oracle Workspace Manager 12.2.0.1.0 WMSYS VALID
3 CONTEXT Oracle Text 12.2.0.1.0 CTXSYS VALID
3 ORDIM Oracle Multimedia 12.2.0.1.0 ORDSYS VALID
3 SDO Spatial 12.2.0.1.0 MDSYS VALID
3 XOQ Oracle OLAP API 12.2.0.1.0 OLAPSYS VALID
3 DV Oracle Database Vault 12.2.0.1.0 DVSYS VALID
3 CATPROC Oracle Database Packages and Types 12.2.0.1.0 SYS VALID
45 rows selected.
Elapsed: 00:00:00.08
16:25:50 SQL> set line 200
set pages 1000
col COMP_ID format a8
col COMP_NAME format a34
col SCHEMA format a12
col STATUS format a10
col VERSION format a12
col CON_ID format 99
select CON_ID, COMP_ID, comp_name, schema, status, version from CDB_REGISTRY order by 1,2;16:26:29 SQL> 16:26:29 SQL> 16:26:29 SQL> 16:26:29 SQL> 16:26:29 SQL> 16:26:29 SQL> 16:26:29 SQL> 16:26:29 SQL> 16:26:29 SQL>
CON_ID COMP_ID COMP_NAME SCHEMA STATUS VERSION
------ -------- ---------------------------------- ------------ ---------- ------------
1 APS OLAP Analytic Workspace SYS VALID 12.2.0.1.0
1 CATALOG Oracle Database Catalog Views SYS VALID 12.2.0.1.0
1 CATJAVA Oracle Database Java Packages SYS VALID 12.2.0.1.0
1 CATPROC Oracle Database Packages and Types SYS VALID 12.2.0.1.0
1 CONTEXT Oracle Text CTXSYS VALID 12.2.0.1.0
1 DV Oracle Database Vault DVSYS VALID 12.2.0.1.0
1 JAVAVM JServer JAVA Virtual Machine SYS VALID 12.2.0.1.0
1 OLS Oracle Label Security LBACSYS VALID 12.2.0.1.0
1 ORDIM Oracle Multimedia ORDSYS VALID 12.2.0.1.0
1 OWM Oracle Workspace Manager WMSYS VALID 12.2.0.1.0
1 RAC Oracle Real Application Clusters SYS OPTION OFF 12.2.0.1.0
1 SDO Spatial MDSYS VALID 12.2.0.1.0
1 XDB Oracle XML Database XDB VALID 12.2.0.1.0
1 XML Oracle XDK SYS VALID 12.2.0.1.0
1 XOQ Oracle OLAP API OLAPSYS VALID 12.2.0.1.0
2 APS OLAP Analytic Workspace SYS VALID 12.2.0.1.0
2 CATALOG Oracle Database Catalog Views SYS VALID 12.2.0.1.0
2 CATJAVA Oracle Database Java Packages SYS VALID 12.2.0.1.0
2 CATPROC Oracle Database Packages and Types SYS VALID 12.2.0.1.0
2 CONTEXT Oracle Text CTXSYS VALID 12.2.0.1.0
2 DV Oracle Database Vault DVSYS VALID 12.2.0.1.0
2 JAVAVM JServer JAVA Virtual Machine SYS VALID 12.2.0.1.0
2 OLS Oracle Label Security LBACSYS VALID 12.2.0.1.0
2 ORDIM Oracle Multimedia ORDSYS VALID 12.2.0.1.0
2 OWM Oracle Workspace Manager WMSYS VALID 12.2.0.1.0
2 RAC Oracle Real Application Clusters SYS OPTION OFF 12.2.0.1.0
2 SDO Spatial MDSYS VALID 12.2.0.1.0
2 XDB Oracle XML Database XDB VALID 12.2.0.1.0
2 XML Oracle XDK SYS VALID 12.2.0.1.0
2 XOQ Oracle OLAP API OLAPSYS VALID 12.2.0.1.0
3 APS OLAP Analytic Workspace SYS VALID 12.2.0.1.0
3 CATALOG Oracle Database Catalog Views SYS VALID 12.2.0.1.0
3 CATJAVA Oracle Database Java Packages SYS VALID 12.2.0.1.0
3 CATPROC Oracle Database Packages and Types SYS VALID 12.2.0.1.0
3 CONTEXT Oracle Text CTXSYS VALID 12.2.0.1.0
3 DV Oracle Database Vault DVSYS VALID 12.2.0.1.0
3 JAVAVM JServer JAVA Virtual Machine SYS VALID 12.2.0.1.0
3 OLS Oracle Label Security LBACSYS VALID 12.2.0.1.0
3 ORDIM Oracle Multimedia ORDSYS VALID 12.2.0.1.0
3 OWM Oracle Workspace Manager WMSYS VALID 12.2.0.1.0
3 RAC Oracle Real Application Clusters SYS OPTION OFF 12.2.0.1.0
3 SDO Spatial MDSYS VALID 12.2.0.1.0
3 XDB Oracle XML Database XDB VALID 12.2.0.1.0
3 XML Oracle XDK SYS VALID 12.2.0.1.0
3 XOQ Oracle OLAP API OLAPSYS VALID 12.2.0.1.0
45 rows selected.
Elapsed: 00:00:00.13
16:26:31 SQL> set line 200
set pages 1000
col owner format a12
col object_type format a12
col object_name format a30
col STATUS format a8
col CON_ID format 9
select con_id, owner, object_type, object_name, status from CDB_OBJECTS where status='INVALID' order by 1,2,3;16:26:49 SQL> 16:26:49 SQL> 16:26:49 SQL> 16:26:49 SQL> 16:26:49 SQL> 16:26:49 SQL> 16:26:49 SQL> 16:26:49 SQL>
no rows selected
Elapsed: 00:00:14.03
16:27:05 SQL>
16:27:06 SQL>
16:27:07 SQL>
16:27:07 SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
---------- ------------------------------ ---------- ----------
2 PDB$SEED READ WRITE NO
3 ORCLPDBPLUG READ WRITE NO
16:27:09 SQL>
16:27:09 SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlabgg3 db_2]$
[oracle@srlabgg3 db_2]$ cd $ORACLE_HOME/rdbms/admin
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b owm_clean_pdbs -d '''.''' owmuinst.plb
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/owm_clean_pdbs_catcon_24471.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/owm_clean_pdbs*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/owm_clean_pdbs_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b owm_clean_cdb -d '''.''' owmuinst.plb
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/owm_clean_cdb_catcon_26217.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/owm_clean_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/owm_clean_cdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ ls -lrt *catnools.sql*
ls: cannot access *catnools.sql*: No such file or directory
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ pwd
/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ cd ..
[oracle@srlabgg3 rdbms]$ cd ..
[oracle@srlabgg3 db_2]$ cd ..
[oracle@srlabgg3 12.2.0.1]$ cd ..
[oracle@srlabgg3 product]$ cd 12.1.0.2/db_3/rdbms/admin/
[oracle@srlabgg3 admin]$ ls -lrt *catnools.sql*
-rw-r--r--. 1 oracle oinstall 4836 Dec 11 2012 catnools.sql
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ cp catnools.sql /u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin
[oracle@srlabgg3 admin]$ cd /u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin
[oracle@srlabgg3 admin]$ pwd
/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin
[oracle@srlabgg3 admin]$ ls -lrt *catnools.sql*
-rw-r--r--. 1 oracle oinstall 4836 Apr 4 16:35 catnools.sql
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b catnools_pdbs -d '''.''' catnools.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnools_pdbs_catcon_30294.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnools_pdbs*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnools_pdbs_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b catnools_cdb -d '''.''' catnools.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnools_cdb_catcon_30929.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnools_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnools_cdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ vi clean_ols.sql
[oracle@srlabgg3 admin]$ ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b clean_ols -d '''.''' clean_ols.sql
-bash: ORACLE_HOME/perl/bin/perl: No such file or directory
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b clean_ols -d '''.''' clean_ols.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/clean_ols_catcon_899.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/clean_ols*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/clean_ols_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$ vi drop_MDSYS.sql
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ vi drop_MDSYS.sql
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ vi drop_others.sql
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -C 'CDB$ROOT' -e -b drop_MDSYS_pdbs -d '''.''' drop_MDSYS.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_pdbs_catcon_4069.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_pdbs*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_pdbs_*.lst] files for spool files, if any
pickNextProc: unexpected error in next_proc
catconExec: unexpected error in pickNextProc
catcon.pl: Unexpected error encountered in catconExec; exiting
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ ls -lrt dropsyn.sql
-rw-r--r--. 1 oracle oinstall 93417 Apr 4 16:50 dropsyn.sql
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -C 'CDB$ROOT' -e -b dropsyn_pdbs -d '''.''' dropsyn.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dropsyn_pdbs_catcon_7007.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dropsyn_pdbs*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dropsyn_pdbs_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'CDB$ROOT' -e -b drop_MDSYS_cdb -d '''.''' drop_MDSYS.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_cdb_catcon_11659.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_cdb_*.lst] files for spool files, if any
wait_for_completion: unexpected error in next_proc()
catconExec: unexpected error in wait_for_completions
catcon.pl: Unexpected error encountered in catconExec; exiting
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'CDB$ROOT' -e -b dropsyn_cdb -d '''.''' dropsyn.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dropsyn_cdb_catcon_13025.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dropsyn_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dropsyn_cdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -C 'CDB$ROOT' -e -b drop_others_pdbs -d '''.''' drop_others.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_pdbs_catcon_14528.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_pdbs*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_pdbs_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'CDB$ROOT' -e -b drop_others_cdb -d '''.''' drop_others.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_cdb_catcon_14630.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_cdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ vi drop_leftovers.sql
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b drop_leftovers -d '''.''' drop_leftovers.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_leftovers_catcon_15945.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_leftovers*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_leftovers_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'CDB$ROOT' -e -b drop_MDSYS_pdb -d '''.''' drop_MDSYS.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_pdb_catcon_18764.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_pdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_pdb_*.lst] files for spool files, if any
wait_for_completion: unexpected error in next_proc()
catconExec: unexpected error in wait_for_completions
catcon.pl: Unexpected error encountered in catconExec; exiting
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'CDB$ROOT' -e -b drop_others_pdb -d '''.''' drop_others.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_pdb_catcon_20501.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_pdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_pdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ ORCLPDBPLUG
bash: ORCLPDBPLUG: command not found...
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCLPDBPLUG' -e -b drop_MDSYS_pdb -d '''.''' drop_MDSYS.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_pdb_catcon_21892.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_pdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_MDSYS_pdb_*.lst] files for spool files, if any
wait_for_completion: unexpected error in next_proc()
catconExec: unexpected error in wait_for_completions
catcon.pl: Unexpected error encountered in catconExec; exiting
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -n 1 -c 'ORCLPDBPLUG' -e -b drop_others_pdb -d '''.''' drop_others.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_pdb_catcon_24764.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_pdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_others_pdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'ORCLPDBPLUG' -e -b drop_leftovers -d '''.''' drop_leftovers.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_leftovers_catcon_26192.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_leftovers*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/drop_leftovers_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b catnoctx_pdbs -d $ORACLE_HOME/ctx/admin catnoctx.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoctx_pdbs_catcon_26308.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoctx_pdbs*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoctx_pdbs_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ vi ctx_leftovers.sql
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b ctx_leftovers_pdbs -d '''.''' ctx_leftovers.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ctx_leftovers_pdbs_catcon_27764.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ctx_leftovers_pdbs*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ctx_leftovers_pdbs_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b catnoctx_cdb -d $ORACLE_HOME/ctx/admin catnoctx.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoctx_cdb_catcon_27962.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoctx_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoctx_cdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b ctx_leftovers_cdb -d '''.''' ctx_leftovers.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ctx_leftovers_cdb_catcon_29195.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ctx_leftovers_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ctx_leftovers_cdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$ vi ctx_rmsyn.sql
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b ctx_rmsys -d '''.''' ctx_rmsyn.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ctx_rmsys_catcon_29341.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ctx_rmsys*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ctx_rmsys_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b imremchk -d $ORACLE_HOME/ord/im/admin imremchk.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/imremchk_catcon_32231.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/imremchk*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/imremchk_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b imremdo_pdbs -d $ORACLE_HOME/ord/im/admin imremdo.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/imremdo_pdbs_catcon_32515.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/imremdo_pdbs*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/imremdo_pdbs_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_11717.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b imremdo_cdb -d $ORACLE_HOME/ord/im/admin imremdo.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/imremdo_cdb_catcon_13300.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/imremdo_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/imremdo_cdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_15319.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ vi dropim.sql
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b dropim -d '''.''' dropim.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dropim_catcon_16585.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dropim*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dropim_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$ chopt disable olap
Writing to /u03/app/oracle/product/12.2.0.1/db_2/install/disable_olap.log...
/usr/bin/make -f /u03/app/oracle/product/12.2.0.1/db_2/rdbms/lib/ins_rdbms.mk olap_off ORACLE_HOME=/u03/app/oracle/product/12.2.0.1/db_2
/usr/bin/make -f /u03/app/oracle/product/12.2.0.1/db_2/rdbms/lib/ins_rdbms.mk ioracle ORACLE_HOME=/u03/app/oracle/product/12.2.0.1/db_2
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'ORCLPDBPLUG' -e -b catnoaps_pdb2 -d $ORACLE_HOME/olap/admin/ catnoaps.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_pdb2_catcon_19448.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_pdb2*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_pdb2_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'ORCLPDBPLUG' -e -b catnoaps_pdb1 -d $ORACLE_HOME/olap/admin/ catnoaps.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_pdb1_catcon_19521.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_pdb1*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_pdb1_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'PDB$SEED' -e -b catnoaps_pdbseed -d $ORACLE_HOME/olap/admin/ catnoaps.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_pdbseed_catcon_19587.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_pdbseed*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_pdbseed_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_19715.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_*.lst] files for spool files, if any
curr_pdb_mode_info: data returned for PDB PDB$SEED contained an element (' || p.open_mode || ',' || nvl(p.restricted, 'NO') || ',' || i.instance_name from gv$pdbs p, gv$instance i where p.name='PDB$SEED' and p.inst_id = i.inst_id) with unexpected format
curr_pdb_mode_info: unexpected error in exec_DB_script
output produced in exec_DB_script [
SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 4 18:13:22 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> Connected to an idle instance.
' || p.open_mode || ',' || nvl(p.restricted, 'NO') || ',' || i.instance_name from gv$pdbs p, gv$instance i where p.name='PDB$SEED' and p.inst_id = i.inst_id *
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL> SQL>
SQL> Disconnected
] end of output produced in exec_DB_script
force_pdb_modes: unexpected error in curr_pdb_mode_info
catconExec: unexpected error in force_pdb_modes when trying to reopen PDB$SEED
catcon.pl: Unexpected error encountered in catconExec; exiting
exec_DB_script: /u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_19715_exec_DB_script.done did not need to be deleted before running a script
exec_DB_script: opened Reader and Writer
exec_DB_script: connected
exec_DB_script: executed set echo on
exec_DB_script: executed @@/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_kill_sess_19715_ALL.sql
exec_DB_script: sent
host sqlplus -v > /u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_19715_exec_DB_script.done to Writer
exec_DB_script: sent -exit- to Writer
exec_DB_script: closed Writer
exec_DB_script: marker was undefined; read and ignore output, if any
exec_DB_script: finished reading and ignoring output
exec_DB_script: waiting for child process to exit
exec_DB_script: child process exited
sureunlink: unlink(/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_19715_exec_DB_script.done) succeeded after 1 attempt(s)
sureunlink: verify that the file really no longer exists
sureunlink: confirmed that /u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_19715_exec_DB_script.done no longer exists after 1 attempts
exec_DB_script: deleted /u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_19715_exec_DB_script.done after running a script
exec_DB_script: closed Reader
exec_DB_script: waitpid returned
kill_sqlplus_sessions: output produced in exec_DB_script [
SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 4 18:13:24 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
SQL> Connected to an idle instance.
SQL> SQL> SQL>
SQL> ALTER SYSTEM KILL SESSION '33,25418' force timeout 0 -- process 19752
2 /
ALTER SYSTEM KILL SESSION '33,25418' force timeout 0 -- process 19752
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 0
Session ID: 0 Serial number: 0
SQL>
SQL> SQL>
SQL> Disconnected
] end of output produced in exec_DB_script
[oracle@srlabgg3 admin]$ ps -ef |grep pmon
oracle 11207 1 0 08:38 ? 00:00:04 ora_pmon_srlab
oracle 21141 16303 0 18:14 pts/1 00:00:00 grep --color=auto pmon
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ eccho $ORACLE_SID
[oracle@srlabgg3 admin]$ echo $ORACLE_SID
srcdb
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ sqlplus / as sysdba
SQL*Plus: Release 12.2.0.1.0 Production on Sun Apr 4 18:14:33 2021
Copyright (c) 1982, 2016, Oracle. All rights reserved.
Connected to an idle instance.
SQL> startup
ORACLE instance started.
Total System Global Area 1778384896 bytes
Fixed Size 8793784 bytes
Variable Size 536871240 bytes
Database Buffers 1224736768 bytes
Redo Buffers 7983104 bytes
Database mounted.
Database opened.
SQL> exit
Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b catnoaps_cdb -d $ORACLE_HOME/olap/admin/ catnoaps.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_cdb_catcon_25697.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/catnoaps_cdb_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ ls -lrt *dv*
-rw-r--r--. 1 oracle oinstall 2163 Aug 11 2008 dvu102.sql
-rw-r--r--. 1 oracle oinstall 4943 Aug 2 2010 spadvrpt.sql
-rw-r--r--. 1 oracle oinstall 34237 May 17 2012 dve111.sql
-rw-r--r--. 1 oracle oinstall 1083 Mar 23 2013 dve102.sql
-rw-r--r--. 1 oracle oinstall 9062 Oct 8 2013 dvpatch.sql
-rw-r--r--. 1 oracle oinstall 3030 Feb 21 2014 catxdbdv.sql
-rw-r--r--. 1 oracle oinstall 17087 Feb 21 2014 dbmsuadv.sql
-rw-r--r--. 1 oracle oinstall 2428 Apr 14 2014 dvregrant.sql
-rw-r--r--. 1 oracle oinstall 90635 Jul 3 2014 catsadv.sql
-rw-r--r--. 1 oracle oinstall 4819 Dec 15 2014 catcredv.sql
-rw-r--r--. 1 oracle oinstall 273331 May 25 2015 utlspadv.sql
-rw-r--r--. 1 oracle oinstall 5837 Jun 12 2015 dbfs_create_filesystem_advanced.sql
-rw-r--r--. 1 oracle oinstall 4554 Jul 6 2015 dvu111.sql
-rw-r--r--. 1 oracle oinstall 2544 Jul 6 2015 dvrelod.sql
-rw-r--r--. 1 oracle oinstall 70801 Aug 20 2015 catadvtb.sql
-rw-r--r--. 1 oracle oinstall 37669 Aug 21 2015 dvu112.sql
-rw-r--r--. 1 oracle oinstall 53538 Aug 21 2015 dve112.sql
-rw-r--r--. 1 oracle oinstall 114026 Nov 6 2015 dvremov.sql
-rw-r--r--. 1 oracle oinstall 5095 Feb 23 2016 owmcmdv.plb
-rw-r--r--. 1 oracle oinstall 4947 Mar 8 2016 mgdview.sql
-rw-r--r--. 1 oracle oinstall 6769 Apr 17 2016 dvdbmig.sql
-rw-r--r--. 1 oracle oinstall 75021 Aug 3 2016 catadv.sql
-rw-r--r--. 1 oracle oinstall 54789 Aug 11 2016 dbmsadv.sql
-rw-r--r--. 1 oracle oinstall 48433 Nov 27 2016 dvu121.sql
-rw-r--r--. 1 oracle oinstall 106664 Dec 19 2016 dve121.sql
-rw-r--r--. 1 oracle oinstall 7504 Jan 26 2017 prvtuadv.plb
-rw-r--r--. 1 oracle oinstall 2100 Jan 26 2017 dvmacfnc.plb
-rw-r--r--. 1 oracle oinstall 13648 Jan 26 2017 prvtdadv.plb
-rw-r--r--. 1 oracle oinstall 38982 Jan 26 2017 prvtadv.plb
-rw-r--r--. 1 oracle oinstall 6069 Jan 26 2017 prvsadv.plb
-rw-r--r--. 1 oracle oinstall 34534 Jan 26 2017 catolsddv.sql
-rw-r--r--. 1 oracle oinstall 3599 Jan 26 2017 prvtstatadv.plb
-rw-r--r--. 1 oracle oinstall 32467 Jan 26 2017 prvtstatadvi.plb
[oracle@srlabgg3 admin]$ dvremov.sql
bash: dvremov.sql: command not found...
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b dv_cdb -d dvremov.sql
At least one file name must be supplied at catcon.pl line 396.
[oracle@srlabgg3 admin]$ pwd
/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b dv_cdb -d /u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dvremov.sql
At least one file name must be supplied at catcon.pl line 396.
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b dv_cdb -d /u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/ dvremov.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dv_cdb_catcon_28528.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dv_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dv_cdb_*.lst] files for spool files, if any
wait_for_completion: unexpected error in next_proc()
catconExec: unexpected error in wait_for_completions
catcon.pl: Unexpected error encountered in catconExec; exiting
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -c 'CDB$ROOT' -e -b dvremove_cdb -d '''.''' dvremov.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dvremove_cdb_catcon_31405.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dvremove_cdb*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dvremove_cdb_*.lst] files for spool files, if any
wait_for_completion: unexpected error in next_proc()
catconExec: unexpected error in wait_for_completions
catcon.pl: Unexpected error encountered in catconExec; exiting
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -C 'CDB$ROOT' -e -b dvremove_pdbs -d '''.''' dvremov.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dvremove_pdbs_catcon_31577.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dvremove_pdbs*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/dvremove_pdbs_*.lst] files for spool files, if any
pickNextProc: unexpected error in next_proc
catconExec: unexpected error in pickNextProc
catcon.pl: Unexpected error encountered in catconExec; exiting
[oracle@srlabgg3 admin]$ $ORACLE_HOME/perl/bin/perl catcon.pl -n 1 -e -b utlrp -d '''.''' utlrp.sql
catcon: ALL catcon-related output will be written to [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_catcon_1989.lst]
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp*.log] files for output generated by scripts
catcon: See [/u03/app/oracle/product/12.2.0.1/db_2/rdbms/admin/utlrp_*.lst] files for spool files, if any
catcon.pl: completed successfully
[oracle@srlabgg3 admin]$
Ramesh.
Post a Comment: