Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], []
java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [] [message #76449] Thu, 11 July 2002 01:57 Go to next message
Somil Dixit
Messages: 1
Registered: July 2002
Junior Member
We are trying to deploy a application with Oracle 9i Application Server on Solaris.

While trying to connect to DB it gives the error

java.sql.SQLException: ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]

at java.lang.Throwable.fillInStackTrace(Native Method)
at java.lang.Throwable.fillInStackTrace(Compiled Code)
at java.lang.Throwable.<init>(Compiled Code)
at java.lang.Exception.<init>(Compiled Code)
at java.sql.SQLException.<init>(SQLException.java:43)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:169)
at oracle.jdbc.ttc7.TTIoer.processError(Compiled Code)
at oracle.jdbc.ttc7.Oall7.receive(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(Compiled Code)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:1826)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2015)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:571)
at webarch.localdb.OradbAccess.executeQuery(Compiled Code)
at webarch.EXT_ERRMSG.getResultSet(Compiled Code)
at webarch.EXT_ERRMSG.Show_Msg(EXT_ERRMSG.java:25)
at guitypes.MCAppDataMngr.callService(Compiled Code)
at Gui_assetmgmt.w_OfficeMenu.defaultsearch(w_OfficeMenu.java:2051)
at Gui_assetmgmt.w_OfficeMenu.ProcessButtonClick(w_OfficeMenu.java:560)
at guitypes.gu_multiud.ProcessButtonClick(gu_multiud.java:87)
at guitypes.gu_cbutton.actionPerformed(gu_cbutton.java:95)
at comnServlet.doGet(Compiled Code)
at comnServlet.doPost(comnServlet.java:489)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:211)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:309)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:336)
at com.evermind.server.http.ServletRequestDispatcher.invoke(Compiled Code)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(Compiled Code)
at com.evermind.server.http.HttpRequestHandler.processRequest(Compiled Code)
at com.evermind.server.http.HttpRequestHandler.run(Compiled Code)
at com.evermind.util.ThreadPoolThread.run(Compiled Code)

The database (Oracle 9i) is on the same server.
There is no previous installation of oracle on the server.

The solution given on the net is to apply the patch for jdbc thin driver 1725012. after applying the patch same error occurs.
We tried to include classes12.zip and classes111.zip in classpath but got the same error.

We also tried to rename the classes12.zip and classes111.zip from the database login as well as the Oracle 9iAS login but application fails at the same place. Is there a possibility that mentioned files are picked from some other place. Or do any other files serve the same purpose? May be these files have to be replaced.

The same application runs perfectly on NT with Oracle 9iAS.

Thanks and regards,
Somil.
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #76456 is a reply to message #76449] Thu, 18 July 2002 07:15 Go to previous messageGo to next message
Trung Nhut Tran
Messages: 1
Registered: July 2002
Junior Member
Somil,

Check the classpath in the 9iAS start-up script. Make sure there are ONLY ONE file classesxx.jarin the classpath.

Regards,
Trung
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #76611 is a reply to message #76449] Tue, 11 February 2003 00:11 Go to previous messageGo to next message
Malir
Messages: 1
Registered: February 2003
Junior Member
I tried to switch to the Oracle 9i classes12.jar file but that did nto work either. Does anyone has a solution?
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #76846 is a reply to message #76449] Mon, 15 December 2003 17:49 Go to previous messageGo to next message
blue eyes
Messages: 1
Registered: December 2003
Junior Member
I have the same Exception. when I connect, insert it's OK. But I query data from table it thrown java.sql.SQLException: ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]].
Any help ?
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #76862 is a reply to message #76846] Tue, 20 January 2004 00:03 Go to previous messageGo to next message
chandra shekar
Messages: 3
Registered: November 2001
Junior Member
hi

this exception will raise when u dont have classes12.zip or classes12.jar in u r classpath

classes12.zip is used for 8i client
classes12.jar for 9i client

