Make sure that the connect string used between UNIX box and 9 DB is same
as connect string between your PC and 9 DB
It will work.

Mohan.

-----Original Message-----
From: Jimmy Sanby (J)
[mailto:oracledba-ezmlmshield-x49418450.[Email address protected]
Sent: Friday, February 25, 2005 2:15 AM
To: LazyDBA Discussion
Subject: DBLINK problem


I have created a dblink from an Oracle 8 DB to an Oracle 9 DB.

When I connect via sqlplus on the unix box, the link works Select * from
[Email Address Removed] I connect via sqlplus from my PC the link fails with ORA-12154.

Any ideas??

Jimmy

==================================================================
This e-mail and its contents are subject to the Telkom SA Limited e-mail
legal notice available at

http://www.telkom.co.za/TelkomEMailLegalNotice.PDF


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html


Oracle LazyDBA home page