Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!border1.nntp.dca.giganews.com!nntp.giganews.com!postnews.google.com!g44g2000cwa.googlegroups.com!not-for-mail
From: roar.dale@serve.no
Newsgroups: comp.databases.oracle.server
Subject: Re: ORA-12518 Listener could not hand off connection
Date: 10 Oct 2005 01:35:55 -0700
Organization: http://groups.google.com
Lines: 15
Message-ID: <1128933355.685839.285190@g44g2000cwa.googlegroups.com>
References: <1128526003.965134.68960@g14g2000cwa.googlegroups.com>
   <1128532783.375166.218760@g47g2000cwa.googlegroups.com>
NNTP-Posting-Host: 212.33.141.178
Mime-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
X-Trace: posting.google.com 1128933366 17123 127.0.0.1 (10 Oct 2005 08:36:06 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: Mon, 10 Oct 2005 08:36:06 +0000 (UTC)
In-Reply-To: <1128532783.375166.218760@g47g2000cwa.googlegroups.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),gzip(gfe),gzip(gfe)
Complaints-To: groups-abuse@google.com
Injection-Info: g44g2000cwa.googlegroups.com; posting-host=212.33.141.178;
   posting-account=AMgUEg0AAAD4adlHZmbOxKDlfpYspBDF
Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:253082


JTommaney wrote:
> Is it possible you are picking up a different tnsnames file?
> tnsnames.ora references local/1521:
> ..  (HOST = localhost)(PORT = 1521)) ..
>
> The log references this for devtest.
> ... HOST=127.0.0.1)(PORT=3711  ...
>
> > host tnsping devtest
>
> should echo back out the tnsnames.ora entry to double check.

Try to change SID = ..... to SERVICE_NAME = .... in tnsnames.ora