alcurci
asked on
ORA-03113 end-of-file.... when I execute a query in SQL Plus
I execute a sql statement like this
SELECT NUMP, NUMPO, NUMOGG, NUMIDR, CDOMIC, TO_CHAR(DATEIN,'DD/MM/YYYY HH24.MI.SS') DATEIN, TO_CHAR(DATEAN,'DD/MM/YYYY HH24.MI.SS') DATEAN from TBL1 where NUMP in (4704,16765,16806) and NUMPO in (5957,5958,10166,10167,108 10)
by sql plus and the program returns a number of rows.
If I increase the number of values in the sets an error occur:
ORA-03113: end-of-file on communication channel
Oracle Database 9.2.0.1.0
Have you an idea?
Is there a limit to a statement lenght?
I've tried to modify this parameter
SQLNET.EXPIRE_TIME=10
but nothing append.
Thank you
ANNA
SELECT NUMP, NUMPO, NUMOGG, NUMIDR, CDOMIC, TO_CHAR(DATEIN,'DD/MM/YYYY
by sql plus and the program returns a number of rows.
If I increase the number of values in the sets an error occur:
ORA-03113: end-of-file on communication channel
Oracle Database 9.2.0.1.0
Have you an idea?
Is there a limit to a statement lenght?
I've tried to modify this parameter
SQLNET.EXPIRE_TIME=10
but nothing append.
Thank you
ANNA
hi
well if ur oracle DB version is 8 then its a bug in that version. because i have this problem in one my servers where i have installed my oracle 8 enterprise server.another reason is because of the network also.
regards
annamalai
well if ur oracle DB version is 8 then its a bug in that version. because i have this problem in one my servers where i have installed my oracle 8 enterprise server.another reason is because of the network also.
regards
annamalai
I have fixed this problem in the past by reinstalling the Oracle client.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
From Oracle Documentation Library:
ORA-03113: end-of-file on communication channel
Cause: An unexpected end-of-file was processed on the communication channel. The problem could not be handled by the Net8, two task, software. This message could occur if the shadow two-task process associated with a Net8 connect has terminated abnormally, or if there is a physical failure of the interprocess communication vehicle, that is, the network or server machine went down.
Action: If this message occurs during a connection attempt, check the setup files for the appropriate Net8 driver and confirm Net8 software is correctly installed on the server. If the message occurs after a connection is well established, and the error is not due to a physical failure, check if a trace file was generated on the server at failure time. Existence of a trace file may suggest an Oracle internal error that requires the assistance of customer support.