tnsnames.ora数据库连接的设置

最新推荐文章于 2025-05-02 14:30:10 发布

overmind

最新推荐文章于 2025-05-02 14:30:10 发布

阅读量1.5k

点赞数

CC 4.0 BY-SA版权

分类专栏： sql 文章标签：数据库 service sql server list oracle server

本文链接：https://blog.youkuaiyun.com/overmind/article/details/322183

sql 专栏收录该内容

36 篇文章

订阅专栏

博客介绍了Oracle的tnsnames.ora文件，位于D:/oracle/ora9/network/admin/路径下，设置该文件可方便sql plus登陆。还给出了文件中的配置示例，同时提到作者发现Oracle似乎比SQL Server复杂，dblink操作还待研究。

D:/oracle/ora9/network/admin/tnsnames.ora

里面有个这样的一个文件，通过设置它可以方便sql plus的登陆，具体由一些什么样的应用，或者，具体怎么使用dblink进行操作，我还要研究一下，发现oracle似乎比sql server复杂很多。

# TNSNAMES.ORA Network Configuration File: D:/oracle/ora9/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

INST1_HTTP =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = overmind)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = SHARED)
      (SERVICE_NAME = MODOSE)
      (PRESENTATION = http://HRService)
    )
)

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

OVERMIND =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = overmind)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = overmind)
    )
)

BV_210 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 210.74.178.23)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = bv)
    )
)