本文探讨了在三个生产数据库（HRDB、FINDB 和 ORGDB）同时运行的情况下，尝试使用 IMMEDIATE 模式关闭ASM实例所产生的结果。文章指出，由于存在连接的RDBMS实例，该操作将导致错误，并解释了相关的原因。
77.You have three production databases, HRDB, FINDB, and ORGDB, that use the same ASM instance.
At the end of the day, while all three production database instances are running, you execute the following
command on the ASM instance :
SQL> shutdown immediate;
What is the result of executing this command?
A. The ASM instance is shut down, but the other instances are still running.
B. It results in an error because other database instances are connected to it.
C. All the instances, including the ASM instance, are shut down in the IMMEDIATE mode.
D. HRDB, FINDB, and ORGDB instances are shut down in the ABORT mode and the ASM instance is
shut down in the IMMEDIATE mode.
Answer: B
答案解析：
参考：http://blog.csdn.net/rlhua/article/details/12972983
有连接的RDBMS 实例时，不应用NORMAL、IMMEDIATE和 TRANSACTIONAL形式的关闭，而将返回下面的错误：
SQL> shutdown
ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 14372)
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
