pl/sql developer连接数据库

下个工具，免安装

http://www.oracle.com/technology/software/tech/oci/instantclient/htdocs/winsoft.html

 

解压缩到一个文件夹，在这个文件夹下建network目录，在network目录下建admin目录，在admin目录下添加一个tnsnames.ora文件，添加内容如下：

# tnsnames.ora Network Configuration File: /export/home/oracle/product/10.2.02/network/admin/tnsnames.ora
# Generated by Oracle configuration tools.

UEP =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = SOLDAVID)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = uep)
    )
  )

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

打开PL/SQL，在perference里面设置OCI Library和Oracle_home，我的设置是OCI Library=c:/oracleclient/oci.dll,Oracle_home=c:/oracleclient。根据自己的实际情况配置，c:/oracleclient其实就是刚才下载下来的那个包的路径。

 

重新打开PL/SQL dev