Linked Server Error Oracle Database

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,
Jan K.
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...&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
"Jan K." <anonymous@.discussions.microsoft.com> wrote in message
news:00a601c4a4c1$249d2ba0$a601280a@.phx.gbl...
> 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,
> Jan K.
|||We are having the same error, we are on Win 2000. What was your resolution?
"Hilary Cotter" wrote:

> 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...&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
>
> "Jan K." <anonymous@.discussions.microsoft.com> wrote in message
> news:00a601c4a4c1$249d2ba0$a601280a@.phx.gbl...
>
>
|||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...[vbcol=seagreen]
> We are having the same error, we are on Win 2000. What was your
> resolution?
> "Hilary Cotter" wrote: