Install Oracle 11 32/64 bit client on same machine?
Hello, I need to install both the 32/64 Oracle 11 client on a Windows 7 machine and I have followed these steps:
1. First installing the 32-bit version and custom installation with only the Client and ODP.Net option
2. Then installing the 64-bit version with the same options in a different directory
3. Adding the relevant TNS-file to the clients network/admin folder:
I can however not connect to a database and when I do a tnsping <instance> I get the following error:
Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage
3512 not found; No message file for product=NETWORK, facility=TNSAttempting to
contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = tellurium.ascade.se)(P
ORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = tellurium1)))
Message 3509 not found; No message file for product=NETWORK, facility=TNS
From Google I have understood that this error might indicate a problem with the ORACLE_HOME and when I check the ORACLE_HOME registry key I can only see the 64-bit entries but no 32-bit?
All help is appreciated!
1. First installing the 32-bit version and custom installation with only the Client and ODP.Net option
2. Then installing the 64-bit version with the same options in a different directory
3. Adding the relevant TNS-file to the clients network/admin folder:
I can however not connect to a database and when I do a tnsping <instance> I get the following error:
Message 3511 not found; No message file for product=NETWORK, facility=TNSMessage
3512 not found; No message file for product=NETWORK, facility=TNSAttempting to
contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = tellurium.ascade.se)(P
ORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = tellurium1)))
Message 3509 not found; No message file for product=NETWORK, facility=TNS
From Google I have understood that this error might indicate a problem with the ORACLE_HOME and when I check the ORACLE_HOME registry key I can only see the 64-bit entries but no 32-bit?
All help is appreciated!
ASKER
As a matter of fact it is for developments reasons so I cannot tell more about the specific reasons than that it is a requirement here. I suppose this makes sense that the installer only sets ORACLE_HOME for the 64-bit client but then it seems like typing SQLPLUS or TNSPING at the command should run should run the 64-bit client instead.
Perhaps installing the 64-bit client after 32-bit still does not make it the default client so why and how can this be dealt with? Thanks!
Perhaps installing the 64-bit client after 32-bit still does not make it the default client so why and how can this be dealt with? Thanks!
ASKER
I just confirmed that the PATH variable for the 64-bit client has precedence before the 32-client path and I get the same error if I run the commands just from the 64-bit/bin folder so it seems the 64-client still has problems although the ORACLE_HOME is properly configured in the registry.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I have yet not had the time to try the new Oracle versions but will do so very soon.
ASKER
The new Oracle versions seems to work so the case can be closed. Thanks!
Why do you need 32 bit client?
On WinDoze 2008 installing Oracle 32 bit on a 64 bit host, the installer DOES NOT create any entries in the registry, this appears to be true also with W7.
Every time you have to execute the 32 bit client, you will need to manually set the Oracle home.