如何在oracle中配置数据库的网络连接

最新推荐文章于 2024-03-08 08:30:00 发布

原创最新推荐文章于 2024-03-08 08:30:00 发布 · 174 阅读

0 ·

CC 4.0 BY-SA版权

本文介绍了Oracle数据库中tnsnames.ora文件的配置方法，详细展示了如何设置不同数据库实例的连接参数，包括主机名、端口和服务名称等。

G:\oracle\product\10.2.0\db_2\NETWORK\ADMIN\tnsnames.ora

该文件为以下格式:

# tnsnames.ora Network Configuration File: G:\oracle\product\10.2.0\db_2\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

ZXIN =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = LENOVO-40E97FC2)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = zxin)
    )
)

ZXIN250 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.4.250)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = zxin)
    )
)

EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
)