Thursday, August 17, 2023

oracle errors and how to resolve them

 fix for ORA-03113 end-of-file on communication channel:-

1. SQLPLUS / AS SYSDBA

2. startup mount;

SQL> alter database clear unarchived logfile group 1;

Database altered.

SQL> alter database clear unarchived logfile group 2;

Database altered.
SQL> alter database clear unarchived logfile group 3;

SQL> shut immediate;
SQL> startup ;

No comments:

Post a Comment

opatchauto

# Log in as root su - root # Execute opatchauto against the unzipped patch directory /u01/app/19.0.0/ grid /OPatch/opatchauto apply /tmp/pat...