11g RAC集群启动关闭、各种资源检查、配置信息查看汇总。

 admin   2022-08-18 14:45   219 人阅读  0 条评论

简要:
一:集群的启动与关闭

1.  rac集群的手动启动
[root@node1 bin]# ./crsctl start cluster -all
2.  查看rac集群的状态
[root@node1 bin]# ./crsctl  stat res -t
3.  rac集群的关闭
[root@node1 bin]# ./crscrl stop cluster -all
————————————————————————————————
二:集群的各种资源状态的检查

1.  检查集群的运行状况
[root@node1 bin]# ./crsctl check cluster
2.  检查集群的数据库实例运行状态
[root@node1 bin]# ./srvctl status database -d orcldb
3.  检查节点asm实例运行状态
[root@node1 bin]# ./srvctl status asm
4.  检查节点应用程序运行状态
[root@node1 bin]# ./srvctl status nodeapps
5.  检查节点监听运行状态
[root@node1 bin]# ./srvctl status listener
6.  检查scan监听运行状态
[root@node1 bin]# ./srvctl status scan
7.  检查所有集群节点间的时钟同步(非root用户执行)
[oracle@node1 ~]$ cluvfy comp clocksync -verbose

—————————————————————————————————
三: 集群的各种配置信息查看

1. 查看数据库配置信息。
[root@node1 bin]# ./srvctl config database -d orcldb
2. 查看应用程序配置信息
[root@node1 bin]# ./srvctl config nodeapps
3.  查看asm配置信息  
[root@node1 bin]# ./srvctl config asm
4. 查看监听配置信息
[root@node1 bin]# ./srvctl config listener
5.  查看scan配置信息
[root@node1 bin]# ./srvctl config scan
6.  查看RAC注册表磁盘配置信息
[root@node1 bin]# ./ocrcheck
7.  查看RAC仲裁磁盘配置信息
[root@node1 bin]# ./crsctl query css votedisk

————————————————————-————————
下面是详细操作输出信息

11g rac r2启动(默认开机会自动启动)关闭需要用root用户维护。

--执行命令的路径
[root@node1 bin]# pwd            
/u01/app/11.2.0/grid/bin


一: 11g rac集群的正常启动与关闭。

--rac集群的手动启动
[root@node1 bin]# ./crsctl start cluster -all    
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node2'
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'node1'
CRS-2676: Start of 'ora.cssdmonitor' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node2'
CRS-2672: Attempting to start 'ora.diskmon' on 'node2'
CRS-2676: Start of 'ora.cssdmonitor' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'node1'
CRS-2672: Attempting to start 'ora.diskmon' on 'node1'
CRS-2676: Start of 'ora.diskmon' on 'node2' succeeded
CRS-2676: Start of 'ora.diskmon' on 'node1' succeeded
CRS-2676: Start of 'ora.cssd' on 'node2' succeeded
CRS-2676: Start of 'ora.cssd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.ctssd' on 'node2'
CRS-2672: Attempting to start 'ora.ctssd' on 'node1'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'node1'
CRS-2676: Start of 'ora.ctssd' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'node2'
CRS-2676: Start of 'ora.ctssd' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.evmd' on 'node1'
CRS-2672: Attempting to start 'ora.cluster_interconnect.haip' on 'node2'
CRS-2676: Start of 'ora.evmd' on 'node2' succeeded
CRS-2676: Start of 'ora.evmd' on 'node1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'node1' succeeded
CRS-2676: Start of 'ora.cluster_interconnect.haip' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.asm' on 'node2'
CRS-2672: Attempting to start 'ora.asm' on 'node1'
CRS-2676: Start of 'ora.asm' on 'node1' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node1'
CRS-2676: Start of 'ora.crsd' on 'node1' succeeded
CRS-2676: Start of 'ora.asm' on 'node2' succeeded
CRS-2672: Attempting to start 'ora.crsd' on 'node2'
CRS-2676: Start of 'ora.crsd' on 'node2' succeeded

-- 查看rac集群的状态
[root@node1 bin]# ./crsctl  stat res -t
--------------------------------------------------------------------------------
NAME           TARGET  STATE        SERVER                   STATE_DETAILS      
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
              ONLINE  ONLINE       node1                                        
              ONLINE  ONLINE       node2                                        
