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


  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

  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

  3. 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

  4. 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


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...