MSDAORA reported an error

[TheKidd]

I'm getting the following errors on one of two identical SQL Servers. Can anyone help? Thanks.

Server: Msg 7399, Level 16, State 1, Line 1
OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: ORA-12154: TNS:could not resolve service name]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBInitialize::Initialize returned 0x80004005: ].


OLE DB provider 'MSDAORA' reported an error.
[OLE/DB provider returned message: Unspecified error]
[OLE/DB provider returned message: ORA-03113: end-of-file on communication channel ]
OLE DB error trace [OLE/DB Provider 'MSDAORA' IDBSchemaRowset::GetRowset returned 0x80004005: ].

 

[SQLBill]

It looks like you have something that is trying to connect to an ORACLE server and is failing.

-SQLBill

Posting advice: FAQ481-4875

 

[mrdenny]

The first one is telling you that the tnsnames.ora file isn't setup correctly for the Oracle server you are trying to connect to.

As to the second one

http://ora-03113.ora-code.com/

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[TheKidd]

Thanks guys. Stopping and restarting the SQL services appears to have fixed the problem. Thanks again.

 

[MauraDae]

I am running into the same error. Connecting from sql server 800.760(SP3) on Windows NT - 5.0(2195). Same set up as my other server which is working correctly. Problem is, the O/S team installed the Oracle client and from the looks of things, multiple times.

Question: How do I see where SQL Server is looking for the tnsnames file? Usually it is under Oracle/network/admin.

 

[mrdenny]

I'd hunt down all the tnsnames.ora and start updating them one at a time until it works.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[MauraDae]

So, what is the deal with Oracle 9i client install? Does it install multiple directories with multiple tnsnames for resolution? That doesn't sound right. Also-what about this ODBC Instant client - is that a separate install?

 

[mrdenny]

There should only be two copies of tnsnames. One in the ADMIN folder and on in the ADMIN\SAMPLE folder.

I'm not sure about the ODBC Instance Client. You'd need to ask an Oracle person.

Denny
MCSA (2003) / MCDBA (SQL 2000) / MCTS (SQL 2005)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com