Home » RDBMS Server » Server Administration » ORA-00600 Error messages
ORA-00600 Error messages [message #51972] Mon, 24 June 2002 12:38 Go to next message
Vladimir Grams
Messages: 5
Registered: June 2002
Junior Member
I received a lot of messages errors with this ORA-00600 errors code, it is not in particular situation, some traces files show things like this:
Oracle8i Enterprise Edition Release 8.1.6.3.0 - Production
With the Partitioning option
JServer Release 8.1.6.3.0 - Production
ORACLE_HOME = /soft/app/oracle/product/8.1.6
System name: UnixWare
Node name: uxrjo021
Release: 5
Version: 7.1.1
Machine: i386
Instance name: psab
Redo thread mounted by this instance: 0 <none>
Oracle process number: 0
9881

*** 2002-01-17 13:58:49.240
*** SESSION ID:(98.1069) 2002-01-17 13:58:49.200
********** Internal heap ERROR 17112 addr=0x947a3f0 *********
***** Dump of memory around addr 0x947a3f0:
.....
UNPINNED RECREATABLE CHUNKS (lru first):
PERMANENT CHUNKS:
Chunk 94ffe68 sz= 8224 perm "perm " alo=4824
Chunk 9491024 sz= 4408 perm "perm " alo=4408
Chunk 947ae50 sz= 4308 perm "perm " alo=4308
Chunk 94780c4 sz= 2912 perm "perm " alo=2912
Chunk 9475f7c sz= 4212 perm "perm " alo=4212
Chunk 946fba4 sz= 6492 perm "perm " alo=6492
Chunk 946f81c sz= 752 perm "perm " alo=752
Chunk 9465518 sz= 1016 perm "perm " alo=1000
Chunk 946da5c sz= 7616 perm "perm " alo=7616
Chunk 9464d0c sz= 2060 perm "perm " alo=2060
Permanent space = 42000
******************************************************
Hla: 0
*** 2002-01-17 13:58:49.250
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [[17112]], [[155689968]], [[]], [[]], [[]], [[]], [[]], [[]]
Current SQL information unavailable - no session.
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedmp()+179 ? ksedst 0
ksfdmp()+14 ? ksedmp 3
kgeriv()+216 ? ksfdmp 941E5A0 3
kgesiv()+87 ? kgeriv 941E5A0 0 42D8 1 8047340
kgesic1()+33 ? kgesiv 941E5A0 0 42D8 1 8047340
kgherror()+861 ? kgesic1 941E5A0 0 42D8 0 947A3F0
kghfre()+442 ? kgherror 941E5A0 941E474 42D8 947A3F0
kghfrh()+541 ? kghfre 941E5A0 941E474 946FB38 72000
946FB40
kgffdcn()+381 ? kghfrh 941E5A0 946FB18
ksfhdxh()+59 ? kgffdcn 941E5A0 947E508
ksfhnfy()+124 ? ksfhdxh 9465374
kscnfy()+134 ? ksfhnfy 17 0
ksmdpg()+8 ? kscnfy 17 0
opidcl()+520 ? ksmdpg 941E614 0 94216E0 3C
opidrv()+1546 ? opidcl 94216E0 0
sou2o()+25 ? opidrv 3C 4 80477FC
main()+187 ? sou2o 804780C 3C 4 80477FC
_start()+92 ? main 2 8047974 8047980
----- Argument/Register Address Dump -----
Argument/Register addr=0.
Dump of memory from 0x0 to 0x100
000 00000000 00000000 00000000 00000000 [[................]]
Repeat 15 times
Argument/Register addr=941e5a0.
Dump of memory from 0x941E560 to 0x941E6A0

I aprecciate any suggestion to resolve this
Thanks
Vladimir
Re: ORA-00600 Error messages [message #51976 is a reply to message #51972] Mon, 24 June 2002 12:52 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
May be due to an Operating System memory overwrite. Run diagnostics to check the physical memory on the machine and check the OS system logs. I beleive you need to call OSS.
Re: ORA-00600 Error messages [message #51978 is a reply to message #51976] Mon, 24 June 2002 13:22 Go to previous messageGo to next message
Vladimir Grams
Messages: 5
Registered: June 2002
Junior Member
But this errors appears in many servers not in one particulary.
If you have another tip, i will apreciate ok!
Thanks
Vladimir
Re: ORA-00600 Error messages [message #51980 is a reply to message #51976] Mon, 24 June 2002 13:39 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
normally internal heap errror
is impacted with process failure, memory corruption or even a pssible instance failure. but it is NON DATA CORRUPTIVE. First thing to do is to check your memory for failures. or u may be in need to install some kinda patchset or anything like that.
and
By chance, are u getting this error when u try to execute a query with order by .. desc?
Re: ORA-00600 Error messages [message #51983 is a reply to message #51976] Mon, 24 June 2002 16:23 Go to previous messageGo to next message
Vladimir Grams
Messages: 5
Registered: June 2002
Junior Member
Thanks to all, i will send another trace file tomorrow to try another tips about this error messages.
The support area did opened a support call in the Oracle company, but no recived no one answer still.
Thanks again
Re: ORA-00600 Error messages [message #53330 is a reply to message #51976] Thu, 12 September 2002 11:31 Go to previous message
Bob
Messages: 49
Registered: March 1999
Member
Check your ORA-NLS33 settings and make sure they are correct.
Previous Topic: Patitioning small sized tables , I need advice !!!!
Next Topic: Oracle Installation
Goto Forum:
  


Current Time: Thu Sep 19 11:53:37 CDT 2024