PLSQL+ORACLE（连接远程数据库）

下载与安装

1. 软件准备
   1.1 win64_11gR2_client.zip
   1.2 instantclient_11_2.rar
   1.3 PLSQL Developer.rar
2. 软件安装
   2.1 解压win64_11gR2_client.zip并安装
   2.2 解压instantclient_11_2.rar并放置在oracle\app\product目录下与11.2.0并列
   2.3 解压PLSQL Developer.rar即可

配置文件

1. 在oracle\app\product\instantclient_11_2\NETWORK\ADMIN\sqlnet.ora中的SQLNET.AUTHENTICATION_SERVICES= (NTS)前添加#注释该行
2. 将oracle\app\product\instantclient_11_2\NETWORK\ADMIN\tnsnames.ora的内容替换为下面的内容（其中的IP地址换为相应地址）

# tnsnames.ora Network Configuration File: D:\...\oracle\app\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

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

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

TEST_ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xxx.xxx.xxx )(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
My_ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

环境变量

1. 添加环境变量NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
2. 添加环境变量TNS_ADMIN=D:...\oracle\app\product\instantclient_11_2\NETWORK\ADMIN

使用PLSQL

1. 打开PLSQL（不用登录），选择【工具】-【首选项】在Oracle主目录名中填入D:...\oracle\app\product\instantclient_11_2，在OCI库中填入D:...\oracle\app\product\instantclient_11_2\oci.dll
2. 重新打开PLSQL登录后即可连接到数据库