Path: news.f.de.plusline.net!news-fra1.dfn.de!keepthis.news.telefonica.de!telefonica.de!news.cs.univ-paris8.fr!news.glorb.com!postnews.google.com!m7g2000cwm.googlegroups.com!not-for-mail From: "frank.van.bortel@gmail.com" Newsgroups: comp.databases.oracle.server Subject: Re: Database Link::ORA-12154: TNS:could not resolve........ Date: 17 Nov 2006 03:19:56 -0800 Organization: http://groups.google.com Lines: 43 Message-ID: <1163762396.663458.8810@m7g2000cwm.googlegroups.com> References: <1163748967.973456.178970@e3g2000cwe.googlegroups.com> NNTP-Posting-Host: 145.12.10.1 Mime-Version: 1.0 Content-Type: text/plain; charset="us-ascii" X-Trace: posting.google.com 1163762402 4036 127.0.0.1 (17 Nov 2006 11:20:02 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Fri, 17 Nov 2006 11:20:02 +0000 (UTC) In-Reply-To: <1163748967.973456.178970@e3g2000cwe.googlegroups.com> User-Agent: G2/1.0 X-HTTP-UserAgent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.8.0.8) Gecko/20061025 Firefox/1.5.0.8,gzip(gfe),gzip(gfe) Complaints-To: groups-abuse@google.com Injection-Info: m7g2000cwm.googlegroups.com; posting-host=145.12.10.1; posting-account=VU9ObQ0AAABpUdxfkDNLCGpxPvBEDT56 Xref: news.f.de.plusline.net comp.databases.oracle.server:189673 sanjeev schreef: > Hi Freinds, > > My platform is windows 2000 and oracle 9.2.0..... > > I have created link as below : > > create public database link A_LINK > connect to SCOTT identified by tiger > using 'AVAYA' > -------------------------------- > In tnsnames.ora file > > AVAYA = > (DESCRIPTION = > (ADDRESS_LIST = > (ADDRESS = (PROTOCOL = TCP)(HOST = ADB)(PORT = 1521)) > ) > (CONNECT_DATA = > (SERVICE_NAME = AVAYA.ADB) > ) > ) > ------------------------------- > select * > from BOSSDEPARTMENT@A_LINK; > > After firing the above query i got the error > > ERROR at line 2: > ORA-12154: TNS:could not resolve service name Is the a default domain in sqlnet.ora? If so - use that in the db link definition. Is this the tnsnames from the server? Also: is global_names true? If so, you will get another error if avaya point to a sid orcl (or anything different than avaya - however, not the error you are facing)