PL/SQL Developer 11 64bit 安装和配置
安装后,
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;