Oracle Database Discussions

We are encountering a strange issue with DB link(may be new to me)

We have Oracle 9.2.0.8 and 10.2.0.3 in Solrais 10

We are accesing both servers from the 10g

We are able to connect to both the database through SQLplus

We created a DBLink in oracle 9i to access 10g

SQL:

create public database link PRD connect to admin identified by ***** using 'PRD';

Database link is created

We have an entry in the TNSNAMES.ora for PRD which has a description connecting to 10g database.

now we are issuin

select * from table@PRD


The error message is

ora 12514-TNS could not resolve connect identifier sepcified


But i am ablt to connect to both the databases from SQLPLUS but not by DBlink

My global_names parmaeter is TRUE:

Global_name=PRD without the domain name..