Re: db link

From: Cliff Nadler <>
Date: Thu, 29 Oct 2009 12:15:40 -0500
Message-ID: <>

On Thu, Oct 29, 2009 at 11:35 AM, Zelli, Brian <> wrote:
> SQL> desc rpci.ert_lims_iface_at_lims_to_ert;
> ORA-12154: TNS:could not resolve the connect identifier specified
> I have the PRODERT.ROSWELLPARK.ORG in my tnsnames and I can connect with
> sqlplus to that db.  So what's wrong?  All we did was move the database to a
> new server.

Asking the basic question here:

Did you make the change to the tnsnames.ora file on the server where the source database is (the one where you created the link)? A link uses the database's naming files to connect to the database, not the one on your client.


Received on Thu Oct 29 2009 - 12:15:40 CDT

Original text of this message