PLSQL 连接数据库配置

最新推荐文章于 2024-12-24 13:41:05 发布

美涟漪

最新推荐文章于 2024-12-24 13:41:05 发布

阅读量703

点赞数

本文链接：https://blog.csdn.net/bingdongsanxian/article/details/54911911

版权

本文介绍了如何配置PLSQL Developer连接Oracle数据库的步骤。首先，下载并解压Instant Client到指定目录，创建并编辑tnsnames.ora文件。接着，配置环境变量，设置Oracle Home为Instant Client路径，OCI Library指向oci.dll。最后，在PLSQL Developer中更新配置并重启应用，即可成功连接。

摘要由CSDN通过智能技术生成

1、下载Instant Client。下载完成后解压该文件。如：我将其解压在E:\oracleClient\instantclient_11_2该路径下。进入到instantclient_11_2下创建目录NETWORK，然后再NETWORK下建立目录ADMIN。在ADMIN目录下建立tnsnames.ora文件，在该tnsnames.ora文件中添加如下内容：

LISTENER_ORCL =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

ORACLR_CONNECTION_DATA =
(DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
    )
    (CONNECT_DATA =
      (SID = CLRExtProc)
      (PRESENTATION = RO)
    )
)

ORCL =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
)

128 =
(DESCRIPTION =
    (ADDRESS = (PROTOCOL =