Re: Oracle 9.2.0.1 listener not starting

From: <frank.van.bortel_at_gmail.com>
Date: 5 Sep 2006 07:49:33 -0700
Message-ID: <1157467773.586754.80420@e3g2000cwe.googlegroups.com>

fitzjarrell_at_cox.net schreef:

> Jack wrote:
> > The error:
> >
> >
> > LSNRCTL> start
> > Starting tnslsnr: please wait...
> >
> > Failed to start service, error 3.
> > TNS-12560: TNS:protocol adapter error
> > TNS-00530: Protocol adapter error
> > 32-bit Windows Error: 3: No such process
> >
> >
> > Listener.ora:
> >
> > LISTENER =
> > (DESCRIPTION_LIST =
> > (DESCRIPTION =
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))
> > )
> > (ADDRESS_LIST =
> > (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> > )
> > )
> > )
> <rest snipped>

>

> If you insist upon using 'localhost' you can't capitalise it as
> /etc/hosts lists it in all lower case. Change that and you should see
> your listener start.

>
David,

windows isn't as case aware as a normal OS, LOCALHOST gets resolved similar
as localhost:
Listening Endpoints Summary...

  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC3ipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\ORCLipc)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))

Services Summary... Received on Tue Sep 05 2006 - 09:49:33 CDT