Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tnslistener dying with 9.2 on Win XP Pro

Re: Tnslistener dying with 9.2 on Win XP Pro

From: Adam Lipscombe <adam_at_cobar.fsbusiness.co.uk>
Date: Mon, 7 Apr 2003 15:49:24 +0100
Message-ID: <b6s35i$hoa$1@newsg1.svr.pol.co.uk>


The listener.log contains:

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 07-APR-2003 15:44:26

Copyright (c) 1991, 2002, Oracle Corporation. All rights reserved.

System parameter file is D:\oracle\ora92\network\admin\listener.ora Log messages written to D:\oracle\ora92\network\log\listener.log Trace information written to D:\oracle\ora92\network\trace\listener.trc Trace level is currently 0

Started with pid=2604
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cobar)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 07-APR-2003 15:45:59 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2799)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:13 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2802)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:13 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2805)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:17 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2808)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:18 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2811)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:18 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2814)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:22 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2820)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:22 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2823)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:25 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2826)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:25 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2829)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:28 * service_register * oradb1 * 0 07-APR-2003 15:46:28 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2834)) * establish *
oradb1.cobar * 0
07-APR-2003 15:46:35 * service_update * oradb1 * 0 07-APR-2003 15:46:38 * service_update * oradb1 * 0 Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cobar)(PORT=8080))(Presentation=HT
TP)(Session=RAW))
Listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cobar)(PORT=2100))(Presentation=FT
P)(Session=RAW))
07-APR-2003 15:46:41 * service_update * oradb1 * 0 07-APR-2003 15:47:02 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2842)) * establish *
oradb1.cobar * 0
07-APR-2003 15:47:03 * service_update * oradb1 * 0 No longer listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cobar)(PORT=2100))(Presentation=FT
P)(Session=RAW))
No longer listening on:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=cobar)(PORT=8080))(Presentation=HT
TP)(Session=RAW))
07-APR-2003 15:47:07 * service_died * oradb1 * 12537 07-APR-2003 15:47:11 *
(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=oradb1.cobar)(CID=(PROGRAM=C:\
Program Files\Oracle\jre\1.1.8\bin\jrew.exe)(HOST=COBAR)(USER=adam))) *
(ADDRESS=(PROTOCOL=tcp)(HOST=10.48.30.199)(PORT=2845)) * establish *
oradb1.cobar * 0

"Adam Lipscombe" <adam_at_cobar.fsbusiness.co.uk> wrote in message news:b6s2eo$97k$1_at_newsg3.svr.pol.co.uk...

> Apologies - long week :-)
>
> TNSLSNR appears to fall over regulalrly when I am administering the DB via
> Enterprise Manager.
>
> The error dialog dialog box says:
> "TNSLSNR.exe has encountered a problem and needs to close. We are sorry
for
> the inconvenience."
> followed buy a request to send the error report to Microsoft.
>
> If I click the link entitled "To see what data this error report
> contains..." the following is displayed:
>
> "szAppName : TNSLSNR.EXE szAppVer : 0.0.0.0 szModName : orantcp9.dll"
> "szModVer : 0.0.0.0 offset : 00005732"
>
> Followed by some text about Microsoft not collecting any personal info,
and
> an exhortation to send the report.
>
>
> Any ideas?
>
>
> TIA - Adam Lipscombe
>
>
> "Sybrand Bakker" <gooiditweg_at_nospam.demon.nl> wrote in message
> news:11pr8v0e4043tr6c3tngfllgoim9522ga5_at_4ax.com...
> > On Fri, 4 Apr 2003 11:10:52 +0100, "Adam Lipscombe"
> > <adam_at_cobar.fsbusiness.co.uk> wrote:
> >
> > >Hi,
> > >
> > >
> > >I have 9i personal installed on an XP Pro box.
> > >When I try to adminsiter the db through the Enterprise Manager it
manages
> to
> > >logon OK, but when I try to shutdown or start the DB tThe tns listener
> dies
> > >with a MS error dialog displayed.
> > >
> > >I have to then manually restart the tnslistener service.
> > >
> > >
> > >Does anyone know what causes this and how to fix?
> > >
> > >
> > >TIA - Adam Lipscombe
> > >
> >
> > No, basically you don't provide any useful clues except for 'a
> > Microsoft error'.
> > Please provide the *exact* error and look in the listener.log file.
> >
> >
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
>
Received on Mon Apr 07 2003 - 09:49:24 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US