不用安装Oracle客户端,使用PLSQL连接服务器Oracle

1、下载 Instant Clinet Package - basic 下面有连接
2、解压在目录（以E:/instantclient 解压地址随意）
3、在E:/instantclient下创建network 文件夹，接着在network 下创建admin文件夹,
     在admin文件夹里新建tnsnames.ora文件,内容:
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 服务器IP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )
EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )
4、打开PLSQL Developer工具,工具->首选项->链接;设置
        Oracle home(主目录): E:\instantclient\ 

        OCI 库: E:\instantclient\oci.dll

5、 Instant Clinet工具下载

     http://download.csdn.net/detail/u011850780/8740361

截图如下