Re: Newbie has TNS listener problem

TNS-12500: TNS:listener failed to start a dedicated server process

usually isn't a listener problem, but an authentication problem. Look into your sqlnet.ora (same directory as listener.ora). Search for a line like
sqlnet.authentication = (NTS)
and delete the NTS, leaving only the empty parenthesis.

Yours Sigrid

IKerr. schrieb:
> Hi,
>
> I had a w2k crash which needed a partial re-install. I have also
> re-installed Oracle 9 & Oracle DS. This is on a local desktop machine.
> Towards the very end of the install there was a glitch (possibly because I
> didn't know how to answer some net setup questions ?). Now when I try and
> startup my old db I get
>
> ORA-12541: TNS: no listener
>
> I have searched on the newsgroups and tried this
>
> c:\> lsnrctl
>
> and then:
>
> LSNRCTL> start
> Starting tnslsnr: please wait...
> TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production
> System parameter file is C:\orant\network\admin\listener.ora
> Log messages written to C:\orant\network\log\listener.log
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521))
> Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=myhost)(PORT=1521))
> STATUS of the LISTENER
> ------------------------
> Alias LISTENER
> Version TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Prod
> tion
> Start Date 12-MAR-2003 12:01:29
> Uptime 0 days 0 hr. 0 min. 2 sec
> Trace Level off
> Security OFF
> SNMP OFF
> Listener Parameter File C:\orant\network\admin\listener.ora
> Listener Log File C:\orant\network\log\listener.log
> Listening Endpoints Summary...
> (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
> Services Summary...
> Service "PLSExtProc" has 1 instance(s).
> Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
> Service "myGlobal" has 1 instance(s).
> Instance "myGlobal", status UNKNOWN, has 1 handler(s) for this service...
> The command completed successfully
> LSNRCTL>
>
> When I try to logon to the db in Enterprise Manager Console (standalone). I
> get:
>
> ORA-12500: TNS listener failed to start a dedicated server process.
>
> C:\orant\network\log\listener.log
>
> shows
>
> TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 12-MAR-2003
> 12:08:44
> Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.
> System parameter file is C:\orant\network\admin\listener.ora
> Log messages written to C:\orant\network\log\listener.log
> Trace information written to C:\orant\network\trace\listener.trc
> Trace level is currently 0
> Started with pid=1276
> Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=myhost)(PORT=1521)))
> TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
> 12-MAR-2003 12:08:46 *
> (CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Me))(COMMAND=status)(ARGUMENTS=64)
> (SERVICE=LISTENER)(VERSION=153092352)) * status * 0
> 12-MAR-2003 12:09:13 *
> (CONNECT_DATA=(SERVICE_NAME=myglobal)(CID=(PROGRAM=C:\Program
> Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=myhost)(USER=Me))) *
> (ADDRESS=(PROTOCOL=tcp)(HOST=**.*.***.***)(PORT=1638)) * establish *
> myglobal * 12500
> TNS-12500: TNS:listener failed to start a dedicated server process
> TNS-12560: TNS:protocol adapter error
> TNS-00530: Protocol adapter error
> 32-bit Windows Error: 2: No such file or directory
>
> What file/directory is this referring to & is that the problem or a red
> herring ?
> Where it referrs to HOST=**.*.***.*** - that is the IP of my cable modem -
> why ???
> Also, in the listener.ora & tnsnames.ora there are two entries that I don't
> understand:
>
> # LISTENER.ORA Network Configuration File:
> C:\orant\network\admin\listener.ora
> # Generated by Oracle configuration tools.
> LISTENER =
> (DESCRIPTION_LIST =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MYHOST)(PORT = 1521))
> )
> )
> )
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = PLSExtProc)
> (ORACLE_HOME = C:\orant)
> (PROGRAM = extproc)
> )
> (SID_DESC =
> (GLOBAL_DBNAME = myGlobal)
> (ORACLE_HOME = C:\orant)
> (SID_NAME = myGlobal)
> )
> )
>
> # TNSNAMES.ORA Network Configuration File:
> C:\orant\network\admin\tnsnames.ora
> # Generated by Oracle configuration tools.
> MYGLOBAL =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MYHOST)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = myglobal)
> )
> )
> INST1_HTTP =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = MYHOST)(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)
> )
> )
>
> What are "PLSExtProc" & "INST1_HTTP" ?
> Can any kind soul help a newbie out ?
>
> thanks
>
> Iain
>
>
>
>
Received on Fri Mar 14 2003 - 09:58:01 CST