Oracle linked server error

Hello,
sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
Oracle 9i client installed.
We have set up a linked server to an Oracle instance using the 'Microsoft
OLE DB Provider for Oracle', this works for a while without any problems and
then for an unknown reason ceases to work.
The only error messages I have been able to get is by running the t-sql quer
y
SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
Server:Msg 7399, Level 16, State 1, Line 1
OLE DB Provider MSDAORA reported an error.
[OLE/DB provider returned message: Oracle error occured but error messag
e
could not be retrieved from Oracle.}
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize
returned 0x80004005:].
However using the Oracle client on the server I can still connect to any
Oracle instance but I have to stop and start the sql service to get the
linked server to work again, becuase I have to stop and start sql server I'm
presuming that the fault is with sql server.Did you check out that article before ?
HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
http://support.microsoft.com/d_efau...;en-us;Q280_106
HTH, Jens Suessmeyer.
http://www.sqlserver2005.de
"Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb im
Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
> Hello,
> sql server 2000 cluster patched to SP3 and NT5 patched to SP4.
> Oracle 9i client installed.
> We have set up a linked server to an Oracle instance using the 'Microsoft
> OLE DB Provider for Oracle', this works for a while without any problems
> and
> then for an unknown reason ceases to work.
> The only error messages I have been able to get is by running the t-sql
> query
> SELECT * FROM LINKSERV..SCHEMA.TABLE which returns
> Server:Msg 7399, Level 16, State 1, Line 1
> OLE DB Provider MSDAORA reported an error.
> [OLE/DB provider returned message: Oracle error occured but error mess
age
> could not be retrieved from Oracle.}
> OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initializ
e
> returned 0x80004005:].
> However using the Oracle client on the server I can still connect to any
> Oracle instance but I have to stop and start the sql service to get the
> linked server to work again, becuase I have to stop and start sql server
> I'm
> presuming that the fault is with sql server.
>
>|||Yes, I've seen this document and it has been of help to me before but not in
this case as the linked server works and then stops without notice
"Jens Sü?meyer" wrote:

> Did you check out that article before ?
> HOW TO: Set Up and Troubleshoot a Linked Server to Oracle in SQL Server
> http://support.microsoft.com/d_efa...en-us;Q280_106
>
>
> HTH, Jens Suessmeyer.
> --
> http://www.sqlserver2005.de
> --
> "Chris@.CambridgeUK" <Chris@.CambridgeUK@.discussions.microsoft.com> schrieb
im
> Newsbeitrag news:0BE21B83-BA02-4C0D-AA57-573AD76C3FB5@.microsoft.com...
>
>