Oracle10g RAC的简单操作

2023-08-29 18:54:52

1.查看OCR位置
用户指定的位置会被放置在 /etc/oracle/ocr.loc(Liunx系统) 或 /var/opt/oracle/ocr.loc

[oracle@rac4 opt]$ cat /etc/oracle/ocr.loc

ocrconfig_loc=/dev/raw/raw1

local_only=FALSE

2.查看voting disk位置

[oracle@rac4 opt]$ crsctl query css votedisk

 .         /dev/raw/raw2

located  votedisk(s).

3.关键的3个进程

EVMD和CRSD两个进程如果出现异常,则系统会自动重启这两个进程,但是如果CSSD进程异常,系统会立即重启

h1::respawn:/etc/init.d/init.evmd run >/dev/null >& </dev/null

h2::respawn:/etc/init.d/init.cssd fatal >/dev/null >& </dev/null

h3::respawn:/etc/init.d/init.crsd run >/dev/null >& </dev/null

4.CSS服务两种心跳网络延时参数

[oracle@rac4 opt]$ crsctl get css disktimeout

[oracle@rac4 opt]$ crsctl get css misscount

修改心跳时间设置 crsctl set css misscount 100 慎用

5.查看集群的节点信息

[oracle@rac4 opt]$ olsnodes --help

Usage: olsnodes [-n] [-p] [-i] [<node> | -l] [-g] [-v]

        where

                -n print node number with the node name

                -p print private interconnect name with the node name

                -i print virtual IP name with the node name

                <node> print information for the specified node

                -l print information for the local node

                -g turn on logging

                -v run in verbose mode

[oracle@rac4 opt]$ olsnodes -n

rac3

rac4

[oracle@rac4 opt]$ olsnodes -n -p

rac3           rac3-priv

rac4           rac4-priv

[oracle@rac4 opt]$ olsnodes -n -p -i

rac3           rac3-priv       rac3-vip

rac4           rac4-priv       rac4-vip

备注：本文部分例子来源于张晓明《大话Oracle RAC:集群高可用性备份与恢复》

6.配置crs栈是否自动启动

root@rac3 bin]# ./crsctl

crsctl enable crs    - enables startup for all CRS daemons
       crsctl disable crs    - disables startup for all CRS daemons

其实 crsctl enable crs    修改的是/etc/oracle/scls_scr/节点名/root/crsstart文件

[root@rac3 root]# more crsstart
enable

其实可以手动把它编辑成disable或enable也可以，因为crsctl enable crs/crsctl disable crs就是改的这个文件。

7.查看RAC资源的状态

[oracle@rac4 ~]$ srvctl status nodeapps -n rac3

VIP is running on node: rac3

GSD is running on node: rac3

Listener is running on node: rac3

ONS daemon is running on node: rac3

[oracle@rac4 ~]$ srvctl status asm -n rac3

ASM instance +ASM1 is running on node rac3.

[oracle@rac4 ~]$ srvctl status database -d racdb

Instance racdb2 is running on node rac4

Instance racdb1 is running on node rac3

[oracle@rac4 ~]$ srvctl status service -d racdb

Service racdbserver is running on instance(s) racdb2

8.查看集群件的状态

[oracle@rac3 ~]$ crsctl check crs

CSS appears healthy

CRS appears healthy

EVM appears healthy

[oracle@rac4 ~]$ crsctl check crs

CSS appears healthy

CRS appears healthy

EVM appears healthy

[oracle@rac4 ~]$ crsctl check cssd
CSS appears healthy
[oracle@rac4 ~]$ crsctl check crsd
CRS appears healthy
[oracle@rac4 ~]$ crsctl check evmd
EVM appears healthy

9.oifcfg命令的使用

oifcfg命令有以下4个子命令，每个命令又可以有不同的参数，具体可通过oifcfg -help获取帮助

[oracle@rac4 ~]$ oifcfg --hlep

PRIF-: incorrect usage

