Re: Listener crashing, 9i on XP Pro

From: Tony Rothwell <rothwellt_at_hotmail.com>
Date: 22 Feb 2002 15:53:32 -0800
Message-ID: <5e430aec.0202221553.2dcfec2c@posting.google.com>

Sybrand Bakker <postbus_at_sybrandb.demon.nl> wrote in message news:<pbnb7u43og7brggdqqvi8ht2253raash1v_at_4ax.com>...

>
> Probably you posted this without your listener.ora and so on the last
> time.
> Hence you can not expect any reasonable answer.

Hello Sybrand, I posted those details, and had a response from a number of people including yourself (thanks for that), but I was unable to resolve the problem.

I've included below the listener.ora, tnsnames.ora, sqlnet.ora and init.ora. These were all created automatically on install of 9i by the Net Configuration Assistant or Database Configuration Assistane. i.e. I've made no manual changes to the files. The listener.log is placed at the end.

JUst to clarify: a TNSPING crashes the listener every time. If I connect through SQL*plus, the connection succeeds but the listener crashes immediately following the connection.

Any help you can provide is appreciated.

Regards,
Tony.

listener.ora:-

# 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 = 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 = dev91.tony)
      (ORACLE_HOME = C:\oracle\ora90)
      (SID_NAME = dev91)

)
)

tnsnames.ora:-

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

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

    )
    (CONNECT_DATA =
      (SERVICE_NAME = dev91.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)

)
)

sqlnet.ora

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

SQLNET.AUTHENTICATION_SERVICES= (NTS) NAMES.DIRECTORY_PATH= (TNSNAMES, ONAMES, HOSTNAME) init.ora

##############################################################################

##############################################################################
 
###########################################

# Cache and I/O

###########################################

db_block_size=4096
db_cache_size=33554432

###########################################

# Cursors and Library Cache

###########################################

open_cursors=300

###########################################

# Diagnostics and Statistics

###########################################

background_dump_dest=C:\oracle\admin\dev91\bdump core_dump_dest=C:\oracle\admin\dev91\cdump timed_statistics=TRUE
user_dump_dest=C:\oracle\admin\dev91\udump

###########################################

# Distributed, Replication and Snapshot

###########################################

db_domain=tony
remote_login_passwordfile=EXCLUSIVE

###########################################

# File Configuration

###########################################
control_files=("C:\oracle\oradata\dev91\CONTROL01.CTL",

"C:\oracle\oradata\dev91\CONTROL02.CTL", "C:\oracle\oradata\dev91\CONTROL03.CTL")

###########################################

# MTS

###########################################

dispatchers="(PROTOCOL=TCP)(SER=MODOSE)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)", "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"

###########################################

# Miscellaneous

###########################################

compatible=9.0.0
db_name=dev91

###########################################

# Network Registration

###########################################

instance_name=dev91

###########################################

# Pools

###########################################

java_pool_size=33554432
large_pool_size=1048576
shared_pool_size=33554432

###########################################

# Processes and Sessions

###########################################

processes=150

###########################################

# Redo Log and Recovery

###########################################

fast_start_mttr_target=300

###########################################

# Sort, Hash Joins, Bitmap Indexes

###########################################

sort_area_size=524288

###########################################

# System Managed Undo and Rollback Segments

###########################################

undo_management=AUTO
undo_tablespace=UNDOTBS

listener.log

System parameter file is C:\oracle\ora90\network\admin\listener.ora Log messages written to C:\oracle\ora90\network\log\listener.log Trace information written to
C:\oracle\ora90\network\trace\listener.trc Trace level is currently 0

Started with pid=3252
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC0ipc))) Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=TONYR_DELL18GHZ)(PORT=1521)))

TIMESTAMP * CONNECT DATA [* PROTOCOL INFO] * EVENT [* SID] * RETURN CODE
22-FEB-2002 23:41:39 * ping * 0

Received on Fri Feb 22 2002 - 17:53:32 CST