INSTALLATION DOCUMENTS BY RAVI

Monday, October 16, 2017

Steps for resolving the oracle database startup error " ORA-03113: end-of-file on communication channel"

When trying to start the oracle database some times we may get the below error

ORA-03113: end-of-file on communication channel
Process ID: 18413

Session ID: 247 Serial number: 29985















Please find the steps below for resolving this issue

1. Exit from the sql prompt and again connect as sysdba to an idle instance.










2. Now start the database into nomount as below







3. Now alter the database to mount as below




4. Clear the unarchived log files as below










5. Shutdown the database now






6. Start the database now and it will start without errors










2 comments:



  1. how to solve the following issue....


    SQL> alter database mount;
    alter database mount
    *
    ERROR at line 1:
    ORA-03113: end-of-file on communication channel
    Process ID: 3256
    Session ID: 130 Serial number: 3



    ReplyDelete
  2. The way you package products says a lot about your brand. If you intend to build unique inkling for your business and offerings, pay attention to detail when designing and... Politics

    ReplyDelete

Loading xml file data to oracle table using python

Sample xml file (test.xml): <?xml version="1.0"?> <data>     <customer name="Ravi" >     ...