Name:

        oifcfg - Oracle Interface Configuration Tool.

Usage:  oifcfg iflist [-p [-n]]

        oifcfg setif {-node <nodename> | -global} {<if_name>/<subnet>:<if_type>}...

        oifcfg getif [-node <nodename> | -global] [ -if <if_name>[/<subnet>] [-type <if_type>] ]

        oifcfg delif [-node <nodename> | -global] [<if_name>[/<subnet>]]

        oifcfg [-help]

        <nodename> - name of the host, as known to a communications network

        <if_name>  - name by which the interface is configured in the system

        <subnet>   - subnet address of the interface

        <if_type>  - type of the interface { cluster_interconnect | public | storage }

<1>.iflist 显示网口列表
<2>.getif 获得单个网口信息
<3>.setif 配置单个网口
<4>.delif 删除网口

--使用iflist显示网口列表

[oracle@rac4 ~]$ oifcfg iflist

eth0  192.168.1.0

eth1  192.168.2.0

--使用getif子命令查看每个网卡的属性

[oracle@rac4 ~]$ oifcfg getif

eth0  192.168.1.0  global  public

eth1  192.168.2.0  global  cluster_interconnect

注意：网络接口的配置方式分成两类：global和node-specific。前者说明集群所有节点的配置信息相同，也就是说
所有节点的配置是对称的；而后者意味着这个节点的配置和其他节点的配置不同，是非对称的。

--查询rac4/rac3节点的global类型配置

[oracle@rac4 ~]$ oifcfg getif -global rac4

eth0  192.168.1.0  global  public

eth1  192.168.2.0  global  cluster_interconnect

[oracle@rac4 ~]$ oifcfg getif -global rac3

eth0  192.168.1.0  global  public

eth1  192.168.2.0  global  cluster_interconnect

--查询rac4/rac3节点的node-specific类型配置

[oracle@rac4 ~]$ oifcfg getif -node rac3

[oracle@rac4 ~]$ oifcfg getif -node rac4

两个节点都没有输出，说明集群中没有node-specific的配置

--按类型查看网卡的配置（public/cluster_interconnect）

[oracle@rac4 ~]$ oifcfg getif -type public

eth0  192.168.1.0  global  public

[oracle@rac4 ~]$ oifcfg getif -type cluster_interconnect

eth1  192.168.2.0  global  cluster_interconnect

--通过setif添加新的网卡

[oracle@rac4 ~]$ oifcfg setif -global livan@net/10.0.0.0:public   --注意这个命令并不会检查网卡是否真的存在

[oracle@rac4 ~]$ oifcfg getif -global

eth0  192.168.1.0  global  public

eth1  192.168.2.0  global  cluster_interconnect

livan@net  10.0.0.0  global  public

--使用delif命令删除接口配置

[oracle@rac4 ~]$ oifcfg getif -global

eth0  192.168.1.0  global  public

eth1  192.168.2.0  global  cluster_interconnect

livan@net  10.0.0.0  global  public

[oracle@rac4 ~]$ oifcfg delif -global livan@net

[oracle@rac4 ~]$ oifcfg getif -global

eth0  192.168.1.0  global  public

eth1  192.168.2.0  global  cluster_interconnect

[oracle@rac4 ~]$ oifcfg delif -global   --删除所有网络配置

[oracle@rac4 ~]$ oifcfg getif -global

[oracle@rac4 ~]$ oifcfg setif -global eth0/192.168.1.0:public

[oracle@rac4 ~]$ oifcfg setif -global eth1/192.168.2.0:cluster_interconnect

[oracle@rac4 ~]$ oifcfg getif -global

eth0  192.168.1.0  global  public

eth1  192.168.2.0  global  cluster_interconnect

[oracle@rac4 ~]$ oifcfg delif -global

[oracle@rac4 ~]$ oifcfg setif -global eth0/192.168.1.0:public eth1/192.168.2.0:cluster_interconnect

[oracle@rac4 ~]$ oifcfg getif -global

