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

building semantic layer
1

rror with BO

Hi:

We are running Oracle 7.3 on HP-Unix.
I am running a BO report in 5.0 and for some parameter values it runs fine, but for a particular parameter value I always get the following SQL/Oracle error: “ORA-03113: end-of-file on communication channel :-3113”.

Can anyone help me out?

Thank you,

Andreas

Listserv Archives (BOB member since 2002-06-25)

2

hann el :-3113" error with BO and In SQL Plus/Oracle MIME-Version: 1.0

there are a lot of reasons for this error, eg, its a catchall error in oracle…

you might try pinging your station, shutting it down, seeing if you can still ping it (eg, duplicate IP address somewhere)… you could look into an upgrade to your SQL*net driver…

if it’s a server side problem, you’ll see something in the alert log… if you cant see that, have the DBA check…

good luck!
brent

  • call oracle if you have support, this can be tough to fix…

From: Andreas Schneider [SMTP:aschneider@WMSGRPINTL.COM] Sent: Monday, May 07, 2001 1:30 PM

chann el :-3113" error with BO and In SQL Plus/Oracle

Hi all:

I ran the underlying SQL directly in oracle using SQL Plus. For a certain parameter value (Organization Unit = 3000) I get the same error.

Help :wink:

Thank you,

Andreas

From: Andreas Schneider
Sent: Thursday, May 03, 2001 9:18 AM

Hi:

We are running Oracle 7.3 on HP-Unix.
I am running a BO report in 5.0 and for some parameter values it runs fine,
but for a particular parameter value I always get the following SQL/Oracle error: “ORA-03113: end-of-file on communication channel :-3113”.

Can anyone help me out?

Thank you,

Andreas

Listserv Archives (BOB member since 2002-06-25)

3

hann el :-3113" error with BO and In SQL Plus/Oracle MIME-Version: 1.0

the problem is that your SQL*net packets are getting corrupted… it can happen because of the size of the result set, it can happen because of memory locations (eg, your driver is not linking correctly to your network layer), it can happen because of network traffic…

i would start with your driver(s) - get the latest SQL*net supported for your version of oracle, then consider your network driver… also, there are registry settings you can change to keep your network card ‘listening’ longer, but you will have to get that from M’soft…

good luck,
brent

From: Andreas Schneider [SMTP:aschneider@WMSGRPINTL.COM] Sent: Monday, May 07, 2001 1:58 PM

communication c hann el :-3113" error with BO and In SQL Plus/Oracle

Hi:

Pinging works fine. This is the main accounting server HP Unix. Why would it work fine for some parameters and for some not?

Andreas

you might try pinging your station, shutting it down, seeing if you can still ping it (eg, duplicate IP address somewhere)… you could look into an upgrade to your SQL*net driver…

if it’s a server side problem, you’ll see something in the alert log… if
you cant see that, have the DBA check…

brent

Hi all:

I ran the underlying SQL directly in oracle using SQL Plus. For a certain parameter value (Organization Unit = 3000) I get the same error.

Help :wink:

Thank you,

Andreas

From: Andreas Schneider
Sent: Thursday, May 03, 2001 9:18 AM

Hi:

We are running Oracle 7.3 on HP-Unix.
I am running a BO report in 5.0 and for some parameter values it runs fine,
but for a particular parameter value I always get the following
SQL/Oracle
error: “ORA-03113: end-of-file on communication channel :-3113”.

Can anyone help me out?

Thank you,

Andreas

s

Listserv Archives (BOB member since 2002-06-25)

4

Hi,
i think this is an older post.
But I have the same issue:ora-03113 end-of-communication error
Please help me out…

Regards,
Sai

saikrishnag21 :india: (BOB member since 2011-02-10)