Home » RDBMS Server » Server Administration » ORA-00600 Error in Alert Log (Oracle 10g Rel 2)
ORA-00600 Error in Alert Log [message #351884] Fri, 03 October 2008 10:42 Go to next message
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
Re: ORA-00600 Error in Alert Log [message #351889 is a reply to message #351884] Fri, 03 October 2008 11:06 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Known bug.
Check metalink.
Re: ORA-00600 Error in Alert Log [message #351893 is a reply to message #351889] Fri, 03 October 2008 11:53 Go to previous messageGo to next message
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
Re: ORA-00600 Error in Alert Log [message #351896 is a reply to message #351893] Fri, 03 October 2008 12:07 Go to previous message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: TNS 11254 error
Next Topic: change default database
Goto Forum:
  


Current Time: Wed Dec 07 22:13:46 CST 2016

Total time taken to generate the page: 0.09408 seconds