Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

ORA-03113 end-of-file  in .net

Posted on 2003-03-07
4
Medium Priority
?
884 Views
Last Modified: 2013-12-12
Hi,

I am getting ora-03113 with .net as front end.

I have to send 4000 id's to a "select" statement from front end. I know i have to use "IN" option in my select statement. But "IN" doesnot support for more than 1000 ids. So I created a table(X) and inserted all 4000 ids into table and i used
"SELECT .. FROM .. WHERE id IN (SELECT id FROM X)". I tested my procedure from sql editor. IT WORKS FINE.

But same procedure if i call from front end .NET i am getting error like
"  ORA-03113 end-of-file on communication channel ". and it not at all hitting the my procedure.

I am looking for some ones help. Or Please let me know if any better way to handle 4000 ids to select satement.

I will really appreciate your help.

Regards,
venkat.
0
Comment
Question by:venkateswarlu
4 Comments
 
LVL 8

Expert Comment

by:Danielzt
ID: 8091549
Please read these:

(pay attehtion to the first two,if works, please let me know.)
http://www.oracledba.co.uk/tips/817_subqueries.htm
http://home.clara.net/dwotton/dba/ora3113.htm


http://www.experts-exchange.com/Databases/Oracle/Q_20295868.html

http://www.oracle-error.com/ora-03113.htm

http://www.dbaoncall.net/cgi-bin/ikonboard/topic.cgi?forum=1&topic=107

ORA-03113 means "end-of-file on communication channel"
It is not the problem of Oracle database or listener.
Most likely it is caused by the configuration of you network and server.

For example, on our site we have one server that is configured it that way: any user connection to the Unix box get killed if it is not active for 10 minutes.

For me it means, when I run SQL*Plus or Toad from my maching, and I do not run anything during 10 minutes I recive this error. To reistablish I have to CLOSE the SQL*Plus or TOAD and reestablish my connection.

Any way in most cases, ORA-03113 implies that you process was killed on Unix side.

http://www.experts-exchange.com/Databases/Oracle/Q_20097507.html
0
 
LVL 4

Expert Comment

by:iozturk
ID: 8140482
Did you set connection timeout parameter? If not its default to OLEdb and ODBC to 90 seconds and your query seems to run more.
0
 
LVL 22

Expert Comment

by:Helena Marková
ID: 10154412
No comment has been added lately, so it's time to clean up this TA.
I will leave a recommendation in the Cleanup topic area that this question is:

PAQ/No Refund.

Please leave any comments here within the next seven days.

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER!

Henka
EE Cleanup Volunteer
0
 
LVL 1

Accepted Solution

by:
Computer101 earned 0 total points
ID: 10214617
PAQed - no points refunded (of 125)

Computer101
E-E Admin
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
Via a live example, show how to take different types of Oracle backups using RMAN.
Suggested Courses

578 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question