I created a DB link to an instance called SPRODEV.AEL but when I try and use it I get the error message thus:

SQL> select * from [email protected];
select * from [email protected]
*
ERROR at line 1:
ORA-12154: TNS:could not resolve service name

The service name I used in the USING clause when I created the DB link works fine when I just issue a CONNECT user/pwd@servicename command, what can be causing it to fail in a DB link?

Both databases (local and remote) have GLOBAL_NAME parameter set to TRUE and SPRODEV.AEL is the global name of the remote DB.