oracle 配置传统的双机ha时需要修改的相关文件

假设如下的环境
1号机主机名为hosta,物理ip地址为192.168.0.1
2号机主机名为hostb,物理ip地址为192.168.0.2
active ip(ha软件虚拟出来的ip) 地址为192.168.0.10

1. /etc/hosts文件中,可以有127.0.0.1这一行,但是127.0.0.1之后,不能有主机名。可以是127.0.0.1 localhost 等等

2.1号主机的/etc/hosts文件,应该有如下的行:
192.168.0.1 hosta
192.168.0.2 hostb
192.168.0.10 cluster

3.2号主机的/etc/hosts文件,应该有如下的行:
192.168.0.1 hosta
192.168.0.2 hostb
192.168.0.10 cluster

4.1号主机中oracle_home/network/admin下的listener.ora文件配置:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:appAdministratorproduct11.1.0db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_NAME = ora11g)
(ORACLE_HOME = F:appAdministratorproduct11.1.0db_1)
(SID_NAME = ora11g)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cluster)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)

注意:以上HOST = cluster 可以换成HOST = 192.168.0.10

5.2号主机中oracle_home/network/admin下的listener.ora文件配置:

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = F:appAdministratorproduct11.1.0db_1)
(PROGRAM = extproc)
)
(SID_DESC =
(GLOBAL_NAME = ora11g)
(ORACLE_HOME = F:appAdministratorproduct11.1.0db_1)
(SID_NAME = ora11g)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = cluster)(PORT = 1521))
)
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
)


注意:以上HOST = cluster 可以换成HOST = 192.168.0.10

[@more@]
请使用浏览器的分享功能分享到微信等