在WindowsServer2008R2
msvcr80.dll
tnsnames.ora
d:\oracle\product\11.2.0\dbhome_1\BIN\msvcr80.dll ,D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
tnsnames.ora
d:\oracle\product\11.2.0\dbhome_1\BIN\msvcr80.dll ,D:\oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\tnsnames.ora
将上面两个文件拷贝覆盖 instantClient 文件夹中
在C:\Program Files (x86)\PLSQL Developer(PLSQL安装目录)中新建 plsqldev.bat
内容为:
@echo off
set path=F:\WinX64Data\InstanceClient\instantclient_11_2
set ORACLE_HOME=F:\WinX64Data\InstanceClient\instantclient_11_2
set path=F:\WinX64Data\InstanceClient\instantclient_11_2
set ORACLE_HOME=F:\WinX64Data\InstanceClient\instantclient_11_2
set TNS_ADMIN=F:\WinX64Data\InstanceClient\instantclient_11_2
set NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
start plsqldev.exe
F:\WinX64Data\InstanceClient\instantclient_11_2 地址为instantClient文件夹地址
运行bat文件成功,登陆进去,修改 tools->preferences OracleHome OCI library 地址 F:\WinX64Data\InstanceClient\instantclient_11_2