Oracle RAC11g上关于服务操作的一些命令小结:
首先可以通过crsctl status serverpool -p 打印出已有serverpool的基本信息,其中已有service的serverpool中会有SERVER_NAMES字段,是说明service对应的实例名。如下:
[oracle@rac10g1 ~]$ crsctl status serverpool -p
NAME=Free
IMPORTANCE=0
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=
PARENT_POOLS=
EXCLUSIVE_POOLS=
ACL=owner:grid:rwx,pgrp:oinstall:rwx,other::r-x
NAME=Generic
IMPORTANCE=0
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=rac10g1 rac10g2
PARENT_POOLS=
EXCLUSIVE_POOLS=
ACL=owner:grid:r-x,pgrp:oinstall:r-x,other::r-x
NAME=ora.rac11g
IMPORTANCE=1
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=rac10g1 rac10g2
PARENT_POOLS=Generic
EXCLUSIVE_POOLS=
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
NAME=ora.rac11g_ocm
IMPORTANCE=0
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=rac10g2 rac10g1
PARENT_POOLS=ora.rac11g
EXCLUSIVE_POOLS=
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
NAME=ora.rac11g_ocp
IMPORTANCE=0
MIN_SIZE=0
MAX_SIZE=-1
SERVER_NAMES=rac10g1 rac10g2
PARENT_POOLS=ora.rac11g
EXCLUSIVE_POOLS=
ACL=owner:oracle:rwx,pgrp:oinstall:rwx,other::r--
有以下Policy-Managed方式和Admin-Managed方式两种方式来管理Service,可以通过srvctl config database -d racdb
关于serverpool的文章可以参照:
http://czmmiao.iteye.com/blog/2128771
*************************************
Database is administrator managed
这就说明是以Admin Managed 来管理RAC。
==========================================================
使用srvctl 命令来创建,修改,删除,启动,停止 Service:
srvctl add service -d rac11g -s ocm -r rac11g1 -a rac11g2
srvctl modify service -d rac11g -s ocm -r rac11g1 -a rac11g2 -n
srvctl start service -d rac11g -s ocm -i rac11g1