1. Oracle Application Server 10g On Windows 2008 Version
2. Oracle Application Server 10g On Windows 2008 64
3. Oracle Application Server

How to instal Oracle database 10g in windows server 2008 R2 redh kobz. How to install Oracle Database 12c Release 2 in Windows Server 2016. Of Oracle Application Server on Windows x64. Mar 11, 2011  Hi I am trying to install Oracle client 10.2.0.4 on Windows Server 2008 R2 64 bit machine and have downloaded the client install 10204vistaw2k8x64productionclient which is linked from the download page: Oracle Database 10g Release 2 (10.2.0.4.0) Enterprise/Standard Edition for Microsoft Windows Vista x64, Windows Server 2008 x64, Microsoft Windows Server 2008 R2 x64, Windows 7 x64. Re: Oracle 10g R2 on Windows 2008 Server. Version 10.1.3 is certified on Windows 2008 and 2008 R2, noting that this is not an upgrade from 10.1.2. It provides a different suite of products. You can decide on 10.1.2 verses 10.1.3 depending on your needs. For all product offerings, the Oracle Fusion Middleware 11g (11.1.1.) is certified on 2008 and 2008 R2.

I have 64-bit Oracle Database Server (11.2.0.3) installed on Windows 2008 R2, and naturally, it automatically installs the 64-bit client. I have to install an application onto this server that is 32-bit and requires the 32-bit Oracle client. (Don't Ask - I can't install the 64-bit version of this app, it won't work with the 64-bit client, and I can't install it on another server.)

Now i have tried installing the 32-bit Client into a different physical folder and selected a different value for the Oracle Base and Software Location when installing and it installed just fine. And it put the BIN folder of the 32-bit Client installation at the head of the PATH statemtn.

However, when i tried to run 'SQLplus system/system' with the 32-bit version it gives me the 'ORA-12560: TNS:protocol adapter error'. When I go into the folder with the 64-bit sqlplus.exe and ran it (directly and not through PATH), the 'system/system' credentials worked fine.

I copied the TNSNames folder from the Oracle Server's NETWORK/admin folder to the Oracle Client's NETWORK/admin folder, and rebooted the server. Same results.

This is the extent of my troubleshooting knowledge for Oracle.

How can i get the 32-bit Client to run on the same server as the 64-bit Oracle Server?I know in linux/Unix, you simply put in the lib32 folder into the the 64-bit client folder and set a couple of environment variables, but i'm pretty sure it's not that simple in Windows.

If there is a way to do this, please be descriptive in you answer as I will need step-by-step instructions.

Thanks in advance.

1 Answer

Here is an instruction how to install 32-bit and 64-bit Oracle Client on one machine. Follow the instruction, then it should work.

Assumptions: Oracle Home is called OraClient11g_home1, Client Version is 11gR2

Oracle Application Server 10g On Windows 2008 Version

• Download and install Oracle x86 Client, for example into C:Oracle11.2Client_x86

• Download and install Oracle x64 Client into different folder, for example to C:Oracle11.2Client_x64

• Open command line tool, go to folder %WINDIR%System32, typically C:WindowsSystem32 and create a symbolic link ora112 to folder C:Oracle11.2Client_x64 (see commands section below)

• Change to folder %WINDIR%SysWOW64, typically C:WindowsSysWOW64 and create a symbolic link ora112 to folder C:Oracle11.2Client_x86, (see below)

• Modify the PATH environment variable, replace all entries like C:Oracle11.2Client_x86 and C:Oracle11.2Client_x64 by C:WindowsSystem32ora112, respective their bin subfolder. Note: C:WindowsSysWOW64ora112 must not be in PATH environment.

• If needed set your ORACLE_HOME environment variable to C:WindowsSystem32ora112

• Open your Registry Editor. Set Registry value HKLMSoftwareORACLEKEY_OraClient11g_home1ORACLE_HOME to C:WindowsSystem32ora112. Using C:Oracle11.2Client_x64 should also work.

• Set Registry value HKLMSoftwareWow6432NodeORACLEKEY_OraClient11g_home1ORACLE_HOME to C:WindowsSystem32ora112 (not C:WindowsSysWOW64ora112). Using C:Oracle11.2Client_x86 should also work.

• 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 smart idea to set your TNS_ADMIN environment variable (resp. TNS_ADMIN entries in Registry) to a common location, for example TNS_ADMIN=C:OracleCommonnetworkadmin

Commands to create symbolic links:

Oracle Application Server 10g On Windows 2008 64

cd C:WindowsSystem32mklink /d ora112 C:Oracle11.2Client_x64cd C:WindowsSysWOW64mklink /d ora112 C:Oracle11.2Client_x86Visual foxpro odbc driver windows 10 64 bit.

Notes:

Both symbolic links must have the same name, e.g. ora112.

Despite of their names folder C:WindowsSystem32 contains the x64 libraries, whereas C:WindowsSysWOW64 contains the x86 (32-bit) libraries. Don't be confused.

Oracle Application Server

Not the answer you're looking for? Browse other questions tagged databaseoracleclient32-bit or ask your own question.