Message-ID: <F001.00518A27.20021212073905@fatcity.com>
Date: Thu, 12 Dec 2002 07:39:05 -0800
To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
Sender: root@fatcity.com
Reply-To: ORACLE-L@fatcity.com
Errors-To: ML-ERRORS@fatcity.com
From: "Casey A. Jordan" <cjordan@imcwv.com>
Subject: Re:  ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0],
Organization: Fat City Network Services, San Diego, California
Precedence: bulk
Mime-Version: 1.0
Content-Type: text/plain;	charset="iso-8859-1"
Content-Transfer-Encoding: 7bit

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@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@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@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@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).