您好,欢迎访问一九零五行业门户网

手工方式配置Service的过程

在使用srvctl创建service时,需要注意taf策略选项必须通过dbms_service包来配置。下面例子演示了如何创建一个服务felix_ora: 1.创建之前查看系统现有的service: sql show parameter service name type value ------------------------------------ -------
在使用srvctl创建service时,需要注意taf策略选项必须通过dbms_service包来配置。下面例子演示了如何创建一个服务felix_ora:
1.创建之前查看系统现有的service:sql> show parameter service
name type value
------------------------------------ -----------------------------------------
service_names string felix
sql>
2.使用srvctl创建felix_ora服务;[oracle@felix1 ~]$ srvctl add service -d felix -s felix_ora -r felix1 -a felix2 -p basic
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl config service -d felix-a
felix_ora pref: felix1 avail: felix2 taf: basic
[oracle@felix1 ~]$ srvctl status service -d felix
service felix_ora is not running.
[oracle@felix1 ~]$
3.确认服务创建成功,以下标红部分说明服务已经作为一项crs resource注册到crs中,但是目前没有启动。[oracle@felix1 ~]$ crs_stat -t -v
name type r/ra f/ft target state host
----------------------------------------------------------------------
ora.felix.db application 0/0 0/1 online online felix1
ora....x1.inst application 0/5 0/0 online online felix1
ora....x2.inst application 0/5 0/0 online online felix2
ora...._ora.cs application 0/0 0/1 offline offline
ora....ix1.srv application 0/0 0/0 offline offline
ora....sm1.asm application 0/5 0/0 online online felix1
ora....x1.lsnr application 0/5 0/0 online online felix1
ora.felix1.gsd application 0/5 0/0 online online felix1
ora.felix1.ons application 0/3 0/0 online online felix1
ora.felix1.vip application 0/0 0/0 online online felix1
ora....sm2.asm application 0/5 0/0 online online felix2
ora....x2.lsnr application 0/5 0/0 online online felix2
ora.felix2.gsd application 0/5 0/0 online online felix2
ora.felix2.ons application 0/3 0/0 online online felix2
ora.felix2.vip application 0/0 0/0 online online felix2
[oracle@felix1 ~]$
4.配置服务自动启动[oracle@felix1 ~]$ srvctl enable service -d felix-s felix_ora
prkp-1018 : service felix_ora already enabled.
[oracle@felix1 ~]$
5.启动这个服务[oracle@felix1 ~]$ srvctl start service -d felix -s felix_ora
[oracle@felix1 ~]$
[oracle@felix1 ~]$ srvctl status service -d felix -s felix_ora
service felix_ora is running on instance(s) felix1
[oracle@felix1 ~]$
6.确认服务状态;[oracle@felix2 ~]$ crs_stat -t -v
name type r/ra f/ft target state host
----------------------------------------------------------------------
ora.felix.db application 0/0 0/1 online online felix1
ora....x1.inst application 0/5 0/0 online online felix1
ora....x2.inst application 0/5 0/0 online online felix2
ora...._ora.cs application 0/0 0/1 online online felix1
ora....ix1.srv application 0/0 0/0 online online felix1
ora....sm1.asm application 0/5 0/0 online online felix1
ora....x1.lsnr application 0/5 0/0 online online felix1
ora.felix1.gsd application 0/5 0/0 online online felix1
ora.felix1.ons application 0/3 0/0 online online felix1
ora.felix1.vip application 0/0 0/0 online online felix1
ora....sm2.asm application 0/5 0/0 online online felix2
ora....x2.lsnr application 0/5 0/0 online online felix2
ora.felix2.gsd application 0/5 0/0 online online felix2
ora.felix2.ons application 0/3 0/0 online online felix2
ora.felix2.vip application 0/0 0/0 online online felix2
[oracle@felix2 ~]$
说明已经全部启动了;
新建的服务会自动添加到初始化参数文件中:
sql> show parameter service
name type value
------------------------------------ -----------------------------------------
service_names string felix, felix_ora
sql>
7.修改service的taf配置,需要使用dbms_service.modify_servicebegin
dbms_service.modify_service(service_name => 'felix_ora',
failover_method =>dbms_service.failover_method_basic,
failover_type =>dbms_service.failover_type_select,
failover_retries => 180,
failover_delay => 5);
end;
/
pl/sql procedure successfully completed.
8.确认以生效
set lines 1000 pages 1000
col name for a50
col clb_goal for a15
col failover_method for a15
col failover_type for a20;
sql> selectname,failover_method,failover_type,clb_goal from dba_services;
name failover_method failover_type clb_goal
----------------------------------------------------------------- -------------------- ---------------
sys$background short
sys$users short
seeddataxdb long
seeddata.regress.rdbms.dev.us.oracle.com long
felixxdb long
felix long
taf_server long
taf_srvctl long
felix_ora basic select long
9 rows selected.
[oracle@felix1 ~]$ srvctl config service -d felix -a
felix_ora pref: felix1 avail: felix2 taf: basic
[oracle@felix1 ~]$
【参考大话rac--张晓明】
其它类似信息

推荐信息