ora 03113 end-of-file communication

ora 03113 end-of-file communication

Its a very strange very and very unsual problem which makes your day ruin.

Reason : The root cause for the ORA 03113 seems to be linked with the archivelogs of oracle. Usually the space is main reson which stops oracle service to continue with logging. When no space left, oracle will automatically stop its failover service and database and you... you don't known any thing...

Resolution : Now note that, Oracle have many services and instances depends on your configuration during installation.
Check the resources and services on oracle at first step by :
STEP 1
from oracle user
1 - srvctl status service -d SERVICE_NAME: check the status of service
2 - srvctl status database -d SERVICE_NAME: check the status of database

Now from above command check whether ur database and service is up or not. Now trying to start by following commands
1 - srvctl start service -d SERVICE_NAME
Now on starting database or service, if u saw ORA- 03113, then now its time to proceed to next step.

Now we are going to get to the exact solution for the end-of-file communication problem:
1 : Login into the problematic machine through oracle db user and export the ORACLE_SID properly:
After login perform following commands and connect on sql through sysdba asSQL> connect / as sysdba

Connected to an idle instance.
SQL> startup;
ORACLE instance started.


On the RMAN tool, delete archivelog older than a week.
# rman target /

RMAN> startup mount;
RMAN> delete force archivelog all;



Now just restart your oracle failover service and enjoy the moment,,, ,don't forget to comment and follow. :)

JUST BELIEVE IN TECHNOLOGY...... LIKE AND COMMENT ON POST