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

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...