Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

URGENT: Can't Create Linked Svr to ORA

2 views
Skip to first unread message

nzr...@googlemail.com

unread,
May 8, 2009, 10:34:13 AM5/8/09
to
Server A - SQL 2005
Server B - SQL 2005
Server C - Oracle 10G

I have created a linked svr from B->C. It works fine. A->C fails.

The err is -

Cannot initialize the data source object of OLE DB provider
"OraOLEDB.Oracle" for linked server "LINK2ORA"
OLE DB provider "OraOLEDB.Oracle" for linked server "LINK2ORA"
returned message "ORA-12154:TNS:could not resolve the connect
identifier".

I have set up LINK2ORA exactly the same on A as on B
The Net Manager settings for the Oracle db are exactly the same on A
and B
On A the Net Manager test connection succeeds with the linked svr
login, just like it does on B
I have the "Allow In Process" provider setting checked on A, just like
B. Unchecking makes no difference

I'm really stuck. Please help!

Erland Sommarskog

unread,
May 8, 2009, 5:40:23 PM5/8/09
to

The error message comes from the Oracle side, so maybe you should
ask around in that world. I went to Googled and searched for
"ORA-12154" and got a bunch of hits. Not that really understood
what they mean, but you cannot accuse me to know too much about Oracle.

--
Erland Sommarskog, SQL Server MVP, esq...@sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

Geoff Muldoon

unread,
May 10, 2009, 7:22:46 PM5/10/09
to
In article <ec5b42b9-256e-432f-891c-d79986286d80
@s21g2000vbb.googlegroups.com>, says...

> I have created a linked svr from B->C. It works fine. A->C fails.
>
> The err is -
>
> Cannot initialize the data source object of OLE DB provider
> "OraOLEDB.Oracle" for linked server "LINK2ORA"
> OLE DB provider "OraOLEDB.Oracle" for linked server "LINK2ORA"
> returned message "ORA-12154:TNS:could not resolve the connect
> identifier".

Check for difference in the contents of the tnsnames.ora files on B and A.

GM

Michael Austin

unread,
May 14, 2009, 4:14:53 PM5/14/09
to
Erland Sommarskog wrote:
> (nzr...@googlemail.com) writes:
>> Server A - SQL 2005
>> Server B - SQL 2005
>> Server C - Oracle 10G
>>
>> I have created a linked svr from B->C. It works fine. A->C fails.
>>
>> The err is -
>>
>> Cannot initialize the data source object of OLE DB provider
>> "OraOLEDB.Oracle" for linked server "LINK2ORA"
>> OLE DB provider "OraOLEDB.Oracle" for linked server "LINK2ORA"
>> returned message "ORA-12154:TNS:could not resolve the connect
>> identifier".
>>
>> I have set up LINK2ORA exactly the same on A as on B
>> The Net Manager settings for the Oracle db are exactly the same on A
>> and B
>> On A the Net Manager test connection succeeds with the linked svr
>> login, just like it does on B
>> I have the "Allow In Process" provider setting checked on A, just like
>> B. Unchecking makes no difference
>>
>> I'm really stuck. Please help!
>
> The error message comes from the Oracle side, so maybe you should
> ask around in that world. I went to Googled and searched for
> "ORA-12154" and got a bunch of hits. Not that really understood
> what they mean, but you cannot accuse me to know too much about Oracle.
>
>
>


and the error itself is fairly self-explanatory - it could find what he
told it to look for...

""ORA-12154:TNS:could not resolve the connect identifier".

He should ensure that his Oracle client is installed and configured
correctly and make sure the TNSNAMES.ora file points to where he thinks
it should be pointed.

0 new messages