PL/SQL Developer 工具连接ORALCE数据库的方法-优快云博客

本文主要参考网上资料而来：

1.利用ORACLE NET MANAGER工具

首先安装ORACLE客户端，然后打开Oracle Net Manager工具，如下图：

单击上图的创建按钮（加号按钮）来创建服务

　　第一步 NET服务名：任意填写

　　第二步通讯协议：如果连接远程机器上的ORACLE，选择TCP/IP（internet协议）

　　第三步主机名：输入IP地址端口号：一般缺省为1521

　　第四步 SID：一般和数据库名字相同

这一步实际上是对tnsnames.ora文件进行编辑（该文件一般放在$\oracle\product\10.1.0\Db_1\NETWORK\ADMIN，我的为D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN）。该文件在未编辑之前的内容为：

# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dell-d46e6ff87f)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

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

在创建服务之后变为：

# tnsnames.ora Network Configuration File: D:\oracle\product\10.1.0\Db_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.

ORCL =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = dell-d46e6ff87f)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)
    )
  )

ORA10G =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.250)(PORT = 1521))
    )
    (CONNECT_DATA =
      (SERVICE_NAME = ora10g)
    )
  )

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

因此你也可以直接在tnsnames.ora文件进行编辑。本文的试验环境为：WinXP + sp3,oracle client 10g。

参考文献：

1. PL/SQL Developer 工具连接ORALCE数据库的方法