PLSQL Developer连接到远程Oracle服务器

1、安装Oracle客户端

2、修改app/oracle/product/10.2.0/server/NETWORK/ADMIN下的tnsnames.ora文件如下面的红体字

      XE =
        (DESCRIPTION =
          (ADDRESS = (PROTOCOL = TCP)(HOST = 你的ip)(PORT = 1521))
            (CONNECT_DATA =
             (SERVER = DEDICATED)
             (SERVICE_NAME = XE)
           )
        )

3、在PLSQL Developer中，Tools下的preferences中配置

    Oracle Home (emply is autodetect)

    OCI library (empty is autodetect)

4、在命令行下测试  sqlplus 用户名@XE

5、在PLSQL Developer测试