背景:因为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
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
ORA-01031: insufficient privileges
5.切换sysasm用户,关闭实例
SQL> conn /as sysasm
Connected.
SQL> shutdown immediate
Connected.
SQL> shutdown immediate