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










3 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. Presently, for individuals like us, startup Founders, this had been quite possibly the most foreseen occasions and glancing back at it, perhaps the most ideal approaches to begin another year with. Dr. Gőz Péter ügyvéd Debrecen

    ReplyDelete
  3. helpless economic situations and substantially more. However, the main factor that the vast majority of the startups miss is an absence of direction, motivation, and criticism from private venture counseling firms and no startup coaching. collaborative task list

    ReplyDelete

  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...