解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
来源:互联网 发布:windows永久激活工具 编辑:程序博客网 时间:2024/06/06 03:22
Windows 64位下装Oracle 11g 64位,PLSQL Developer使用出现以下问题:
1、Database下拉框为空:
2、强制输入用户名、密码及Database,登录弹出:
Initialzation errorCould not initialize"...."Make sure you have the 32 bits Oracle Client installed.OracleHomeKey:OracleHomeDir:...Found:oci.dllUsing:...Loadlibrary(...)returned 0
说明PLSQL Developer并不支持Oracle 64位客户端连接。
解决办法:
1、下载32位Oracle客户端
其实可以下载免安装版的,http://www.oracle.com/technetwork/topics/winsoft-085727.html,我下载的是instantclient-basic-nt-11.2.0.2.0.zip。
2、解压
解压instantclient-basic-nt-11.2.0.2.0.zip,例如到D:\instantclient_11_2
3、设置PLSQL Developer
启动PLSQL Developer,不登录点取消进入PLSQL Developer,Tools->>Preferences:
Oracle Home:OraDb11g_home1(发现这里似乎可以随便写,我填的是安装的Oracle 11g 64位的)
OCI Library:D:\instantclient_11_2\oci.dll
4、添加环境变量
TNS_ADMIN ->> D:\app\YangJin\product\11.2.0\dbhome_1\NETWORK\ADMIN
中文乱码问题:
启动PLSQL Developer,登录发现中文表名乱码:
解决方法:
添加环境变量:NLS_LANG ->> AMERICAN_AMERICA.UTF8
原文:http://blog.csdn.net/microfhu/article/details/7585174
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed .
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- pl sql连接oracle报错12154-解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed 分类: PlSql 2012-05-20 1
- ajax学习笔记
- [译]【Storm入门指南】附录A 安装Storm客户端
- 23种设计模式
- 乘法口诀
- Java多线程——Fork/Join框架
- 解决X64操作系统PL/SQL连接报错问题 make sure you have the 32 bits oracle client installed
- 关于创建Web工程时web.xml文件的部署
- y = x(x>1) ||y = 2*x-1(1<x<10) ||y = 3*x-11(x>=10)
- Android面试题
- python的string模板
- 黑马程序员——继承与多态
- 莫比乌斯反演对gcd问题的优化
- 手动实现NSNotificationCenter功能
- [译]【Storm入门指南】附录B 安装Storm集群