1.创建了两节点
2.创建服务管理实例(dbca或srvctl)
3.dbca创建
rac1-> dbca
- 欢迎页面:选择 Oracle Real Application Clusters database。
- 操作:选择 Services Management。
- 集群数据库列表:单击 Next。
- 数据库服务:单击 Add。
- 添加服务:输入“CRM”。
- 选择 devdb1 作为首选实例。
- 选择 devdb2 作为可用实例。
- TAF 策略:选择 Basic。
- 单击 Finish。
- 添加服务:输入“CRM”。
数据库配置助手将在 tnsnames.ora 中创建以下 CRM 服务名项:
CRM = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = rac1-vip)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = rac2-vip)(PORT = 1521)) (LOAD_BALANCE = yes) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = CRM) (FAILOVER_MODE = (TYPE = SELECT) (METHOD = BASIC) (RETRIES = 180) (DELAY = 5) ) ) )
4.在客户端tns配置
HOMECRM =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.191)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.192)(PORT = 1521))
(LOAD_BALANCE = yes)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = CRM)
(FAILOVER_MODE =
(TYPE = SELECT)
(METHOD = BASIC)
(RETRIES = 180)
(DELAY = 5)
)
)
)
5.其中实例1为首选,在1上执行shutdown abort,
重新在客户端pl/sql developer 按F8刷新不报错,可继续显示结果,实现透明切换;
6.备注
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.....CRM.cs application ONLINE ONLINE rac1
ora....db1.srv application ONLINE ONLINE rac2
ora.devdb.db application ONLINE ONLINE rac1
ora....b1.inst application OFFLINE OFFLINE
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
7.2节点
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string devdb, CRM
8.重新将将1节点设为首选
srvctl relocate service -d devdb -s crm -i devdb2 -t devdb1
rac1-> srvctl relocate service -d devdb -s crm -i devdb2 -t devdb1
rac1-> crs_stat -t
Name Type Target State Host
------------------------------------------------------------
ora.....CRM.cs application ONLINE ONLINE rac1
ora....db1.srv application ONLINE ONLINE rac1
ora.devdb.db application ONLINE ONLINE rac1
ora....b1.inst application ONLINE ONLINE rac1
ora....b2.inst application ONLINE ONLINE rac2
ora....SM1.asm application ONLINE ONLINE rac1
ora....C1.lsnr application ONLINE ONLINE rac1
ora.rac1.gsd application ONLINE ONLINE rac1
ora.rac1.ons application ONLINE ONLINE rac1
ora.rac1.vip application ONLINE ONLINE rac1
ora....SM2.asm application ONLINE ONLINE rac2
ora....C2.lsnr application ONLINE ONLINE rac2
ora.rac2.gsd application ONLINE ONLINE rac2
ora.rac2.ons application ONLINE ONLINE rac2
ora.rac2.vip application ONLINE ONLINE rac2
9.1节点显示
SQL> show parameter service
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
service_names string CRM
10.实验完成;