OraFAQ Forum: Server Administration » ORA-00600 Error in Alert Log

Home » RDBMS Server » Server Administration » ORA-00600 Error in Alert Log (Oracle 10g Rel 2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

ORA-00600 Error in Alert Log [message #351884]

Fri, 03 October 2008 10:42

faiz_hyd
Messages: 294
Registered: February 2006

Senior Member

Hi,

For last 2 days (10/2 and 10/01 ) i am seeing this error in our Production DB in alert log, Although every thing is same no changes and no Impact on Production DB, Is this some thing we should take care of or what,
IF somebody wants to look Trace file i can attach it,

It's a 2 Node cluster environment , and i saw this error on Second Node.
I know Ora-00600 is a generic one , Few lines from trace file .

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters and Data Mining options
ORACLE_HOME = /u01/app/oracle/product/10.2.0/db_1
System name:	SunOS
Node name:	neo6f037n4
Release:	5.10
Version:	Generic_125100-04
Machine:	sun4us
Instance name: ProdAPP01b
Redo thread mounted by this instance: 2
Oracle process number: 79
Unix process pid: 8236, image: ProdAPP01b@nebf07739n4
*** ACTION NAME:() 2008-10-02 14:00:34.740
*** MODULE NAME:(TOAD 9.5.0.31) 2008-10-02 14:00:34.740
*** SERVICE NAME:(edgep01) 2008-10-02 14:00:34.740
*** SESSION ID:(705.7052) 2008-10-02 14:00:34.740
*** 2008-10-02 14:00:34.740
ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [kolaslGetLength-1], [], [], [], [], [], [], []
Current SQL statement for this session:
Select * from gv$sql_plan Where hash_value = :sqlhv
and child_number =:cn and inst_id =:inst order by id

Any help or direction where to look for more info is appreciated.

Thanks

Report message to a moderator

Re: ORA-00600 Error in Alert Log [message #351889 is a reply to message #351884]

Fri, 03 October 2008 11:06

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

Known bug.
Check metalink.

Report message to a moderator

Re: ORA-00600 Error in Alert Log [message #351893 is a reply to message #351889]

Fri, 03 October 2008 11:53

faiz_hyd
Messages: 294
Registered: February 2006

Senior Member

Thanks Mahesh,

I see many Ora 00600 related in metalink,
Can you please refer which Particular bug you are referring, the one related the below error,
And is there Patch being released for this, Any document or link Please.

Version is

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production

Thanks

Report message to a moderator

Re: ORA-00600 Error in Alert Log [message #351896 is a reply to message #351893]

Fri, 03 October 2008 12:07

Michel Cadot
Messages: 68718
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Search for ORA-600 look-up and follow the note guidelines, you will find the related metalink note(s).

Regards
Michel

Report message to a moderator

Previous Topic:	TNS 11254 error
Next Topic:	change default database

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Nov 29 17:48:42 CST 2024