oraleRAC验证以及ORACLE11GR2启动与关闭(二)

2014-11-24 16:55:46 · 作者: · 浏览: 1
listener是oracle网络远程监听器也就是scan vip的监听参数。

另外还可以手动将服务名动态注册到本地监听和远程监听上:alter system register;

查看Rac资源信息:

[grid@rac-two ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS       
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATADG.dg
               ONLINE  ONLINE       rac-one                                      
               ONLINE  ONLINE       rac-two                                      
ora.GIDG.dg
               ONLINE  ONLINE       rac-one                                      
               ONLINE  ONLINE       rac-two                                      
ora.LISTENER.lsnr
               ONLINE  ONLINE       rac-one                                      
               ONLINE  ONLINE       rac-two                                      
ora.asm
               ONLINE  ONLINE       rac-one                  Started             
               ONLINE  ONLINE       rac-two                  Started             
ora.gsd
               OFFLINE OFFLINE      rac-one                                      
               OFFLINE OFFLINE      rac-two                                      
ora.net1.network
               ONLINE  ONLINE       rac-one                                      
               ONLINE  ONLINE       rac-two                                      
ora.ons
               ONLINE  ONLINE       rac-one                                      
               ONLINE  ONLINE       rac-two                                      
ora.registry.acfs
               ONLINE  ONLINE       rac-one                                      
               ONLINE  ONLINE       rac-two                                      
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
      1        ONLINE  ONLINE       rac-two                                      
ora.LISTENER_SCAN2.lsnr
      1        ONLINE  ONLINE       rac-one                                      
ora.LISTENER_SCAN3.lsnr
      1        ONLINE  ONLINE       rac-one                                      
ora.cvu
      1        ONLINE  ONLINE       rac-one                                      
ora.oc4j
      1        ONLINE  ONLINE       rac-one                                      
ora.rac-one.vip
      1        ONLINE  ONLINE       rac-one                                      
ora.rac-two.vip
      1        ONLINE  ONLINE       rac-two                                      
ora.rac.db
      1        ONLINE  ONLINE       rac-two                  Open                
      2        ONLINE  ONLINE       rac-one                  Open                
ora.scan1.vip
      1        ONLINE  ONLINE       rac-two                                      
ora.scan2.vip
      1        ONLINE  ONLINE       rac-one                                      
ora.scan3.vip
      1        ONLINE  ONLINE       rac-one                                      
[grid@rac-two ~]$ 


关闭rac:

1、关闭数据库

/u01/app/11.2.0/grid/bin/srvctl stop database -d Rac

2、查看数据库状态:

[root@rac-one ~]# /u01/app/11.2.0/grid/bin/srvctl status database -d Rac
Instance Rac2 is not running on node rac-one
Instance Rac1 is not running on node rac-two
[root@rac-one ~]# 


2、关闭Rac所有节点的asm以及集群:

[root@rac-one ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'rac-one'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac-one'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'rac-one'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'rac-one'
CRS-2673: Attempting to stop 'ora.oc4j' on 'rac-one'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'rac-one'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac-one'
CRS-2673: Attempting to stop 'ora.GIDG.dg' on 'rac-one'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'rac-one'
CRS-2673: Attempting to stop 'ora.DATADG.dg' on 'rac-one'
CRS-2677: Stop of 'ora.cvu' on 'rac-one' succeeded
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.rac-one.vip' on 'rac-one'
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'rac-one'
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'rac-one' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'rac-one'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac-two'
CRS-2677: Stop of 'ora.scan3.vip' on 'rac-one' succeeded
CRS-2677: Stop of 'ora.rac-one.vip' on 'rac-one' succeeded
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'rac-two'
CRS-2677: Stop of 'o