Forgot your password?    
+ Reply to Thread
Results 1 to 2 of 2

Thread: server error ORA-03113

  1. #1

    server error ORA-03113

    ORA-03113: end-of-file on communication channel
    Process ID: 11300
    Session ID: 96 Serial number: 3


    unable to do any work on the server, please find the solution for above problem

  2. #2
    Oracle DBA
    Join Date
    Mar 2013
    Location
    [India]->[Kuwait]->[India]
    Posts
    11
    ORA-03113: end-of-file on communication channel
    How do I fix this ORA-03113 error?
    Answer: Use the oerr utility to get the details for the ORA-03113 error:
    ORA-03113: end-of-file on communication channel
    Cause: The connection between Client and Server process was broken.
    Action: There was a communication error that requires further investigation.
    • First, check for network problems and review the SQL*Net setup.
    • Also, look in the alert.log file for any errors.
    • Finally, test to see whether the server process is dead and whether a trace file was generated at failure time.

    The ORA-03113: end-of-file on communication channel error is a generic error. The ORA-03113 error when connecting suggests that the connection was established, but lost later, like a timeout.
    Note: Windows users report ORA-03113 errors from non-Oracle issues like Windows logs becoming full.
    There are many possible causes for the ORA-03113 error. It is a "catch-all" type error which means "I cannot communication with the Oracle shadow process." This usually happens when the Oracle server process has died for some reason.
    See MOSC Note:17613.1 "ORA-03113":
    For example, ORA-03113 could be signaled for any of these scenarios:
    • Server machine crashed
    • Your server process was killed at O/S level
    • Network problems
    • Oracle internal errors / aborts on the server
    • Client incorrectly handling multiple connections
    • etc.. etc.. etc.. - a lot of possible causes !!
    It goes on to note that the ORA-03113 End-Of-File error often has additional messages:
    It is common for this error to be accompanied by other errors such as:
    • ORA-01041 internal error. hostdef extension doesn't exist
    Oracle support will likely need more information to determine what caused the error.
    The most useful items are:
    1. Does this occur when trying to (a) make a connection to the database or
      (b) on an established connection ?
    2. Check for a trace file from the failed session in USER_DUMP_DEST and BACKGROUND_DUMP_DEST directories.
    3. Does a particular statement reproduce this problem or is it random ? Use SQL_TRACE on the session to find the problem statement.
    Oracle MOSC documents also reveal that, "ORA-03113 is received when running catpatch after applying the 9.2.0.5 or 9.2.0.6 patchset".
    --
    regards
    Mohammad Shahnawaz
    Kuwait []
    skype-shahnawazm786

+ Reply to Thread

Similar Threads

  1. Rac 11gR2 Server Pool
    By Hemant in forum RAC Performance,LoadBalancing,TAF,FAN,Troubleshooting
    Replies: 0
    Last Post: 11-15-2012, 06:51 PM
  2. Forms server troubleshooting
    By saioracleappsdba in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 1
    Last Post: 06-15-2012, 04:47 AM
  3. OIM Self Service Console- An error occurred while searching tasks from the SOA Server
    By Hemant in forum Oracle Fusion Middleware 11G - OIM , OAM , ODS , Weblogic , Webgate ..
    Replies: 0
    Last Post: 04-18-2012, 02:40 AM
  4. Tools & commands for analyzing server performance.
    By ajaychandi in forum OS for Oracle Administration
    Replies: 0
    Last Post: 03-12-2012, 06:50 PM
  5. Enable Logging on HTTP Web Server/Apache
    By Amit in forum Concepts,Service Management,Apache,OC4J,OPMN,JServ,Forms, Issues,Troubleshooting,
    Replies: 0
    Last Post: 11-01-2011, 11:24 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

DBA Lounge (P) Ltd. deals in Oracle Technologies on Consulting, Resourcing, Corporate Training


Online and corporate training available on Oracle Database 11g, Oracle 11g Real Application Cluster (RAC), Oracle Applications 11i/R12, Oracle Fusion Middleware 11g, Oracle Identity Management-OIM, Oracle Internet Directory 11g-OID, Oracle Business Intelligence Enterprise Edition-OBIEE, Oracle Golden Gate, Oracle Access Management-OAM, Oracle Internet Directory-ODS, Oracle Identity Analytics Architecture-OIA Statistics