Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Create Database Link
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.orgReceived on Sun Oct 29 2006 - 13:24:52 CST