PLSQL 连接数据库配置

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 = TCP)(HOST = 192.168.48.128)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.wtLinux)
    )
  )

2：环境变量的配置

新增下面两个变量

TNS_ADMIN 　　　tnsnames.ora所在路径 如 E:\oracleClient\instantclient_11_2\NETWORK\ADMIN
NLS_LANG 　　　SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3：下载并安装PLSQL Developer

安装完成后进入PLSQL Developer，选择tools->preferences->connection

Oracle Home             

E:\oracleClient\instantclient_11_2 或 E:\app\lijuan\product\11.2.0\dbhome_1（本机oracle安装主目录）

OCI library

E:\oracleClient\instantclient_11_2\oci.dll

修改完毕后保存并重启PLSQL Developer就可以使用该工具了。