regards
k chandra shekar
Re: java.sql.SQLException: ORA-060: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [message #76870 is a reply to message #76862] Wed, 28 January 2004 08:36 Go to previous messageGo to next message
Robert Burns
Messages: 1
Registered: January 2004
Junior Member
You need to replace the "classes" zips and jars with http://download.oracle.com/otn/utilities_drivers/jdbc/9203/ojdbc14.jar from
http://otn.oracle.com/software/tech/java/sqlj_jdbc/htdocs/jdbc9201.html for 9i
Re: java.sql.SQLException: ORA-060: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [message #76952 is a reply to message #76870] Sat, 03 April 2004 00:13 Go to previous messageGo to next message
ABC
Messages: 13
Registered: March 2001
Junior Member
Hello,

Even i m facing the same problme i have replaced classes12.zip and also copied ojdbc14.jar in my oracle91/jdbc/lib but still i m facing this problem

help needed !!
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #76962 is a reply to message #76862] Mon, 12 April 2004 03:33 Go to previous messageGo to next message
Sayed Chhattan shah
Messages: 2
Registered: April 2004
Junior Member
I have the same Exception. When i qury any Numeric data
it works butin case of Varchar datatype it doesnot works.

plz reply if u find any solution.
thanx
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #76968 is a reply to message #76846] Thu, 22 April 2004 06:42 Go to previous messageGo to next message
Sayed Chhattan shah
Messages: 2
Registered: April 2004
Junior Member
There is bug in Oc4J 1.0.2.2.0 version so it does not works while retrieving the char data.

Use Oc4J 1.0.2.2.1 version. It works fine.
Re: java.sql.SQLException: ORA-060: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [message #76984 is a reply to message #76952] Fri, 07 May 2004 08:28 Go to previous messageGo to next message
Malcolm
Messages: 6
Registered: March 2002
Junior Member
Hi I'm Malcolm. I'm Have having the same problem as you described in this message thread. Were you able to resolve the issue?
Re: java.sql.SQLException: ORA-060: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [message #76988 is a reply to message #76984] Mon, 10 May 2004 02:02 Go to previous messageGo to next message
Nicolas
Messages: 3
Registered: February 2002
Junior Member
Hello

I had the same problem and i have an issue:
put in your web-inf/lib the classes12.jar of oracle9i

The problem comes from you try to connect to a oracle 9i database from a oracle8 client. You must put the last classes12.jar

Hope it'll work for you

-----------------------------------------------------
nicolas webmaster of http://www.ksl.fr
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #76994 is a reply to message #76846] Wed, 19 May 2004 04:01 Go to previous messageGo to next message
Tom Green
Messages: 1
Registered: May 2004
Junior Member
Our shop was previously running weblogic 6.1 and oracle 8.1.7.

We upgraded oracle to 9i, and then started receiving this message

It was necessary for me to point the weblogic startup params to point to the 9i classes:
## Oracle stuff
ORACLE_HOME=/u02/opt/oracle/product/9
ORA_JDBC_CLASSPATH=$ORACLE_HOME/jdbc/lib/classes12.zip

Voila!
no more problem!
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #76997 is a reply to message #76846] Fri, 21 May 2004 21:01 Go to previous messageGo to next message
SK
Messages: 26
Registered: March 2001
Junior Member
We solved the problem by keeping the Oracle 9i classes12.jar to be kept infront of the weblogic.jar in the classpath, that solved this problem.
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #77006 is a reply to message #76449] Wed, 02 June 2004 21:03 Go to previous messageGo to next message
Sunil
Messages: 132
Registered: September 1999
Senior Member
Hello all,
iam getting java.sql.SQLEXception:ORA-00600:internal error code,arguments,[[ttcgchnd-1]],[[0]],[[]],[[]],[[]],[[]],[[]] pls any one can give me the solution of
the above problem
Re: java.sql.SQLException: ORA-060: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [message #77015 is a reply to message #76988] Wed, 16 June 2004 05:57 Go to previous messageGo to next message
Sujith
Messages: 1
Registered: June 2004
Junior Member
Thanks guys. Placing the ojdbc.jar file in the WEB-INF/lib directory of the webapp have helped to solve this issue
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #77016 is a reply to message #76997] Wed, 16 June 2004 11:51 Go to previous messageGo to next message
kripan Ghosh
Messages: 1
Registered: June 2004
Junior Member
We also solved the same problem in a different environment, DO NOT RESEARCH ...simply keep classes12.zip(the correct one) ahead of any other driver class
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #77031 is a reply to message #76449] Wed, 07 July 2004 23:37 Go to previous messageGo to next message
Extezy
Messages: 1
Registered: July 2004
Junior Member
Solve this problem by replace classes12.jar on ojdbc14.jar
Re: java.sql.SQLException: ORA-060: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [message #77038 is a reply to message #76988] Thu, 15 July 2004 16:53 Go to previous messageGo to next message
SA
Messages: 37
Registered: March 2002
Member
Thanks for this thread.We had this problem and are able to fix this by putting ora92jdbclibclasses12.zip as the first one in classpath.
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #77047 is a reply to message #77016] Thu, 22 July 2004 06:54 Go to previous messageGo to next message
Sangeeta
Messages: 9
Registered: October 2001
Junior Member
Hi,

Where can I find the latest classes12.zip? I have placed one that I have in the classpath.

Thanks,
Sangeeta
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77084 is a reply to message #77031] Sat, 21 August 2004 16:17 Go to previous messageGo to next message
john espitia
Messages: 1
Registered: August 2004
Junior Member
thanks
i'm using jdeveloper 3.2, it have a jdbc driver for 8i
but i'm using 9i, i changed classes12.jar and my application works

Thank you
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77117 is a reply to message #77047] Wed, 08 September 2004 23:04 Go to previous messageGo to next message
sreedevi
Messages: 2
Registered: February 2003
Junior Member
u can store from the following path in oracle.
C:oracleora81jdbclibclasses12.zip
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77151 is a reply to message #76997] Tue, 28 September 2004 21:22 Go to previous messageGo to next message
Raj
Messages: 411
Registered: November 1998
Senior Member
Thanx...This solution Resolved my problem
-raj
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77181 is a reply to message #77031] Fri, 22 October 2004 22:51 Go to previous messageGo to next message
P. Rathina kumar
Messages: 1
Registered: October 2004
Junior Member
The requirement of classes12.jar or ojdbc14.jar for your Java application to connect to a Oracle 9i database server depends on the JDK version you use.
JDK 1.4 requires ojdbc14.jar to connect to.
Refer to Oracle Technology Network website for precise requirement idetification.
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77184 is a reply to message #76962] Fri, 29 October 2004 05:32 Go to previous messageGo to next message
Ashish Khandelwal
Messages: 1
Registered: October 2004
Junior Member
I have oracle8i client installed
and i am using tomcat web server
and eclipse for IDE
i m still getting this exception
even after i have set the export order
of classes12.zip as first

I m able to connect using oracle.jdbc.driver.OracleDriver driver
i m able to update values
i m able insert values
i m able to select numeric values

and i not ABLE TO SELECT VARCHAR values
this seems really crazy...

any help will really be appriciated

regards
Ashish
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77186 is a reply to message #77181] Sun, 31 October 2004 18:35 Go to previous messageGo to next message
Prabhakaran Subramanian
Messages: 1
Registered: October 2004
Junior Member
Here i connect from java to oracle 9i database, the connection gives failure with the error message of Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [[ttcgcshnd-1]], [[0]], [[]], [[]], [[]], [[]], [[]], [[]]

When i remove the classes12.zip in the classpath and i put ojdbc14.jar, now the database is connected, without showing error.

Thanks and Regards,
Prabhakaran Subramanian.
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77197 is a reply to message #76968] Fri, 05 November 2004 06:25 Go to previous messageGo to next message
Tracychan
Messages: 2
Registered: November 2004
Junior Member
how to change Oc4j 1.0.2.2.0 into Oc4j 1.0.2.2.1?

I also have problems dealing with the char data
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77202 is a reply to message #76449] Wed, 10 November 2004 04:17 Go to previous messageGo to next message
Mahesh
Messages: 90
Registered: January 2001
Member
Hi Extezy and all ,

Its working fine for me now ..

thanks for information.

Mahesh L.
=========
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77243 is a reply to message #76997] Thu, 02 December 2004 23:30 Go to previous messageGo to next message
Ramakrishna Alakunta
Messages: 1
Registered: December 2004
Junior Member
We solved the problem by keeping correct Oracle 9i classes12.zip file. you can find and download the same from http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc901.html
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #77289 is a reply to message #77243] Sun, 13 February 2005 21:32 Go to previous messageGo to next message
Jayaseelan
Messages: 1
Registered: February 2005
Junior Member
Here I'm sending some description of the problem.Need to pay little patience.

>I am running on WebLogic server 7.0 which is installed on my machine.
>I am connecting to Oracle Database, through client Oracle9i-client. The Database itself is a 9i one.
>I've been success, while connecting to Database in the same procedure for ordinary java programs(not the web components).
>My Oracle version is 9.2.0.5.0

If you can find a free time just let me know the possible solution. I am sending the Jsp also.

Here is WebLogic Classpath setting
CLASSPATH=D:beajdk131_03libtools.jar;D:beaweblogic700serverlibweblogic_
sp.jar;D:oracleora90jdbclibclasses12.jar;D:beaweblogic700serverlibwebl
ogic.jar;
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #112048 is a reply to message #76449] Tue, 22 March 2005 12:10 Go to previous messageGo to next message
ceolin
Messages: 1
Registered: March 2005
Junior Member
Please,
Somebody knows if I use classes12.jar for Oracle9i also it works for the Oracle8i? I have the two DB's.
Thanks
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #118643 is a reply to message #76449] Fri, 06 May 2005 12:34 Go to previous messageGo to next message
shri_mujumdar
Messages: 1
Registered: May 2005
Junior Member
I am getting this exception when i am trying to connct to oracle9i through the Servlet on weblogic 6.1(trial version), wheather trial version be making any difference?

java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1],
[0], [], [], [], [], [], []

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.fetch(TTC7Protocol.java:889)
at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.jav
a:1681)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1870)
at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:
538)
at JdbcDemo.<init>(JdbcDemo.java:20)
at AbcServlet.doGet(AbcServlet.java:39)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:740)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:265)
at weblogic.servlet.internal.ServletStubImpl.invokeServlet(ServletStubIm
pl.java:200)
at weblogic.servlet.internal.WebAppServletContext.invokeServlet(WebAppSe
rvletContext.java:2495)
at weblogic.servlet.internal.ServletRequestImpl.execute(ServletRequestIm
pl.java:2204)
at weblogic.kernel.ExecuteThread.execute(ExecuteThread.java:139)
at weblogic.kernel.ExecuteThread.run(ExecuteThread.java:120)



