PL/SQL免安装连接Oracle

1. Oracle 官网下载 InstantClient 压缩包，解压到 x:\oracle。

2. 新建 x:\oracle\network\admin\tnsnames.ora 文件，配置数据库连接。例:

DB_27 =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.27)(PORT = 1521))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = ciis)
      )
    )
DB_29 =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.29)(PORT = 1521))
      )
      (CONNECT_DATA =
        (SERVICE_NAME = orcl)
      )
    )

3. 配置PL/SQL：Tools -> Perferences -> Oracle -> Connection

    设置Oracle Home 为 x:\oracle；

    设置OCI library 为 x:\oracle\oci.dll。