背景介绍:
2.在主库中创建并启动service
在switchover或failover时主库进行切换后,客户端获得自己重连主库的能力。
环境修改:
1.修改$ORACLE_HOME/network/admin/tnsnames.ora
PRIOCM=
(DESCRIPTION =
(ADDRESS_LIST=
(ADDRESS = (PROTOCOL = TCP)(HOST = ocm1.example.com)(PORT = 1521)) --主库
(ADDRESS = (PROTOCOL = TCP)(HOST = ocm2.example.com)(PORT = 1521)) --备库
)
(CONNECT_DATA =
(SERVICE_NAME = priocm) --指定service名字
)
)
2.在主库中创建并启动service
begin
dbms_service.create_service('priocm','priocm'); --service_name,network_name
end;
/
begin
DBMS_SERVICE.START_SERVICE('priocm');
end;
/