Linked server to Oracle from SQL 2000 cluster

Question

Linked server to Oracle from SQL 2000 cluster

Jay Byoun

SSC-Addicted

Points: 428
More actions
May 23, 2007 at 7:36 am

#62300

Am trying to create a linked server to Oracle from sql 2000 cluster, here're my questions;
1> Should I install oracle client on local drive on each cluster node ?
2> After installing oracle client (9i) on the local drives, and set up a linked server to oracle using MSDAORA.
Here's the error msg.
Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Oracle client and networking components were not found. These components are supplied by Oracle Corporation and are part of the Oracle Version 7.3.3 or later client software installation.
Provider is unable to function until these components are installed.]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].
Pls post your thoughts.
Thanks, JB

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

Jay Byoun SSC-Addicted Points: 428 More actions · Answer 1

I made some progress, the sql service account did not have the latest PATH for the new oracle client. this problem was fixed by rebooting server.

Now I'm getting different error message, at least, I feel going forward.

=======================================================

Server: Msg 7399, Level 16, State 1, Line 1

OLE DB provider 'MSDAORA' reported an error.

[OLE/DB provider returned message: Oracle error occurred, but error message could not be retrieved from Oracle.]

OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].

===============================================================

any response would be very appreciated.

thanks, JB

Jay Byoun SSC-Addicted Points: 428 More actions · Answer 2

Finally, the problem was solved and here's what I did.

1> Remove Oracle clients cleanly and then re-boot all cluster servers

2> Install Oracle client (10g) on the share drive (I do no think it's required, but I did it for the fail-over)

3> Re-boot all cluster servers (this is the most important step, just fail-over is not good enough).

4> Check PATH (make sure oracle root in is the path) and check the version of MDAC (2.82.3959)

5> Create an Oracle linked server and test (it worked !!!)

thanks, JB

Linda Johanning SSCertifiable Points: 6727 More actions · Answer 3

I see that you switched from Oracle 9i to version 10--that's good. We had version 9i on a SQL 2000 cluster and there were issues with that particular driver (mostly that the linked server would hang and then eventually the SQL Server agent would freeze up). I uninstalled 9i and installed 8 and the link works fine. Haven't tried 10 yet but it's good to know that you've got it working. Let us know if it later causes issues 🙂

shelleybobelly SSC Eights! Points: 836 More actions · Answer 4

Hey Jay,

When you say install oracle client on the share drive are you talking about the "quorum"?