Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

OraOLEDB.Oracle.1 is not registered on the local machine Expand / Collapse
Author
Message
Posted Thursday, August 9, 2012 12:08 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:06 PM
Points: 4,253, Visits: 4,295
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/

Post #1342909
Posted Thursday, August 9, 2012 12:48 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:45 AM
Points: 1,402, Visits: 6,893
Did you install them in a different base directory? 11g has a deinstall bug
Post #1342950
Posted Thursday, August 9, 2012 1:10 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:06 PM
Points: 4,253, Visits: 4,295



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/

Post #1342964
Posted Thursday, August 9, 2012 1:38 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:45 AM
Points: 1,402, Visits: 6,893
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.
More in detail
There is also a post which only needs the odac components
Post #1342973
Posted Thursday, August 9, 2012 1:45 PM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:06 PM
Points: 4,253, Visits: 4,295
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.
More in detail
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.

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/

Post #1342979
Posted Thursday, August 9, 2012 1:57 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:45 AM
Points: 1,402, Visits: 6,893
Glad you sniffed it out.
Post #1342990
Posted Wednesday, August 15, 2012 11:45 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Thursday, December 11, 2014 1:06 PM
Points: 4,253, Visits: 4,295
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.
More in detail
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/

Post #1345419
Posted Thursday, August 16, 2012 1:01 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Thursday, December 11, 2014 2:22 AM
Points: 518, Visits: 260
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.
Post #1345694
Posted Thursday, August 16, 2012 12:50 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Yesterday @ 10:45 AM
Points: 1,402, Visits: 6,893
If you have access to oracle support checkout note 1132253.1
OPD.NET xcopy deployment
Post #1346191
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse