I created database link, and when issuing

select * from ticket@prod where abc='xyz'

(prod is my database link name)

it gives me TNS error,
ORA-12154: TNS:could not resolve service name

Please let me know how to resolve it.