eth0  192.168.1.0  global  public

eth1  192.168.2.0  global  cluster_interconnect

10.查看Votedisk磁盘的位置

[oracle@rac4 ~]$ crsctl query css votedisk

0. 0 /dev/raw/raw2

located 1 votedisk(s).

上面的输入说明votedisk为于 /dev/raw/raw2

11.列出crs集群件的安装及操作版本

[oracle@rac4 ~]$ crsctl query crs softwareversion rac3 CRS software version on node [rac3] is [10.2.0.1.0] [oracle@rac4 ~]$ crsctl query crs softwareversion rac4 CRS software version on node [rac4] is [10.2.0.1.0] [oracle@rac4 ~]$ crsctl query crs activeversion CRS active version on the cluster is [10.2.0.1.0]

12.列出crs各服务模块

CRS由CRS、CSS、EVM这3个服务组成，而每个服务又是由一系列modeule（模块)组成， crsctl允许对每个modeule进行跟踪，并把跟踪内容记录的日志中。

--列出CRS服务对应的模块

[oracle@rac4 ~]$ crsctl lsmodules crs

The following are the CRS modules ::

    CRSUI

    CRSCOMM

    CRSRTI

    CRSMAIN

    CRSPLACE

    CRSAPP

    CRSRES

    CRSCOMM

    CRSOCR

    CRSTIMER

    CRSEVT

    CRSD

    CLUCLS

    CSSCLNT

    COMMCRS

    COMMNS

--列出CSS服务对应的模块

[oracle@rac4 ~]$ crsctl lsmodules css

The following are the CSS modules ::

    CSSD

    COMMCRS

    COMMNS

--列出EVM服务对应的模块

[oracle@rac4 ~]$ crsctl lsmodules evm

The following are the EVM modules ::

   EVMD

   EVMDMAIN

   EVMCOMM

   EVMEVT

   EVMAPP

   EVMAGENT

   CRSOCR

   CLUCLS

   CSSCLNT

   COMMCRS

   COMMNS

13.跟踪cssd模块（需要用root用户执行）

[root@rac4 bin]# ./crsctl debug log css "CSSD:1"

Configuration parameter trace is now set to .

Set CRSD Debug Module: CSSD  Level:

[root@rac4 10.2.]# more ./crs_1/log/rac4/cssd/ocssd.log

......

[    CSSD]-- ::12.891 [] >TRACE:   clssscSetDebugLevel: The logging level is set to  ,the cache level is set to

[    CSSD]-- ::46.587 [] >TRACE:   clssgmClientConnectMsg: Connect from con(0x7c3bf0) proc(0x7c0850) pid() proto(:::)

[    CSSD]-- ::46.948 [] >TRACE:   clssgmClientConnectMsg: Connect from con(0x7a4bf0) proc(0x7c0900) pid() proto(:::)

[    CSSD]-- ::47.299 [] >TRACE:   clssgmClientConnectMsg: Connect from con(0x7c3bf0) proc(0x7c0850) pid() proto(:::)

[    CSSD]-- ::47.553 [] >TRACE:   clssgmClientConnectMsg: Connect from con(0x7a4bf0) proc(0x7c0900) pid() proto(:::)

......

14.增加或删除Votedisk

加和删除votedisk的操作比较危险，必须在停止数据库、停止ASM、停止CRS Stack后操作,并且操作时必须使用-force参数

注意：即使在CRS关闭后，也必须通过-force参数来添加删除votedisk。并且-force参数只有在crs关闭的场合下使用才安全。因为votedisk的数量应该是奇数，所以添加删除操作都是成对进行的。

我们在RAC上增加了两个裸设备，分别都是2G

--添加前
[root@rac3 ~]# raw -qa
/dev/raw/raw1: bound to major 8, minor 17
/dev/raw/raw2: bound to major 8, minor 33
/dev/raw/raw3: bound to major 8, minor 49
/dev/raw/raw4: bound to major 8, minor 65
/dev/raw/raw5: bound to major 8, minor 81
[root@rac3 ~]#