ora.FLASH.dg
              ONLINE  ONLINE       node1                                        
              ONLINE  ONLINE       node2                                        
ora.GRIDDG.dg
              ONLINE  ONLINE       node1                                        
              ONLINE  ONLINE       node2                                        
ora.ORCLDB.lsnr
              ONLINE  ONLINE       node1                                        
              ONLINE  ONLINE       node2                                        
ora.asm
              ONLINE  ONLINE       node1                    Started            
              ONLINE  ONLINE       node2                    Started            
ora.gsd
              OFFLINE OFFLINE      node1                                        
              OFFLINE OFFLINE      node2                                        
ora.net1.network
              ONLINE  ONLINE       node1                                        
              ONLINE  ONLINE       node2                                        
ora.ons
              ONLINE  ONLINE       node1                                        
              ONLINE  ONLINE       node2                                        
ora.registry.acfs
              ONLINE  ONLINE       node1                                        
              ONLINE  ONLINE       node2                                        
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
     1        ONLINE  ONLINE       node1                                        
ora.cvu
     1        ONLINE  ONLINE       node1                                        
ora.node1.vip
     1        ONLINE  ONLINE       node1                                        
ora.node2.vip
     1        ONLINE  ONLINE       node2                                        
ora.oc4j
     1        ONLINE  ONLINE       node1                                        
ora.orcldb.db
     1        ONLINE  ONLINE       node1                    Open                
     2        ONLINE  ONLINE       node2                    Open                
ora.scan1.vip
     1        ONLINE  ONLINE       node1


--rac集群的关闭
[root@node1 bin]# ./crscrl stop cluster -all
-bash: ./crscrl: No such file or directory
[root@node1 bin]# ./crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'node1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'node1'
CRS-2673: Attempting to stop 'ora.oc4j' on 'node1'
CRS-2673: Attempting to stop 'ora.cvu' on 'node1'
CRS-2673: Attempting to stop 'ora.ORCLDB.lsnr' on 'node1'
CRS-2673: Attempting to stop 'ora.GRIDDG.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'node1'
CRS-2673: Attempting to stop 'ora.orcldb.db' on 'node1'
CRS-2677: Stop of 'ora.cvu' on 'node1' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'node1'
CRS-2677: Stop of 'ora.ORCLDB.lsnr' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.node1.vip' on 'node1'
CRS-2677: Stop of 'ora.scan1.vip' on 'node1' succeeded
CRS-2677: Stop of 'ora.orcldb.db' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node1'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'node1'
CRS-2677: Stop of 'ora.node1.vip' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.crsd' on 'node2'
CRS-2677: Stop of 'ora.registry.acfs' on 'node1' succeeded
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on 'node2'
CRS-2673: Attempting to stop 'ora.GRIDDG.dg' on 'node2'
CRS-2673: Attempting to stop 'ora.registry.acfs' on 'node2'
CRS-2673: Attempting to stop 'ora.orcldb.db' on 'node2'
CRS-2673: Attempting to stop 'ora.ORCLDB.lsnr' on 'node2'
CRS-2677: Stop of 'ora.FLASH.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'node1' succeeded
CRS-2677: Stop of 'ora.GRIDDG.dg' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.ORCLDB.lsnr' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.node2.vip' on 'node2'
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2677: Stop of 'ora.node2.vip' on 'node2' succeeded
CRS-2677: Stop of 'ora.oc4j' on 'node1' succeeded
CRS-2677: Stop of 'ora.GRIDDG.dg' on 'node2' succeeded
CRS-2677: Stop of 'ora.registry.acfs' on 'node2' succeeded
CRS-2677: Stop of 'ora.orcldb.db' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'node2'
CRS-2673: Attempting to stop 'ora.FLASH.dg' on 'node2'
CRS-2677: Stop of 'ora.DATA.dg' on 'node2' succeeded
CRS-2677: Stop of 'ora.FLASH.dg' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
CRS-2677: Stop of 'ora.asm' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.ons' on 'node2'
CRS-2677: Stop of 'ora.ons' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node2'
CRS-2677: Stop of 'ora.net1.network' on 'node2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node2' has completed
CRS-2673: Attempting to stop 'ora.ons' on 'node1'
CRS-2677: Stop of 'ora.ons' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'node1'
CRS-2677: Stop of 'ora.net1.network' on 'node1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'node1' has completed
CRS-2677: Stop of 'ora.crsd' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'node2'
CRS-2673: Attempting to stop 'ora.evmd' on 'node2'
CRS-2673: Attempting to stop 'ora.asm' on 'node2'
CRS-2677: Stop of 'ora.crsd' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'node1'
CRS-2673: Attempting to stop 'ora.evmd' on 'node1'
CRS-2673: Attempting to stop 'ora.asm' on 'node1'
CRS-2677: Stop of 'ora.evmd' on 'node2' succeeded
CRS-2677: Stop of 'ora.evmd' on 'node1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'node1' succeeded
CRS-2677: Stop of 'ora.asm' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node2'
CRS-2677: Stop of 'ora.asm' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'node1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'node2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'node2'
CRS-2677: Stop of 'ora.cssd' on 'node1' succeeded
CRS-2677: Stop of 'ora.cssd' on 'node2' succeeded

