Oracle 12.2 catcon.pl

catcon.pl脚本在12.1中就已经有了，不知道为什么在12.2里面还算新特性，对比了下12.1和12.2官方文档关于这部分完全一模一样。
网上能查到的文档也是照抄翻译官方文档。
使用后总结如下：
1、对DBA来说，权限变更、打补丁后运行脚本、升级后运行脚本、编译失效对象、跑脚本等等维护性的工作比较实用，如果是统计查询类就不要使用这个了，输出非常乱；
2、如果不使用-u参数默认就以'/ as sysdba'登陆，所有很纳闷为什么网上全是跟着官方使用-u SYS；
3、必须指定-b参数，也就是输出日志名称；
4、-l参数指定日志位置；
5、-c只在哪些PDB中运行，-C不在这些PDB中运行；
6、-- --x"select name from v$datafile"，直接执行SQL，注意先是两个短横线，空格，两个短横线接着双引号里面包含要执行的SQL，另外特殊字符需要转义；
7、-d指定要执行脚本的目录，默认是当前目录；
8、-p指定并行度，默认并行度为1，也就是串行一个个执行。
命令参考：
$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl
[-u username[/password]] [-U username[/password]] [-d directory]
[-l directory] [{-c|-C} container] [-p parallelism] [-e] [-s]
[-E { ON | errorlogging-table-other-than-SPERRORLOG } ] [-I] [-g] [-f]
-b log_file_name_base -- { SQL_script [arguments] | --x'SQL_statement' }
下面是查询数据文件的语句，两种方式结果一样：
[code]$ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -p 4 -b dbfile -- --x"select name from v\\$datafile"
[oracle@orasql2 ~]$ cat dbfile.sql
select name from v$datafile;
[oracle@orasql2 ~]$ $ORACLE_HOME/perl/bin/perl $ORACLE_HOME/rdbms/admin/catcon.pl -p 4 -b dbfile dbfile.sql
catcon: ALL catcon-related output will be written to [/home/oracle/dbfile_catcon_2181.lst]
catcon: See [/home/oracle/dbfile*.log] files for output generated by scripts
catcon: See [/home/oracle/dbfile_*.lst] files for spool files, if any
reset_seed_pdb_mode: output produced in exec_DB_script [

SQL*Plus: Release 12.2.0.1.0 Production on Thu Nov 24 17:04:02 2016

Copyright (c) 1982, 2016, Oracle. All rights reserved.

SQL> Connected.
SQL> 2
Session altered.

SQL> 2
Pluggable database altered.

SQL> 2
Warning: PDB altered with errors.

SQL> SQL>
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
] end of output produced in exec_DB_script
reset_seed_pdb_mode: output produced in exec_DB_script [

SQL*Plus: Release 12.2.0.1.0 Production on Thu Nov 24 17:04:03 2016

Copyright (c) 1982, 2016, Oracle. All rights reserved.

SQL> Connected.
SQL> 2
Session altered.

SQL> 2
Pluggable database altered.

SQL> 2
Warning: PDB altered with errors.

SQL> SQL>
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
] end of output produced in exec_DB_script
catcon.pl: completed successfully
[oracle@orasql2 ~]$ ls -lrt
total 156
....
-rw-r--r-- 1 oracle oinstall 29 Nov 24 17:03 dbfile.sql
-rw-r--r-- 1 oracle oinstall 7905 Nov 24 17:04 dbfile0.log
-rw-r--r-- 1 oracle oinstall 1457 Nov 24 17:04 dbfile_catcon_2181.lst
[oracle@orasql2 ~]$ cat dbfile0.log

SQL*Plus: Release 12.2.0.1.0 Production on Thu Nov 24 17:04:01 2016

Copyright (c) 1982, 2016, Oracle. All rights reserved.

SQL> Connected.
SQL> 2
Session altered.

SQL> 2
Session altered.

SQL>
ALTER SYSTEM KILL SESSION '250,41549' force timeout 0 -- process 2241
/

SQL> SQL> 2
Session altered.

SQL> 2
Session altered.

SQL> SQL>
SQL> 2
Session altered.

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = CDB$ROOT Id = 1 ====

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = CDB$ROOT Id = 1 ====

SQL> 2
Session altered.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2
CATCONSECTION
--------------------------
==== CATCON EXEC ROOT ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:CDB$ROOT Id:1 16-11-24 05:04:01 Proc:0 ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:CDB$ROOT Id:1 16-11-24 05:04:01 Proc:0 ====

SQL> 2
Session altered.

SQL> 2
Session altered.

