ITPub博客

首页 > 数据库 > Oracle > 管理11gRAC基本命令

管理11gRAC基本命令

原创 Oracle 作者:jelephant 时间:2014-02-11 15:15:59 0 删除 编辑
在 Oracle Clusterware 11g 第 2 版 (11.2) 中,有许多子程序和命令已不再使用:
    crs_stat
    crs_register
    crs_unregister
    crs_start
    crs_stop
    crs_getperm
    crs_profile
    crs_relocate
    crs_setperm
    crsctl check crsd
    crsctl check cssd
    crsctl check evmd
    crsctl debug log
    crsctl set css votedisk
    crsctl start resources
    crsctl stop resources

检查集群的运行状况 —(集群化命令)

    以 grid 用户身份运行以下命令。

    [grid@racnode1 ~]$ crsctl check cluster
    CRS-4537: Cluster Ready Services is online
    CRS-4529: Cluster Synchronization Services is online
    CRS-4533: Event Manager is online

所有 Oracle 实例 —(数据库状态)

    [oracle@racnode1 ~]$ srvctl status database -d racdb
    Instance racdb1 is running on node racnode1
    Instance racdb2 is running on node racnode2

单个 Oracle 实例 —(特定实例的状态)

    [oracle@racnode1 ~]$ srvctl status instance -d racdb -i racdb1
    Instance racdb1 is running on node racnode1

节点应用程序 —(状态)

    [oracle@racnode1 ~]$ srvctl status nodeapps
    VIP racnode1-vip is enabled
    VIP racnode1-vip is running on node: racnode1
    VIP racnode2-vip is enabled VIP racnode2-vip is running on node: racnode2
    Network is enabled Network is running on node: racnode1
    Network is running on node: racnode2 GSD is disabled
    GSD is not running on node: racnode1
    GSD is not running on node: racnode2
    ONS is enabled
    ONS daemon is running on node: racnode1
    ONS daemon is running on node: racnode2
    eONS is enabled eONS daemon is running on node: racnode1
    eONS daemon is running on node: racnode2

节点应用程序 —(配置)

    [oracle@racnode1 ~]$ srvctl config nodeapps
    VIP exists.:racnode1 VIP exists.: /racnode1-vip/192.168.1.251/255.255.255.0/eth0
    VIP exists.:racnode2
    VIP exists.: /racnode2-vip/192.168.1.252/255.255.255.0/eth0
    GSD exists.
    ONS daemon exists. Local port 6100, remote port 6200
    eONS daemon exists. Multicast port 24057, multicast IP address 234.194.43.168,
    listening port 2016

数据库 —(配置)

    [oracle@racnode1 ~]$ srvctl config database -d racdb -a
    Database unique name: racdb
    Database name: racdb
    Oracle home: /u01/app/oracle/product/11.2.0/dbhome_1
    Oracle user: oracle
    Spfile: +RACDB_DATA/racdb/spfileracdb.ora
    Domain: idevelopment.info
    Start options: open
    Stop options: immediate
    Database role: PRIMARY
    Management policy: AUTOMATIC
    Server pools: racdb
    Database instances: racdb1,racdb2
    Disk Groups: RACDB_DATA,FRA
    Services:  
    Database is enabled
    Database is administrator managed

ASM —(状态)

    [oracle@racnode1 ~]$ srvctl status asm
    ASM is running on racnode1,racnode2

ASM —(配置)

    $ srvctl config asm -a
    ASM home: /u01/app/11.2.0/grid
    ASM listener: LISTENER
    ASM is enabled.

TNS 监听器 —(状态)

    [oracle@racnode1 ~]$ srvctl status listener
    Listener LISTENER is enabled
    Listener LISTENER is running on node(s): racnode1,racnode2

TNS 监听器 —(配置)

    [oracle@racnode1 ~]$ srvctl config listener -a
    Name: LISTENER
    Network: 1, Owner: grid
    Home:  
     /u01/app/11.2.0/grid on node(s) racnode2,racnode1
    End points: TCP:1521

SCAN —(状态)

    [oracle@racnode1 ~]$ srvctl status scan
    SCAN VIP scan1 is enabled
    SCAN VIP scan1 is running on node racnode1

SCAN —(配置)

    [oracle@racnode1 ~]$ srvctl config scan
    SCAN name: racnode-cluster-scan, Network: 1/192.168.1.0/255.255.255.0/eth0
    SCAN VIP name: scan1, IP: /racnode-cluster-scan/192.168.1.187

