-
ORA-03113: end-of-file on communication channel
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
Regards,
Jack
-
Most probably, a network connectivity issue. You have to check your ping statistics from the client to server.
-
I get the error when I use SQLPlus from the Oracle server itself. Ping and tnsping are OK.
Regards,
Jack
-
Couple of things to check:
Are you running Parallel server?
Do you have the PROGRAM parameter specified in your listener.ora?
Regards
Jim
Oracle Certified Professional
"Build your reputation by helping other people build theirs."
"Sarcasm may be the lowest form of wit but its still funny"
Click HERE to vist my website!
-
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?
-
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
-
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.
Regards,
Jack
-
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.
Nagesh
-
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.
Regards,
Jack
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|