Symptom
While trying to shutdown the database, you receive the following error:
Database closed.
Database dismounted.
ORA-03113: end-of-file on communication channel
Disconnected from Oracle Database 11g Enterprise Edition Release
11.2.0.2.0 - 64bit Production
Issue is also seeing while installing a new environment with SAPINST during Oracle post-load activites. The error message is the same.
The error may also be seen while trying to execute an offline backup of the Oracle database:
BR0307I Shutting down database instance <SID> ...
BR0278E Command output of '/oracle/<SID>/112_64/bin/sqlplus /nolog
< /oracle/<SID>/sapbackup/.<logname>.spi':
SQL*Plus: Release 11.2.0.2.0 Production on Sat Dec 10 16:31:42 2011
Copyright (c) 1982, 2010, Oracle. All rights reserved.
SQL> SQL> SQL> Connected.
SQL> csh: The file access permissions do not allow the specified action.
SQL> Database closed.
Database dismounted.
ORA-03113: end-of-file on communication channel
SQL> Disconnected from Oracle Database 11g Enterprise Edition Release
11.2.0.2.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing
options
BR0280I BRBACKUP time stamp: 2011-12-10 16.31.57
BR0279E Return code from '/oracle/<SID>/112_64/bin/sqlplus /nolog
< /oracle/<SID>/sapbackup/.<logname>.spi': 0
BR0302E SQLPLUS call for database instance <SID> failed
This issue may also show up with different situations involving a database shutdown. And it may also occurs for Oracle 11.2.0.3 as well.
Read more...
Environment
- Oracle database 11.2
- AIX version independent
- Not restricted to any SAP Product
Product
Keywords
Oracle, shutdown, ORA-03113, AIX, brbackup, BR*Tools, brtools, 11g, 11.2.0.2, APAR, sapinst , KBA , BC-DB-ORA , Oracle , BC-DB-ORA-DBA , Database Administration , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.