如何在Win 64上使用32位JDK启动Oracle SQL Developer 4? [英] How to start Oracle SQL Developer 4 using 32 bit JDK on Win 64?

问题描述

我需要连接到数据库并使用钱包文件. 如果我尝试使用SQL Developer，则最终会出现"ocijdbc.dll:无法在AMD 64位平台上加载IA 32bit .dll"的情况.

I need to connect to a database and use a wallet file. If i try with my SQL Developer i end up with "ocijdbc.dll: Cant load IA 32bit .dll on a AMD 64-bit platform."

我已经安装了32位JDK(在C:Prog32bit中)和JDK 64位(C:Prog)进行开发.

I have both installed JDK 32 bit (in C:Prog32bit) and JDK 64 bit (C:Prog) for development.

我尝试在sqldeveloper/bin/sqldeveloper.conf中手动设置JavaHome SetJavaHome C:\ Program Files(x86)\ Java \ jdk1.7.0_51

I tried to set JavaHome in sqldeveloper/bin/sqldeveloper.conf manually SetJavaHome C:\Program Files (x86)\Java\jdk1.7.0_51

我的下一步是编辑％USER_HOME％/sqldeveloper/sqldeveloper.conf，我也在那里设置了SetJavaHome，但是没有一个起作用.

My next step was to edit %USER_HOME%/sqldeveloper/sqldeveloper.conf and I set SetJavaHome there too, but none didn't work.

下一步是，我编辑了sqldeveloper/bin/sqldeveloper.bat并设置:

Next step was, i edited sqldeveloper/bin/sqldeveloper.bat and set:

JAVA_HOME="C:\Program Files (x86)\Java\jdk1.7.0_51"
path="C:\Program Files (x86)\Java\jdk1.7.0_51\bin%"

java.exe -Xmx640M -Xms128M -Xveri.... 

我最后的尝试是使用命令行(就像在Linux上一样)并运行:

My last try was to use the command line (as I would do on linux) and run:

D:\sqldeveloper>PATH="C:\Program Files (x86)\Java\jdk1.7.0_51\bin"
D:\sqldeveloper>java -version
java version "1.7.0_51"
Java(TM) SE Runtime Environment (build 1.7.0_51-b13)
Java HotSpot(TM) Client VM (build 24.51-b03, mixed mode, sharing)
D:\sqldeveloper>sqldeveloper.exe

但是我仍然收到消息sqldeveloper正在运行64位Java.

But i still receive the message sqldeveloper is running 64 bit Java.

我找到了一个工作环境.可以从推荐答案

在这种情况下，主要问题是您安装了32位Oracle驱动程序以连接到64位计算机上的数据库.没问题，但是您需要将SetJavaHome设置为包含32位版本的jdk目录.

The main problem in this case is that you have installed a 32 bits Oracle Driver to connect to your database in a 64 bit machine. There is no problem with that but you need to set SetJavaHome to a jdk directory that contains 32 bits version.

在sqldeveloper 4中，您需要编辑文件:

In sqldeveloper 4 you need to edit the file:

"C:\Users\username\AppData\Roaming\sqldeveloper\1.0.0.0.0\product.conf"

在此配置文件中，将jdk1.7.0_71的默认目录更改为32位，如下所示:

and inside this config file change the default directory for jdk1.7.0_71 32 bits is like this:

SetJavaHome C:\Program Files (x86)\Java\jdk1.7.0_71

使用此路径后，在任务管理器中检查您的进程sqldeveloper如下所示: sqldeveloper.exe * 32

After you use this path, check in Task Manager that your process sqldeveloper looks like this: sqldeveloper.exe *32

如果您的进程以"* 32"开头，则可以使用32位oracle驱动程序进行连接.

If your process starts with that "*32" you could be able to connect using your 32 bits oracle driver.

这篇关于如何在Win 64上使用32位JDK启动Oracle SQL Developer 4?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！