ORA-00600: internal error code, arguments: [kssadd: null parent]

parknkjun發表於2016-11-16
某客戶核心系統報ORA-00600,ORA07445錯誤,alert日誌如下:
Fri Nov 04 02:01:01 2016
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1177618):
ORA-00600: internal error code, arguments: [kssadd:  null parent], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/incident/incdir_1177618/jzhdb_ora_15269992_i1177618.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1177619):
ORA-00600: internal error code, arguments: [kssadd:  null parent], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/incident/incdir_1177619/jzhdb_ora_15269992_i1177619.trc
Fri Nov 04 02:01:04 2016
Dumping diagnostic data in directory=[cdmp_20161104020104], requested by (instance=1, osid=15269992), summary=[incident=1177618].
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1177620):
ORA-00600: internal error code, arguments: [kssadd:  null parent], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/incident/incdir_1177620/jzhdb_ora_15269992_i1177620.trc
Fri Nov 04 02:01:07 2016
Sweep [inc][1177619]: completed
Sweep [inc][1177618]: completed
Sweep [inc2][1177619]: completed
Sweep [inc2][1177618]: completed
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1177621):
ORA-00600: internal error code, arguments: [kssadd:  null parent], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/incident/incdir_1177621/jzhdb_ora_15269992_i1177621.trc
Fri Nov 04 02:01:12 2016
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1177622):
ORA-00600: internal error code, arguments: [kssadd:  null parent], [], [], [], [], [], [], [], [], [], [], []
Incident details in: /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/incident/incdir_1177622/jzhdb_ora_15269992_i1177622.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1177623):
ORA-00600: internal error code, arguments: [kssadd:  null parent], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1177624):
ORA-00600: internal error code, arguments: [kssadd:  null parent], [], [], [], [], [], [], [], [], [], [], []
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc:
Fri Nov 04 02:01:15 2016
Dumping diagnostic data in directory=[cdmp_20161104020115], requested by (instance=1, osid=15269992), summary=[incident=1177622].
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1177625):
ORA-00600: internal error code, arguments: [kglssr], [8], [1], [], [], [], [], [], [], [], [], []
Incident details in: /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/incident/incdir_1177625/jzhdb_ora_15269992_i1177625.trc
Use ADRCI or Support Workbench to package the incident.
See Note 411.1 at My Oracle Support for error and packaging details.
Exception [type: SIGSEGV, Address not mapped to object] [ADDR:0x4C00012C4800005E] [PC:0x1008B5AFC, kocedc()+60] [flags: 0x0, count: 1]
Errors in file /oracleser/app11203/oracle/diag/rdbms/jzhdb/jzhdb/trace/jzhdb_ora_15269992.trc  (incident=1232002):
ORA-07445: exception encountered: core dump [kocedc()+60] [SIGSEGV] [ADDR:0x4C00012C4800005E] [PC:0x1008B5AFC] [Address not mapped to object] []
檢視TRACE檔案內容:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning and Automatic Storage Management options
ORACLE_HOME = /oracleser/app11203/oracle/product/11.2.0
System name: AIX
Node name: xxxxxxxx
Release: 1
Version: 6
Machine: 00F6C3CD4C00
Instance name: jzhdb
Redo thread mounted by this instance: 1
Oracle process number: 202
Unix process pid: 15269992, image: oracle@xxxxxx
*** 2016-11-04 02:01:01.683
*** SESSION ID:(2214.61775) 2016-11-04 02:01:01.683
*** CLIENT ID:() 2016-11-04 02:01:01.683
*** SERVICE NAME:(jzhdb) 2016-11-04 02:01:01.683
*** MODULE NAME:(sqlplus.exe) 2016-11-04 02:01:01.683
*** ACTION NAME:() 2016-11-04 02:01:01.683
hstccs:  (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=xxxxxxx)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=jzhdb)(CID=(PROGRAM=D:\oracle\product\10.2.0\db_1\bin\sqlplus.exe)(HOST=xxxxxx02)(USER=SYSTEM))))
trace內容顯示客戶是透過sqlplus連線,並且確認版本是10.2.0.1

查詢MOS發現,該ORA-600、ORA-07445錯誤與bug:16590736非常相似,這是由於客戶端版本過低觸發該bug
建議客戶升級至10.2.0.2以上版本

來自 “ ITPUB部落格 ” ,連結:http://blog.itpub.net/10271187/viewspace-2128569/,如需轉載,請註明出處,否則將追究法律責任。

相關文章