安装后,
1. 解压 instant client 到plsql developer 的安装目录
注意, 此版本只支持 instantclient_11_x, 不支持 instantclient_12_x, 如果使用12_x的会报dll错误
2. 在 instant client 目录下创建 network/admin 目录
3. 创建 tnsnames.ora 文件, 写入内容格式如下
# Generated by Oracle configuration tools. DB_DEV =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 33.5.126.211)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = ORC)
)
) EXTPROC_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
)
(CONNECT_DATA =
(SID = PLSExtProc)
(PRESENTATION = RO)
)
)
4. 设置桌面快捷方式的属性, 加入如下参数, 就可以不需要再设置环境变量
"C:\Program Files\PLSQL Developer\plsqldev.exe" instantclient="C:\Program Files\PLSQL Developer\instantclient_11_2" nls_lang=AMERICAN_AMERICA.AL32UTF8
5. 其中的nls_lang 参数, 可以通过查询数据库得到, sql为
select userenv('language') nls_lang from dual;