Question about listener: Please advise..

From: Henry Kam <kam1_at_whwpe.lucent.com>
Date: Fri, 28 Jun 2002 22:26:03 GMT
Message-ID: <3D1CE236.64924769@whwpe.lucent.com>

Oracle 9iAs1.0.2.2.2 was installed with oracle database 9.0.1.1.1 on W2000. Most of the components seem working...

I have question about "LISTENER": which is defined in the database 9.0.1.1.1 home/network/admin/listener.ora as follows:

# LISTENER.ORA Network Configuration File: C:\oracle\ora90\network\admin\listener.ora # Generated by Oracle configuration tools.

LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0))
      )


      (ADDRESS_LIST =

        (ADDRESS = (PROTOCOL = TCP)(HOST = hktest2)(PORT = 1521))
      )

)
)

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = C:\oracle\ora90)
(PROGRAM = extproc)

    )
    (SID_DESC =
(GLOBAL_DBNAME = orcl.hktest2.home.dom)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = orcl)

    )
    (SID_DESC =
(GLOBAL_DBNAME = OEMREP.home.dom)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = OEMREP)

    )
  )

The output of lsnrctl after "lsnrctl start" is as follows:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 9.0.1.1.1
- Production
Start Date                28-JUN-2002 21:19:06
Uptime                    0 days 0 hr. 0 min. 16 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   C:\oracle\ora90\network\admin\listener.ora
Listener Log File         C:\oracle\ora90\network\log\listener.log

Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc)))   (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hktest2)(PORT=1521))) Services Summary...
Service "OEMREP.home.dom" has 1 instance(s).   Instance "OEMREP", status UNKNOWN, has 1 handler(s) for this service...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl.hktest2.home.dom" has 1 instance(s).   Instance "orcl", status UNKNOWN, has 1 handler(s) for this service... The command completed successfully

The output of "lsnrctl status" after a couple of minutes is as follows:

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC0))) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 9.0.1.1.1
- Production
Start Date                28-JUN-2002 21:19:06
Uptime                    0 days 0 hr. 0 min. 58 sec
Trace Level               off
Security                  OFF
SNMP                      OFF
Listener Parameter File   C:\oracle\ora90\network\admin\listener.ora
Listener Log File         C:\oracle\ora90\network\log\listener.log

Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=hktest2)(PORT=1521)))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=xxx.6.8.18)(PORT=2482))(PRESENTATION=GIOP)(SESSION=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.6.8.18)(PORT=2481))(PRESENTATION=GIOP)(SESSION=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=xxx.6.8.18)(PORT=9090))(PRESENTATION=http://admin)(SESSION=RAW))

(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=xxx.6.8.18)(PORT=8080))(PRESENTATION=http://admin)(SESSION=RAW))

Services Summary...
Service "MODOSE" has 1 instance(s).
  Instance "OEMREP", status READY, has 1 handler(s) for this service... Service "OEMREP.home.dom" has 2 instance(s).   Instance "OEMREP", status UNKNOWN, has 1 handler(s) for this service...
  Instance "OEMREP", status READY, has 3 handler(s) for this service... Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "orcl.hktest2.home.dom" has 2 instance(s).   Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...   Instance "orcl", status READY, has 1 handler(s) for this service... The command completed successfully

My question is :
Where are lines with "SESSION=RAW" coming from? At this time only listener and instance "ORCL" are up (All other oracle services are not started) and the value of dispatchers for instance "ORCL" is blank Received on Fri Jun 28 2002 - 17:26:03 CDT