背景：因为RAC的一个节点故障，需要关闭asm实例
数据库:Oracle 11GR2
1.切换到grid账户
[root@netrac_node02 ~]# su - grid 2.进入数据库 [grid@netrac_node02 ~]$ sqlplus "/as sysdba" 3.查看当前实例 SQL> select * from v$instance; INSTANCE_NUMBER INSTANCE_NAME --------------- ---------------- HOST_NAME ---------------------------------------------------------------- VERSION STARTUP_T STATUS PAR THREAD# ARCHIVE LOG_SWITCH_WAIT ----------------- --------- ------------ --- ---------- ------- --------------- LOGINS SHU DATABASE_STATUS INSTANCE_ROLE ACTIVE_ST BLO ---------- --- ----------------- ------------------ --------- --- 2 +ASM2 netrac_node02 11.2.0.4.0 20-FEB-17 STARTED YES 0 STOPPED ALLOWED NO ACTIVE UNKNOWN NORMAL NO 4.想直接关闭asm实例，但是没有权限，需切换之sysasm用户 SQL> shutdown immediate ORA-01031: insufficient privileges 5.切换sysasm用户，关闭实例 SQL> conn /as sysasm Connected. SQL> shutdown immediate