August 9, 2012 at 12:08 pm
I installed the 64 bit 11g 11.2 Oracle Client on a 64 bit Server.
Then I installed the 32 bit Client on the same Server.
I did this before on another several months ago and I had issues.
I had to install & uninstall about 6 times.
On that Server on the last attempt I installed the 32 bit first and the 64 bit second.
I think that the only registry entry is for the 32 bit client.
I was able to create Linked Servers without issues.
Any help would be greatly appreciated.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 9, 2012 at 12:48 pm
August 9, 2012 at 1:10 pm
Jo Pattyn (8/9/2012)
Did you install them in a different base directory? 11g has a deinstall bug
I did install in the same base?
I removed both installs. I had to remove part of it manually.
I could not remove the Oracle base. Error that a file was open but I could rename the base folder.
Should I install 32 bit first? that is what I'm doing?
Should I use a different base for 32 and 64 bit?
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 9, 2012 at 1:38 pm
Check if you have still remains of oracle software (check registry local machine\software\oracle). If I'm not mistaken the .1 points at home1.
Install 64-bit first (full administrator) and then 32-bit in a separate base.
There is also a post which only needs the odac components
August 9, 2012 at 1:45 pm
Jo Pattyn (8/9/2012)
Check if you have still remains of oracle software (check registry local machine\software\oracle). If I'm not mistaken the .1 points at home1.Install 64-bit first (full administrator) and then 32-bit in a separate base.
There is also a post which only needs the odac components
I made a stupid mistake.
I entered this and it worked.
SETUP.exe ORACLE_HOME="D:\ORACLE\Product\11.2.0\client_64" ORACLE_HOME_NAME="OraClient11g_64bit"
I had the path of the 32bit in my original command line.:w00t:
SETUP.exe ORACLE_HOME="D:\ORACLE\Product\11.2.0\client_32" ORACLE_HOME_NAME="OraClient11g_64bit"
Thanks for the information.
I still don't know why but I can't remove the Original Home Directory.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 9, 2012 at 1:57 pm
Glad you sniffed it out.
August 15, 2012 at 11:45 am
Jo Pattyn (8/9/2012)
Check if you have still remains of oracle software (check registry local machine\software\oracle). If I'm not mistaken the .1 points at home1.Install 64-bit first (full administrator) and then 32-bit in a separate base.
There is also a post which only needs the odac components
Where is the post for the download odac components?
I need to configure Developers PC's.
If I install the Oracle Client do I only need the 32 Bit Client?
Thanks.
For better, quicker answers on T-SQL questions, click on the following...
http://www.sqlservercentral.com/articles/Best+Practices/61537/
For better answers on performance questions, click on the following...
http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
August 16, 2012 at 1:01 am
Welsh Corgi (8/15/2012)
I need to configure Developers PC's.If I install the Oracle Client do I only need the 32 Bit Client?
Thanks.
It depends on the software that communicates with the Oracle database. 32 bit software requires 32 bit Oracle client and 64 bit software requires 64 bit Oracle client.
Once I had to install both on SQL Server 2008 (R2). BIDS is 32 bit and required 32 bit Oracle client. The SQL Server Agent executing the package is 64 bit and required 64 bit Oracle client.
August 16, 2012 at 12:50 pm
If you have access to oracle support checkout note 1132253.1
Viewing 9 posts - 1 through 8 (of 8 total)
You must be logged in to reply to this topic. Login to reply