Groups | Blog | Home
all groups > sql server clustering > september 2004 >

sql server clustering : Linked Server Error Oracle Database


Jan K.
9/27/2004 11:38:12 AM

I'm in the process of upgrading the operating system from
Windows 2000 Advanced Server to Windows 2003 Server.

The server is clustered one is Windows 2000 Advanced
Server and the other Windows 2003 Server.

Before I upgraded the operated system both Linked Server
worked fine.

This is a linked server to an Oracle database. I was able
to connect to the database connection from sqlplus on this
server.

The linked server error is : Error 7399 "OLE DB
provider 'MSDAORA' reported an error.

Plese help me resolve this issue.

Thanks,

Hilary Cotter
9/28/2004 8:30:07 AM
MS DTC must be configured as a cluster resource if you are using linked
servers. Please refer to this link for more info.
http://support.microsoft.com/default.aspx?scid=kb;en-us;260758&Product=sql2k

As it was working before the upgrade it is likely you have configured MS DTC
correctly.

The 7399 is a generic error message. You might want to set this trace flag
on and rerun your query to get a more meaningful error message

DBCC TRACEON (7300, 3604)

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html


[quoted text, click to view]

Mark
1/3/2005 1:37:01 PM
We are having the same error, we are on Win 2000. What was your resolution?

[quoted text, click to view]
Claudio Riefolo
1/5/2005 11:10:42 AM
You must set the change permission fot Everyone on the folder C:\program
file\oracle and c:\oracle.

Claudio Riefolo

"Mark" <Mark@discussions.microsoft.com> ha scritto nel messaggio
news:F7D5E575-9EB4-4DFB-AA44-8907FCE6CFE4@microsoft.com...
[quoted text, click to view]

AddThis Social Bookmark Button