Saturday 22 February 2020

ORA-03113: end-of-file on communication channel on SAP Server

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
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
Database mounted.
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:

SAP HANA DB ANALYSIS AFTER ISSUES

To be able to further analyze your issue and environment please download the attached shell script you can get from KBA: 3218277 - Collectin...