Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: ORA-12518 Listener could not hand off connection

Re: ORA-12518 Listener could not hand off connection

From: <roar.dale_at_serve.no>
Date: 10 Oct 2005 01:35:55 -0700
Message-ID: <1128933355.685839.285190@g44g2000cwa.googlegroups.com> 






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
Received on Mon Oct 10 2005 - 03:35:55 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US