andyho99_at_yahoo.com wrote:
> Hi,
>
> I'm trying to create a database link at test database. In another word,
> I'd like to access DEVL database tables from TEST database.
>
> I used TOAD to create db link (devl) from TEST database. However, I got
> the following error messages:
>
> Link : "devl"
> Error : ORA-12154: TNS:could not resolve service name
>
> I created db link long time ago without problem. I was wondering
> whether this error message means some definitions missing in
> tnsnames.ora. Thanks for your help.
>
> Andrew.
You need a valid TNSNAMES.ORA entry for DEVL on the TEST server in
$ORACLE_HOME/network/admin.
--
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Sun Oct 29 2006 - 13:24:52 CST
