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

[jack9190]

I get "ORA-03113: end-of-file on communication channel" error when I use sqlplus from the Oracle server. If I use another client there is no problem. I cannot see any useful info in trace files. Pls help.

Oracle details:
version: 8.1.7.4 [Client loacted on another machine: 8.1.7.0]
OS: NT4 SP6a

[ggnanaraj]

Most probably, a network connectivity issue. You have to check your ping statistics from the client to server.

[jack9190]

I get the error when I use SQLPlus from the Oracle server itself. Ping and tnsping are OK.

[jovery]

Couple of things to check:

Are you running Parallel server?

Do you have the PROGRAM parameter specified in your listener.ora?

Regards

[pando]

check logs, listener.log in server side and sqlnet.log in client side

sometimes 3113 leave trace files in udump and alertSID.log, check those as well

dont trust too much tnsping, it´s only used to check if listener is up

also are you using same user to login?

[FernandoLima]

Check the swapfile.(disk space)
There's a parameter "..LISTENER_TIMEOUT.." in the listener.ora, check it out the value, and increase it if necessary.
check the Oracle Documentation.

Regards.

Fernando Lima

[jack9190]

Are you running Parallel server?

No

Do you have the PROGRAM parameter specified in your listener.ora?

No

check logs, listener.log in server side and sqlnet.log in client side

I cannot see error msg in listenner.log (as far as I can interpret). I can see error msg in sqlnet.log but I don't think it is the root cause of the problem, because the error has been happening long before the present problem. The first 2 lines of the error are :
"Fatal NI connect error 12631, connecting to:
(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) "

sometimes 3113 leave trace files in udump and alertSID.log, check those as well

I cannot see error msg in alter log file.

also are you using same user to login?

I don't think it is related to the user. I get the error after I run svrmgrl (even before trying to connect by a particular user).

There's a parameter "..LISTENER_TIMEOUT.." in the listener.ora, check it out the value, and increase it if necessary.

I cannot see _TIMEOUT entry in the listener.ora file.

-----------------------------------------------
As I can connect to the Oracle server from another client machine, I presume the problem is happening because of some client problem on the Oracle server. Do you think reinstalling the client on the Oracle server is a good idea? BTW this is a test server.

[gnagesh]

Hi

Set the mentioned parameter (sqlnet.expire_time=0) in the sqlnet.ora (both on the server side and the client side), bounce the listener and check if this error pops up again.

[jack9190]

Guys, my apologies. The problem happened because the NT domain controller was not available. After logging in as local user to the Oracle server, I can use sqlplus to connect to the Oracle server. Thanks a lot for your help.