通过复制构建Oracle数据库Active DataGuard（ADG）
发布时间
阅读量：
阅读量
**
**
1 ：配置情况（主库需要建立实例，从库只需要安装软件）
主库
Centos6.7
Oracle 11.2.0.4.0
IP:192.168.1.155 sid:orcl
备库
Centos6.7
Oracle 11.2.0.4.0软件
IP：192.168.1.156
2 ：关闭防火墙(两边都需要操作)
lsnrctl iptables stop
chkconfig iptables off
3: 配置监听
主库
修改listener.ora
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(GLOBAL_DBNAME = dg1)
(ORACLE_HOME = /u01/oracle/11g)
(SID_NAME = orcl)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = dg1)(PORT = 1521))
)
)
)
修改tnsnames.ora
dg1 =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOS
全部评论 (0)
还没有任何评论哟~