延伸：
vmware workstation RAC环境下添加共享磁盘（裸设备）：

1.在一个节点上创建好虚拟磁盘，预先分配好空间，并设置好磁盘的虚拟设备节点[虚拟机设置-->点击要设置的磁盘-->右边高级选项]
2.在另外节点添加虚拟机磁盘，选择添加已存在的盘，选择在第一个节点创建的盘，并把虚拟设备节点与第一台设备设置为相同
3.fdisk -l 在两个节点上都能看到盘，划分去
4.修改/etc/sysconfig/rawdevices 添加裸设备与磁盘的对应关系
5.重启裸设备服务 service rawdevices start

--添加后
[root@rac3 ~]# raw -qa
/dev/raw/raw1: bound to major 8, minor 17
/dev/raw/raw2: bound to major 8, minor 33
/dev/raw/raw3: bound to major 8, minor 49
/dev/raw/raw4: bound to major 8, minor 65
/dev/raw/raw5: bound to major 8, minor 81
/dev/raw/raw7: bound to major 8, minor 97 --新添加
/dev/raw/raw8: bound to major 8, minor 113 --新添加

[root@rac4 bin]# ./crsctl query css votedisk

 .         /dev/raw/raw2

located  votedisk(s).

[root@rac4 bin]# ./crsctl add css votedisk /dev/raw/raw7      --必须增加force选项

Cluster is not in a ready state for online disk addition

[root@rac4 bin]# ./crsctl add css votedisk /dev/raw/raw7 -force   --没有关闭crs,增加失败

Now formatting voting disk: /dev/raw/raw7

CLSFMT returned with error [].

failed  to initailize votedisk /dev/raw/raw7.

[root@rac4 bin]#

[root@rac4 bin]# ./crsctl stop crs   --所有节点都关闭

Stopping resources.

Successfully stopped CRS resources

Stopping CSSD.

Shutting down CSS daemon.

Shutdown request successfully issued.

[root@rac4 bin]# ./crsctl add css votedisk /dev/raw/raw7 -force  --再添加提示我们已经有了【保险点，重新添加】

votedisk named /dev/raw/raw7 already configured as /dev/raw/raw7.

[root@rac4 bin]# ./crsctl delete css votedisk /dev/raw/raw7   --删除刚次的添加

successful deletion of votedisk /dev/raw/raw7.

[root@rac4 bin]# ./crsctl add css votedisk /dev/raw/raw7 -force   --还是不成功

Now formatting voting disk: /dev/raw/raw7

CLSFMT returned with error [].

failed  to initailize votedisk /dev/raw/raw7.

--重启系统后增加成功，【成对增加或删除】(新增加了裸设备，重启一下系统还是比重启一下裸设备服务保险点)，用来测试的裸设备的有点大，格式化时间会长一点

[root@rac4 bin]# ./crsctl query css votedisk

 .         /dev/raw/raw2

located  votedisk(s).

[root@rac4 bin]# ./crsctl add css votedisk /dev/raw/raw7 -force

Now formatting voting disk: /dev/raw/raw7

successful addition of votedisk /dev/raw/raw7.

[root@rac4 bin]# ./crsctl query css votedisk

 .         /dev/raw/raw2

 .         /dev/raw/raw7

located  votedisk(s).

[root@rac4 bin]# ./crsctl add css votedisk /dev/raw/raw8 -force

Now formatting voting disk: /dev/raw/raw8

successful addition of votedisk /dev/raw/raw8.

[root@rac4 bin]# ./crsctl query css votedisk

 .         /dev/raw/raw2

 .         /dev/raw/raw7

 .         /dev/raw/raw8

located  votedisk(s).

--另一节点查看

[root@rac3 bin]# ./crsctl query css votedisk

 .         /dev/raw/raw2

 .         /dev/raw/raw7

 .         /dev/raw/raw8

--删除votedisk

