,正常启动数据库,执行建表语句报错
SQL> startup
ORACLE instance started.Total System Global Area 1603411968 bytes
Fixed Size 2144824 bytes
Variable Size 1006634440 bytes
Database Buffers 587202560 bytes
Redo Buffers 7430144 bytes
Database mounted.
Database opened.
SQL> create table testtab(id number(2));
create table testtab(id number(2))
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kqlindp-bad-user], [2921], [], [],
[], [], [], []
SQL>
2,查看alert.log
Thu Jan 07 19:44:05 2010
Errors in file /opt/oracle/diag/rdbms/imapdb/imapdb/trace/imapdb_ora_17688.trc (incident=46699):
ORA-00600: internal error code, arguments: [kqlindp-bad-user], [2921], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/imapdb/imapdb/incident/incdir_46699/imapdb_ora_17688_i46699.trc
Thu Jan 07 19:44:08 2010
Trace dumping is performing id=[cdmp_20100107194408]
Thu Jan 07 19:44:10 2010
Sweep Incident[46699]: completed
3,/opt/oracle/diag/rdbms/imapdb/imapdb/trace/imapdb_ora_17688.trc内容:
Trace file /opt/oracle/diag/rdbms/imapdb/imapdb/trace/imapdb_ora_17688.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11.1.0/db_1
System name: Linux
Node name: linux
Release: 2.6.16.46-0.12-smp
Version: #1 SMP Thu May 17 14:00:09 UTC 2007
Machine: x86_64
Instance name: imapdb
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 17688, image: oracle@linux (TNS V1-V3)*** 2010-01-07 19:24:08.586
*** SESSION ID:(170.5) 2010-01-07 19:24:08.586
*** CLIENT ID:() 2010-01-07 19:24:08.586
*** SERVICE NAME:(SYS$USERS) 2010-01-07 19:24:08.586
*** MODULE NAME:(sqlplus@linux (TNS V1-V3)) 2010-01-07 19:24:08.586
*** ACTION NAME:() 2010-01-07 19:24:08.586kwqmnich: current time:: 19: 24: 8
kwqmnich: instance no 0 check_only flag 1
kwqmnich: initialized job cache structure*** 2010-01-07 19:44:05.119
*** MODULE NAME:(Oracle Enterprise Manager.pin EM plsql) 2010-01-07 19:44:05.119
*** ACTION NAME:(start) 2010-01-07 19:44:05.119Incident 46699 created, dump file: /opt/oracle/diag/rdbms/imapdb/imapdb/incident/incdir_46699/imapdb_ora_17688_i46699.trc
ORA-00600: internal error code, arguments: [kqlindp-bad-user], [2921], [], [], [], [], [], []
SQL> startup
ORACLE instance started.Total System Global Area 1603411968 bytes
Fixed Size 2144824 bytes
Variable Size 1006634440 bytes
Database Buffers 587202560 bytes
Redo Buffers 7430144 bytes
Database mounted.
Database opened.
SQL> create table testtab(id number(2));
create table testtab(id number(2))
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [kqlindp-bad-user], [2921], [], [],
[], [], [], []
SQL>
2,查看alert.log
Thu Jan 07 19:44:05 2010
Errors in file /opt/oracle/diag/rdbms/imapdb/imapdb/trace/imapdb_ora_17688.trc (incident=46699):
ORA-00600: internal error code, arguments: [kqlindp-bad-user], [2921], [], [], [], [], [], []
Incident details in: /opt/oracle/diag/rdbms/imapdb/imapdb/incident/incdir_46699/imapdb_ora_17688_i46699.trc
Thu Jan 07 19:44:08 2010
Trace dumping is performing id=[cdmp_20100107194408]
Thu Jan 07 19:44:10 2010
Sweep Incident[46699]: completed
3,/opt/oracle/diag/rdbms/imapdb/imapdb/trace/imapdb_ora_17688.trc内容:
Trace file /opt/oracle/diag/rdbms/imapdb/imapdb/trace/imapdb_ora_17688.trc
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, Oracle Label Security, OLAP, Data Mining,
Oracle Database Vault and Real Application Testing options
ORACLE_HOME = /opt/oracle/product/11.1.0/db_1
System name: Linux
Node name: linux
Release: 2.6.16.46-0.12-smp
Version: #1 SMP Thu May 17 14:00:09 UTC 2007
Machine: x86_64
Instance name: imapdb
Redo thread mounted by this instance: 1
Oracle process number: 18
Unix process pid: 17688, image: oracle@linux (TNS V1-V3)*** 2010-01-07 19:24:08.586
*** SESSION ID:(170.5) 2010-01-07 19:24:08.586
*** CLIENT ID:() 2010-01-07 19:24:08.586
*** SERVICE NAME:(SYS$USERS) 2010-01-07 19:24:08.586
*** MODULE NAME:(sqlplus@linux (TNS V1-V3)) 2010-01-07 19:24:08.586
*** ACTION NAME:() 2010-01-07 19:24:08.586kwqmnich: current time:: 19: 24: 8
kwqmnich: instance no 0 check_only flag 1
kwqmnich: initialized job cache structure*** 2010-01-07 19:44:05.119
*** MODULE NAME:(Oracle Enterprise Manager.pin EM plsql) 2010-01-07 19:44:05.119
*** ACTION NAME:(start) 2010-01-07 19:44:05.119Incident 46699 created, dump file: /opt/oracle/diag/rdbms/imapdb/imapdb/incident/incdir_46699/imapdb_ora_17688_i46699.trc
ORA-00600: internal error code, arguments: [kqlindp-bad-user], [2921], [], [], [], [], [], []
找到如下资料描述:
A synonym previously created to a non-existent object does not
pick up a later creation of that object automatically. This can
lead to various dictionary related errors such as:
- a dump in kgldtin during RENAME
- ORA-600 [kqlindp-bad-user] looking up an object
Workaround:
Manually recompile the problem synonym.
说是同义词无效导致,所以就查询所有无效的同义词recompile,发现public synonym:DBA_NETWORK_ACL_PRIVILEGES重编译失败,因为view:DBA_NETWORK_ACL_PRIVILEGES无效
,package body:XDB.XDB$ACL_PKG_INT无效...重编了半天搞不好,因为用不上这个同义词,又急着使用环境,直接drop public synonym DBA_NETWORK_ACL_PRIVILEGES,问题解决
????????