———————————————————————————
二: 11g rac集群的各种资源状态检查命令。

1. 查看crsctl帮助信息。
[root@node1 bin]# ./crsctl
Usage: crsctl <command> <object> [<options>]
   command: enable|disable|config|start|stop|relocate|replace|status|add|delete|modify|getperm|setperm|check|set|get|unset|debug|lsmodules|query|pin|unpin|discover|release|request
For complete usage, use:
   crsctl [-h | --help]
For detailed help on each command and object and its options use:
   crsctl <command> <object> -h  e.g. crsctl relocate resource -h

--帮助详细介绍
[root@node1 bin]# ./crsctl -h
Usage: crsctl add       - add a resource, type or other entity
      crsctl check     - check a service, resource or other entity
      crsctl config    - output autostart configuration
      crsctl debug     - obtain or modify debug state
      crsctl delete    - delete a resource, type or other entity
      crsctl disable   - disable autostart
      crsctl discover  - discover DHCP server
      crsctl enable    - enable autostart
      crsctl get       - get an entity value
      crsctl getperm   - get entity permissions
      crsctl lsmodules - list debug modules
      crsctl modify    - modify a resource, type or other entity
      crsctl query     - query service state
      crsctl pin       - pin the nodes in the node list
      crsctl relocate  - relocate a resource, server or other entity
      crsctl replace   - replaces the location of voting files
      crsctl release   - release a DHCP lease
      crsctl request   - request a DHCP lease
      crsctl setperm   - set entity permissions
      crsctl set       - set an entity value
      crsctl start     - start a resource, server or other entity
      crsctl status    - get status of a resource or other entity
      crsctl stop      - stop a resource, server or other entity
      crsctl unpin     - unpin the nodes in the node list
      crsctl unset     - unset an entity value, restoring its default

2.  检查集群的运行状况
[root@node1 bin]# ./crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

3.  检查集群的数据库实例运行状态
[root@node1 bin]# ./srvctl status database -d orcldb
Instance orcldb1 is running on node node1
Instance orcldb2 is running on node node2

4.  检查节点应用程序运行状态
[root@node1 bin]# ./srvctl status nodeapps
VIP node1-vip is enabled
VIP node1-vip is running on node: node1
VIP node2-vip is enabled
VIP node2-vip is running on node: node2
Network is enabled
Network is running on node: node1
Network is running on node: node2
GSD is disabled
GSD is not running on node: node1
GSD is not running on node: node2
ONS is enabled
ONS daemon is running on node: node1
ONS daemon is running on node: node2

5.  检查节点asm实例运行状态
[root@node1 bin]# ./srvctl status asm
ASM is running on node2,node1

6.  检查节点监听运行状态
[root@node1 bin]# ./srvctl status listener
Listener ORCLDB is enabled
Listener ORCLDB is running on node(s): node2,node1

7.  检查scan监听运行状态
[root@node1 bin]# ./srvctl status scan
SCAN VIP scan1 is enabled
SCAN VIP scan1 is running on node node1

8.  检查所有集群节点间的时钟同步(非root用户执行)
[oracle@node1 ~]$ 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                  
 ------------------------------------  ------------------------
 node1                                 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                  
 ------------------------------------  ------------------------
 node1                                 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                  
 ------------  ------------------------  ------------------------
 node1         0.0                       passed

