Re: Newbie has TNS listener problem

The IP you see under 'host=*.*.*.*' in the listerer.log should be the ip of the client making the connection request.

As for your other questions, PLSExtProc allows you to do external procedure calls (like from C/C++) and INST1_HTTP is used for connections from web servers like Apache (or other oracle supplied products).

If you have no need for either of these options, you can comment them out and see if that makes a difference in running your listener.

hth
John

IKerr. wrote:
> 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 - 07:08:42 CST