RAC集群配置与查询方式总结

说明:以下命令前面的"./"是在root用户下调用oracle查询信息才使用,如果在oracle或者grid用户下,对应的命令可以直接查询不需要"./"

一:集群的启动与关闭

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

-- 查看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: 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  -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  []

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  -h or

srvctl  -h

-- srvctl命令详细介绍

[root@node1 bin]# ./srvctl -h

Usage: srvctl [-V]

Usage: srvctl add database -d  -o  [-c {RACONENODE | RAC | SINGLE} [-e ] [-i ] [-w ]] [-m ] [-p ] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s ] [-t ] [-n ] [-y {AUTOMATIC | MANUAL | NORESTART}] [-g ""] [-x ] [-a ""] [-j ""]

Usage: srvctl config database [-d  [-a] ] [-v]

Usage: srvctl start database -d  [-o ] [-n ]

Usage: srvctl stop database -d  [-o ] [-f]

Usage: srvctl status database -d  [-f] [-v]

Usage: srvctl enable database -d  [-n ]

Usage: srvctl disable database -d  [-n ]

Usage: srvctl modify database -d  [-n ] [-o ] [-u ] [-e ] [-w ] [-m ] [-p ] [-r {PRIMARY | PHYSICAL_STANDBY | LOGICAL_STANDBY | SNAPSHOT_STANDBY}] [-s ] [-t ] [-y {AUTOMATIC | MANUAL | NORESTART}] [-g "" [-x ]] [-a ""|-z] [-j ""] [-f]

Usage: srvctl remove database -d  [-f] [-y]

Usage: srvctl getenv database -d  [-t ""]

Usage: srvctl setenv database -d  {-t =[,=,...] | -T =}

Usage: srvctl unsetenv database -d  -t ""

Usage: srvctl convert database -d  -c RAC [-n ]

Usage: srvctl convert database -d  -c RACONENODE [-i ] [-w ]

Usage: srvctl relocate database -d  {[-n ] [-w ] | -a [-r]} [-v]

Usage: srvctl upgrade database -d  -o

Usage: srvctl downgrade database -d  -o  -t

Usage: srvctl add instance -d  -i  -n  [-f]

Usage: srvctl start instance -d  {-n  [-i ] | -i } [-o ]

Usage: srvctl stop instance -d  {-n  | -i } [-o ] [-f]

Usage: srvctl status instance -d  {-n  | -i } [-f] [-v]

Usage: srvctl enable instance -d  -i ""

Usage: srvctl disable instance -d  -i ""

Usage: srvctl modify instance -d  -i  { -n  | -z }

Usage: srvctl remove instance -d  -i  [-f] [-y]

Usage: srvctl add service -d  -s  {-r "" [-a ""] [-P {BASIC | NONE | PRECONNECT}] | -g  [-c {UNIFORM | SINGLETON}] } [-k ] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}] [-q {TRUE|FALSE}] [-x {TRUE|FALSE}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z ] [-w ] [-t ] [-f]

Usage: srvctl add service -d  -s  -u {-r "" | -a ""} [-f]

Usage: srvctl config service -d  [-s ] [-v]

Usage: srvctl enable service -d  -s "" [-i  | -n ]

Usage: srvctl disable service -d  -s "" [-i  | -n ]

Usage: srvctl status service -d  [-s ""] [-f] [-v]

Usage: srvctl modify service -d  -s  -i  -t  [-f]

Usage: srvctl modify service -d  -s  -i  -r [-f]

Usage: srvctl modify service -d  -s  -n -i "" [-a ""] [-f]

Usage: srvctl modify service -d  -s  [-g ] [-c {UNIFORM | SINGLETON}] [-P {BASIC|NONE}] [-l [PRIMARY][,PHYSICAL_STANDBY][,LOGICAL_STANDBY][,SNAPSHOT_STANDBY]] [-y {AUTOMATIC | MANUAL}][-q {true|false}] [-x {true|false}] [-j {SHORT|LONG}] [-B {NONE|SERVICE_TIME|THROUGHPUT}] [-e {NONE|SESSION|SELECT}] [-m {NONE|BASIC}] [-z ] [-w ] [-t ]

Usage: srvctl relocate service -d  -s  {-i  -t  | -c  -n } [-f]

Usage: srvctl remove service -d  -s  [-i ] [-f]

Usage: srvctl start service -d  [-s "" [-n  | -i ] ] [-o ]