Help required
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #122689 is a reply to message #77117] Wed, 08 June 2005 00:36 Go to previous messageGo to next message
dalfans
Messages: 1
Registered: June 2005
Location: Jakarta
Junior Member
i have a problem, and i need your help right now ....

java.sql.SQLException: ORA-00600: internal error code, arguments: [kcbgtcr_12],
[1], [], [], [], [], [], []

at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.oci8.OCIDBAccess.check_error(OCIDBAccess.java:2321)
at oracle.jdbc.oci8.OCIDBAccess.executeFetch(OCIDBAccess.java:1741)
at oracle.jdbc.oci8.OCIDBAccess.parseExecuteFetch(OCIDBAccess.java:1902)

at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.ja
va:2047)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.jav
a:1940)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:2709)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePrepar
edStatement.java:589)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStat
ement.java:656)
at com.siemens.mitc.perfreport.AggregateAndClassify.run(AggregateAndClas
sify.java:63)
at com.siemens.mitc.perfreport.INCallTSImport4.runIN(INCallTSImport4.jav
a:198)
at com.siemens.mitc.perfreport.misc.gui.MainMenu.runINData(MainMenu.java
:2307)
at com.siemens.mitc.perfreport.misc.gui.MainMenu.jButton_ImportActionPer
formed(MainMenu.java:2245)
at com.siemens.mitc.perfreport.misc.gui.MainMenu.access$2000(MainMenu.ja
va:50)
at com.siemens.mitc.perfreport.misc.gui.MainMenu$20.actionPerformed(Main
Menu.java:554)
at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:18
49)
at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.jav
a:2169)
at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel
.java:420)
at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:258
)
at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonL
istener.java:234)
at java.awt.Component.processMouseEvent(Component.java:5488)
at javax.swing.JComponent.processMouseEvent(JComponent.java:3093)
at java.awt.Component.processEvent(Component.java:5253)
at java.awt.Container.processEvent(Container.java:1966)
at java.awt.Component.dispatchEventImpl(Component.java:3955)
at java.awt.Container.dispatchEventImpl(Container.java:2024)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4212
)
at java.awt.LightweightDispatcher.processMouseEvent(Container.java:3892)

