PL/SQL Developer配置Oracle远程连接

  1. 安装PL/SQL Developer Version 11.0.5.1790 (64 bit)

  2. 打开PL/SQL Developer,登陆窗口取消登陆,点开 Tools - Preferences , 在Connection里面设置Oracle Home为:C:\OracleClient\product\11.2.0\client_1\BIN, 设置OCI Library为C:\OracleClient\product\11.2.0\client_1\BIN\oci.dll 点击OK保存。

  3. 修改文件C:\OracleClient\product\11.2.0\client_1\network\admin\tnsnames.ora,内容如下:

    XZCF =
    (DESCRIPTION =
    (ADDRESS_LIST =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 10.118.2.196)(PORT = 1521))
    )
    (CONNECT_DATA =
    (SERVICE_NAME = thsmiddledb)
    )
    )

  4. 重新打开PL/SQL Developer,Database选择thsmiddledb。

标签: Oracle, PL/SQL Developer

添加新评论