Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


OraOLEDB.Oracle.1 is not registered on the local machine


OraOLEDB.Oracle.1 is not registered on the local machine

Author
Message
Welsh Corgi
Welsh Corgi
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5158 Visits: 4863
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/
Jo Pattyn
Jo Pattyn
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1588 Visits: 9714
Did you install them in a different base directory? 11g has a deinstall bug
Welsh Corgi
Welsh Corgi
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5158 Visits: 4863



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/
Jo Pattyn
Jo Pattyn
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1588 Visits: 9714
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
Welsh Corgi
Welsh Corgi
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5158 Visits: 4863
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.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/
Jo Pattyn
Jo Pattyn
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1588 Visits: 9714
Glad you sniffed it out.
Welsh Corgi
Welsh Corgi
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5158 Visits: 4863
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/
SQL Surfer '66
SQL Surfer '66
Say Hey Kid
Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)Say Hey Kid (712 reputation)

Group: General Forum Members
Points: 712 Visits: 328
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.
Jo Pattyn
Jo Pattyn
SSCommitted
SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)SSCommitted (1.6K reputation)

Group: General Forum Members
Points: 1588 Visits: 9714
If you have access to oracle support checkout note 1132253.1
OPD.NET xcopy deployment
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search