Re: db link
Date: Thu, 29 Oct 2009 12:15:40 -0500
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;
> 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.
CliffReceived on Thu Oct 29 2009 - 12:15:40 CDT