Usage: srvctl stop service -d  [-s "" [-n  | -i ] ] [-f]

Usage: srvctl add nodeapps { { -n  -A //[if1[|if2...]] } | { -S //[if1[|if2...]] } } [-e ] [-l ] [-r ] [-t [:][,[:]...]] [-v]

Usage: srvctl config nodeapps [-a] [-g] [-s]

Usage: srvctl modify nodeapps {[-n  -A /[/if1[|if2|...]]] | [-S /[/if1[|if2|...]]]} [-u {static|dhcp|mixed}] [-e ] [ -l  ] [-r  ] [-t [:][,[:]...]] [-v]

Usage: srvctl start nodeapps [-n ] [-g] [-v]

Usage: srvctl stop nodeapps [-n ] [-g] [-f] [-r] [-v]

Usage: srvctl status nodeapps

Usage: srvctl enable nodeapps [-g] [-v]

Usage: srvctl disable nodeapps [-g] [-v]

Usage: srvctl remove nodeapps [-f] [-y] [-v]

Usage: srvctl getenv nodeapps [-a] [-g] [-s] [-t ""]

Usage: srvctl setenv nodeapps {-t "=[,=,...]" | -T "="} [-v]

Usage: srvctl unsetenv nodeapps -t "" [-v]

Usage: srvctl add vip -n  -k  -A //[if1[|if2...]] [-v]

Usage: srvctl config vip { -n  | -i  }

Usage: srvctl disable vip -i  [-v]

Usage: srvctl enable vip -i  [-v]

Usage: srvctl remove vip -i "" [-f] [-y] [-v]

Usage: srvctl getenv vip -i  [-t ""]

Usage: srvctl start vip { -n  | -i  } [-v]

Usage: srvctl stop vip { -n  | -i  } [-f] [-r] [-v]

Usage: srvctl relocate vip -i  [-n ] [-f] [-v]

Usage: srvctl status vip { -n  | -i  } [-v]

Usage: srvctl setenv vip -i  {-t "=[,=,...]" | -T "="} [-v]

Usage: srvctl unsetenv vip -i  -t "" [-v]

Usage: srvctl add network [-k ] -S //[if1[|if2...]] [-w ] [-v]

Usage: srvctl config network [-k ]

Usage: srvctl modify network [-k ] [-S /[/if1[|if2...]]] [-w ] [-v]

Usage: srvctl remove network {-k  | -a} [-f] [-v]

Usage: srvctl add asm [-l ]

Usage: srvctl start asm [-n ] [-o ]

Usage: srvctl stop asm [-n ] [-o ] [-f]

Usage: srvctl config asm [-a]

Usage: srvctl status asm [-n ] [-a] [-v]

Usage: srvctl enable asm [-n ]

Usage: srvctl disable asm [-n ]

Usage: srvctl modify asm [-l ]

Usage: srvctl remove asm [-f]

Usage: srvctl getenv asm [-t [, ...]]

Usage: srvctl setenv asm -t "= [,...]" | -T "="

Usage: srvctl unsetenv asm -t "[, ...]"

Usage: srvctl start diskgroup -g  [-n ""]

Usage: srvctl stop diskgroup -g  [-n ""] [-f]

Usage: srvctl status diskgroup -g  [-n ""] [-a] [-v]

Usage: srvctl enable diskgroup -g  [-n ""]

Usage: srvctl disable diskgroup -g  [-n ""]

Usage: srvctl remove diskgroup -g  [-f]

Usage: srvctl add listener [-l ] [-s] [-p "[TCP:][, ...][/IPC:][/NMP:][/TCPS:] [/SDP:]"] [-o ] [-k ]

Usage: srvctl config listener [-l ] [-a]

Usage: srvctl start listener [-l ] [-n ]

Usage: srvctl stop listener [-l ] [-n ] [-f]

Usage: srvctl status listener [-l ] [-n ] [-v]

Usage: srvctl enable listener [-l ] [-n ]

Usage: srvctl disable listener [-l ] [-n ]

Usage: srvctl modify listener [-l ] [-o ] [-p "[TCP:][, ...][/IPC:][/NMP:][/TCPS:] [/SDP:]"] [-u ] [-k ]

Usage: srvctl remove listener [-l  | -a] [-f]

Usage: srvctl getenv listener [-l ] [-t [, ...]]

Usage: srvctl setenv listener [-l ] -t "= [,...]" | -T "="

Usage: srvctl unsetenv listener [-l ] -t "[, ...]"

Usage: srvctl add scan -n  [-k ] [-S /[/if1[|if2|...]]]

Usage: srvctl config scan [-i ]

Usage: srvctl start scan [-i ] [-n ]

Usage: srvctl stop scan [-i ] [-f]

Usage: srvctl relocate scan -i  [-n ]

Usage: srvctl status scan [-i ] [-v]

Usage: srvctl enable scan [-i ]

Usage: srvctl disable scan [-i ]

Usage: srvctl modify scan -n

Usage: srvctl remove scan [-f] [-y]

Usage: srvctl add scan_listener [-l ] [-s] [-p [TCP:][/IPC:][/NMP:][/TCPS:] [/SDP:]]

Usage: srvctl config scan_listener [-i ]

Usage: srvctl start scan_listener [-n ] [-i ]

Usage: srvctl stop scan_listener [-i ] [-f]

Usage: srvctl relocate scan_listener -i  [-n ]

Usage: srvctl status scan_listener [-i ] [-v]

Usage: srvctl enable scan_listener [-i ]

Usage: srvctl disable scan_listener [-i ]

Usage: srvctl modify scan_listener {-u|-p [TCP:][/IPC:][/NMP:][/TCPS:] [/SDP:]}

Usage: srvctl remove scan_listener [-f] [-y]

Usage: srvctl add srvpool -g  [-l ] [-u ] [-i ] [-n ""] [-f]

Usage: srvctl config srvpool [-g ]

Usage: srvctl status srvpool [-g ] [-a]

Usage: srvctl status server -n "" [-a]

Usage: srvctl relocate server -n "" -g  [-f]

Usage: srvctl modify srvpool -g  [-l ] [-u ] [-i ] [-n ""] [-f]

Usage: srvctl remove srvpool -g

Usage: srvctl add oc4j [-v]

Usage: srvctl config oc4j

Usage: srvctl start oc4j [-v]

Usage: srvctl stop oc4j [-f] [-v]

Usage: srvctl relocate oc4j [-n ] [-v]

Usage: srvctl status oc4j [-n ] [-v]

Usage: srvctl enable oc4j [-n ] [-v]

Usage: srvctl disable oc4j [-n ] [-v]

Usage: srvctl modify oc4j -p  [-v] [-f]

Usage: srvctl remove oc4j [-f] [-v]

Usage: srvctl start home -o  -s  -n

Usage: srvctl stop home -o  -s  -n  [-t ] [-f]

Usage: srvctl status home -o  -s  -n

Usage: srvctl add filesystem -d  -v  -g  [-m ] [-u ]

Usage: srvctl config filesystem -d

Usage: srvctl start filesystem -d  [-n ]

Usage: srvctl stop filesystem -d  [-n ] [-f]

Usage: srvctl status filesystem -d  [-v]

Usage: srvctl enable filesystem -d

Usage: srvctl disable filesystem -d

Usage: srvctl modify filesystem -d  -u

Usage: srvctl remove filesystem -d  [-f]

Usage: srvctl start gns [-l ] [-n ] [-v]

Usage: srvctl stop gns [-n ] [-f] [-v]

Usage: srvctl config gns [-a] [-d] [-k] [-m] [-n ] [-p] [-s] [-V] [-q ] [-l] [-v]

Usage: srvctl status gns [-n ] [-v]

Usage: srvctl enable gns [-n ] [-v]

Usage: srvctl disable gns [-n ] [-v]

Usage: srvctl relocate gns [-n ] [-v]

Usage: srvctl add gns -d  -i  [-v]

Usage: srvctl modify gns {-l  | [-i ] [-N  -A ] [-D  -A ] [-c  -a ] [-u ] [-r ] [-V ] [-p :[,:...]] [-F ] [-R ] [-X ] [-v]}

Usage: srvctl remove gns [-f] [-v]

Usage: srvctl add cvu [-t ]

Usage: srvctl config cvu

Usage: srvctl start cvu [-n ]

Usage: srvctl stop cvu [-f]

Usage: srvctl relocate cvu [-n ]

Usage: srvctl status cvu [-n ]

Usage: srvctl enable cvu [-n ]

Usage: srvctl disable cvu [-n ]

Usage: srvctl modify cvu -t

Usage: srvctl remove cvu [-f]

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

-- config database帮助信息

[root@node1 bin]# ./srvctl config database -h

Displays the configuration for the database.

Usage: srvctl config database [-d  [-a] ] [-v]

-d  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:

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).

最后编辑于
©著作权归作者所有,转载或内容合作请联系作者
  • 序言:七十年代末,一起剥皮案震惊了整个滨河市,随后出现的几起案子,更是在滨河造成了极大的恐慌,老刑警刘岩,带你破解...
    沈念sama阅读 158,847评论 4 362
  • 序言:滨河连续发生了三起死亡事件,死亡现场离奇诡异,居然都是意外死亡,警方通过查阅死者的电脑和手机,发现死者居然都...
    沈念sama阅读 67,208评论 1 292
  • 文/潘晓璐 我一进店门,熙熙楼的掌柜王于贵愁眉苦脸地迎上来,“玉大人,你说我怎么就摊上这事。” “怎么了?”我有些...
    开封第一讲书人阅读 108,587评论 0 243
  • 文/不坏的土叔 我叫张陵,是天一观的道长。 经常有香客问我,道长,这世上最难降的妖魔是什么? 我笑而不...
    开封第一讲书人阅读 43,942评论 0 205
  • 正文 为了忘掉前任,我火速办了婚礼,结果婚礼上,老公的妹妹穿的比我还像新娘。我一直安慰自己,他们只是感情好,可当我...
    茶点故事阅读 52,332评论 3 287
  • 文/花漫 我一把揭开白布。 她就那样静静地躺着,像睡着了一般。 火红的嫁衣衬着肌肤如雪。 梳的纹丝不乱的头发上,一...
    开封第一讲书人阅读 40,587评论 1 218
  • 那天,我揣着相机与录音,去河边找鬼。 笑死,一个胖子当着我的面吹牛,可吹牛的内容都是我干的。 我是一名探鬼主播,决...
    沈念sama阅读 31,853评论 2 312
  • 文/苍兰香墨 我猛地睁开眼,长吁一口气:“原来是场噩梦啊……” “哼!你这毒妇竟也来了?” 一声冷哼从身侧响起,我...
    开封第一讲书人阅读 30,568评论 0 198
  • 序言:老挝万荣一对情侣失踪,失踪者是张志新(化名)和其女友刘颖,没想到半个月后,有当地人在树林里发现了一具尸体,经...
    沈念sama阅读 34,273评论 1 242
  • 正文 独居荒郊野岭守林人离奇死亡,尸身上长有42处带血的脓包…… 初始之章·张勋 以下内容为张勋视角 年9月15日...
    茶点故事阅读 30,542评论 2 246
  • 正文 我和宋清朗相恋三年,在试婚纱的时候发现自己被绿了。 大学时的朋友给我发了我未婚夫和他白月光在一起吃饭的照片。...
    茶点故事阅读 32,033评论 1 260
  • 序言:一个原本活蹦乱跳的男人离奇死亡,死状恐怖,灵堂内的尸体忽然破棺而出,到底是诈尸还是另有隐情,我是刑警宁泽,带...
    沈念sama阅读 28,373评论 2 253
  • 正文 年R本政府宣布,位于F岛的核电站,受9级特大地震影响,放射性物质发生泄漏。R本人自食恶果不足惜,却给世界环境...
    茶点故事阅读 33,031评论 3 236
  • 文/蒙蒙 一、第九天 我趴在偏房一处隐蔽的房顶上张望。 院中可真热闹,春花似锦、人声如沸。这庄子的主人今日做“春日...
    开封第一讲书人阅读 26,073评论 0 8
  • 文/苍兰香墨 我抬头看了看天上的太阳。三九已至,却和暖如春,着一层夹袄步出监牢的瞬间,已是汗流浃背。 一阵脚步声响...
    开封第一讲书人阅读 26,830评论 0 195
  • 我被黑心中介骗来泰国打工, 没想到刚下飞机就差点儿被人妖公主榨干…… 1. 我叫王不留,地道东北人。 一个月前我还...
    沈念sama阅读 35,628评论 2 274
  • 正文 我出身青楼,却偏偏与公主长得像,于是被迫代替她去往敌国和亲。 传闻我的和亲对象是个残疾皇子,可洞房花烛夜当晚...
    茶点故事阅读 35,537评论 2 269