Oracle9i: No more data to read from socket (ORA-03113: end-of-file ..)

[ukupatil]

Dear All,

I am working on Oracle-9i. Version details are as below:
Oracle 9i Enterprise Edition Release 9.2.0.8.0 - Production
PL/SQL Release 9.2.0.8.0 - Production

While executing following command, I am facing problem in application. So I tried with SQL PLUS and SQL Developer to execute the sql statement.
The errorsome output from both interface are as mentioned below:

CREATE TABLE TMP_PRIMARY AS
SELECT DISTINCT
EXTRACTVALUE (VALUE(TAB1), '*/DATAID' ) AS DATAID,
EXTRACTVALUE (VALUE(TAB1), '*/VERSIONNUM' ) AS VERSIONNUM,
EXTRACTVALUE (VALUE(TAB1), '*/FIRST_NAME' ) AS FIRST_NAME,
EXTRACTVALUE (VALUE(TAB1), '*/SECOND_NAME' ) AS SECOND_NAME,
EXTRACTVALUE (VALUE(TAB1), '*/THIRD_NAME' ) AS THIRD_NAME
FROM TB_XMLDOC, TABLE (XMLSEQUENCE (EXTRACT (XMLDOCUMENT, '//ENTITY' ))) TAB1
ORDER BY 1;

----SQL Developer
----========================================

Tab Name:Running: IdcConnections%23DB1.jpr
Log:
Connecting to the database DB1.
No more data to read from socket
Process exited.
Disconnecting from the database DB1.

----SQL PLUS
----========================================
Error at line 1:
ORA-03113: end-of-file on communication channel

Interestingly this query gets executed on Oracle10g with proper output.

Following are the DB parameter detailsTried by changing these values, mentioned in () )
==========================
OPEN_CURSORS ----300 Changed to (600)
CURSOR_SHARING ----EXACT Changed to (SIMILAR)
OPTIMIZER_MODE ----CHOOSE Changed to (ALL_ROWS)
PROCESSES ----150 Changed to (300)
java_pool_size ----25165824 Changed to (157286400)
shared_pool_size ----226492416 Changed to (314572800)
sga_max_size ----1091642884 Changed to (524288000)


Still I could not find out any solution, please extend your help to resolve.

Thank You,

ukupatil

 

[carp]

ukupatil -
If you check on support.oracle.com, you will find there are many possible reasons for the situation you describe. Many of these involve bugs/patches. This being the case, I would strongly recommend you open an SR with Oracle on this.