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

[_Olga_]

Hello!

I have next problem.

How can I solve it?

Thanks for help.

Table libOra.table has 24 991 461 records.

Code:

libname libOra ORACLE SCHEMA=myschema PATH=mypath USER='myuser' PASSWORD="mypass";

libname libSAS '/mypath';

data libSAS.table (compress=char);

set libOra.table;

run;　

Log:

ERROR: Error fetching from cursor. ORACLE error is ORA-03113: end-of-file on communication channel

NOTE: The DATA step has been abnormally terminated.

NOTE: The SAS System stopped processing this step because of errors.

NOTE: There were 17448750 observations read from the data set libOra.table.

WARNING: The data set libSAS.table may be incomplete.　 When this step was stopped there were 17448750 observations and 34

　　　　　　　　　variables.

NOTE: Compressing data set libSAS.table decreased size by 81.80 percent.

　　　　　　Compressed is 397068 pages; un-compressed would require 2181094 pages.

WARNING: Data set libSAS.table was not replaced because this step was stopped.

NOTE: DATA statement used (Total process time):

　　　　　 real time　　　　　　　　　　 13:23:03.33

　　　　　 cpu time　　　　　　　　　　　 15:16.03

[Kurt_Bremser · Accepted solution]

The error is internal between the Oracle server and the Oracle client (that SAS uses for the connection). The most likely cause (IMO) is a network problem.

Maybe one of the routers/firewalls in between cuts off the connection after a given time?

See http://www.orafaq.com/wiki/ORA-03113

[Bipasha]

Hi.

I am having the same issue.

Can you tell me how you have resolved the issue?

[SASKiwi]

Just guessing but I suspect that there is a timeout rule on the SAS  - Oracle communications channel / port, possibly caused by a firewall around your SAS or Oracle server. I suggest you check with your SAS administrators or your IT network specialists to get them to check this out.

[Kurt_Bremser]

---

@SASKiwi wrote:

Just guessing but I suspect that there is a timeout rule on the SAS  - Oracle communications channel / port, possibly caused by a firewall around your SAS or Oracle server. I suggest you check with your SAS administrators or your IT network specialists to get them to check this out.

---

Two minds, one thought 😉

Across the globe, at that!