使用PLSQL Developer去访问64位的Oracle时会报错,因为64位的Oracle的oci.all 文件是64位的,PLSQL Developer无法
访问,解决的办法:
1 :下载32位Oracle InstantClient,并展开到某目录,例如C:/oracle/instantclient_10_2;
2 :将系统的tnsnames.ora和msvcr71.dll拷贝到C:/oracle/instantclient_10_2目录下;
3 :设置PLSQL Developer中设置Oracle_Home和OCI Library:
Oracle_Home:C:/oracle/instantclient_10_2
OCI Library:C:/oracle/instantclient_10_2/oci.dll
4:配置环境参数:
path=C:/oracle/instantclient_10_2
ORACLE_HOME=C:/oracle/instantclient_10_2
TNS_ADMIN=C:/oracle/instantclient_10_2
NLS_LANG=AMERICAN_AMERICA.ZHS16GBK
5:祝你成功啦!!!