oracle 10.2.0.1 ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance

来源：互联网发布：奥迪a4l矩阵大灯视频编辑：程序博客网时间：2024/05/16 04:32

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options
[oracle@db ~]$ export ORACLE_SID=+ASM
[oracle@db ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on Sun May 12 10:07:18 2013

Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.1.0 - Production
With the Partitioning, OLAP and Data Mining options

SQL> shutdown immediate
ORA-15097: cannot SHUTDOWN ASM instance with connected RDBMS instance

ORA-15097 OCCUR WHEN ASM SHUTDOWN AFTER DB SHUTDOWN [ID 1089904.1]

修改时间:2013-2-22类型:HOWTO状态:PUBLISHED优先级:3 注释 (0)

In this Document
Goal
Fix
References

--------------------------------------------------------------------------------

Applies to:
Oracle Database - Enterprise Edition - Version 10.1.0.2 to 10.2.0.4 [Release 10.1 to 10.2]
Information in this document applies to any platform.
***Checked for relevance on 22-02-2013***
Goal
You have shutdown the database and are now shutting down the ASM instance. However, you receive an error ORA-15097 : cannot SHUTDOWN ASM instance with connected RDBMS instance. This error is fixed in the 11.1.0.6 version of ASM.

Fix
To workaround the bug 6443217 ORA-15097 OCCUR WHEN ASM SHUTDOWN AFTER DB SHUTDOWN, you must do the following:

1. Wait 3 minutes after shutting down the database.

2. Then you can shutdown the ASM instance without receiving an error.

Reason:

This issue is because ASMB background process is still connected to ASM instance. In 10g, ASMB exists for 300 seconds if it is inactive. Then the process terminates itself.

Changed in 11g to only 3 seconds of inactivity before it will receive termination notice to the ASMB background process.

References
BUG:6443217 - ORA-15097 OCCUR WHEN ASM SHUTDOWN AFTER DB SHUTDOWN