Re: ORA-12518 Listener could not hand off connection

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)