adg oracle 架构_案例:Oracle11G RAC TO 11G RAC ADG详细配置 精华干货

天萃荷净

Oracle 11G RAC TO 11G RAC ADG详细配置

Oracle 11G RDBMS主库tnsnames.ora配置

在主备库的数据库的tns中均增加如下配置

q9dbdg =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = q9db01-dg-vip)(PORT = 1522))

(ADDRESS = (PROTOCOL = TCP)(HOST = q9db02-dg-vip)(PORT = 1522))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = q9db)

)

)

q9adgdg =

(DESCRIPTION =

(ADDRESS = (PROTOCOL = TCP)(HOST = q9adg01-dg-vip)(PORT = 1522))

(ADDRESS = (PROTOCOL = TCP)(HOST = q9adg02-dg-vip)(PORT = 1522))

(CONNECT_DATA =

(SERVER = DEDICATED)

(SERVICE_NAME = q9db)

)

)

Oracle11G RAC主库修改参数配置

alter system set DB_UNIQUE_NAME=q9db scope=spfile;</