at java.awt.LightweightDispatcher.dispatchEvent(Container.java:3822)
at java.awt.Container.dispatchEventImpl(Container.java:2010)
at java.awt.Window.dispatchEventImpl(Window.java:1766)
at java.awt.Component.dispatchEvent(Component.java:3803)
at java.awt.EventQueue.dispatchEvent(EventQueue.java:463)
at java.awt.EventDispatchThread.pumpOneEventForHierarchy(EventDispatchTh
read.java:234)
at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThre
ad.java:163)
at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:157)

at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:149)

at java.awt.EventDispatchThread.run(EventDispatchThread.java:110)
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #144111 is a reply to message #122689] Tue, 25 October 2005 02:10 Go to previous messageGo to next message
orafaq_rev
Messages: 1
Registered: October 2005
Location: Bangalore
Junior Member

I know the possible reason for this error is wrong classpath/drivers, is there any other way you get this exception, may be because of nls_**.jar files that are not compatible? Any one faced such a problem?

Thank you
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #147028 is a reply to message #76449] Tue, 15 November 2005 07:27 Go to previous messageGo to next message
phobos
Messages: 1
Registered: November 2005
Junior Member
Hi there, this is my first post, i salute all the people on this forum.
I have the same problem described in this topic.

Here my configuration:

