As per article Heading explain How We can fix ORA-03113 end-of-file on communication channel Error:
Observation of Problem:
SOLUTION : Follow below steps:
sqlplus /nolog
SQL*Plus: Release 12.1.0.2.0 Production on Wed Feb 22 10:11:09 2020
Copyright (c) 1982, 2014, Oracle. All rights reserved.
SQL> connect as sysdbaEnter Username:Enter Password:
( used oracle administration username password )
SQL>Connected to an idle instance.
SQL>startup nomountORACLE instance started.
Total System Global Area 7147094016 bytes
Fixed Size 3062008 bytes
Variable Size 3573548808 bytes
Database Buffers 3556769792 bytes
Redo Buffers 13713408 bytes
Fixed Size 3062008 bytes
Variable Size 3573548808 bytes
Database Buffers 3556769792 bytes
Redo Buffers 13713408 bytes
SQL> alter database mount;
Database altered.
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;
Database altered.
SQL> shutdown immediateORA-01109: database not openDatabase dismounted.ORACLE instance shut down.
SQL> startup
(startup command for Oracle Database)
ORACLE instance started.
Total System Global Area 7147094016 bytes
Fixed Size 3062008 bytes
Variable Size 3573548808 bytes
Database Buffers 3556769792 bytes
Redo Buffers 13713408 bytes
Fixed Size 3062008 bytes
Variable Size 3573548808 bytes
Database Buffers 3556769792 bytes
Redo Buffers 13713408 bytes
Database mounted.
Database opened.
Database opened.
SQL> exit.
All above steps are follows and resolved the Error log on SAP Database connection issue with application and database.
No comments:
New comments are not allowed.