Re: Listener problems with 9i (9.0.1.1.1) on XP Pro

From: Tony Rothwell <rothwellt_at_hotmail.com>
Date: 19 Jan 2002 09:06:22 -0800
Message-ID: <5e430aec.0201190906.482227c5@posting.google.com>

The 9i install is vanilla from the installer and is on top of an XP Pro install that is virtually fresh. Switching on Trace for the Listener does not indicate any obvious errors.

I've included below the listener.ora and tnsnames.ora files. Please let me know whether there's anything really dumb in there which may be the cause of the crashes:-

---

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

LOGGING_listener = on
TRACE_LEVEL_listener = admin
TRACE_TIMESTAMP = on

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
(ADDRESS_LIST =

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


      (ADDRESS_LIST =

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

    )
  )

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

    )
    (SID_DESC =
(GLOBAL_DBNAME = db2.tony)
(ORACLE_HOME = C:\oracle\ora90)
(SID_NAME = db2)

    )
  )

---

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

DB2 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TONYR_DELL18GHZ)(PORT =
1521))

    )
    (CONNECT_DATA =
(SERVICE_NAME = db2.tony)

    )
  )

INST1_HTTP =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = TONYR_DELL18GHZ)(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)

    )
  )

---

Thanks again for the help. Received on Sat Jan 19 2002 - 11:06:22 CST