[root@rac4 bin]# ./crsctl delete css votedisk /dev/raw/raw7

Cluster is not in a ready state for online disk removal

[root@rac4 bin]# ./crsctl delete css votedisk /dev/raw/raw7 -force

successful deletion of votedisk /dev/raw/raw7.

[root@rac4 bin]# ./crsctl delete css votedisk /dev/raw/raw8 -force

successful deletion of votedisk /dev/raw/raw8.

[root@rac4 bin]# ./crsctl query css votedisk

 .         /dev/raw/raw2

located  votedisk(s).

15.备份Votedisk

<1>. 刘宪军的《Oracle RAC 11g实战指南》p94第9行：“从Oracle 11.2开始，Voting文件的备份不需要手工进行，只要对Clusterware的结构做了修改，Voting文件便被自动备份到OCR文件中。”

<2>. 刘炳林的《构建最高可用Oracle数据库系统 Oracle11gR2 RAC管理、维护与性能优化》p326第2行：“在Clusterware 11gR2中，不需要备份表决磁盘。表决磁盘的任何改变会自动备份到OCR备份文件中，相关信息会自动还原到任何添加的表决磁盘文件中。”

[oracle@rac3 ~]$ dd if=/dev/raw/raw2 of=/home/oracle/votedisk.bak

208864+0 records in

208864+0 records out

同样恢复的命令是 dd if=/home/oracle/votedisk.bak of=/dev/raw/raw2

16.清除裸设备的内容（我们之前增加的两个裸设备，重装crs的时候需要清除一下裸设备）

[root@rac3 bin]# dd if=/dev/zero of=/dev/raw/raw7 bs=10M

dd: writing `/dev/raw/raw7': No space left on device

+ records in

+ records out

[root@rac3 bin]# dd if=/dev/zero of=/dev/raw/raw8 bs=10M

dd: writing `/dev/raw/raw8': No space left on device

+ records in

+ records out

17.使用ocrdump打印ocr内容

ocrdump命令能以ASCII的方式打印出OCR的内容，这是这个命令不能用作OCR的辈分恢复，也就是说产生的文件只能用于阅读，而不能用于恢复OCR.

执行 ocrdump -help 寻求帮组

orcdump [-stdout] [filename] [-keyname name] [-xml]

【-stdout】把内容打印输出到屏幕上

【filename】把内容输出到文件中

【-keyname name】只打印某个键及其子键的内容

【-xml】以.xml格式打印输出

--把SYSTEM.css键的内容以.xml格式打印输出到屏幕上

[root@rac3 bin]# ./ocrdump -stdout -keyname SYSTEM.css -xml|more

<OCRDUMP>

<TIMESTAMP>// ::</TIMESTAMP>

<COMMAND>./ocrdump.bin -stdout -keyname SYSTEM.css -xml </COMMAND>

<KEY>

<NAME>SYSTEM.css</NAME>

<VALUE_TYPE>UNDEF</VALUE_TYPE>

<VALUE><![CDATA[]]></VALUE>

<USER_PERMISSION>PROCR_ALL_ACCESS</USER_PERMISSION>

<GROUP_PERMISSION>PROCR_READ</GROUP_PERMISSION>

<OTHER_PERMISSION>PROCR_READ</OTHER_PERMISSION>

<USER_NAME>root</USER_NAME>

<GROUP_NAME>root</GROUP_NAME>

。。。。。。

ocrdump命令执行过程中会在$CRS_HOME/log/<nodename>/client目录下产生日志文件，文件名ocrdump_<pid>.log,
如果命令执行出现问题，可以从这个日志查看问题原因。

[root@rac3 client]# pwd

/opt/ora10g/product/10.2./crs_1/log/rac3/client

[root@rac3 client]# ll -ltr ocrdump_2*

-rw-r-----   root root  Jan  : ocrdump_26850.log

-rw-r-----   root root  Jan  : ocrdump_29423.log

18.使用ocrcheck检查OCR内容的一致性

