Hi,
The tns entry needs to be there on the machine which has the DB
(dbsrc1). Did you check there?
Regards,
Jay



"Nagarajan
VinodhKumar "
<oracledba-ezml To
mshield-x465042 "LazyDBA Discussion"
2.[Email Address Removed] <[Email address protected]
azyDBA.com> cc

03/05/2008 Subject
02:11 PM RE: Regarding Database Schema .










Hi,

The TNSname entries are right . And i had created the DBlink in the
second
schema , but i'm getting the same error .



Thanks,

Vinodh.





-----Original Message-----
From: Vijayakumar K - DBA(Data Center) - SIS
[mailto:oracledba-ezmlmshield-x64338109.[Email address protected]
Sent: Wednesday, March 05, 2008 1:11 PM
To: LazyDBA Discussion
Subject: RE: Regarding Database Schema .


Dear Nagaraj

The error shows that the tns entry is not there .
Try tnsping <servername> first and if it resolves

Regards
Vijayakumar K

-----Original Message-----
From: Nagarajan VinodhKumar
[mailto:oracledba-ezmlmshield-x72841436.[Email address protected]
Sent: Wednesday, March 05, 2008 12:59 PM
To: LazyDBA Discussion
Subject: Regarding Database Schema .



Hi all ,

I had two schemas both in different systems, the db_src1 and
db_src2.

In which i want to get the tables from db_src1 to db_src2 . I had
tried this by
creating dblink . But i get the TNS error while i try to access the
table .

This is the error .

ORA-12154: TNS:could not resolve the connect identifier specified

help me to get rid of this.


Thanks

Vinodh,

Confidential: This electronic message and all contents contain
information from Syntel, Inc. which may be privileged, confidential or
otherwise protected from disclosure. The information is intended to be
for the addressee only. If you are not the addressee, any disclosure,
copy, distribution or use of the contents of this message is
prohibited. If you have received this electronic message in error,
please notify the sender immediately and destroy the original message
and all copies.

Confidential: This electronic message and all contents contain
information from Syntel, Inc. which may be privileged, confidential or
otherwise protected from disclosure. The information is intended to be
for the addressee only. If you are not the addressee, any disclosure,
copy, distribution or use of the contents of this message is
prohibited. If you have received this electronic message in error,
please notify the sender immediately and destroy the original message
and all copies.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html




Visit us at www.sundaraminfotech.in

This E-mail may contain privileged information and is intended solely
for the addressee, and any disclosure of this information is strictly
prohibited, and may be unlawful. If you have received this mail by
mistake, please inform us immediately and delete this mail. Any
information expressed in this mail does not necessarily reflect the
views of SUNDARAM INFOTECH SOLUTIONS. As per SUNDARAM INFOTECH
SOLUTIONS's policy, unencrypted mail via Internet is not considered
secure.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Confidential: This electronic message and all contents contain
information from Syntel, Inc. which may be privileged, confidential or
otherwise protected from disclosure. The information is intended to be
for the addressee only. If you are not the addressee, any disclosure,
copy, distribution or use of the contents of this message is
prohibited. If you have received this electronic message in error,
please notify the sender immediately and destroy the original message
and all copies.


---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html







Oracle LazyDBA home page