Oracle issue - 64-bit and 32-bit -IMP

Dear all,

My machine is 64-bit Windows 7 with 8GB RAM.

I have installed Oracle 11g Client - both 32-bit and 64-bit.

I am using SQLDeveloper to connect to the client.

Toad is not working - Error - "Cannot load oci.dll file" - I checked in BIN Folder - FIle is there.

My Queries are -

1. My portal has backend as Oracle. WHen I run it on my machine to debug, it gives error -

BadImageFormatException. This will occur when running in 64 bit mode with the 32 bit Oracle client components installed

Exact Error Message - Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed.

How to solve this ?

2.In SQLDeveloper - How to find which client the SQLDEveloper has connected to.

3. TOAD - From where to download TOAD That is compatible with Oracle 11g client.

Question 1

====================

Optionally remove any installed Oracle client

Download and install Oracle x86 Client, for example into C:\Oracle\11.2\Client_x86

Download and install Oracle x64 Client into different folder, for example to C:\Oracle\11.2\Client_x64

Open command line tool, go to folder %WINDIR%\System32, typically C:\Windows\System32 and create a symbolic link ora112 to folder C:\Oracle\11.2\Client_x64 (see below)

Change to folder %WINDIR%\SysWOW64, typically C:\Windows\SysWOW64 and create a symbolic link ora112 to folder C:\Oracle\11.2\Client_x86, (see below)

Modify the PATH environment variable, replace all entries like C:\Oracle\11.2\Client_x86 and C:\Oracle\11.2\Client_x64 by C:\Windows\System32\ora112, respective their \bin subfolder. Note: C:\Windows\SysWOW64\ora112 must not be in PATH environment.

If needed set yor ORACLE_HOME environment variable to C:\Windows\System32\ora112

Open your Registry Editor. Set Registry value HKLM\Software\ORACLE\KEY_OraClient11g_home1\ORACLE_HOME to C:\Windows\System32\ora112

Set Registry value HKLM\Software\Wow6432Node\ORACLE\KEY_OraClient11g_home1\ORACLE_HOME to C:\Windows\System32\ora112 (not C:\Windows\SysWOW64\ora112)

You are done! Now you can use x86 and x64 Oracle client seamless together, i.e. an x86 application will load the x86 libraries, an x64 application loads the x64 libraries without any further modification on your system.

Probably it is a wise option to set your TNS_ADMIN environment variable (resp. TNS_ADMIN entries in Registry) to a common location, for example TNS_ADMIN=C:\Oracle\Common\network.

In addition, during the discussions people were talking about 32-bit mode etc. This is how you can check / set that for an IIS 7 hosted application. You shouldn't need to change this but I have added here for completeness / future reference.

Launch IIS 7 and expand the server name node.

Click on Application Pools node and find the application Pool you are using.

On the right-hand panel click Advanced Settings...

In the pop-up box that appears check Enabled 32-Bit Applications setting which is third option from the top.

Question 2

==============

1) https://docs.oracle.com/en/cloud/paas/exadata-express-cloud/csdbp/using-sql-developer-monitor-database-performance-ee.html

2) http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/257055.htm

3) https://docs.oracle.com/cd/E11882_01/datamine.112/e16807/connecting.htm#DMADM218

Question 3

=============

you can download from here

https://www.toadworld.com/m/freeware/544

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Sundaram Subramanian9y ago
Question 1
====================

Optionally remove any installed Oracle client
Download and install Oracle x86 Client, for example into C:\Oracle\11.2\Client_x86
Download and install Oracle x64 Client into different folder, for example to C:\Oracle\11.2\Client_x64
Open command line tool, go to folder %WINDIR%\System32, typically C:\Windows\System32 and create a symbolic link ora112 to folder C:\Oracle\11.2\Client_x64 (see below)
Change to folder %WINDIR%\SysWOW64, typically C:\Windows\SysWOW64 and create a symbolic link ora112 to folder C:\Oracle\11.2\Client_x86, (see below)
Modify the PATH environment variable, replace all entries like C:\Oracle\11.2\Client_x86 and C:\Oracle\11.2\Client_x64 by C:\Windows\System32\ora112, respective their \bin subfolder. Note: C:\Windows\SysWOW64\ora112 must not be in PATH environment.
If needed set yor ORACLE_HOME environment variable to C:\Windows\System32\ora112
Open your Registry Editor. Set Registry value HKLM\Software\ORACLE\KEY_OraClient11g_home1\ORACLE_HOME to C:\Windows\System32\ora112
Set Registry value HKLM\Software\Wow6432Node\ORACLE\KEY_OraClient11g_home1\ORACLE_HOME to C:\Windows\System32\ora112 (not C:\Windows\SysWOW64\ora112)
You are done! Now you can use x86 and x64 Oracle client seamless together, i.e. an x86 application will load the x86 libraries, an x64 application loads the x64 libraries without any further modification on your system.
Probably it is a wise option to set your TNS_ADMIN environment variable (resp. TNS_ADMIN entries in Registry) to a common location, for example TNS_ADMIN=C:\Oracle\Common\network.

In addition, during the discussions people were talking about 32-bit mode etc. This is how you can check / set that for an IIS 7 hosted application. You shouldn't need to change this but I have added here for completeness / future reference.
Launch IIS 7 and expand the server name node.
Click on Application Pools node and find the application Pool you are using.
On the right-hand panel click Advanced Settings...
In the pop-up box that appears check Enabled 32-Bit Applications setting which is third option from the top.

Question 2
==============

1) https://docs.oracle.com/en/cloud/paas/exadata-express-cloud/csdbp/using-sql-developer-monitor-database-performance-ee.html

2) http://www.oracle.com/ocom/groups/public/@otn/documents/webcontent/257055.htm

3) https://docs.oracle.com/cd/E11882_01/datamine.112/e16807/connecting.htm#DMADM218

Question 3
=============

you can download from here

https://www.toadworld.com/m/freeware/544

0

Oracle issue - 64-bit and 32-bit -IMP - PLZZZ HELP