Oracle Database Express Edition (XE)

Howdy - anyone having problems starting the listener ?

Installation runs fine to completion, and database can be connected to with SQL Plus eg

C:\>sqlplus / as sysdba

SQL*Plus: Release 10.2.0.1.0 - Beta on Tue Nov 8 10:33:40 2005

Copyright (c) 1982, 2005, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Express Edition Release 10.2.0.1.0 - Beta

SQL>

but the htmldb connection does not work. Upon closer inspection, I'm guessing this is due to the listener not working properly, eg

C:\>lsnrctl start

LSNRCTL for 32-bit Windows: Version 10.2.0.1.0 - Beta on 08-NOV-2005 10:34:27

Copyright (c) 1991, 2005, Oracle. All rights reserved.

Starting tnslsnr: please wait...[long pause]

TNS-12560: TNS:protocol adapter error

The other bummer is that setting the listener trace parameters does not appear to have any impact, so diagnosis isn't that easy either. My listener.ora is as follows:

TRACE_LEVEL_LISTENER = 16

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\xe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = C:\oracle\xe\app\oracle\product\10.2.0\server)
(PROGRAM = extproc)
)
)

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
)
)

DEFAULT_SERVICE_LISTENER = (XE)

but no trace files are produced when trying to start the listener. Setting ORACLE_HOME and/or TNS_ADMIN on the command line does has no impact either.

Any ideas anyone ? Is there a truss for XP :-)

Cheers
Connor