Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.icl.net!newsfeed.fjserv.net!oleane.net!oleane!news.in2p3.fr!in2p3.fr!proxad.net!64.233.160.134.MISMATCH!postnews.google.com!j33g2000cwa.googlegroups.com!not-for-mail
From: "GM" <ganesh_boston@yahoo.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
Date: 20 Apr 2006 07:50:26 -0700
Organization: http://groups.google.com
Lines: 5
Message-ID: <1145544626.758117.296570@j33g2000cwa.googlegroups.com>
References: <1145458230.665262.78160@z34g2000cwc.googlegroups.com>
   <e2616k$v27$00$1@news.t-online.com>
   <1145480307.303976.123810@t31g2000cwb.googlegroups.com>
   <e27gel$gae$03$1@news.t-online.com>
NNTP-Posting-Host: 192.233.155.20
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1145544637 15584 127.0.0.1 (20 Apr 2006 14:50:37 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Thu, 20 Apr 2006 14:50:37 +0000 (UTC)
In-Reply-To: <e27gel$gae$03$1@news.t-online.com>
User-Agent: G2/0.2
X-HTTP-UserAgent: Mozilla/4.0 (compatible; MSIE 6.0; Windows NT 5.1; SV1; .NET CLR 1.1.4322; InfoPath.1; .NET CLR 2.0.50727),gzip(gfe),gzip(gfe)
X-HTTP-Via: 1.0 EDGEISAMA1
Complaints-To: groups-abuse@google.com
Injection-Info: j33g2000cwa.googlegroups.com; posting-host=192.233.155.20;
   posting-account=55f6LgwAAABsNwcfryW3nAJAGRqxBdIf
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:265930

Thanks Maxim, Sorry I misunderstood what you meant. I used the
TNS_ADMIN environment variable to point to the right directory of the
XE's tnsnames.ora and everything seems to work fine now.
Thanks Maxim and Sybrand for your help.