-
I see in the alert log there was a ora 600 some days back, the database is running fine now, but I want to know the cause of this error, here's the excerpt trace file which has the error.
Please help if you can determine what went wrong and if there is any reason to worry.
*** SESSION ID:(123.65) 2002-01-11 11:48:03.115
*** 2002-01-11 11:48:03.115
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [15454], [0], [], [], [], [], [],
Current SQL statement for this session:
BEGIN bmc$pkkpkg.data_collector('START','60'); END;
----- PL/SQL Call Stack -----
object line object
handle number name
cbd64a48 201 package body SYS.DBMS_LOCK
ca0dc8e8 1166 package body SPOT.BMC$PKKPKG
ca0dc8e8 1213 package body SPOT.BMC$PKKPKG
c9e0f160 1 anonymous block
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- --------------------------
Cannot read string table section header in /usr/lib/libnwora.so.
Cannot read string table section header in /usr/lib/libnwora.so.
Cannot read string table section header in /usr/lib/libnwora.so.
Cannot read string table section header in /usr/lib/libnwora.so.
Cannot read string table section header in /usr/lib/libnwora.so.
ksedmp()+168 CALL ksedst()+0 3F0 ? 1 ? FFBE97A0 ?
FFBE9244 ? FFBE9228 ? 0 ?
kgeriv()+196 PTR_CALL 00000000 3 ? 0 ? 0 ? 258 ? 1 ? 3C5E
kgeasi()+164 CALL kgeriv()+0 1 ? FFBE9F68 ? 19B5A88 ?E9
psdwat()+64 CALL kgeasi()+0 19C6EE4 ? 1A1AB6C ? 3C5E ?
2 ? 1 ? 0 ?
pfrrun()+25440 PTR_CALL 00000000 1A226D4 ? 1 ? 1A2B5D0 ?
7C1818 ? 0 ? 19B5A88 ?
peicnt()+324 CALL pfrrun()+0 1B9FE34 ? 1A226D4 ? 60 ? 1
C9FBDD8E ? 1BA2728 ?
kkxexe()+468 CALL peicnt()+0 FFBEBDAC ? 1A226D4 ?
1A226D4 ? FFBEBDAC ?
FFBEBCDC ? 0 ?
opiexe()+11608 CALL kkxexe()+0 19CC400 ? 1A226D4 ?
7FFFFC00 ? 1572400 ?
19C6C00 ? C9E0F160 ?
opiall0()+4944 CALL opiexe()+0 19C9AE4 ? 1A2F524 ?C9E1247
opial7()+324 CALL opiall0()+0 1A1CEA0 ? FFBED6A8 ?
161F3F8 ? 1A2F524 ? 3E ? 0
opiodr()+5688 PTR_CALL 00000000 1 ? F ? FFBEF1F8 ? 0 ?
CE828100 ? CD17AA58 ?
ttcpip()+956 PTR_CALL 00000000 161F828 ? FFBED99C ?
19CB000 ? 3 ? 1654676 ? 0
opitsk()+664 CALL ttcpip()+0 FFBEE85C ? FFBEE9F8 ? 0 ?7
opiino()+1792 CALL opitsk()+0 0 ? 19C8838 ? 19CB2B4 ? 0
1 ? 0 ?
opiodr()+5688 PTR_CALL 00000000 FFBEFBD8 ? 80005000 ?
19C9800 ? 19FFDC8 ? 0 ?
19B5A88 ?
opidrv()+1316 CALL opiodr()+0 161F778 ? FFBEF7DC ?
19CB000 ? 0 ? 165464A ?
19D4DC4 ?
sou2o()+20 CALL opidrv()+0 3C ? FFBEF8EC ? 19C6C00 ?
FFBEF940 ? 0 ? 2F ?
main()+160 CALL sou2o()+0 FFBEFBE8 ? 3C ? 4 ?
FFBEFBD8 ? 171882C ?
19D4DC4 ?
_start()+220 CALL main()+0 0 ? FFBEFD94 ? 19EC3A8 ?
19C6C00 ? 0 ? 0 ?
----- Argument/Register Address Dump -----
Argument/Register addr=ffbe97a0.
Dump of memory from 0xFFBE9760 to 0xFFBE98A0
FFBE9760 00000000 00000000 019C6EE4 FFBE9802 [..........n.....]
FFBE9770 0156CE94 000000A6 FFBE97AC 019C73F4 [.V............s.]
FFBE9780 FFBE9DC0 00160234 00000000 00000000 [.......4........]
FFBE9790 63396530 66313630 20202020 20202020 [c9e0f160 ]
FFBE97A0 FFBE8FA8 00000006 00000006 FFBE9DC0 [................]
FFBE97B0 00000006 00000006 FFBE9E40 00000006 [...........@....]
FFBE97C0 00000006 FFBE9EB0 00000006 00000006 [................]
FFBE97D0 FFBE9F10 00000006 00000006 FFBE9F90 [................]
FFBE97E0 00000006 00000006 FFBEBC60 00000006 [...........`....]
FFBE97F0 00000006 FFBEBD28 00000006 00000006 [.......(........]
FFBE9800 FFBEBE90 00000006 00000006 FFBED350 [...............P]
FFBE9810 00000006 00000006 FFBED638 00000006 [...........8....]
FFBE9820 00000006 FFBED730 00000006 00000006 [.......0........]
FFBE9830 FFBEDA10 00000006 00000006 FFBEDF10 [................]
FFBE9840 00000006 00000006 FFBEF300 00000006 [................]
FFBE9850 00000006 FFBEF570 00000006 00000006 [.......p........]
FFBE9860 FFBEF850 00000006 00000006 FFBEFB08 [...P............]
FFBE9870 00000006 00000006 FFBEFB68 00000006 [...........h....]
FFBE9880 00000006 FFBE9517 FFBE9518 000003B0 [................]
FFBE9890 00000000 00000028 00000028 FFBE9517 [.......(...(....]
Argument/Register addr=ffbe9244.
Dump of memory from 0xFFBE9204 to 0xFFBE9344
FFBE9200 0188C188 0188C188 0188C188 [............]
FFBE9210 00000001 FFFFFFFF 00000001 7FFFFFFF [................]
FFBE9220 00000001 FFBE9450 00160258 6B736564 [.......P...Xksed]
FFBE9230 6D702829 2B313638 00000000 00000000 [mp()+168........]
FFBE9240 00000001 00160924 6B736564 73742829 [.......$ksedst()]
FFBE9250 2B300000 FFBE938C 00000000 00000001 [+0..............]
FFBE9260 00D7E998 6B676572 69762829 2B313936 [....kgeriv()+196]
FFBE9270 00616C20 6572726F 00000001 00000000 [.al erro........]
FFBE9280 30303030 30303030 003A205B 31353435 [00000000.: [1545]
FFBE9290 00000000 00000000 00D7EEAC 6B676561 [............kgea]
FFBE92A0 73692829 2B313634 00000000 00000000 [si()+164........]
FFBE92B0 00000001 00D7E8D4 6B676572 69762829 [........kgeriv()]
FFBE92C0 2B30000A 0000000A FFBE9570 00000001 [+0.........p....]
FFBE92D0 007C1858 70736477 61742829 2B363400 [.|.Xpsdwat()+64.]
FFBE92E0 7FFFFFFF 00000001 00000001 00D7EE08 [................]
FFBE92F0 6B676561 73692829 2B300001 000003FF [kgeasi()+0......]
FFBE9300 019C6EE4 00000001 00EDAE2C 70667272 [..n........,pfrr]
FFBE9310 756E2829 2B323534 343000BD 00000000 [un()+25440......]
FFBE9320 00000001 00000000 30303030 30303030 [........00000000]
FFBE9330 00A12028 FF0F1A7C FFBE94A3 00000000 [.. (...|........]
FFBE9340 00EC4AC8 [..J.]
Argument/Register addr=ffbe9228.
Dump of memory from 0xFFBE91E8 to 0xFFBE9328
FFBE91E0 0188C188 0188C098 [........]
FFBE91F0 0188C098 0188C188 0188C188 0188C098 [................]
FFBE9200 0188C188 0188C188 0188C188 0188C188 [................]
FFBE9210 00000001 FFFFFFFF 00000001 7FFFFFFF [................]
FFBE9220 00000001 FFBE9450 00160258 6B736564 [.......P...Xksed]
FFBE9230 6D702829 2B313638 00000000 00000000 [mp()+168........]
FFBE9240 00000001 00160924 6B736564 73742829 [.......$ksedst()]
FFBE9250 2B300000 FFBE938C 00000000 00000001 [+0..............]
FFBE9260 00D7E998 6B676572 69762829 2B313936 [....kgeriv()+196]
FFBE9270 00616C20 6572726F 00000001 00000000 [.al erro........]
FFBE9280 30303030 30303030 003A205B 31353435 [00000000.: [1545]
FFBE9290 00000000 00000000 00D7EEAC 6B676561 [............kgea]
FFBE92A0 73692829 2B313634 00000000 00000000 [si()+164........]
FFBE92B0 00000001 00D7E8D4 6B676572 69762829 [........kgeriv()]
FFBE92C0 2B30000A 0000000A FFBE9570 00000001 [+0.........p....]
FFBE92D0 007C1858 70736477 61742829 2B363400 [.|.Xpsdwat()+64.]
FFBE92E0 7FFFFFFF 00000001 00000001 00D7EE08 [................]
FFBE92F0 6B676561 73692829 2B300001 000003FF [kgeasi()+0......]
FFBE9300 019C6EE4 00000001 00EDAE2C 70667272 [..n........,pfrr]
FFBE9310 756E2829 2B323534 343000BD 00000000 [un()+25440......]
FFBE9320 00000001 00000000 [........]
Argument/Register addr=19c6ee4.
Dump of memory from 0x19C6EA4 to 0x19C6FE4
19C6EA0 0002000C 019C6EA8 019C6EA8 [......n...n.]
19C6EB0 0004000C 019C6EB4 019C6EB4 0008000C [......n...n.....]
19C6EC0 019C6EC0 019C6EC0 0020000C 019C6ECC [..n...n.. ....n.]
19C6ED0 019C6ECC 01A1DD58 01A1406C 01A18218 [..n....X..@l....]
PROCESS STATE
-------------
Process global information:
process: cd1110ac, call: ce828100, xact: 0, curses: cd17aa58, usrses: cd17a
a58
----------------------------------------
SO: cd1110ac, type: 1, owner: 0, pt: 0, flag: INIT/-/-/0x00
(process) Oracle pid=107, calls cur/top: ce828100/ce828100, flag: (0) -
int error: 0, call error: 0, sess error: 0, txn error 0
(post info) last post received: 0 0 4
last post received-location: kslpsr
last process to post me: cd0fe310 1 2
last post sent: 0 0 18
last post sent-location: ksqrcl
last process posted by me: cd1084c0 5 0
(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: cd136a84
O/S info: user: oracle, term: UNKNOWN, ospid: 14578
OSD pid info: 14578
----------------------------------------
SO: cd17aa58, type: 3, owner: cd1110ac, pt: 0, flag: INIT/-/-/0x00
(session) trans: 0, creator: cd1110ac, flag: (8000041) USR/- BSY/-/-/-/-/-
DID: 0001-006B-00000002, short-term DID: 0000-0000-00000000
txn branch: 0
oct: 0, prv: 0, user: 65/SPOT
O/S info: user: oracle, term: unknown, ospid: , machine: rm
program: JDBC Thin Client
last wait for 'direct path read' blocking sess=0x0 seq=3407 wait_time=-1
file number=5, first dba=e22, block cnt=1
----------------------------------------
SO: ce807078, type: 36, owner: cd17aa58, flag: INIT/-/-/0x00
LIBRARY OBJECT PIN: pin=ce807078 handle=0 lock=ce80b764
00] user=cd17aa58 session=cd17aa58 count=0 mask=0000 savepoint=3499628 flags=[
Thanx in advance
-
You have hit Bug_222424. It causes Ora-600 when calling DBMS_LOCK.SLEEP with null argument. Don't use in the future the null argument.
-
Is this bug published I am not able to find any info about this bug in metalink.
Thanx
Kavita
