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

最新推荐文章于 2022-11-13 23:11:35 发布

原创最新推荐文章于 2022-11-13 23:11:35 发布 · 1.6k 阅读

0 ·

CC 4.0 BY-SA版权

Oracle 同时被 2 个专栏收录

523 篇文章

订阅专栏

Oracle EBS

416 篇文章

订阅专栏

在尝试关闭ASM实例时遇到ORA-15097错误，该错误在数据库关闭后出现。问题在于ASMB后台进程仍连接到ASM实例。在10g中，ASMB在无活动状态下存在300秒，而在11g中减少到3秒。解决方法是在关闭数据库后等待3分钟再关闭ASM实例。

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