ORA-03113: end-of-file on communication channel
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 9 of 9

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

  1. #1
    Join Date
    Jun 2002
    Posts
    62

    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

  2. #2
    Join Date
    Sep 2000
    Location
    Chennai, India
    Posts
    865
    Most probably, a network connectivity issue. You have to check your ping statistics from the client to server.

  3. #3
    Join Date
    Jun 2002
    Posts
    62
    I get the error when I use SQLPlus from the Oracle server itself. Ping and tnsping are OK.
    Regards,
    Jack

  4. #4
    Join Date
    Jan 2002
    Location
    Up s**t creek
    Posts
    1,525
    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!

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,448
    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?

  6. #6
    Join Date
    Nov 2002
    Location
    Rio de Janeiro - Brazil
    Posts
    3
    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

  7. #7
    Join Date
    Jun 2002
    Posts
    62
    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

  8. #8
    Join Date
    Aug 2000
    Location
    Singapore
    Posts
    323
    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

  9. #9
    Join Date
    Jun 2002
    Posts
    62
    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
  •  



Click Here to Expand Forum to Full Width