ITPub博客

首页 > 数据库 > Oracle > oracle 配置传统的双机ha时需要修改的相关文件

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

原创 Oracle 作者:msdnchina 时间:2011-09-18 23:10:18 0 删除 编辑

假设如下的环境
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@]

来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/161195/viewspace-1055174/ ,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2008-07-30

  • 博文量
    498
  • 访问量
    1542059