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

.

Relevant Pages

  • Cancel query in 10g
    ... We are using forms 10g and would like to be able to cancel a query. ... Just setting the module to non-blocking, pops up the Oracle Cancel ... Oracle9i Enterprise Edition Release 9.2.0.7.0 - Production ...
    (comp.databases.oracle.tools)
  • No data returned from linked database
    ... I'm desperately trying to update my existing production system (Oracle 8.1.7, DBD::Oracle 1.14, on a system with a dying RAID controller) to a new system running a current version of Oracle. ... I have a database link to an RDB system via Oracle's Rdb OCI Server. ... Oracle Rdb OCI Server Release 7.3.0.0.1 - Production, ... My problem is that UNLESS I build DBD::Oracle against the 8.1.7 client I cannot query the RDB database through the database link using DBD::Oracle, even though the query works JUST FINE in SQLPlus or through a JDBC tool like DBVisualizer. ...
    (perl.dbi.users)
  • Re: Delete behaviour
    ... the query. ... PL/SQL Release 10.2.0.1.0 - Production ... Plan hash value: 1067833891 ... Oracle Ace Director & Instructor ...
    (comp.databases.oracle.server)
  • Oracle JDBC Driver ps.setTimestamp() slows down query execution many times
    ... I perform simple sql query to Oracle database, ... I can't believe that preparedStatement.setTimestampmakes Oracle ... for each version I used proper jdbc driver, ...
    (comp.lang.java.databases)
  • Re: TO_DATE function causes table scan
    ... When in production this table will grow at the rate ... of about 10,000 rows a day so I need to know if the query is going to ... One other thing to note is that I am always going to grabbing the ... Does Oracle have a silver bullet like this? ...
    (comp.databases.oracle.tools)