ORA-00600 internal error code

Thread view:

tkonrath@gmx.at - 12 Dec 2006 09:39 GMT

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

Reply to this Message

Juha Laiho - 12 Dec 2006 19:47 GMT

tkonrath@gmx.at said:

>Wie having the follwing problem in our java Web Application:
>
[quoted text clipped - 3 lines]
>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).

Signature

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)

Reply to this Message

ORA-00600 internal error code

Free Magazines