Home / Errors/Workarounds10g / ORA-03113: END-OF-FILE ON COMMUNICATION CHANNEL

ORA-03113: END-OF-FILE ON COMMUNICATION CHANNEL

ERROR

SQL> connect / as sysdba
Connected to an idle instance.
SQL> startup;
ORACLE instance started.

Total System Global Area 1987563520 bytes
Fixed Size 2214696 bytes
Variable Size 1040188632 bytes
Database Buffers 939524096 bytes
Redo Buffers 5636096 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 5114
Session ID: 191 Serial number: 3

SOLUTION

Connect to the RMAN, and delete archive log older than a week.

$rman target /

RMAN> startup mount;

RMAN> delete archivelog until time “sysdate-7”;

OR

RMAN> delete force archivelog all;

OR

RMAN> delete backup completed before “sysdate-3”;

 

 

About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

Check Also

OracleDBconfig

Manually remove ODA DB HOME

Manually remove OLD DB HOMES if odacli-delete dbhome fails Please follow the instructions below: 1. …

Leave a Reply