With the 64-bit Oracle database installed and the 32-bit Oracle client, prompting for the path to the Java.exe when you first open the client's SQL developer in the Start menu, I select the JDK path that comes with the Oracle database and then make an error:
Baidu looks for a workaround because the JDK that comes with the 64-bit Oracle database is also 64-bit, but the installed Oracle client is 32-bit, so it is incompatible.
There are generally two approaches to the solution:
1) Download Oracle SQL Developer x64 from the Web (http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/ index.html), and then replace the original directory: the 32-bit Oracle SQL Developer under D:\app\oracle\product\11.1.0\db_1\sqldeveloper. This will restart the Oracle SQL Developer and make the Java.exe path.
2) Install JDK6 x86, which is 32-bit JDK, although our system is 64-bit, but also compatible with 32-bit JDK.
Because of other needs, I have to use 32-bit client, so I chose the second method, the Oracle official website downloaded 32-bit JDK installation completed. After that, you will modify the Java.exe startup path of SQL developer. You cannot click SQL Developer to define the Java.exe path in the Start menu, because the path is already initialized, and a single click of SQL Developer will report the above error. You will need to modify the configuration file to modify the Java.exe path at this time.
1. Locate the sqldeveloper.conf file in the path below
D:\app\mattran\product\11.2.0\client_1\sqldeveloper\sqldeveloper\bin
2. Open the file
3. Change the path at the red line to the following path for the 32-bit JDK you just installed:
4. Save and exit.
After that, click SQL Developer under Oracle-oraclient11g_home1 in the Start menu to start successfully.
Oracle SQL Developer Error: Unable to find a Java Virtual machine workaround