【Oracle XE系列之二】PLSQL Developer 远程连接Oracle XE数据库

1、去http://www.oracle.com/technetwork/database/features/instant-client/index-097480.html下载Instant Client Package - Basic: All files required to run OCI, OCCI, and JDBC-OCI applications

 

instantclient-basic-win-x86-64-11.2.0.1.0.zip (55,084,309 bytes)

2、将下载的客户端包安装到例如E:\App\PLSQL下，最终客户端主目录是E:\App\PLSQL\instantclient_11_2

3、设定环境变量

    NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK

    TNS_ADMIN = E:\App\PLSQL\instantclient_11_2

4、配置PL/SQL Developer 环境设置（打开PL/SQL，取消登录，直接配置），  在”工具 -> 首选项 -> 连接“下设置：

        Oracle主目录名  = E:\App\PLSQL\instantclient_11_2

        OCI库 = E:\App\PLSQL\instantclient_11_2\oci.dll

 

5、从C:\oraclexe\app\oracle\product\11.2.0\server\network\ADMIN下拷贝文件tnsnames.ora到E:\App\PLSQL\instantclient_11_2下，

     并配置E:\App\PLSQL\instantclient_11_2\tnsnames.ora

     XE =
       (DESCRIPTION =
         (ADDRESS_LIST =
           (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
         )
         (CONNECT_DATA =
           (SERVER = DEDICATED)
           (SERVICE_NAME = XE)
         )
       )

     smis =
        (DESCRIPTION =
          (ADDRESS_LIST =
            (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.75.61)(PORT = 1521))
          )
          (CONNECT_DATA =
            (SERVICE_NAME = orcl)
          )
        )

6、打开PL/SQL测试OracleXE连接成功。