<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>
Log in
::
Register
::
Not logged in
Home
Tags
Articles
Editorials
Stairways
Forums
Scripts
Videos
Blogs
QotD
Books
Ask SSC
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Write for us
<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>
Recent Posts
Recent Posts
Popular Topics
Popular Topics
Home
Search
Members
Calendar
Who's On
Home
»
SQL Server 2008
»
Working with Oracle
»
OraOLEDB.Oracle.1 is not registered on the...
OraOLEDB.Oracle.1 is not registered on the local machine
Rate Topic
Display Mode
Topic Options
Author
Message
Welsh Corgi
Welsh Corgi
Posted Thursday, August 09, 2012 12:08 PM
Hall of Fame
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833,
Visits: 4,052
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
Jo Pattyn
Jo Pattyn
Posted Thursday, August 09, 2012 12:48 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:28 AM
Points: 1,333,
Visits: 4,417
Did you install them in a different base directory? 11g has a deinstall bug
Post #1342950
Welsh Corgi
Welsh Corgi
Posted Thursday, August 09, 2012 1:10 PM
Hall of Fame
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833,
Visits: 4,052
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/
Post #1342964
Jo Pattyn
Jo Pattyn
Posted Thursday, August 09, 2012 1:38 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:28 AM
Points: 1,333,
Visits: 4,417
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
Welsh Corgi
Welsh Corgi
Posted Thursday, August 09, 2012 1:45 PM
Hall of Fame
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833,
Visits: 4,052
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
Jo Pattyn
Jo Pattyn
Posted Thursday, August 09, 2012 1:57 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:28 AM
Points: 1,333,
Visits: 4,417
Glad you sniffed it out.
Post #1342990
Welsh Corgi
Welsh Corgi
Posted Wednesday, August 15, 2012 11:45 AM
Hall of Fame
Group: General Forum Members
Last Login: Wednesday, May 22, 2013 6:19 AM
Points: 3,833,
Visits: 4,052
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
SQL Surfer '66
SQL Surfer '66
Posted Thursday, August 16, 2012 1:01 AM
SSC Veteran
Group: General Forum Members
Last Login: Wednesday, June 12, 2013 6:21 AM
Points: 235,
Visits: 192
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
Jo Pattyn
Jo Pattyn
Posted Thursday, August 16, 2012 12:50 PM
Ten Centuries
Group: General Forum Members
Last Login: Today @ 1:28 AM
Points: 1,333,
Visits: 4,417
If you have access to oracle support checkout note 1132253.1
OPD.NET xcopy deployment
Post #1346191
« Prev Topic
|
Next Topic »
Permissions
You
cannot
post new topics.
You
cannot
post topic replies.
You
cannot
post new polls.
You
cannot
post replies to polls.
You
cannot
edit your own topics.
You
cannot
delete your own topics.
You
cannot
edit other topics.
You
cannot
delete other topics.
You
cannot
edit your own posts.
You
cannot
edit other posts.
You
cannot
delete your own posts.
You
cannot
delete other posts.
You
cannot
post events.
You
cannot
edit your own events.
You
cannot
edit other events.
You
cannot
delete your own events.
You
cannot
delete other events.
You
cannot
send private messages.
You
cannot
send emails.
You
may
read topics.
You
cannot
rate topics.
You
cannot
vote within polls.
You
cannot
upload attachments.
You
may
download attachments.
You
cannot
post HTML code.
You
cannot
edit HTML code.
You
cannot
post IFCode.
You
cannot
post JavaScript.
You
cannot
post EmotIcons.
You
cannot
post or upload images.
Copyright © 2002-2013 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use.
Report Abuse.
