I created a db link on our 11g RAC database.
When I try to use it from sql developer on my client machine in following way:
I get the error:
[tt]ORA-12154: TNS:could not resolve the connect identifier specified
12154. 00000 - "TNS:could not resolve the connect identifier specified"[/tt]
But when I login to sqlplus on the server itself and try the same thing it works fine:
It seems a bit strange behavior. In both the cases the user is same. Tns entry for the EAIPREPROD is present in all the RAC nodes.
Any ideas?
Thanks,
Prashant
Code:
CREATE DATABASE LINK nst_test CONNECT TO eai_rt IDENTIFIED BY eai_rt USING 'EAIPREPROD';
Code:
select * from dual@nst_test;
[tt]ORA-12154: TNS:could not resolve the connect identifier specified
12154. 00000 - "TNS:could not resolve the connect identifier specified"[/tt]
But when I login to sqlplus on the server itself and try the same thing it works fine:
Code:
select * from dual@nst_test;
It seems a bit strange behavior. In both the cases the user is same. Tns entry for the EAIPREPROD is present in all the RAC nodes.
Any ideas?
Thanks,
Prashant