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: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 05 Oct 2005 10:11:54 -0700
Message-ID: <1128532308.886755@yasure>


Comments in-line.

brhurley_at_gmail.com wrote:
> Background: Fresh install of oracle 10g on WindowsXP for a development
> enviroment. This computer is a laptop that moves between domains/ips.
> I used DBCA to create the database while I was attached to my work IP.
> This instance is setup in a dedicated server mode. Everything worked
> just fine at work but when I got home I could not connect using connect
> <user>/<pass>@devtest returning ORA-12518.
> I can connect using connect <user>/<pass>.
> Here is the related files along with the listener trace.
>
> listener.ora
> ----------------

  > LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

Drop LOCALHOST and use the machine name or static IP.

> tnsnames.ora
> -------------
> DEVTEST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = devtest)
> )
> )

Same here.

Alternatively use NETCA to drop and recreate the listener.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Wed Oct 05 2005 - 12:11:54 CDT

Original text of this message

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