Time offset is within the specified limits on the following set of nodes:
"[node1]"
Result: Check of clock time offsets passed
Oracle Cluster Time Synchronization Services check passed
Verification of Clock Synchronization across the cluster nodes was successful.

——————————————————————————————————————————
三  集群各种配置信息检查

1.  查看srvctl帮助信息。
[root@node1 bin]# ./srvctl
Usage: srvctl <command> <object> [<options>]
   commands: enable|disable|start|stop|relocate|status|add|remove|modify|getenv|setenv|unsetenv|config|convert|upgrade
   objects: database|instance|service|nodeapps|vip|network|asm|diskgroup|listener|srvpool|server|scan|scan_listener|oc4j|home|filesystem|gns|cvu
For detailed help on each command and object and its options use:
 srvctl <command> -h or
 srvctl <command> <object> -h

2.  查看数据库配置信息。

--  config database帮助信息
[root@node1 bin]# ./srvctl config database -h
Displays the configuration for the database.
Usage: srvctl config database [-d <db_unique_name> [-a] ] [-v]
   -d <db_unique_name>      Unique name for the database
   -a                       Print detailed configuration information
   -v                       Verbose output
   -h                       Print usage

-- 查看数据库配置信息。
[root@node1 bin]# ./srvctl config database -d orcldb
Database unique name: orcldb
Database name: orcldb
Oracle home: /u01/app/oracle/product/11.2.0/db_1
Oracle user: oracle
Spfile: +DATA/orcldb/spfileorcldb.ora
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools: orcldb
Database instances: orcldb1,orcldb2
Disk Groups: DATA,FLASH
Mount point paths:
Services:
Type: RAC
Database is administrator managed

3. 查看应用程序配置信息
[root@node1 bin]# ./srvctl config nodeapps
Network exists: 1/10.0.0.0/255.0.0.0/eth0, type static
VIP exists: /node1-vip/10.100.25.10/10.0.0.0/255.0.0.0/eth0, hosting node node1
VIP exists: /node2-vip/10.100.25.11/10.0.0.0/255.0.0.0/eth0, hosting node node2
GSD exists
ONS exists: Local port 6100, remote port 6200, EM port 2016

4.  查看asm配置信息  
[root@node1 bin]# ./srvctl config asm
ASM home: /u01/app/11.2.0/grid
ASM listener: ORCLDB

5. 查看监听配置信息
[root@node1 bin]# ./srvctl config listener
Name: ORCLDB
Network: 1, Owner: grid
Home: <CRS home>
End points: TCP:1521

6.  查看scan配置信息
[root@node1 bin]# ./srvctl config scan
SCAN name: scan-cluster.localdomain, Network: 1/10.0.0.0/255.0.0.0/eth0
SCAN VIP name: scan1, IP: /scan-cluster.localdomain/10.100.25.100
[root@node1 bin]# ./srvctl config scan_listener
SCAN Listener LISTENER_SCAN1 exists. Port: TCP:1521

7.  查看RAC注册表磁盘配置信息
[root@node1 bin]# ./ocrcheck
Status of Oracle Cluster Registry is as follows :
Version                  :          3
Total space (kbytes)     :     262120
Used space (kbytes)      :       3100
Available space (kbytes) :     259020
ID                       : 1970085021
Device/File Name         :    +GRIDDG
                                   Device/File integrity check succeeded
                                   Device/File not configured
                                   Device/File not configured
                                   Device/File not configured
                                   Device/File not configured

Cluster registry integrity check succeeded
Logical corruption check succeeded

8.  查看RAC仲裁磁盘配置信息
[root@node1 bin]# ./crsctl query css votedisk
##  STATE    File Universal Id                File Name Disk group
--  -----    -----------------                --------- ---------
1. ONLINE   97b3037ba6684f0bbf04fa53aa7efb37 (ORCL:VOL1) [GRIDDG]
Located 1 voting disk(s).


本文地址:https://liuchunjie.top/?id=461
版权声明:本文为原创文章,版权归 admin 所有,欢迎分享本文,转载请保留出处!

 发表评论


表情

还没有留言,还不快点抢沙发?