关于plsql developer 连 Oracle 的配置文件 tnsnames.ora

最新推荐文章于 2025-06-09 14:54:35 发布

programpoet

最新推荐文章于 2025-06-09 14:54:35 发布

阅读量3.2w

点赞数

CC 4.0 BY-SA版权

分类专栏：数据库开发文章标签： oracle list server oracle10g tcp service

本文链接：https://blog.youkuaiyun.com/programpoet/article/details/4045262

数据库开发专栏收录该内容

33 篇文章

订阅专栏

本文介绍如何配置 Oracle 数据库的 tnsnames.ora 文件，以实现通过 PL/SQL Developer 工具连接不同版本的 Oracle 数据库。包括 Oracle 9i 和 10g 的具体配置示例及解决常见连接错误的方法。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Oracle10g所在目录大概是:

E:/oracle/product/10.2.0/db_1/NETWORK/ADMIN/tnsnames.ora

Oracle9i所在目录大概是:

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

配置该文件,诸如:

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

MAO =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = maowenlei)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = mao.name)
    )
)

APP_172.22.22.6 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.22.6)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = app)
      (SERVER = DEDICATED)
    )
)

APP_172.22.22.1 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 172.22.22.1)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = app)
      (SERVER = DEDICATED)
    )
)

APP_CESHI =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.141.200)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = APP)
    )
)

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

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

APP_10.10.141.200 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.10.141.200)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = app)
      (SERVER = DEDICATED)
    )
)

之后在plsql developer登陆时就有以上下拉选择框了.

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

关于9i换成10g后,使用plsql developer登陆报错的问题.

原因:还在找老版本的tnsnames.ora.

解决方案,重新安装plsql developer,自动找新安装的数据库10g.