SQL> SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/orasql2/system01.dbf
/u02/app/oracle/oradata/orasql2/sysaux01.dbf
/u02/app/oracle/oradata/orasql2/undotbs01.dbf
/u02/app/oracle/oradata/orasql2/pdbseed/system01.dbf
/u02/app/oracle/oradata/orasql2/pdbseed/sysaux01.dbf
/u02/app/oracle/oradata/orasql2/users01.dbf
/u02/app/oracle/oradata/orasql2/pdbseed/undotbs01.dbf
/u02/app/oracle/oradata/orasql2/PDB1/system01.dbf
/u02/app/oracle/oradata/orasql2/PDB1/sysaux01.dbf
/u02/app/oracle/oradata/orasql2/PDB1/undotbs01.dbf
/u02/app/oracle/oradata/orasql2/PDB1/users01.dbf

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/ORASQL2/41F31523ADEA74B4E053AEAE100A326A/datafile/o1_mf_
system_d3bg3z8f_.dbf

/u02/app/oracle/oradata/ORASQL2/41F31523ADEA74B4E053AEAE100A326A/datafile/o1_mf_
sysaux_d3bg3zf1_.dbf

/u02/app/oracle/oradata/ORASQL2/41F31523ADEA74B4E053AEAE100A326A/datafile/o1_mf_
undotbs1_d3bg3zf4_.dbf

14 rows selected.

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:CDB$ROOT Id:1 16-11-24 05:04:01 Proc:0 ====

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:CDB$ROOT Id:1 16-11-24 05:04:01 Proc:0 ====

SQL> SQL>
SQL> 2
Session altered.

SQL> SQL>
SQL> 2
Session altered.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2
Session altered.

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = PDB$SEED Id = 2 ====

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = PDB$SEED Id = 2 ====

SQL> SQL> 2
CATCONSECTION
-----------------------------------
==== CATCON EXEC IN CONTAINERS ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB$SEED Id:2 16-11-24 05:04:03 Proc:0 ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB$SEED Id:2 16-11-24 05:04:03 Proc:0 ====

SQL> 2
Session altered.

SQL> 2
Session altered.

SQL> SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/orasql2/pdbseed/system01.dbf
/u02/app/oracle/oradata/orasql2/pdbseed/sysaux01.dbf
/u02/app/oracle/oradata/orasql2/pdbseed/undotbs01.dbf

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB$SEED Id:2 16-11-24 05:04:03 Proc:0 ====

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB$SEED Id:2 16-11-24 05:04:03 Proc:0 ====

SQL> SQL>
SQL> 2
Session altered.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2
Session altered.

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = PDB1 Id = 3 ====

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = PDB1 Id = 3 ====

SQL> SQL> 2
CATCONSECTION
-----------------------------------
==== CATCON EXEC IN CONTAINERS ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB1 Id:3 16-11-24 05:04:03 Proc:0 ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB1 Id:3 16-11-24 05:04:03 Proc:0 ====

SQL> 2
Session altered.

SQL> 2
Session altered.

SQL> SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/orasql2/PDB1/system01.dbf
/u02/app/oracle/oradata/orasql2/PDB1/sysaux01.dbf
/u02/app/oracle/oradata/orasql2/PDB1/undotbs01.dbf
/u02/app/oracle/oradata/orasql2/PDB1/users01.dbf

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB1 Id:3 16-11-24 05:04:03 Proc:0 ====

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB1 Id:3 16-11-24 05:04:03 Proc:0 ====

SQL> SQL>
SQL> 2
Session altered.

SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> SQL> 2
Session altered.

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = PDB2 Id = 4 ====

SQL>
NOW_CONNECTED_TO
--------------------------------------------------------------------------------
==== Current Container = PDB2 Id = 4 ====

SQL> SQL> 2
CATCONSECTION
-----------------------------------
==== CATCON EXEC IN CONTAINERS ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB2 Id:4 16-11-24 05:04:03 Proc:0 ====

SQL>
BEGIN_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB2 Id:4 16-11-24 05:04:03 Proc:0 ====

SQL> 2
Session altered.

SQL> 2
Session altered.

SQL> SQL> select name from v$datafile;

NAME
--------------------------------------------------------------------------------
/u02/app/oracle/oradata/ORASQL2/41F31523ADEA74B4E053AEAE100A326A/datafile/o1_mf_
system_d3bg3z8f_.dbf

/u02/app/oracle/oradata/ORASQL2/41F31523ADEA74B4E053AEAE100A326A/datafile/o1_mf_
sysaux_d3bg3zf1_.dbf

/u02/app/oracle/oradata/ORASQL2/41F31523ADEA74B4E053AEAE100A326A/datafile/o1_mf_
undotbs1_d3bg3zf4_.dbf

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB2 Id:4 16-11-24 05:04:03 Proc:0 ====

SQL>
END_RUNNING
--------------------------------------------------------------------------------
==== @dbfile.sql Container:PDB2 Id:4 16-11-24 05:04:03 Proc:0 ====

SQL> SQL>
SQL> 2
Session altered.

SQL> SQL>
SQL> ========== PROCESS ENDED ==========
SQL> Disconnected from Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
[oracle@orasql2 ~]$[/code]
详细参考官方文档：
http://docs.oracle.com/database/122/ADMIN/administering-a-cdb-with-sql-plus.htm#ADMIN14072