分类:
2012-06-13 22:13:03
原文地址:11gR2 停止ASM服务进程 作者:zrp999
[grid@t_rac_one:~]# sqlplus sys/Xinao332014 as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 7 01:14:40 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.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
SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
[grid@t_rac_one:~]# crsctl stop crs
CRS-4563: Insufficient user privileges.
CRS-4000: Command Stop failed, or completed with errors.
解决办法:
使用root用户执行该命令 :
但需注意命令的路径没有在root的PATH里面,因此需要进入grid_home/bin目录下执行
[root@t_rac_two:~]# cd /u01/app/11.2.0/grid/bin
[root@t_rac_two:/u01/app/11.2.0/grid/bin]# ./crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on 't_rac_two'
CRS-2673: Attempting to stop 'ora.crsd' on 't_rac_two'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 't_rac_two'
CRS-2673: Attempting to stop 'ora.asm' on 't_rac_two'
CRS-2677: Stop of 'ora.asm' on 't_rac_two' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 't_rac_two' has completed
CRS-2677: Stop of 'ora.crsd' on 't_rac_two' succeeded
CRS-2673: Attempting to stop 'ora.mdnsd' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.gpnpd' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.ctssd' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.evmd' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.asm' on 't_rac_two'
CRS-2677: Stop of 'ora.cssdmonitor' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.mdnsd' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.evmd' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.gpnpd' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.ctssd' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.asm' on 't_rac_two' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 't_rac_two'
CRS-2677: Stop of 'ora.cssd' on 't_rac_two' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.gipcd' on 't_rac_two'
CRS-2677: Stop of 'ora.gipcd' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.diskmon' on 't_rac_two' succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on 't_rac_two' has completed
CRS-4133: Oracle High Availability Services has been stopped.
检查:
[root@t_rac_two:/u01/app/11.2.0/grid/bin]# ./crsctl status res -t
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4000: Command Status failed, or completed with errors.
相关进程服务己不存在,说明己停止。
[grid@t_rac_one:~]# crsctl stop res -all
CRS-2500: Cannot stop resource 'ora.eons' as it is not running
CRS-2500: Cannot stop resource 'ora.health.db' as it is not running
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 't_rac_one'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.ons' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.oc4j' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.gsd' on 't_rac_two'
CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 't_rac_one'
CRS-2673: Attempting to stop 'ora.CRSDATA.dg' on 't_rac_one'
CRS-2673: Attempting to stop 'ora.DBDATA.dg' on 't_rac_one'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 't_rac_one'
CRS-2673: Attempting to stop 'ora.CRSDATA.dg' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.DBDATA.dg' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.FRA.dg' on 't_rac_two'
CRS-2677: Stop of 'ora.ons' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 't_rac_two' succeeded
CRS-2673: Attempting to stop 'ora.t_rac_two.vip' on 't_rac_two'
CRS-2677: Stop of 'ora.t_rac_two.vip' on 't_rac_two' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 't_rac_two'
CRS-2677: Stop of 'ora.net1.network' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.gsd' on 't_rac_two' succeeded
CRS-2789: Cannot stop resource 'ora.gsd' as it is not running on server 't_rac_two'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 't_rac_one' succeeded
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 't_rac_one'
CRS-2673: Attempting to stop 'ora.t_rac_one.vip' on 't_rac_one'
CRS-2677: Stop of 'ora.t_rac_one.vip' on 't_rac_one' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 't_rac_one' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 't_rac_one'
CRS-2677: Stop of 'ora.scan1.vip' on 't_rac_one' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 't_rac_one'
CRS-2677: Stop of 'ora.net1.network' on 't_rac_one' succeeded
CRS-2677: Stop of 'ora.CRSDATA.dg' on 't_rac_one' succeeded
CRS-2677: Stop of 'ora.CRSDATA.dg' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 't_rac_one' succeeded
CRS-2677: Stop of 'ora.DBDATA.dg' on 't_rac_one' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 't_rac_one'
CRS-2677: Stop of 'ora.FRA.dg' on 't_rac_two' succeeded
CRS-2677: Stop of 'ora.DBDATA.dg' on 't_rac_two' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 't_rac_two'
CRS-2673: Attempting to stop 'ora.asm' on 't_rac_two'
ORA-15097: cannot SHUTDOWN ASM instance with connected client
CRS-2675: Stop of 'ora.asm' on 't_rac_two' failed
CRS-2675: Stop of 'ora.asm' on 't_rac_two' failed
CRS-2673: Attempting to stop 'ora.asm' on 't_rac_one'
ORA-15097: cannot SHUTDOWN ASM instance with connected client
CRS-2675: Stop of 'ora.asm' on 't_rac_one' failed
CRS-2675: Stop of 'ora.asm' on 't_rac_one' failed
CRS-2677: Stop of 'ora.oc4j' on 't_rac_two' succeeded
CRS-4000: Command Stop failed, or completed with errors.
[grid@t_rac_one:~]# crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRSDATA.dg
OFFLINE OFFLINE t_rac_one
OFFLINE OFFLINE t_rac_two
ora.DBDATA.dg
OFFLINE OFFLINE t_rac_one
OFFLINE OFFLINE t_rac_two
ora.FRA.dg
OFFLINE OFFLINE t_rac_one
OFFLINE OFFLINE t_rac_two
ora.LISTENER.lsnr
OFFLINE OFFLINE t_rac_one
OFFLINE OFFLINE t_rac_two
ora.asm
OFFLINE ONLINE t_rac_one Started
OFFLINE ONLINE t_rac_two Started
ora.eons
OFFLINE OFFLINE t_rac_one
OFFLINE OFFLINE t_rac_two
ora.gsd
OFFLINE OFFLINE t_rac_one
OFFLINE OFFLINE t_rac_two
ora.net1.network
OFFLINE OFFLINE t_rac_one
OFFLINE OFFLINE t_rac_two
ora.ons
OFFLINE OFFLINE t_rac_one
OFFLINE OFFLINE t_rac_two
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 OFFLINE OFFLINE
ora.health.db
1 OFFLINE OFFLINE Instance Shutdown
2 OFFLINE OFFLINE Instance Shutdown
ora.oc4j
1 OFFLINE OFFLINE
ora.scan1.vip
1 OFFLINE OFFLINE
ora.t_rac_one.vip
1 OFFLINE OFFLINE
ora.t_rac_two.vip
1 OFFLINE OFFLINE
[grid@t_rac_one:~]# sqlplus sys/Xinao332014 as sysasm
SQL*Plus: Release 11.2.0.1.0 Production on Thu Jul 7 01:14:40 2011
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.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
SQL>