使用 TNSNAMES.ORA 文件:
在客户端计算机上配置 TNSAMES.ORA 文件,该文件包含与 Oracle RAC 集群的连接信息。在文件中定义数据库连接别名和连接描述符。然后,在客户端应用程序中使用别名作为数据库连接的目标。
例如:
ORACLERAC =
(DESCRIPTION =
(ADDRESS_LIST =
(LOAD_BALANCEon)
(FAILOVER=on)
(ADDRESS = (PROTOCOL = TCP)(HOST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
(ADDRESS = (PROTOCOL = TCP)(HOST =
)
(CONNECT_DATA =
(SERVICE_NAME =
(FAILOVER_MODE =
(TYPE=select)
(METHOD=basic)
)
)
)
然后可以使用别名 "ORACLERAC" 来连接到 Oracle RAC。