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

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sat, 19 Jan 2002 20:03:55 +0100
Message-ID: <2igj4ucu5h15jm5hsctnl3tbgpppr0mjih@4ax.com>

Remarks and questions embedded in your original replay, marked by #

On 19 Jan 2002 09:06:22 -0800, rothwellt_at_hotmail.com (Tony Rothwell) wrote:

>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)
> )

# this block shouldn't be here anymore, unless using OEM
> (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))
> )

# do you have a matching service_name in init.ora?
# service_name definitions will NOT match with sid_name
#definitions!!!!


>    (CONNECT_DATA =

>      (SERVICE_NAME = db2.tony)

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

# do you have MTS set up in init.ora?
# do you have the service MODOSE defined in init.ora?
> (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.

Hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jan 19 2002 - 13:03:55 CST