Hi Friends,

Can you help me with my database link problem please.
Something just went wrong here :(

You see, I have 2 10g DBs on both WIN2003 (ORCL, AND ORCL2).
On ORCL server I created a database link connecting to ORCL2.
I also make a connection test first, say:
At db server 1,
C:\> sqlplus scott/tiger@orcl (connected)
C:\> sqlplus scott/tiger@orcl2 (connected)

Connecting back to orcl (conn scott/tiger@orcl) I then create a db link:

SQL> create database link orcl2_lnk connect to scott identified by
tiger using 'orcl2';

SQL> select * from tab@orcl2_lnk;
select * from tab@orcl2_lnk
*
ERROR at line 1:
ORA-12154: TNS:could not resolve the connect identifier specified


Why is this error pleaseeeeeeeee

Thanks a lot