VIP —(特定节点的状态)

    [oracle@racnode1 ~]$ srvctl status vip -n racnode1
    VIP racnode1-vip is enabled
    VIP racnode1-vip is running on node: racnode1  

    [oracle@racnode1 ~]$ srvctl status vip -n racnode2
    VIP racnode2-vip is enabled
    VIP racnode2-vip is running on node: racnode2

VIP —(特定节点的配置)

    [oracle@racnode1 ~]$ srvctl config vip -n racnode1
    VIP exists.:racnode1
    VIP exists.: /racnode1-vip/192.168.1.251/255.255.255.0/eth0  

    [oracle@racnode1 ~]$ srvctl config vip -n racnode2
    VIP exists.:racnode2
    VIP exists.: /racnode2-vip/192.168.1.252/255.255.255.0/eth0

节点应用程序配置 —(VIP、GSD、ONS、监听器)

    [oracle@racnode1 ~]$ srvctl config nodeapps -a -g -s -l
    -l option has been deprecated and will be ignored.
    VIP exists.:racnode1
    VIP exists.: /racnode1-vip/192.168.1.251/255.255.255.0/eth0
    VIP exists.:racnode2
    VIP exists.: /racnode2-vip/192.168.1.252/255.255.255.0/eth0
    GSD exists.
    ONS daemon exists. Local port 6100, remote port 6200
    Name: LISTENER
    Network: 1, Owner: grid
    Home:  
     /u01/app/11.2.0/grid on node(s) racnode2,racnode1
    End points: TCP:1521

验证所有集群节点间的时钟同步

    [oracle@racnode1 ~]$ cluvfy comp clocksync -verbose  

    Verifying Clock Synchronization across the cluster nodes   

    Checking if Clusterware is installed on all nodes...
    Check of Clusterware install passed  

    Checking if CTSS Resource is running on all nodes...
    Check: CTSS Resource running on all nodes  
      Node Name                             Status                     
      ------------------------------------  ------------------------
      racnode1                              passed
                                       
    Result: CTSS resource check passed   

    Querying CTSS for time offset on all nodes...
    Result: Query of CTSS for time offset passed  

    Check CTSS state started...
    Check: CTSS state
      Node Name                             State                    
      ------------------------------------  ------------------------
      racnode1                              Active                   
    CTSS is in Active state. Proceeding with check of clock time offsets on all nodes...
    Reference Time Offset Limit: 1000.0 msecs
    Check: Reference Time Offset
      Node Name     Time Offset               Status                   
      ------------  ------------------------  ------------------------
      racnode1      0.0                       passed
                                        

    Time offset is within the specified limits on the following set of nodes:  "[racnode1]"  
    Result: Check of clock time offsets passed   

    Oracle Cluster Time Synchronization Services check passed  

    Verification of Clock Synchronization across the cluster nodes was successful.


以下停止/启动操作需要以 root 身份来执行。

在本地服务器上停止 Oracle Clusterware 系统

在 racnode1 节点上使用 crsctl stop cluster 命令停止 Oracle Clusterware 系统:

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster
CRS-2673: Attempting to stop 'ora.crsd' on 'racnode1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on
'racnode1'
CRS-2673: Attempting to stop 'ora.LISTENER.lsnr' on 'racnode1'
CRS-2673: Attempting to stop 'ora.CRS.dg' on 'racnode1'
CRS-2673: Attempting to stop 'ora.racdb.db' on 'racnode1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'racnode1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'racnode1'
CRS-2677: Stop of 'ora.LISTENER.lsnr' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.racnode1.vip' on 'racnode1'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'racnode1'
CRS-2677: Stop of 'ora.scan1.vip' on 'racnode1' succeeded
CRS-2672: Attempting to start 'ora.scan1.vip' on 'racnode2'
CRS-2677: Stop of 'ora.racnode1.vip' on 'racnode1' succeeded
CRS-2672: Attempting to start 'ora.racnode1.vip' on 'racnode2'
CRS-2677: Stop of 'ora.registry.acfs' on 'racnode1' succeeded
CRS-2676: Start of 'ora.racnode1.vip' on 'racnode2' succeeded            
                                
<-- Notice racnode1 VIP moved to racnode2
CRS-2676: Start of 'ora.scan1.vip' on 'racnode2' succeeded               
                                
