windows 7 上plsql dev 和 oracle instantclient 配置 博客分类: windows plsql devoracle instantclient 配置win7 plsql devMsvcp71.dllMsvcr71.dll
++ plsql
+++通过oracle instantclient 连接数据库
++++ 安装
下载instantclient-basic-win32-10.2.0.5.zip instantclient-sqlplus-win32-10.2.0.5.zip解压到
D:\Program Files\instantclient_10_205下,在该目录下新建 network/admin/tnsnames.ora
++++ 配置Windows环境变量
ORACLE_HOME=D:\Program Files\instantclient_10_205
Path=xxxxxxxx%ORACLE_HOME%;
++++ cmd下测试
sqlplus /nolog
windows 7上报错:找不到 msvcr71.dll库,到网上找到 MSVCP71.DLL及msvcr71.dll复制到C:\Windows\System32(64位复制到System64)
下载地址:http://cloud.addictivetips.com/wp-content/uploads/2010/12/Msvcp71.dll-And-Msvcr71.dll-files.zip
(注意:win7上缺少这两个库时打开plsql,即使设置了TNS_ADMIN=%ORACLE_HOME%network/admin/tnsnames.ora也会找不到tnsnames.ora文件)
sqlplus /nolog
SQL> conn sjw/sjw@test
已经能连上
+++ plsql配置
++++ 配置oracle home和oci library
在tools/preference里,oracle-connection选项配置oracle home和oci library
oracle home:D:\Program Files\instantclient_10_205
oci library:D:\Program Files\instantclient_10_205\coi.dll
++++中文乱码
设置环境变量:
NLS_LANG=SIMPLIFIED CHINESE_CHINA.ZHS16GBK
参考:
http://www.addictivetips.com/windows-tips/fix-msvcp71-dll-and-msvcr71-dll-missing-error-in-windows-7/