1678268 - ORA-03113 during the database shutdown | SAP Knowledge Base Article

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 with Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.