Client:
Windows XP pro SP2
Tomcat 5.0.28
Oracle 8i (8.1.7) client
Eclipse 3.1
Java 1.5.0_04 (jdk and jre)

Server:
Linux Red Hat 9
Oracle DB 9i

CLASSPATH: C:\oracle\ora81\jdbc\lib\classes12.zip;C:\oracle\ora81\jdbc\lib\nls_charset12.zip
JAVA_HOME: C:\Programmi\Java\jdk1.5.0_05
PATH: C:\oracle\ora81\bin;C:\Programmi\Oracle\jre\1.1.7\bin;%SystemRoot%\system32;
%SystemRoot%;%SystemRoot%\System32\Wbem;%JAVA_HOME%\bin;C:\oracle\ora81\jdbc\lib
TOMCAT_HOME: C:\Programmi\Tomcat 5.0

I've the patched 1.2 classes from Oracle primary site as described in this readme:

# Patch for JDBC Bug-1725012 This patch fixes a compatibility problem that shows up when
# using the 8.1.7.0 and 8.1.7.1 JDBC Thin drivers to connect to the 9i databases.
# Without this patch, you would not be able to connect to the 9i databases using
# the 8.1.7.0 and 8.1.7.1 JDBC Thin drivers.
# This patch contains the following:
# 1. This readme file
# 2. oracle/jdbc/ttc7/v8TTIoac.class
# To apply the patch, you should:
# 1. Unzip your JDBC classes12.zip or classes111.zip (depending on which JDK version you use).
# 2. Replace the old oracle/jdbc/ttc7/v8TTIoac.class with the new version.
# 3. Re-zip your zip file.

i've also put the files (classes12.zip, classes111.zip, nls_charset12.zip, ojdbc14_g.zip)
in the following dirs:

C:\Programmi\Tomcat 5.0\webapps\%APPLICATION_NAME%\WEB-INF\lib
C:\Programmi\Tomcat 5.0\common\lib
C:\oracle\ora81\jdbc\lib

i've also tried to rename classes12.zip (and the other files) to .jar

but i get the same error in the tomcat log:

java.sql.SQLException: ORA-00600: codice errore INT., argom.: [ttcgcshnd-1], [0], [], [], [], [], [], []

(the version of client is italian)

Any idea to help me to solve?

