Dear Members,

I want to access table from the remote database .For that

I CREATED A DATABASE LINK WITH

create database link testconnect connect to ccis identified by ccis using 'DB1';
Database link created.

when I am accesing the table: It is giving an error

select docid from blobdoc@testconnect;
ERROR at line 1:

ORA-12154: TNS:could not resolve service name


These are the tnsnames.ora and sqlnet.ora files

SQLNET.ORA

NAMES.DEFAULT_DOMAIN=HOSTNAME
SQLNET.AUTHENTICATION-SERVICES=(NTS)
NAMES.DIRECTORY-PATH=(TNSNAMES,ONAMES,HOSTNAME)


TNSNAMES.ORA

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.1)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=LOBIS))

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.0.0.1)(PORT=1521))
(CONNECT_DATA=(SERVICE_NAME=DB1))


can anyone send me where its going wrong.