oracle PL/SQL Developer 初始化错误
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/42710396/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
PL/SQL Developer Initialization error
提问by chohyunwook
I want use PL/SQL Developer
我想使用 PL/SQL Developer
first my oracle directory
首先是我的 oracle 目录
C:\oracle\product\10.2.0\client_1\BIN
C:\oracle\product\10.2.0\client_1\BIN
I use windows10 and environment variable setting
我使用 windows10 和环境变量设置
ORACLE_HOME C:\oracle\product\10.2.0\client_1
ORACLE_HOME C:\oracle\product\10.2.0\client_1
Path C:\oracle\product\10.2.0\client_1\BINbut execute Initialization error.
Path C:\oracle\product\10.2.0\client_1\BIN但执行初始化错误。
Initialization error
Could not load "C:\oracle\product.2.0\client_1\bin\oci.dll"
OracleHomeKey: SOFTWARE\ORACLE\KEY_OraClient10g_home1
OracleHomeDir: C:\oracle\product.2.0\client_1
Found: oci.dll
Using: C:\oracle\product.2.0\client_1\bin\oci.dll
LoadLibrary(C:\oracle\product.2.0\client_1\bin\oci.dll) return 0
回答by honglin zhang
steps:
脚步：
- download oracle instant client (64 bits for latest version of PL/SQL; 32 bits for old version)
- extract to a folder. for example: c:\oracle\instantclient
- open PL/SQL developer--> Configure-->Preferences--> Oracle Connection
- under OCI library, keyin OCI.DLL file path in the text box: c:\oracle\instantclient\oci.dll
- click OK and restart PL/SQL
- 下载oracle即时客户端（最新版PL/SQL为64位；旧版为32位）
- 解压到一个文件夹。例如：c:\oracle\instantclient
- 打开PL/SQL developer-->Configure-->Preferences-->Oracle Connection
- 在OCI库下，在文本框中输入OCI.DLL文件路径：c:\oracle\instantclient\oci.dll
- 单击确定并重新启动 PL/SQL
done
完毕
回答by u7855432
I meet the same error on my new windows 10 computer. At last i found that i missed the Microsoft Visual Studio 2013 Redistributable. After i install it, the error gone.
我在新的 Windows 10 计算机上遇到了同样的错误。最后我发现我错过了Microsoft Visual Studio 2013 Redistributable。我安装后，错误消失了。
回答by Dipesh Deb
Check Environment Variables %PATH%
检查环境变量 %PATH%
回答by Shashi
I had the similar problem and these steps did helped me
我遇到了类似的问题，这些步骤确实帮助了我
steps:
脚步：
- Download oracle instant client (64 bits for latest version of PL/SQL; 32 bits for old version)
- Extract to a folder. for example: c:\oracle\instantclient
- Open PL/SQL developer--> Configure-->Preferences--> Oracle Connection
- Under OCI library, keyin OCI.DLL file path in the text box: c:\oracle\instantclient\oci.dll
- Click OK and restart PL/SQL done
- 下载oracle即时客户端（最新版PL/SQL为64位；旧版为32位）
- 解压到一个文件夹。例如：c:\oracle\instantclient
- 打开PL/SQL developer-->Configure-->Preferences-->Oracle Connection
- 在OCI库下，在文本框中输入OCI.DLL文件路径：c:\oracle\instantclient\oci.dll
- 单击确定并重新启动 PL/SQL 完成
