SAP Knowledge Base Article - Preview

1678268 - ORA-03113 during the database shutdown

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.0.2
  • AIX version independent

Product

SAP NetWeaver 2004 ; SAP NetWeaver 7.0 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

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.