<-- Notice SCAN moved to racnode2
CRS-2672: Attempting to start 'ora.LISTENER_SCAN1.lsnr' on 'racnode2'
CRS-2676: Start of 'ora.LISTENER_SCAN1.lsnr' on 'racnode2' succeeded     
                                
<-- Notice LISTENER_SCAN1 moved to racnode2
CRS-2677: Stop of 'ora.CRS.dg' on 'racnode1' succeeded
CRS-2677: Stop of 'ora.racdb.db' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.FRA.dg' on 'racnode1'
CRS-2673: Attempting to stop 'ora.RACDB_DATA.dg' on 'racnode1'
CRS-2677: Stop of 'ora.RACDB_DATA.dg' on 'racnode1' succeeded
CRS-2677: Stop of 'ora.FRA.dg' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'racnode1'
CRS-2677: Stop of 'ora.asm' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'racnode1'
CRS-2673: Attempting to stop 'ora.eons' on 'racnode1'
CRS-2677: Stop of 'ora.ons' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'racnode1'
CRS-2677: Stop of 'ora.net1.network' on 'racnode1' succeeded
CRS-2677: Stop of 'ora.eons' on 'racnode1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'racnode1' has
completed
CRS-2677: Stop of 'ora.crsd' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.cssdmonitor' on 'racnode1'
CRS-2673: Attempting to stop 'ora.ctssd' on 'racnode1'
CRS-2673: Attempting to stop 'ora.evmd' on 'racnode1'
CRS-2673: Attempting to stop 'ora.asm' on 'racnode1'
CRS-2677: Stop of 'ora.cssdmonitor' on 'racnode1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'racnode1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'racnode1' succeeded
CRS-2677: Stop of 'ora.asm' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'racnode1'
CRS-2677: Stop of 'ora.cssd' on 'racnode1' succeeded
CRS-2673: Attempting to stop 'ora.diskmon' on 'racnode1'
CRS-2677: Stop of 'ora.diskmon' on 'racnode1' succeeded


注:在运行“ crsctl stop cluster”命令之后,如果 Oracle Clusterware 管理的资源中有任何一个还在运行,则整个命令失败。使用 -f 选项无条件地停止所有资源并停止 Oracle Clusterware 系统。

另请注意,可通过指定 -all 选项在集群中所有服务器上停止 Oracle Clusterware 系统。以下命令将在 racnode1 和 racnode2 上停止 Oracle Clusterware 系统:

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl stop cluster -all


在本地服务器上启动 Oracle Clusterware 系统

在 racnode1 节点上使用 crsctl start cluster 命令启动 Oracle Clusterware 系统:

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'racnode1'
CRS-2676: Start of 'ora.cssdmonitor' on 'racnode1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'racnode1'
CRS-2672: Attempting to start 'ora.diskmon' on 'racnode1'
CRS-2676: Start of 'ora.diskmon' on 'racnode1' succeeded
CRS-2676: Start of 'ora.cssd' on 'racnode1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'racnode1'
CRS-2676: Start of 'ora.ctssd' on 'racnode1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'racnode1'
CRS-2672: Attempting to start 'ora.asm' on 'racnode1'
CRS-2676: Start of 'ora.evmd' on 'racnode1' succeeded
CRS-2676: Start of 'ora.asm' on 'racnode1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'racnode1'
CRS-2676: Start of 'ora.crsd' on 'racnode1' succeeded


注:可通过指定 -all 选项在集群中所有服务器上启动 Oracle Clusterware 系统。

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster -all


还可以通过列出服务器(各服务器之间以空格分隔)在集群中一个或多个指定的服务器上启动 Oracle Clusterware 系统:

[root@racnode1 ~]# /u01/app/11.2.0/grid/bin/crsctl start cluster -n
racnode1 racnode2


使用 SRVCTL 启动/停止所有实例

最后,可使用以下命令来启动/停止所有实例及相关服务:

[oracle@racnode1 ~]$ srvctl stop database -d racdb  
[oracle@racnode1 ~]$ srvctl start database -d racdb

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29337971/viewspace-1079546/,如需转载,请注明出处,否则将追究法律责任。

下一篇: OGG安装准备工作
请登录后发表评论 登录
全部评论

注册时间:2013-12-07

  • 博文量
    143
  • 访问量
    626792