12c：ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN]
今天，在启动我自己的实验环境的时候，遇到了如题所示的异常。
关于该异常的具体呈现如下所示：
启动数据库，并尝试操作：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 |
[oracle@rhel7 ~]$ export ORACLE_SID=callah [oracle@rhel7 ~]$ env | grep SID ORACLE_SID=callah [oracle@rhel7 ~]$ [oracle@rhel7 ~]$ ps -ef | grep --color pmon oracle 5670 1 0 20:59 ? 00:00:00 ora_pmon_conme oracle 9082 5525 0 22:34 pts/1 00:00:00 grep --color=auto --color pmon [oracle@rhel7 ~]$ [oracle@rhel7 ~]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Fri Apr 22 22:34:36 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to an idle instance. SQL> startup ORACLE instance started. Total System Global Area 251658240 bytes Fixed Size 2923096 bytes Variable Size 192939432 bytes Database Buffers 50331648 bytes Redo Buffers 5464064 bytes Database mounted. Database opened. SQL> SQL> select con_id,name,open_mode from v$pdbs; select con_id,name,open_mode from v$pdbs * ERROR at line 1: ORA-03135: connection lost contact Process ID: 9139 Session ID: 1 Serial number: 38484 SQL> SQL> exit Disconnected from Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options [oracle@rhel7 ~]$ [oracle@rhel7 ~]$ ps -ef | grep --color pmon oracle 5670 1 0 20:59 ? 00:00:00 ora_pmon_conme oracle 9341 5525 0 22:35 pts/1 00:00:00 grep --color=auto --color pmon [oracle@rhel7 ~]$ |
而这个过程中的后台日志（alert）的异常部分如下：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 |
alter database open Sat Apr 23 09:01:58 2016 Ping without log force is disabled . Sat Apr 23 09:01:58 2016 Beginning crash recovery of 1 threads Sat Apr 23 09:01:58 2016 Started redo scan Sat Apr 23 09:01:58 2016 Completed redo scan read 707 KB redo, 114 data blocks need recovery Sat Apr 23 09:01:58 2016 Started redo application at Thread 1: logseq 18, block 3 Sat Apr 23 09:01:58 2016 Recovery of Online Redo Log: Thread 1 Group 3 Seq 18 Reading mem 0 Mem# 0: /u01/app/oracle/oradata/callah/redo03a.log Mem# 1: /u01/app/oracle/oradata/callah/redo03b.log Sat Apr 23 09:01:58 2016 Completed redo application of 0.48MB Sat Apr 23 09:01:58 2016 Completed crash recovery at Thread 1: logseq 18, block 1417, scn 910411 114 data blocks read, 78 data blocks written, 707 redo k-bytes read Sat Apr 23 09:01:58 2016 Starting background process TMON Sat Apr 23 09:01:58 2016 TMON started with pid=21, OS id=11917 Sat Apr 23 09:01:58 2016 LGWR: STARTING ARCH PROCESSES Starting background process ARC0 Sat Apr 23 09:01:58 2016 ARC0 started with pid=22, OS id=11919 ARC0: Archival started LGWR: STARTING ARCH PROCESSES COMPLETE Sat Apr 23 09:01:58 2016 ARC0: STARTING ARCH PROCESSES Starting background process ARC1 Sat Apr 23 09:01:58 2016 ARC1 started with pid=23, OS id=11921 Starting background process ARC2 Sat Apr 23 09:01:59 2016 Thread 1 advanced to log sequence 19 (thread open) Sat Apr 23 09:01:59 2016 ARC2 started with pid=24, OS id=11923 Starting background process ARC3 Sat Apr 23 09:01:59 2016 ARC3 started with pid=25, OS id=11925 Sat Apr 23 09:01:59 2016 ARC1: Archival started ARC2: Archival started ARC3: Archival started ARC0: STARTING ARCH PROCESSES COMPLETE ARC0: Becoming the 'no FAL' ARCH ARC0: Becoming the 'no SRL' ARCH Sat Apr 23 09:01:59 2016 ARC1: Becoming the heartbeat ARCH Sat Apr 23 09:01:59 2016 Thread 1 opened at log sequence 19 Current log# 1 seq# 19 mem# 0: /u01/app/oracle/oradata/callah/redo01a.log Current log# 1 seq# 19 mem# 1: /u01/app/oracle/oradata/callah/redo01b.log Successful open of redo thread 1 Sat Apr 23 09:01:59 2016 MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set Sat Apr 23 09:01:59 2016 SMON: enabling cache recovery Sat Apr 23 09:01:59 2016 Archived Log entry 9 added for thread 1 sequence 18 ID 0x26ebd7b7 dest 1: Sat Apr 23 09:01:59 2016 [11656] Successfully onlined Undo Tablespace 2. Undo initialization finished serial:0 start:15109154 end:15109194 diff:40 ms (0.0 seconds) Verifying minimum file header compatibility (11g) for tablespace encryption.. Verifying 11g file header compatibility for tablespace encryption completed Sat Apr 23 09:01:59 2016 SMON: enabling tx recovery Sat Apr 23 09:01:59 2016 ********************************************************************* WARNING: The following temporary tablespaces in container(CDB$ROOT) contain no files. This condition can occur when a backup controlfile has been restored. It may be necessary to add files to these tablespaces. That can be done using the SQL statement: ALTER TABLESPACE <tablespace_name> ADD TEMPFILE Alternatively, if these temporary tablespaces are no longer needed, then they can be dropped. Empty temporary tablespace: TEMPTBS01 ********************************************************************* Starting background process SMCO Database Characterset is AL32UTF8 Sat Apr 23 09:01:59 2016 SMCO started with pid=27, OS id=11929 No Resource Manager plan active replication_dependency_tracking turned off (no async multimaster replication found) Starting background process AQPC Sat Apr 23 09:01:59 2016 AQPC started with pid=30, OS id=11935 Database Characterset for PDB$SEED is AL32UTF8 ********************************************************************* WARNING: The following temporary tablespaces in container(PDB$SEED) contain no files. This condition can occur when a backup controlfile has been restored. It may be necessary to add files to these tablespaces. That can be done using the SQL statement: ALTER TABLESPACE <tablespace_name> ADD TEMPFILE Alternatively, if these temporary tablespaces are no longer needed, then they can be dropped. Empty temporary tablespace: TEMPTBS01 ********************************************************************* Due to limited space in shared pool (need 6094848 bytes, have 3981120 bytes), limiting Resource Manager entities from 2048 to 32 Opening pdb PDB$SEED (2) with no Resource Manager plan active Sat Apr 23 09:01:59 2016 ORA-7452: resource manager plan 'INTERNAL_PLAN' does not exist Sat Apr 23 09:01:59 2016 Resource Manager failed to initialize on pdb 2 Starting background process CJQ0 Sat Apr 23 09:01:59 2016 CJQ0 started with pid=34, OS id=11943 Completed: alter database open Sat Apr 23 09:02:03 2016 Shared IO Pool defaulting to 4MB. Trying to get it from Buffer Cache for process 10055. =========================================================== Dumping current patch information =========================================================== No patches have been applied =========================================================== Fri Apr 22 22:17:46 2016 Setting Resource Manager plan SCHEDULER[0x4447]:DEFAULT_MAINTENANCE_PLAN via scheduler window Setting Resource Manager CDB plan DEFAULT_MAINTENANCE_PLAN via parameter Errors in file /u01/app/oracle/diag/rdbms/callah/callah/trace/callah_dbrm_8465.trc (incident=26495) (PDBNAME=PDB$SEED): ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], [] Incident details in: /u01/app/oracle/diag/rdbms/callah/callah/incident/incdir_26495/callah_dbrm_8465_i26495.trc Use ADRCI or Support Workbench to package the incident. See Note 411.1 at My Oracle Support for error and packaging details. Fri Apr 22 22:17:46 2016 Errors in file /u01/app/oracle/diag/rdbms/callah/callah/trace/callah_dbrm_8465.trc: ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], [] Fri Apr 22 22:17:46 2016 Errors in file /u01/app/oracle/diag/rdbms/callah/callah/trace/callah_dbrm_8465.trc: ORA-00600: internal error code, arguments: [kgskigetelt_subplan], [INTERNAL_PLAN], [], [], [], [], [], [], [], [], [], [] Fri Apr 22 22:17:46 2016 USER (ospid: 8465): terminating the instance due to error 56710 Fri Apr 22 22:17:46 2016 System state dump requested by (instance=1, osid=8465 (DBRM)), summary=[abnormal instance termination]. System State dumped to trace file /u01/app/oracle/diag/rdbms/callah/callah/trace/callah_diag_8463_20160422221746.trc Fri Apr 22 22:17:46 2016 Dumping diagnostic data in directory=[cdmp_20160422221746], requested by (instance=1, osid=8465 (DBRM)), summary=[abnormal instance termination]. Fri Apr 22 22:17:47 2016 Instance terminated by USER, pid = 8465 |
由上面的过程与日志，你可以看到，虽然数据库的启动成功了，… 但是数据库启动后，便立即CRASH了。
而这，是有问题的。
MOS官方对于该异常有文档做出说明：
12c Instance Crashes after Errors ORA-600 [kgskigetelt_subplan] (文档 ID 2120842.1)
官方文档对于该问题的说明如下：
官方认为，产生这个问题的原因，是因为，在数据库OPEN之前，CDB的数据字典，并没有被完整的安装或配置。
在我的环境中，（也是官方的文档说明的，通常环境）造成该问题的环境是：CDB的数据库实例，是我手动创建的。并且，在执行完catproc.sql脚本后，数据库实例就被关闭了，因此导致了数据字典的不完整。
接下来，打开数据库的时候，内部的资源管理计划“INTERNAL_PLAN”事实上是不存在的，因此，ORA-600，被触发了。
可以对比一下两个不同的方法创建的CDB，这个差别就很显而易见了：
DBCA创建的：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 |
SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ conme OPEN SQL> select id,name from v$rsrc_plan; ID NAME ---------- -------------------------------- 17341 DEFAULT_MAINTENANCE_PLAN 17313 INTERNAL_PLAN SQL> SQL> show parameter resource NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ resource_limit boolean TRUE resource_manager_cpu_allocation integer 1 resource_manager_plan string SCHEDULER[0x4448]:DEFAULT_MAIN TENANCE_PLAN SQL> |
手工创建的：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 |
SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ callah OPEN SQL> select id,name from v$rsrc_plan; ID NAME ---------- -------------------------------- 17342 ORA$INTERNAL_CDB_PLAN SQL> SQL> show parameter resource NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ resource_limit boolean TRUE resource_manager_cpu_allocation integer 1 resource_manager_plan string SQL> |
解决方法：
1. 如果，你是使用“create database”，手动建库。那么你在建库完成后，需要执行“catcdb.sql”脚本。
2. 不过，Oracle强烈建议你不要手动建库，而是使用DBCA工具创建你的CDB。
————————
关于手动建库后，需要执行哪些脚本，Oracle官方也给出了文档说明这件事情：
“ORA-01917: User Or Role ‘PDB_DBA’ Does Not Exist” while creating container enabled (cdb) database manually (文档 ID 1967358.1)
官方文档内容如下：
手动建库。
对于非CDB的数据库来说，可以执行这些脚本：
@$ORACLE_HOME/rdbms/admin/catalog.sql;
@$ORACLE_HOME/rdbms/admin/catblock.sql;
@$ORACLE_HOME/rdbms/admin/catproc.sql;
@$ORACLE_HOME/rdbms/admin/catoctk.sql;
@$ORACLE_HOME/rdbms/admin/owminst.plb;
@$ORACLE_HOME/sqlplus/admin/pupbld.sql;
对于CDB的数据库来说，你需要执行以下脚本就足够了：
@?/rdbms/admin/catcdb.sql
完整的官方的手动建库的参考文档：
http://docs.oracle.com/database/121/ADMIN/cdb_create.htm#ADMIN13547
关于该问题的其他的相关文档：
Bug 20479923 : ORA-00600:[KGSKIGETELT_SUBPLAN] FOLLOWED BY INSTANCE CRASH
没有对应的补丁程序：
——————————————————
下面，来解决上面的问题：
安装需要的YUM包：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 |
[root@rhel7 ~]# yum list | grep --color perl-Term perl-Term-UI.noarch 0.36-2.el7 ISO perl-TermReadKey.x86_64 2.30-20.el7 ISO [root@rhel7 ~]# [root@rhel7 ~]# yum install -y perl-TermReadKey Loaded plugins: langpacks, product-id, search-disabled-repos, subscription-manager This system is not registered to Red Hat Subscription Management. You can use subscription-manager to register. HighAvailability | 4.1 kB 00:00:00 ISO | 4.1 kB 00:00:00 ResilientStorage | 4.1 kB 00:00:00 Resolving Dependencies --> Running transaction check ---> Package perl-TermReadKey.x86_64 0:2.30-20.el7 will be installed --> Finished Dependency Resolution Dependencies Resolved ===================================================================================================================================================================================================== Package Arch Version Repository Size ===================================================================================================================================================================================================== Installing: perl-TermReadKey x86_64 2.30-20.el7 ISO 31 k Transaction Summary ===================================================================================================================================================================================================== Install 1 Package Total download size: 31 k Installed size: 59 k Downloading packages: perl-TermReadKey-2.30-20.el7.x86_64.rpm | 31 kB 00:00:00 Running transaction check Running transaction test Transaction test succeeded Running transaction Installing : perl-TermReadKey-2.30-20.el7.x86_64 1/1 Verifying : perl-TermReadKey-2.30-20.el7.x86_64 1/1 Installed: perl-TermReadKey.x86_64 0:2.30-20.el7 Complete! [root@rhel7 ~]# |
编辑环境变量PATH，添加：$ORACLE_HOME/perl/bin。
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 |
[root@rhel7 ~]# cat /home/oracle/.bash_profile # .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH export TMP=/tmp export TMPDIR=$TMP export ORACLE_HOSTNAME=`hostname` export ORACLE_UNQNAME=callah export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12/db_1 export ORACLE_SID=callah export PATH=/usr/sbin:$PATH export PATH=$ORACLE_HOME/bin:$ORACLE_HOME/perl/bin:$PATH export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib [root@rhel7 ~]# |
确保CDB打开为OPEN，并且旗下没有除SEED以外的PDB：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 |
SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ callah OPEN SQL> SQL> select pdb_name,status from cdb_pdbs; PDB_NAME STATUS ------------ --------- PDB$SEED NORMAL SQL> |
执行脚本：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 195 196 197 198 199 200 201 202 203 204 205 206 207 208 209 210 211 212 213 214 215 216 217 218 219 220 221 222 223 224 225 226 227 228 229 230 231 232 233 234 235 236 237 238 239 240 241 242 243 244 245 246 247 248 249 250 251 252 253 254 255 256 257 258 259 260 261 262 263 264 265 266 267 268 269 270 271 272 273 274 275 276 277 278 279 280 281 282 283 284 |
[oracle@rhel7 db_1]$ env | grep --color perl PATH=/u01/app/oracle/product/12/db_1/bin:/u01/app/oracle/product/12/db_1/perl/bin:/usr/sbin:/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/oracle/.local/bin:/home/oracle/bin [oracle@rhel7 db_1]$ [oracle@rhel7 db_1]$ env | grep SID ORACLE_SID=callah [oracle@rhel7 db_1]$ [oracle@rhel7 db_1]$ sqlplus / as sysdba SQL*Plus: Release 12.1.0.2.0 Production on Sat Apr 23 15:48:40 2016 Copyright (c) 1982, 2014, Oracle. All rights reserved. Connected to: Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production With the Partitioning, OLAP, Advanced Analytics and Real Application Testing options SQL> select instance_name,status from v$instance; INSTANCE_NAME STATUS ---------------- ------------ callah OPEN SQL> SQL> select name,cdb from v$database; NAME CDB --------- --- CALLAH YES SQL> SQL> @?/rdbms/admin/catcdb.sql Session altered. Enter new password for SYS: Enter new password for SYSTEM: Enter temporary tablespace name: temptbs01 Session altered. Connected. old 1: select '&&oracle_home'||'&&slash'||'rdbms'||'&&slash'||'admin'||'&&slash'||'catcon.pl' as rdbms_admin_catcon from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'rdbms'||'/'||'admin'||'/'||'catcon.pl' as rdbms_admin_catcon from dual old 1: select '&&oracle_home'||'&&slash'||'rdbms'||'&&slash'||'admin' as rdbms_admin from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'rdbms'||'/'||'admin' as rdbms_admin from dual old 1: select '&&oracle_home'||'&&slash'||'sqlplus'||'&&slash'||'admin'||'&&slash'||'help' as sqlplus_admin_help from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'sqlplus'||'/'||'admin'||'/'||'help' as sqlplus_admin_help from dual old 1: select '&&oracle_home'||'&&slash'||'sqlplus'||'&&slash'||'admin' as sqlplus_admin from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'sqlplus'||'/'||'admin' as sqlplus_admin from dual old 1: select '&&oracle_home'||'&&slash'||'javavm'||'&&slash'||'install' as jvm_install from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'javavm'||'/'||'install' as jvm_install from dual old 1: select '&&oracle_home'||'&&slash'||'xdk'||'&&slash'||'admin' as xdk_admin from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'xdk'||'/'||'admin' as xdk_admin from dual old 1: select '&&oracle_home'||'&&slash'||'ctx'||'&&slash'||'admin' as ctx_admin from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'ctx'||'/'||'admin' as ctx_admin from dual old 1: select '&&oracle_home'||'&&slash'||'ctx'||'&&slash'||'admin'||'&&slash'||'defaults' as ctx_admin_defaults from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'ctx'||'/'||'admin'||'/'||'defaults' as ctx_admin_defaults from dual old 1: select '&&oracle_home'||'&&slash'||'ord'||'&&slash'||'admin' as ord_admin from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'ord'||'/'||'admin' as ord_admin from dual old 1: select '&&oracle_home'||'&&slash'||'ord'||'&&slash'||'im'||'&&slash'||'admin' as im_admin from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'ord'||'/'||'im'||'/'||'admin' as im_admin from dual old 1: select '&&oracle_home'||'&&slash'||'olap'||'&&slash'||'admin' as olap_admin from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'olap'||'/'||'admin' as olap_admin from dual old 1: select '&&oracle_home'||'&&slash'||'md'||'&&slash'||'admin' as md_admin from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'md'||'/'||'admin' as md_admin from dual old 1: select '&&oracle_home'||'&&slash'||'apex' as apex_home from dual new 1: select '/u01/app/oracle/product/12/db_1'||'/'||'apex' as apex_home from dual catcon: ALL catcon-related output will be written to catalog_catcon_29163.lst catcon: See catalog*.log files for output generated by scripts catcon: See catalog_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catproc_catcon_29269.lst catcon: See catproc*.log files for output generated by scripts catcon: See catproc_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catoctk_catcon_30082.lst catcon: See catoctk*.log files for output generated by scripts catcon: See catoctk_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to owminst_catcon_30139.lst catcon: See owminst*.log files for output generated by scripts catcon: See owminst_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to pupbld_catcon_30202.lst catcon: See pupbld*.log files for output generated by scripts catcon: See pupbld_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to hlpbld_catcon_30255.lst catcon: See hlpbld*.log files for output generated by scripts catcon: See hlpbld_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to initjvm_catcon_30308.lst catcon: See initjvm*.log files for output generated by scripts catcon: See initjvm_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to initxml_catcon_30422.lst catcon: See initxml*.log files for output generated by scripts catcon: See initxml_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to xmlja_catcon_30512.lst catcon: See xmlja*.log files for output generated by scripts catcon: See xmlja_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catjava_catcon_30565.lst catcon: See catjava*.log files for output generated by scripts catcon: See catjava_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catxdbj_catcon_30634.lst catcon: See catxdbj*.log files for output generated by scripts catcon: See catxdbj_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catctx_catcon_30687.lst catcon: See catctx*.log files for output generated by scripts catcon: See catctx_*.lst files for spool files, if any catcon.pl: completed successfully User altered. catcon: ALL catcon-related output will be written to dr0defin_catcon_30752.lst catcon: See dr0defin*.log files for output generated by scripts catcon: See dr0defin_*.lst files for spool files, if any catcon.pl: completed successfully User altered. catcon: ALL catcon-related output will be written to dbmsxdbt_catcon_30805.lst catcon: See dbmsxdbt*.log files for output generated by scripts catcon: See dbmsxdbt_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to ordinst_catcon_30858.lst catcon: See ordinst*.log files for output generated by scripts catcon: See ordinst_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catim_catcon_30911.lst catcon: See catim*.log files for output generated by scripts catcon: See catim_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to olap.sql_catcon_31225.lst catcon: See olap.sql*.log files for output generated by scripts catcon: See olap.sql_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to mdinst_catcon_31323.lst catcon: See mdinst*.log files for output generated by scripts catcon: See mdinst_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catols_catcon_31517.lst catcon: See catols*.log files for output generated by scripts catcon: See catols_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catapx_catcon_31574.lst catcon: See catapx*.log files for output generated by scripts catcon: See catapx_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catmac_catcon_32186.lst catcon: See catmac*.log files for output generated by scripts catcon: See catmac_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catclust_catcon_32305.lst catcon: See catclust*.log files for output generated by scripts catcon: See catclust_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to catbundleapply_catcon_32358.lst catcon: See catbundleapply*.log files for output generated by scripts catcon: See catbundleapply_*.lst files for spool files, if any catcon.pl: completed successfully catcon: ALL catcon-related output will be written to utlrp_catcon_32413.lst catcon: See utlrp*.log files for output generated by scripts catcon: See utlrp_*.lst files for spool files, if any catcon.pl: completed successfully Connected. Session altered. Pluggable database altered. Pluggable database altered. PL/SQL procedure successfully completed. Session altered. PL/SQL procedure successfully completed. Session altered. Pluggable database altered. Pluggable database altered. Session altered. Session altered. Session altered. SQL> |
脚本“@?/rdbms/admin/catcdb.sql”的执行时间较为漫长，需要耐心等待。
最后，重启数据库，就可以查询到“INTERNAL_PLAN”了：
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
SQL> shutdown immediate; Database closed. Database dismounted. ORACLE instance shut down. SQL> SQL> startup ORACLE instance started. Total System Global Area 2483027968 bytes Fixed Size 2927432 bytes Variable Size 822084792 bytes Database Buffers 1644167168 bytes Redo Buffers 13848576 bytes Database mounted. Database opened. SQL> SQL> SQL> select id,name from v$rsrc_plan; ID NAME ---------- -------------------------------- 17342 ORA$INTERNAL_CDB_PLAN 17315 INTERNAL_PLAN SQL> |
至此，该问题的解决完成。
——————————————————————————
Done。
如果，你遇到了诸如这样的错误：
Can’t locate Term/ReadKey.pm in @INC (@INC contains: /u01/ap，…
则表明你没有安装上面文档中我通过YUM安装的：perl-TermReadKey。
或者，你没有把Oracle的$ORACLE_HOME/perl/bin，写入到PATH，变量中，并使其生效。
————————————
Done。
2016年4月23日17:47:44