Re: Please help ! Listener crashes on Windows Xp SP1 without reason

From: Herbert Ebberg <herbert.ebberg_at_eitcon.de>
Date: Thu, 8 Apr 2004 17:07:21 +0200
Message-ID: <c53pqk$l8h$1@ngspool-d02.news.aol.com>

Hi Niall,

the listener-Log say nothing - it seems that the listener realy crashes. Also Windows say nothing:

'Dienst "OracleOraHome92TNSListener" wurde unerwartet beendet, Dies ist bereits 36 Mal passiert'
(in English: 'Service "OracleOraHome92TNSListener" unexpacted stopped. This has happend 36b times')

Listener-log (sorry, in German):
...
TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 08-APR-2004 15:52:45

Die System-Parameterdatei ist
C:\Programme\oracle\ora92\network\admin\listener.ora Log-Meldungen wurden geschrieben in:
C:\Programme\oracle\ora92\network\log\listener.log Die Trace-Information wurde in
C:\Programme\oracle\ora92\network\trace\listener.trc geschrieben Die Trace-Ebene ist derzeitig 0

Gestartet mit Pid=2512
Listen auf:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=leporello.ebberg.no-ip.com)(PORT=1 521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE 08-APR-2004 15:52:51 *
(CONNECT_DATA=(CID=(PROGRAM=)(HOST=)(USER=Administrator))(COMMAND=status)(AR GUMENTS=64)(SERVICE=LISTENER)(VERSION=153092352)) * status * 0

TNSLSNR for 32-bit Windows: Version 9.2.0.1.0 - Production on 08-APR-2004 16:07:40

Gestartet mit Pid=3496
Listen auf:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=leporello.ebberg.no-ip.com)(PORT=1 521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE Listen auf:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=leporello.ebberg.no-ip.com)(PORT=8 080))(Presentation=HTTP)(Session=RAW))
Listen auf:
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=leporello.ebberg.no-ip.com)(PORT=2 100))(Presentation=FTP)(Session=RAW))

08-APR-2004 16:07:41 * service_register * orcl * 0
08-APR-2004 16:13:44 * service_update * orcl * 0
08-APR-2004 16:17:35 * service_update * orcl * 0
08-APR-2004 16:27:38 * service_update * orcl * 0
08-APR-2004 16:57:23 *

(CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=C:\Programme\Oracle\ora92\bin \sqlplusw.exe)(HOST=LEPORELLO)(USER=hebberg))) * (ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1980)) * establish * orcl * 0

---

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> schrieb im
Newsbeitrag news:407564b1$0$6555$ed9e5944_at_reading.news.pipex.net...


> What does listener.log say?

>

> -- 

> Niall Litchfield

> Oracle DBA

> Audit Commission UK

> http://www.niall.litchfield.dial.pipex.com/

> "Herbert Ebberg" <herbert.ebberg_at_eitcon.de> wrote in message

> news:c53m4h$gni$1_at_ngspool-d02.news.aol.com...

> > Hello,

> > I need some help - my listener crashes without reason after installing

> > Oracle 9i on a Windows XP Prof ServicePack2. I can start the listener

with


> > lsnrctl or with the services of xp, the first tnsping works fine, but

when


> I

> > try it again, the listener crashes without reason. Is there a known

> problen

> > with winsock or is there a path for xp ?

> >

> > Please help

> >

> > Herbert Ebberg

> >

> >

> > My listener.ora:

> >

> > LISTENER =

> >   (DESCRIPTION =

> >     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

> >   )

> >

> > SID_LIST_LISTENER =

> >   (SID_LIST =

> >     (SID_DESC =

> >       (SID_NAME = PLSExtProc)

> >       (ORACLE_HOME = C:\Programme\oracle\ora92)

> >       (PROGRAM = extproc)

> >     )

> >     (SID_DESC =

> >       (GLOBAL_DBNAME = orcl)

> >       (ORACLE_HOME = C:\Programme\oracle\ora92)

> >       (SID_NAME = orcl)

> >     )

> >   )

> >

> > My tnsnames.ora:

> > ORCL.EBBERG.NO-IP.COM =

> >   (DESCRIPTION =

> >     (ADDRESS_LIST =

> >       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))

> >     )

> >     (CONNECT_DATA =

> >       (SERVICE_NAME = orcl)

> >     )

> >   )

> >

> >

> >

>

>

Received on Thu Apr 08 2004 - 10:07:21 CDT