Oracle-L: Re: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],

From: Casey A. Jordan <cjordan_at_imcwv.com>
Date: Thu, 12 Dec 2002 07:39:05 -0800
Message-ID: <F001.00518A27.20021212073905@fatcity.com>

I looked on Metalink and found several hits. Most of them point to Note:147731.1. I states you can get this error when using the 8i JDBC driver to connect to a 9i database.

Just in case you didn't know, ora-600 is just a catch all error that you can get for many, many reasons. You when searching Metalink you must include the arguments. Metalink also has a tool for looking up ora-600 errors. You can find it under DOC ID 153788.1.

Casey

Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, December 12, 2002 9:33 AM

Hi ,

we are getting the error ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],
[], [], [], [], [], [] when trying to retrieve a result set from Java EJB. Searched metalink giving arguments for ORA-00600 but couldn't get any solution.
I am being told that Weblogic 6.1 with oracle 9i is giving some problems. Any info on this ?

Setup is mentioned Below:
Oracle database 9.0.1.1.0 on sunsolaris
Weblogic Applications Server 6.1 on Sunsolaris (different Unix box). JDBC driver thin - Classes12.jar

In fact , If an Insert from the Application is working fine. But when we try a query it is displaying the above mentioned error.

>From udump trace file of oracle below is the error message :

/usr/gsci/OraHome1/admin/GMODC/udump/gmodc_ora_1182.trc Oracle9i Enterprise Edition Release 9.0.1.1.0 - 64bit Production With the Partitioning option
JServer Release 9.0.1.1.0 - Production
ORACLE_HOME = /usr/gsci/OraHome1
System name: SunOS
Node name: lotus

Release: 5.8
Version: Generic
Machine: sun4u

Redo thread mounted by this instance: 1
Oracle process number: 19
Unix process pid: 1182, image: oracle_at_lotus (TNS V1-V3)

SESSION ID:(19.2868) 2002-12-11 10:41:43.563
2002-12-11 10:41:43.563 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] Current SQL statement for this session: SELECT VALUE FROM NLS_INSTANCE_PARAMETERS WHERE PARAMETER ='NLS_DATE_FORMAT' ----- Call Stack Trace -----

Is there any solution for this problem? TIA
Satish

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Casey A. Jordan
  INET: cjordan_at_imcwv.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Thu Dec 12 2002 - 09:39:05 CST