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

Question

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.

Sundar · Answer

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