关于PLSQL Developer连接ORACLE设置

最新推荐文章于 2024-01-05 14:50:10 发布

jiang5460

最新推荐文章于 2024-01-05 14:50:10 发布

阅读量1.7k

点赞数

分类专栏： Oracle方面文章标签： oracle server tcp service list database

本文链接：https://blog.csdn.net/jiang5460/article/details/919782

版权

Oracle方面专栏收录该内容

11 篇文章 0 订阅

订阅专栏

1 、找到 ORACLE 的安装目录

E:/Oracle10/NETWORK/ADMIN

下的 tnsnames.ora 文件，用记事本打开。

大致内容：

# tnsnames.ora Network Configuration File: E:/Oracle10/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

JZYORL =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = jiangzy)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = JzyOrl)
    )
)

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

ORACLE_13 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.188.13)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = oratest)
      (SERVER = oratest)
    )
)

ORCL155 =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 10.188.188.155)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SID = orcltest)
      (SERVER = orcltest)
    )
)

或者直接在PLSQL 的登录窗体

DATABASE:写入连接串：

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.188.188.155)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL_Tes)))