ora -00600 Internal error code

Printable View

07-29-2002, 12:46 PM
Noemi

Hello

I have a problem that donÂ´t let me connect sometimes, i have checked the alert file and it show me an error :

ora - 00600 Internal error code , arguments
[12333],[0],[2],[31].

Please if someone knows how i can solve this problem, help me.

NoemÃ*
07-29-2002, 12:49 PM
mkumarnk

Hi,

Did u check whehter block corruption is there ? chek it.Check trace file also.Bock corruption is there u wull have to solve it.If u have the support from oracle that is hte best way to solve the block corruption

Mnaoj
07-29-2002, 03:06 PM
Noemi

How can i check the block corruption ?
07-29-2002, 03:21 PM
JUNE

Quote:

Originally posted by Noemi
How can i check the block corruption ?

tHE ORA-600 ERROR messages is a generic messages. It could be caused for any number of reasons. You should try and look at the alert logs and trace files which should be located in your home directory or you can look in the init file to find the locations of these files.

Seeing that you are unable to connect. You may want to look at the number you have your process limit set to.
07-29-2002, 03:30 PM
alapps

To check the processes on Unix...

ps -ef|grep oracleSID|wc -l

*** Replace SID with your sid in question... ***

i.e. for sid PSERV it would be:

ps -ef|grep oraclePSRV|wc -l
07-29-2002, 04:10 PM
Noemi

I have checked the number of process that i have limit set , it is 150 .

what else can i check ?
07-30-2002, 04:48 AM
chao_ping

Quote:

Originally posted by mkumarnk
Hi,

Did u check whehter block corruption is there ? chek it.Check trace file also.Bock corruption is there u wull have to solve it.If u have the support from oracle that is hte best way to solve the block corruption

Mnaoj

hei,
As far as i know, 12333 is not block corruption, it is because of network unstable, right?
07-30-2002, 05:14 AM
moff

Hi,

Yes - it looks like it could be a network problem - Below is an extract from Metalink - Hope it helps point you in the right direction....

Regards
Moff.

ORA-600[12333] is reported with three additional numeric values when a request is being received from a network packet and the request code in the packet is not recognized.
The error may have a number of different root causes. For example, a network error may have caused bad data to be received, or the client application may have sent wrong data, or the data in the network buffer may have been overwritten. Since there are many potential causes of this
error, it is essential to have a reproducible testcase to correctly diagnose the underlying cause. If operating system network logs are available, it is advisable to check them for evidence of network failures which may indicate network transmission problems.