dblink problem

[sri_dba]

Hi Everyone,

I created a dblink, but the following error shown.

create database link dovetest
connect to dovetest identified by dovetest
using 'dovetest'

select count(*) from rep_refinance@dovetest;

ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor

Pls help.What could be the problem.

Thanx in advance.

[Srinivas_Sharma]

Hi,

do u have a TNS entry in the tnsnames file for the other database.

Srini

[DaPi]

The tnsnames entry for the remote db must exist on the SERVER which hosts the "local" db.