现象:
alert日志报错:
Sat May 18 07:59:47 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3690630.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:51 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_4530210.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Sat May 18 07:59:52 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_4571226.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:55 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3580036.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:55 2013
Errors in file /oracle/PP/saptrace/background/PP_smon_3174646.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Sat May 18 07:59:55 2013
Errors in file /oracle/PP/saptrace/usertrace/PP_ora_3690634.trc:
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
ORA-01017: invalid username/password; logon denied
Sat May 18 07:59:59 2013
Errors in file /oracle/PP/saptrace/background/PP_pmon_3006490.trc:
ORA-00474: SMON process terminated with error
Sat May 18 07:59:59 2013
PMON: terminating instance due to error 474
Instance terminated by PMON, pid = 3006490
PP_ora_3477608.trc信息:
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - 64bit Production
With the Partitioning and Data Mining options
System name: AIX
Node name: ppserver01
Release: 3
Version: 5
Machine: 00C2E56F4C00
Instance name: PP
Redo thread mounted by this instance: 1
Oracle process number: 38
Unix process pid: 3477608, image: oraclePP@ppserver01
*** 2013-05-18 07:49:04.855
*** ACTION NAME:(298) 2013-05-18 07:49:04.854
*** MODULE NAME:(GP4IV83BY2WCKQIJN2P2XT31F5T) 2013-05-18 07:49:04.854
*** SERVICE NAME:(SYS$USERS) 2013-05-18 07:49:04.854
*** SESSION ID:(1252.62448) 2013-05-18 07:49:04.854
***** Internal heap ERROR KGHLKREM1 addr=7000008c2000020 ds=700000010000058 *****
***** Dump of memory around addr 7000008c2000020:
7000008C2000000 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
7000008C2000020 07000000 10001990 00000000 00000000 [................]
7000008C2000030 00000000 00000000 00000000 00000000 [................]
******************************************************
HEAP DUMP heap name="sga heap" desc=700000010000058
extent sz=0xfe0 alt=216 het=32767 rec=9 flg=-126 opc=4
parent=0 owner=0 nex=0 xsz=0x20
*** 2013-05-18 07:49:04.866
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [KGHLKREM1], [0x7000008C2000020], [], [], [], [], [], []
Current SQL statement for this session:
SELECT /*+ FIRST_ROWS(1) */ "COMP_CODE" , "CHRT_ACCTS" , "GL_ACCOUNT" , "FISCVARNT" , "FISCPER" , "AC_DOC_NO" , "ITEM_NUM" , "FI_DOCSTAT" , "ACCT_TYPE" , "SP_GL_IND" , "AC_DOC_TYP" , "POST_KEY" , "DOC_DATE" , "PSTNG_DATE" , "CREATEDON" , "CLEAR_DATE" , "CLR_DOC_NO" , "CO_AREA" , "COSTCENTER" , "PROFIT_CTR" , "COORDER" , "WBS_ELEMT" , "PLANT" , "BUS_AREA" , "FUNC_AREA" , "PART_PRCTR" , "PCOM