PLSQL Developer Oracle11g配置及使用

下载：https://www.oracle.com/database/technologies/instant-client/microsoft-windows-32-downloads.html

1、把instantclient-basic-nt-11.2.0.4.0.zip文件解压缩C:\instantclient_11_2。
2、将oracle安装目录下的D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN拷贝至C:\instantclient_11_2\NETWORK\ADMIN。

# tnsnames.ora Network Configuration File: D:\oracle\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 = 192.168.2.4)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

根据数据库所在 IP地址 填写。HOST = 192.168.2.4
根据连接的数据库 服务名 填写。SERVICE_NAME = orcl

3、PLSQL Developer 10。设置 Oracle Home、OCI library。

4、PLSQL Developer 14。通过Oracle客户端 Net Manager配置服务名。