Re: Oracle 9.2.0.1 listener not starting

On 4 Sep 2006 09:56:32 -0700, "Jack" <jackmcbarn_at_hotmail.com> 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))
> )
> )
> )
>
>SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = C:\db01\opt\oracle\product\9.2.0)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = oemp.world)
> (ORACLE_HOME = C:\db01\opt\oracle\product\9.2.0)
> (SID_NAME = oemp)
> )
> )
>
>Sqlnet.ora:
>SQLNET.AUTHENTICATION_SERVICES= (NTS)
>
>NAMES.DIRECTORY_PATH= (LOCAL)
>
>Tnsnames.ora:
>
>INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = SHARED)
> (SERVICE_NAME = MODOSE)
> (PRESENTATION = http://HRService)
> )
> )
>
>EXTPROC_CONNECTION_DATA =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
> )
> (CONNECT_DATA =
> (SID = PLSExtProc)
> (PRESENTATION = RO)
> )
> )
>
>OEMP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = LOCALHOST)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVER = DEDICATED)
> (SERVICE_NAME = oemp.world)
> )
> )

localhost has been correctly set up in
%WINDOWS%\system32\drivers\etc\hosts as
127.0.0.1 localhost
?
I usually prefer to order IPC TCP/IP in the address section.

--
Sybrand Bakker, Senior Oracle DBA