该命令用于检查OCR内容的一致性，命令执行过程中会在$CRS_HOME/log/<nodename>/client/ocrcheck_<pid>.log日志文件。这个命令没有参数。

[root@rac3 bin]# ./ocrcheck

Status of Oracle Cluster Registry is as follows :

         Version                  :

         Total space (kbytes)     :

         Used space (kbytes)      :

         Available space (kbytes) :

         ID                       :

         Device/File Name         : /dev/raw/raw1    --OCR盘所在位置

                                    Device/File integrity check succeeded   --这里表示内容一致，内容不一致的话会输出 Device/File needs to be synchronized with the other device

                                    Device/File not configured

         Cluster registry integrity check succeeded

--查看该命令生成的日志

[root@rac3 client]# pwd

/opt/ora10g/product/10.2./crs_1/log/rac3/client

[root@rac3 client]# ll -ltr ocrcheck_*

-rw-r-----   oracle oinstall  Apr    ocrcheck_25577.log

-rw-r-----   root   root      Jan  : ocrcheck_7947.log

19.使用ocrconfig命令维护OCR磁盘

ocrconfig命令用于维护OCR磁盘，安装Clusterware过程中，如果选择External Redundancy冗余方式，则只能输入一个OCR磁盘位置。但是Oracle允许配置两个OCR磁盘互为镜像，以防止OCR磁盘的单点故障。OCR磁盘和votedisk磁盘不一样，OCR磁盘最多只能有两个，一个Primary OCR和一个Mirror OCR（镜像的OCR）。

[root@rac3 bin]# ./ocrconfig -help

Name:

        ocrconfig - Configuration tool for Oracle Cluster Registry.

Synopsis:

        ocrconfig [option]

        option:

                -export <filename> [-s online]

                                                    - Export cluster register contents to a file

                -import <filename>                  - Import cluster registry contents from a file

                -upgrade [<user> [<group>]]

                                                    - Upgrade cluster registry from previous version

                -downgrade [-version <version string>]

                                                    - Downgrade cluster registry to the specified version

                -backuploc <dirname>                - Configure periodic backup location

                -showbackup                         - Show backup information

                -restore <filename>                 - Restore from physical backup

                -replace ocr|ocrmirror [<filename>] - Add/replace/remove a OCR device/file

                -overwrite                          - Overwrite OCR configuration on disk

                -repair ocr|ocrmirror <filename>    - Repair local OCR configuration

                -help                               - Print out this help information

Note:

        A log file will be created in

        $ORACLE_HOME/log/<hostname>/client/ocrconfig_<pid>.log. Please ensure

        you have file creation privileges in the above directory before

        running this tool.

ocrconfig命令非常的重要，我们通过一些试验来了解该命令：
http://www.cnblogs.com/myrunning/p/4253696.html

##RAC应用层的一些命令

20.crs_stat命令维护crs资源

crs_stat这个命令用于查看CRS维护的所有资源的运行状态。如果不带任何参数时，显示所有资源的概要信息。每个资源显示各个属性：资源的名称、类型、目标、资源状态等。

--查看所有资源详细信息

[oracle@rac3 ~]$ crs_stat

NAME=ora.rac3.ASM1.asm

TYPE=application

TARGET=ONLINE

STATE=ONLINE on rac3

NAME=ora.rac3.LISTENER_RAC3.lsnr

TYPE=application

TARGET=ONLINE

STATE=ONLINE on rac3

NAME=ora.rac3.gsd

TYPE=application

TARGET=ONLINE

STATE=ONLINE on rac3

NAME=ora.rac3.ons

TYPE=application

TARGET=ONLINE

STATE=ONLINE on rac3

。。。。。。。。。。。。

--查看指定资源的状态

[oracle@rac3 ~]$ crs_stat ora.racdb.racdb1.inst

NAME=ora.racdb.racdb1.inst

TYPE=application

TARGET=ONLINE

STATE=ONLINE on rac3

--使用-v选项查看详细

