• 技术文章 >数据库 >mysql教程

    Oracle 10g RAC网络设置

    2016-06-07 16:18:41原创480

    在Oracle10g RAC的安装过程中,网络的设置需要谨慎,也极其重要。 以下将我的Oracle10g RAC环境的网络配置列举一下,供参考。 1.hosts文件的设置 由于RAC要设置多个地址,所以需要准备好网络环境,我的hosts文件设置如下: # # Internet host table # 127.0.

    在Oracle10g RAC的安装过程中,,网络的设置需要谨慎,也极其重要。

    以下将我的Oracle10g RAC环境的网络配置列举一下,供参考。

    1.hosts文件的设置

    由于RAC要设置多个地址,所以需要准备好网络环境,我的hosts文件设置如下:

    #

    # Internet host table

    #

    127.0.0.1 localhost

    172.16.19.11 db210-rac1 db210-rac1.hurray.com.cn loghost

    172.16.19.211 db210-rac1vip db210-rac1vip.hurray.com.cn

    192.168.18.11 db210-rac1priv db210-rac1priv.hurray.com.cn

    192.168.19.11 db210-rac1hb db210-rac1hb.hurray.com.cn

    172.16.19.12 db210-rac2 db210-rac2.hurray.com.cn

    172.16.19.212 db210-rac2vip db210-rac2vip.hurray.com.cn

    192.168.18.12 db210-rac2priv db210-rac2priv.hurray.com.cn

    192.168.19.12 db210-rac2hb db210-rac2hb.hurray.com.cn

    2.监听器的配置

    我的监听器文件配置如下:

    bash-2.05$ cat listener.ora

    # listener.ora.db210-rac1 Network Configuration

    File: /opt/oracle/product/10.2.0/db/network/admin/listener.ora.db210-rac1

    # Generated by Oracle configuration tools.
    LISTENER_DB210-RAC1 =

    (DESCRIPTION_LIST =

    (DESCRIPTION =

    (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac1vip)(PORT = 1521)(IP = FIRST))

    )

    (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.19.11)(PORT = 1521)(IP = FIRST))

    )

    (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))

    )

    )

    )


    3.tnsnames.ora文件配置

    网络服务名等配置如下:

    bash-2.05$ cat tnsnames.ora

    # tnsnames.ora Network Configuration File: /opt/oracle/product/10.2.0/db/network/admin/tnsnames.ora

    # Generated by Oracle configuration tools.

    EYGLE2 =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac2vip)(PORT = 1521))

    (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = eygle)

    (INSTANCE_NAME = eygle2)

    )

    )
    EYGLE1 =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac1vip)(PORT = 1521))

    (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = eygle)

    (INSTANCE_NAME = eygle1)

    )

    )

    EYGLE =

    (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac1vip)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac2vip)(PORT = 1521))

    (LOAD_BALANCE = yes)

    (CONNECT_DATA =

    (SERVER = DEDICATED)

    (SERVICE_NAME = eygle)

    (FAILOVER_MODE =

    (TYPE = SELECT)

    (METHOD = BASIC)

    (RETRIES = 180)

    (DELAY = 5)

    )

    )

    )

    LISTENERS_EYGLE =

    (ADDRESS_LIST =

    (ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac1vip)(PORT = 1521))

    (ADDRESS = (PROTOCOL = TCP)(HOST = db210-rac2vip)(PORT = 1521))

    )

    这就是主要的一些配置文件,其中,Oracle的相关配置文件都是自动生成的,VIP可以实现故障时的自动切换。

    声明:本文内容由网友自发贡献,版权归原作者所有,本站不承担相应法律责任。如您发现有涉嫌抄袭侵权的内容,请联系admin@php.cn核实处理。
    专题推荐:Oracle 网络 设置
    上一篇:解析SQLServer任意列之间的聚合 下一篇:如何对Oracle中的优化器进行评估优化

    相关文章推荐

    • mysql怎样修改用户• 完全掌握MySQL三大日志binlog、redo log和undo log• mysql怎样增加表格• mysql怎样查询最新的一条记录• mysql中怎么调用存储过程

    全部评论我要评论

  • 取消发布评论发送
  • 1/1

    PHP中文网