Chinaunix首页 | 论坛 | 博客
  • 博客访问: 827717
  • 博文数量: 101
  • 博客积分: 1311
  • 博客等级: 中尉
  • 技术积分: 1191
  • 用 户 组: 普通用户
  • 注册时间: 2009-07-25 12:15
文章分类

全部博文(101)

文章存档

2012年(101)

分类: Oracle

2012-06-12 21:34:46

[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用户执行该命令

 但需注意命令的路径没有在rootPATH里面,因此需要进入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>

阅读(6288) | 评论(0) | 转发(1) |
给主人留下些什么吧!~~