AppletTalk.com Java discussions newsgroups   Archives   FAQ   Search   Memberlist   Usergroups   Register   Profile   Log in to check your private messages   Log in  ORA-00600 internal error code          AppletTalk.com Forum Index -> Java and Databases View previous topic :: View next topic   Author Message Guest Posted: Tue Dec 12, 2006 3:39 pm    Post subject: ORA-00600 internal error code Hi ... Wie having the follwing problem in our java Web Application: We have a table with a column of VARCHAR2(255) with an text index using ctxsys. Entering a serch for this column in our application creates an SQL query with an cointains in the where clause. This Query raises an Error in our Web-Applikation: Caused by: java.sql.SQLException: No more data to read from socket at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134) at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179) at oracle.jdbc.dbaccess.DBError.check_error(DBError.java:1160) at oracle.jdbc.ttc7.MAREngine.unmarshalUB1(MAREngine.java:963) at oracle.jdbc.ttc7.MAREngine.unmarshalSB1(MAREngine.java:893) at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:369) at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1891) at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:1093) In the allert file, oracle writes the following message: Tue Dec 12 09:40:36 2006 Errors in file d:\oracle\admin\sag\udump\sag_ora_1028.trc: ORA-00600: internal error code, arguments: [kpotcfnd-3], [Invalid Handle], [], [], [], [], [], [] The trace file contains: Dump file d:\oracle\admin\sag\udump\sag_ora_1028.trc Tue Dec 12 09:40:36 2006 ORACLE V9.2.0.6.0 - Production vsnsta=0 vsnsql=12 vsnxtr=3 Windows 2000 Version 5.2 Service Pack 1, CPU type 586 Oracle9i Release 9.2.0.6.0 - Production JServer Release 9.2.0.6.0 - Production Windows 2000 Version 5.2 Service Pack 1, CPU type 586 Instance name: sag Redo thread mounted by this instance: 1 Oracle process number: 37 Windows thread id: 1028, image: ORACLE.EXE *** SESSION ID:(36.27) 2006-12-12 09:40:36.254 *** 2006-12-12 09:40:36.254 ksedmp: internal or fatal error ORA-00600: internal error code, arguments: [kpotcfnd-3], [Invalid Handle], [], [], [], [], [], [] Followed by the SQL Query. This error cause an other error: After this, no new connection to the database instanz can be establiched!!! Connections, which are alredy created, working fine. How can this be???? If we execute this query in our SQL Client, the query is executed without any problems very fast. So, were is here the problem? We using: Oracle 9.2.0.7 Tomcat 4.25 Windows XP Please help or give my a hint how to solve this problem Back to top Juha Laiho Guest Posted: Wed Dec 13, 2006 1:47 am    Post subject: Re: ORA-00600 internal error code tkonrath (AT) gmx (DOT) at said: Quote: Wie having the follwing problem in our java Web Application: We have a table with a column of VARCHAR2(255) with an text index using ctxsys. Entering a serch for this column in our application creates an SQL query with an cointains in the where clause. This Query raises an Error in our Web-Applikation: Caused by: java.sql.SQLException: No more data to read from socket .... In the allert file, oracle writes the following message: Tue Dec 12 09:40:36 2006 Errors in file d:\oracle\admin\sag\udump\sag_ora_1028.trc: ORA-00600: internal error code, arguments: [kpotcfnd-3], [Invalid Handle], [], [], [], [], [], [] Typically ORA-00600 errors are something you handle through Oracle support -- they really are Oracle internal errors, often caused by a bug in the database server itself. So, at least search the Oracle Metalink support site for that error message (including the arguments), if you have access to Metalink (a valid support contract is required, I think). -- Wolf a.k.a. Juha Laiho Espoo, Finland (GC 3.0) GIT d- s+: a C++ ULSH++++$ P++@ L+++ E- W+$@ N++ !K w !O !M V PS(+) PE Y+ PGP(+) t- 5 !X R !tv b+ !DI D G e+ h---- r+++ y++++ "...cancel my subscription to the resurrection!" (Jim Morrison) Back to top Display posts from previous: All Posts1 Day7 Days2 Weeks1 Month3 Months6 Months1 Year Oldest FirstNewest First         AppletTalk.com Forum Index -> Java and Databases All times are GMT Page 1 of 1   Jump to: Select a forum Java Newsgroups----------------Java DiscussionsWeb-based java games comp.lang.java 3D Graphics API's for Java Java: Support and criticism Java System Announcements comp.lang.java.api JavaBeans Java and CORBA Java and Databases comp.lang.java.developer Java GUI Toolkits Java Help comp.lang.java.javascript JVM, native methods and hardware comp.lang.java.misc Java Language Programming Security and Java comp.lang.java.setup Java Software Tools comp.lang.java.tech ibm.software.java.linux  Non-English Java Newsgroups----------------Java Language (German)Language Java (Français)Java (Italian)  You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum Powered by phpBB © 2001, 2006 phpBB Group SEO toolkit © 2004-2006 webmedic.