使用instantclient_11_2 和PL/SQL Developer工具包连接oracle 11g远程数据库

最新推荐文章于 2022-09-06 16:49:16 发布

陕西小伙伴网络科技有限公司

最新推荐文章于 2022-09-06 16:49:16 发布

阅读量842

点赞数

本文链接：https://blog.csdn.net/shuaizai88/article/details/45312185

版权

1,先到Oracle网站下载Instant Client :

http://www.oracle.com/technology/global/cn/software/tech/oci/instantclient/index.html

根据你的操作系统选择不同的Instant Client版本

下载回是一个压缩文件,解压之后的文件夹叫:D:/instantclient_11_2.放在你喜欢的目录即可.例如:D:/instantclient_11_2

2 下载PLSQL_Developer8.0

在 D:/instantclient_11_2 创建 tnsnames.ora

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

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

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

dmpsx2 =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.51)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

3 配置环境变量

PATH=D:/instantclient_11_2 ；TNS_ADMIN=D:/instantclient_11_2；NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK

4 打开plsql 客户端

在登陆页面点取消。

进入到工具主页面后点击工具首选项

oracle 主目录名字 D:\instantclient_12_1

OCI库 D:\instantclient_12_1\oci.dll