ORA-00600: internal error code, arguments: [kssadd: null parent]
某客戶核心系統報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
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/,如需轉載,請註明出處,否則將追究法律責任。
相關文章
- ORA-00600: internal error code, arguments: [kpnatdm】Error
- ORA-00600: internal error code, arguments: [525]Error
- ORA-00600: internal error code, arguments: [4194]Error
- ORA-00600: internal error code, arguments: [15753]Error
- ORA-00600: internal error code, arguments: [17087]Error
- ORA-00600: internal error code, arguments: [Cursor not typechecked],Error
- ORA-00600: internal error code, arguments: [32695]Error
- ORA-00600: internal error code, arguments: [kcbgtcr_13], [], [],Error
- ORA-00600: internal error code, arguments: [2662], [0],Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnCloseError
- 轉載:ORA-00600: internal error code, arguments: [504]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose]Error
- ORA-00600: internal error code, arguments: [15709]Error
- ORA-00600: internal error code, arguments: [LibraryCacheNotEmptyOnClose], [],[], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []ErrorIndex
- ORA-00600: internal error code, arguments: [krvxbpns01], [], [], [], [], [],Error
- ORA-00600: internal error code, arguments: [15160], [], [], [], [], [], [], []Error
- ORA-00600 : internal error code, arguments: [qertbFetchByRowID]Error
- ORA-00600: internal error code, arguments: [2131], [9], [8]Error
- ORA-00600: internal error code, arguments: [13011]Error
- 案例ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], []ErrorIndex
- ora-00600:internal error code,arguments:[4194],[7],[2],[],[]Error
- ORA-00600: internal error code, arguments: [1433], [60], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [729], [4280], [space leak]Error
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [ErrorAST
- ORA-00600: internal error code, arguments: [kcratr1_lastbwr], [], [], [], [],ErrorAST
- ORA-00600: internal error code, arguments: [ksuinfos_modact1]ErrorUI
- ORA-00600: internal error code, arguments: [4194], [4], [31]Error
- ORA-00600: internal error code, arguments: [2103]錯誤Error
- ORA-00600: internal error code, arguments: [kcbgtcr_12], [4]Error
- ORA-00600: internal error code, arguments: [4194], [30], [30], [],Error
- ORA-00600: internal error code, arguments: [knacpft_ProcessFetchedTxns250]Error
- ORA-00600: internal error code, arguments: [qosdExpStatRead: expcnt mismatch], [Error
- ORA-00600: internal error code, arguments: [keltnfy-ldmInit], [46]Error
- ORA-00600: internal error code, arguments: [12235], [], [], [], [], [], [], []Error
- ORA-00600: internal error code, arguments: [ktecgeb-2], (一)Error
- ORA-00600: internal error code, arguments: [kcblasm_1], [103], []ErrorASM
- 遭遇ORA-00600: internal error code, arguments: [kcrrrfswda.11], [4], [368], [], [], [], [], []Error