PS/SQL连接远程

条件：已经装有ps/sql，目前尚不清楚如果没有安装orcle能否装pl/sql;

到oracle的安装路径下：%安装目录%/network/admin/;

修改目录下的listener.ora和tnsnames.ora两个文件。

listener文件大致如下：

# listener.ora Network Configuration File: F:\app\hpadmin\oradata\network\admin\listener.ora
# Generated by Oracle configuration tools.

LISTENER1 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1523))
      (ADDRESS = (PROTOCOL = TCP)(HOST = CHENHAOH3.asiapacific.hpqcorp.net)(PORT = 1523))
    )
  )

  LISTENER3 =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPRO1521))
      (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521))
    )
  ))

ADR_BASE_LISTENER = F:\app\hpadmin

tnsnames.ora文件大致修改如下：

# tnsnames.ora Network Configuration File: F:\app\hpadmin\oradata\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.

LISTENER_ORACLETESTDB =
  (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))


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)
    )
  )

name = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = ip)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = orcl) ) ) 
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl.asiapacific.hpqcorp.net)
    )
  )

按照要求添加一些内容即可！
在PL/SQL developer中配置客户端信息。
打开PL/SQL developer，暂不登录，选择菜单tools->preferences->connection,设置如下两项：
Oracle Home: D:\Program Files\instantclient_11_1 #客户端解压目录
OCI library: D:\Program Files\instantclient_11_1\oci.dll #oci库文件路径，oci.dll应该在客户端目录下。
如果本机安装了orcle，则只需要把Oracle Home：OraDb11g_home1（此为其中一个选择项）选中即可；

保存，重启PL/SQL developer，些时应可看到登录框中Database下拉选项里有你刚刚配置的远程服务器上的服务实例name了。