Stack Overflow
Stack Overflow

Questions tagged [ora-03113]

ORA-03113: end-of-file on communication channel

Error: ORA-03113: end-of-file on communication channel.

Cause: The connection between Client and Server process was broken.

Action: There was a communication error that requires further investigation. First, check for network problems and review the SQL*Net setup. Also, look in the alert.log file for any errors. Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

12 questions
9
votes
8 answers

ORA-03113 while executing a sql query

I have a 400 line sql query which is throwing exception withing 30 seconds ORA-03113: end-of-file on communication channel Below are things to note: I have set the timeout as 10 mins There is one last condition when removed resolves this…
Ravi Gupta
  • 4,468
  • 12
  • 54
  • 85
3
votes
4 answers

Are there limits to the number of tables that can be joined in Oracle?

I'm writing a fairly large query, and I have 2 tables, inner joined and 15 tables left-outer joined. when I add the 16, I get ORA-03113: end-of-file on communication channel. If I remove a table to add the new one, the query works fine. The query…
Phillip Parker
  • 148
  • 2
  • 9
3
votes
1 answer

error OPENing an OUT SYS_REFCURSOR with FOR UPDATE SKIP LOCKED

I'm calling a procedure (from C# via ODP.Net with Oracle.DataAccess.dll 4.112.3.0 to OracleDB 11.2.0.1 with some patches) that has an OUT SYS_REFCURSOR (let's call it pCursorOut). In the procedure, I do this: OPEN pCursorOut FOR SELECT ... FOR…
Thought
  • 700
  • 2
  • 9
  • 21
1
vote
4 answers

Oracle ODP.NET BulkCopy to temporary table issue

I'm using BulkCopy method from ODP.NET to insert a DataTable to a temporary table. If the temporary table is simple (no triggers or indexes) it works, fine, but as soon as I create an index or trigger, i get the "End-of-file on communication…
maephisto
  • 333
  • 8
  • 21
1
vote
0 answers

ORA-03113 for OracleException ODP.NET in ASP.NET

We are using ODP.NET in ASP.NET web site. Environment: ODP.NET Oracle.DataAccess, Version=4.112.2.0 on Windows Server 2008R2. IIS 7.5 Issue: From time to time, ODP.NET Oracle connection gets terminated with ORA-03113 error. Sequence of events…
Kiquenet
  • 14,494
  • 35
  • 148
  • 243
1
vote
0 answers

"end-of-file on communication channel" error with UNION of DISTINCT columns

I'm cleaning up SQL code from a previous engineer (not a programmer). One query UNIONs the results to 2 almost identical queries, with an exactly identical sub-query, and the original code has a lot of "where" clauses (in both queries) to filter the…
beschner
  • 11
  • 3
0
votes
2 answers

select statement give ora-03113 on Oracle 11

When I run next sql statement on Oracle 11g I got ora - 03113 but same statement run normal on oracle 10gr2 can any one help me on this issue SELECT /*+ INDEX_JOIN(b) */ b.child_ FROM tab1 b START WITH b.child_ IN ( SELECT…
Hasan
  • 39
  • 1
  • 4
0
votes
1 answer

why dosen't oracle database link show column with image type from sqlserver

we have 2 server : 1-sqlserver 2012 on windows 2012 2-oracle 11g on linux we want to show information from table1 in sql server on oracle database and created database link between them when i have a query like "select ID,NAME from TABLE1" in…
Morteza Zahedi
  • 3
  • 1
0
votes
2 answers

ORA-07445 access violation

I have this error when running a large query on oracle. any advice? I'm using pl sql version 10.2 I have noticed that the error is due to creating a view that is based up on many tables, and when I do a select from this view to a specific parameter…
Luci
  • 3,174
  • 7
  • 31
  • 36
0
votes
1 answer

ORA-03113: end-of-file on communication channel after os_command.exec is redirected to standard output

I am getting a weird error that I just can't figure out.... I am getting an ORA-03113 error when executing a script. I have made a dummy script that gives the essence of what is happening: declare command_line varchar2(100); v_stdout clob; v_return…
Tyler Spoon
  • 1
  • 1
0
votes
0 answers

How to enable ActiveRecord Oracle OCI8 ORA-03113 AutoRecover

I am using activerecord with oracle enhaced adapter and oci8. I am having some trouble with the ORA-03113 error. I believe that using OCI8 AutoRecover could solve my problem, though, I cannot find anywere how to tell activerecord to use this…
Pedro Rolo
  • 28,273
  • 12
  • 60
  • 94
-1
votes
2 answers

ORA-03113 end of file communication

I am running a long query(having lot of subqueries) with rownum from VB6 which is giving ORA-03113 end of file on communication after approximately 1 minute. The query run fine from Toad. When the same query is run from VB6 without ROWNUM then query…
saurabh maccani
  • 1
  • 1
  • 3