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.
why option B is correct i think option D is correct.
Option B is right, Not D. Oracle prevent for this
tdaa7966:oracle:/home/oracle:+ASM2
> ps -ef | grep pmon
oracle 6947048 1 0 May 27 – 42:33 asm_pmon_+ASM2
oracle 15073362 1 0 May 27 – 41:35 ora_pmon_KXSQ101
oracle 19398680 1 0 Aug 12 – 12:03 ora_pmon_K1SQ101
oracle 32571400 1 0 Jun 13 – 35:41 ora_pmon_EAIQA101
oracle 50725820 1 0 Jul 20 – 53:32 ora_pmon_ATGB1012
oracle 6030576 6161338 3 18:25:24 pts/0 0:00 grep pmon
tdaa7966:oracle:/home/oracle:+ASM2
> echo $ORACLE_SID
+ASM2
tdaa7966:oracle:/home/oracle:+ASM2
> sqlplus / as sysasm
SQL*Plus: Release 11.2.0.3.0 Production on Fri Sep 4 18:25:43 2015
Copyright (c) 1982, 2011, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL> shutdown immediate;
ORA-15097: cannot SHUTDOWN ASM instance with connected client (process 15138840)
SQL>