PLSQLDeveloper连接远程Oracle数据…

声明:允许转载，转载请注明链接，谢谢合作!

亲测有效

此说明主要针对，本地无oracle，想远程连接oracle的情况。

1、首先去oracle官网下载三个需要的压缩包

具体地址是：http://www.oracle.com/technetwork/topics/winsoft-085727.html

需要的包：

instantclient-basic-nt-12.1.0.1.0.zip
instantclient-odbc-nt-12.1.0.1.0.zip
instantclient-sqlplus-nt-12.1.0.1.0.zip

下载PLSQL Developer

将下载的安装包全部解压，放在同一个目录下，比如在D:\oracle

解压完成后安装解压出的 odbc_install

2.安装plsql，无脑安装

3.添加五个环境变量

NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK(或AMERICAN_AMERICA.ZHS16GBK)
TNS_ADMIN = D:\oracle
LD_LIBRARY_PATH = D:\oracle
SQLPATH = D:\oracle

Path变量结尾添加D:\oracle

4.在D:\oracle下创建tnsnames.ora文件

我的文件的内容

# tnsnames.ora Network Configuration File: D:\Oracle\instantclient_12_1\tnsnames.ora

# Generated by Oracle configuration tools.

  XE=

  (DESCRIPTION =

    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.100)(PORT = 1521))

    (CONNECT_DATA =

      (SERVER = DEDICATED)

      (SERVICE_NAME = xe)

    )

  )

  

LISTENER_XE =

  (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.99.100)(PORT = 1521))

ORACLR_CONNECTION_DATA =

  (DESCRIPTION =

    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))

    )

    (CONNECT_DATA =

      (SID = xe)

      (PRESENTATION = RO)

    )

  )

5.最后用plsql连接，稍加配置即可连接使用了

参考文献：http://www.2cto.com/database/201407/319297.html