如何在 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: Cant load IA 32bit .dll on a AMD 64-bit platform".

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."

我已经安装了 JDK 32 位(在 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 中手动设置 JavaHomeSetJavaHome C:Program Files (x86)Javajdk1.7.0_51

I tried to set JavaHome in sqldeveloper/bin/sqldeveloper.conf manually SetJavaHome C:Program Files (x86)Javajdk1.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)Javajdk1.7.0_51"
path="C:Program Files (x86)Javajdk1.7.0_51in%"

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)Javajdk1.7.0_51in"
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.

我找到了一个解决方法.http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-downloads-v322-2080107.html

推荐答案

这种情况下的主要问题是您安装了 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:UsersusernameAppDataRoamingsqldeveloper1.0.0.0.0product.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)Javajdk1.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屋！