Oracle 10g RAC 网络设置

最新推荐文章于 2025-12-27 08:36:50 发布

转载最新推荐文章于 2025-12-27 08:36:50 发布 · 94 阅读

文章标签：

#数据库 #网络

本文展示了Oracle Real Application Clusters (RAC) 的配置文件示例，包括 hosts 文件中定义的网络地址、tnsnames.ora 中的服务实例描述以及 listener.ora 中的监听器配置。

ecsrac01$cat hosts

127.0.0.1 localhost.localdomain localhost

10.134.130.177 ecsrac01

192.168.1.11 ecspri01
10.134.130.179 ecsvip01

10.134.130.178 ecsrac02
192.168.1.12 ecspri02
10.134.130.180 ecsvip02

----------------------------------------------

ecsrac01$cat tnsnames.ora
# tnsnames.ora Network Configuration File: /u01/product/oracle/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

ECSDB2 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip02)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ecsdb)
      (INSTANCE_NAME = ecsdb2)
    )
)

ECSDB1 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip01)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ecsdb)
      (INSTANCE_NAME = ecsdb1)
    )
)

ECSDB =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip01)(PORT = 1521))
    (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip02)(PORT = 1521))
    (LOAD_BALANCE = yes)
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = ecsdb)
    )
)

LISTENERS_ECSDB =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip01)(PORT = 1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip02)(PORT = 1521))
)

------------------------------------------------------------------------------------------------

ecsrac01$cat listener.ora
# listener.ora.ecsrac01 Network Configuration File: /u01/product/oracle/network/admin/listener.ora.ecsrac01
# Generated by Oracle configuration tools.

LISTENER_ECSRAC01 =
(DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = ecsvip01)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 10.134.130.177)(PORT = 1521)(IP = FIRST))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
    )
)