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.
version: 184.108.40.206 [Client loacted on another machine: 220.127.116.11]
OS: NT4 SP6a
Do you have the PROGRAM parameter specified in your listener.ora?
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:
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.
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.