Re: db link
From: Cliff Nadler <cnadler_at_gmail.com>
Date: Thu, 29 Oct 2009 12:15:40 -0500
Message-ID: <148f79bc0910291015r2b8a7609u553c5c992d117f99_at_mail.gmail.com>
On Thu, Oct 29, 2009 at 11:35 AM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:
> SQL> desc rpci.ert_lims_iface_at_lims_to_ert;
> ERROR:
> 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.
Date: Thu, 29 Oct 2009 12:15:40 -0500
Message-ID: <148f79bc0910291015r2b8a7609u553c5c992d117f99_at_mail.gmail.com>
On Thu, Oct 29, 2009 at 11:35 AM, Zelli, Brian <Brian.Zelli_at_roswellpark.org> wrote:
> SQL> desc rpci.ert_lims_iface_at_lims_to_ert;
> ERROR:
> 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.
Cliff
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Oct 29 2009 - 12:15:40 CDT