oracle 创建新的链接

最新推荐文章于 2022-11-14 11:20:16 发布

最新推荐文章于 2022-11-14 11:20:16 发布 · 219 阅读

文章标签：

#Oracle

本文介绍如何在tnsnames.ora文件中配置Oracle数据库链接，包括COREV6_DBSERVER和V5两个链接的详细设置。通过指定主机地址、端口和服务名等参数，实现与不同数据库实例的有效连接。

D:\oracle\ora92\network\admin\tnsnames.ora

创建新的链接

COREV6_DBSERVER =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = corev6)
      (SERVER = DEDICATED)
    )
)

V5 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = *.*.*.*)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ZMIIMS)
    )
)