many thanx
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #152083 is a reply to message #147028] Tue, 20 December 2005 21:12 Go to previous messageGo to next message
shuklix
Messages: 1
Registered: December 2005
Location: saurabh
Junior Member
I also solved the problem by keeping correct classes12.zip file. you can find and download the same from

http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc901.htmlClick Here
icon6.gif  Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #176159 is a reply to message #77181] Wed, 07 June 2006 04:13 Go to previous messageGo to next message
chandra_sekhar_mca
Messages: 1
Registered: June 2006
Location: CHANDIGARH
Junior Member
Laughing hi, add the following jar files to the classpath ...thats all..
like
%JAVA_HOME%\bin;%JAVA_HOME%\lib\tools.jar;E:\oracle\ora92\jdbc\lib\classes12.jar;E:\oracle\ora92\jdbc\lib\classes111.jar;E:\oracle\or a92\jdbc\lib\nls_charset12.jar;

you can find all the above jar files in the folder where oracle is installed on your machine.. like e:\oracle\ora92\jdbc\lib....

make sure JAVA_HOME should be first before these jar files added to the classpath like above...

with regards
chandra_sekhar_mca@yahoo.com

[Updated on: Wed, 07 June 2006 04:16]

Report message to a moderator

Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #223341 is a reply to message #176159] Thu, 08 March 2007 08:56 Go to previous messageGo to next message
themaster_001
Messages: 1
Registered: March 2007
Junior Member
I use an oracle 9i database and i try via a webspohere application to access the database running on a Sun one 8.1 server, i got the following error:

[message=SQL error during command execution][detail=ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [], [], [], [] ]

On the Server machine, java 1.5 is installed
I tried ojdbc14.jar and nothing.
Note that the same application run fine on another Sun one 7 server.

The ping to the database wroks fine but any application with oracle 9i database.
There is others applications working fine with oracle8i on that Sun one Server 8.1.

Can some one help me?

Thanks in advance.
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd [message #223343 is a reply to message #223341] Thu, 08 March 2007 09:03 Go to previous messageGo to next message
Maaher
Messages: 7065
Registered: December 2001
Senior Member
Check out Metalink doc: 1725012.8

MHE
Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #240897 is a reply to message #76449] Sun, 27 May 2007 07:21 Go to previous messageGo to next message
mahendra_sahu
Messages: 3
Registered: May 2007
Junior Member





This Problem is caused due to Bug in oracle and happens when accessing Oracle 9.0.1 Database with JDBC 8.1.7.0.0.
This bug is caused by the mismatch between the 9i server and the 8.1.7 Jdbc-Thin clients. OERI:ttcgcshnd-1 using JDBC thin pre-9i to 9i database

You are using class12.jar of JDBC 8.1.7.0.0.

Solution:

This is fixed in the JDBC Thin Driver bundled in Database patchset 8.1.7.2 or higher version.

So use Oracle provided class12.jar
This might be from JDBC thin driver 8.1.7.2 .
Which is under \oracle\ora92\jdbc\lib\class12.jar


Re: java.sql.SQLException: ORA-00600: internal error code, arguments: [ttcgcshnd-1], [0], [], [], [] [message #240898 is a reply to message #76449] Sun, 27 May 2007 07:27 Go to previous messageGo to previous message
mahendra_sahu
Messages: 3
Registered: May 2007
Junior Member





This Problem is caused due to Bug in oracle and happens when accessing Oracle 9.0.1 Database with JDBC 8.1.7.0.0.
This bug is caused by the mismatch between the 9i server and the 8.1.7 Jdbc-Thin clients. OERI:ttcgcshnd-1 using JDBC thin pre-9i to 9i database

You are using class12.jar of JDBC 8.1.7.0.0.

Solution:

This is fixed in the JDBC Thin Driver bundled in Database patchset 8.1.7.2 or higher version.

So use Oracle provided class12.jar
This might be from JDBC thin driver 8.1.7.2 .
Which is under \oracle\ora92\jdbc\lib\class12.jar


Previous Topic: OC4J XML Parsing
Next Topic: need help for application server installation
Goto Forum:
  


Current Time: Thu Mar 28 08:51:30 CDT 2024