[oracle@rac3 ~]$ crs_stat -v ora.racdb.racdb1.inst

NAME=ora.racdb.racdb1.inst

TYPE=application

RESTART_ATTEMPTS=

RESTART_COUNT=

FAILURE_THRESHOLD=

FAILURE_COUNT=

TARGET=ONLINE

STATE=ONLINE on rac3

--使用-p选项查看更详细信息

[oracle@rac3 ~]$ crs_stat -p ora.racdb.racdb1.inst

NAME=ora.racdb.racdb1.inst

TYPE=application

ACTION_SCRIPT=/opt/ora10g/product/10.2./db_1/bin/racgwrap

ACTIVE_PLACEMENT=

AUTO_START=

CHECK_INTERVAL=

DESCRIPTION=CRS application for Instance

FAILOVER_DELAY=

FAILURE_INTERVAL=

FAILURE_THRESHOLD=

HOSTING_MEMBERS=rac3

OPTIONAL_RESOURCES=

PLACEMENT=restricted

REQUIRED_RESOURCES=ora.rac3.vip ora.rac3.ASM1.asm

RESTART_ATTEMPTS=

SCRIPT_TIMEOUT=

START_TIMEOUT=

STOP_TIMEOUT=

UPTIME_THRESHOLD=7d

USR_ORA_ALERT_NAME=

USR_ORA_CHECK_TIMEOUT=

USR_ORA_CONNECT_STR=/ as sysdba

USR_ORA_DEBUG=

USR_ORA_DISCONNECT=false

USR_ORA_FLAGS=

USR_ORA_IF=

USR_ORA_INST_NOT_SHUTDOWN=

USR_ORA_LANG=

USR_ORA_NETMASK=

USR_ORA_OPEN_MODE=

USR_ORA_OPI=false

USR_ORA_PFILE=

USR_ORA_PRECONNECT=none

USR_ORA_SRV=

USR_ORA_START_TIMEOUT=

USR_ORA_STOP_MODE=immediate

USR_ORA_STOP_TIMEOUT=

USR_ORA_VIP=

--使用-ls选项，查看每个资源的权限定义

[oracle@rac3 ~]$ crs_stat -ls

Name           Owner          Primary PrivGrp          Permission

-----------------------------------------------------------------

ora....SM1.asm oracle         oinstall                 rwxrwxr--

ora....C3.lsnr oracle         oinstall                 rwxrwxr--

ora.rac3.gsd   oracle         oinstall                 rwxr-xr--

ora.rac3.ons   oracle         oinstall                 rwxr-xr--

ora.rac3.vip   root           oinstall                 rwxr-xr--

ora....SM2.asm oracle         oinstall                 rwxrwxr--

ora....C4.lsnr oracle         oinstall                 rwxrwxr--

ora.rac4.gsd   oracle         oinstall                 rwxr-xr--

ora.rac4.ons   oracle         oinstall                 rwxr-xr--

ora.rac4.vip   root           oinstall                 rwxr-xr--

ora.racdb.db   oracle         oinstall                 rwxrwxr--

ora....b1.inst oracle         oinstall                 rwxrwxr--

ora....b2.inst oracle         oinstall                 rwxrwxr--

ora....rver.cs oracle         oinstall                 rwxrwxr--

ora....db2.srv oracle         oinstall                 rwxrwxr--

21.rac srvctl命令使用理解

srvctl命令是RAC维护中最常用到的命令，也最为复杂，使用这个命令可以操作CRS上的Database,Instance, ASM,Service、Listener和Node Application资源，其中Node Application资源又包括了GSD、ONS、VIP。

这些资源还有独立的管理工具，比如

ONS可以使用onsctl命令进行管理： http://www.cnblogs.com/myrunning/p/4265522.html

listener还可以通过lsnrctl命令进行管理：http://www.cnblogs.com/myrunning/p/3977931.html

srvctl命令使用理解：http://www.cnblogs.com/myrunning/p/4265539.html

码农公寓

相关文章