Persistent Listener Problem - Aggravating!

Am still having problems with the Listener detaching at every 'call' to the db. Am using Oracle 9i on WIN2K, and am using Powerbuilder 8.0.1. I am not a DBA, nor do I intend to beome one. Am just trying to familiarize myself with this version of Oracle. The problem happens when I use Toad, SQL Plus, or Powerbuilder. I always recieve a Messagebox with the 'error' in it. I have included these files for your perusal: 'error message',INIT.ora, TNSNAMES.ora, LISTENER.ora, and SQL.ora files:

[ERROR Message]
PROGRAM ERROR
TNSLNR.EXE has generated errors and will be closed by Windows. You will need to restart the program. An error log is being created. (However, there does not appear to be any error log created!)

INIT.ORA
# Copyright (c) 1991, 2001 by Oracle Corporation

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

# 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\TEST\bdump

core_dump_dest=C:\oracle\admin\TEST\cdump

timed_statistics=TRUE

user_dump_dest=C:\oracle\admin\TEST\udump

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

# Distributed, Replication and Snapshot

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

db_domain=DB

remote_login_passwordfile=EXCLUSIVE

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

# File Configuration

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

control_files=("C:\oracle\oradata\TEST\CONTROL01.CTL",
"C:\oracle\oradata\TEST\CONTROL02.CTL",
"C:\oracle\oradata\TEST\CONTROL03.CTL")



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

# MTS
###########################################

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

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

# Miscellaneous

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

compatible=9.0.0

db_name=TEST.NHEMS.DB

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

# Network Registration

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

instance_name=TEST

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

# 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.ORA Network Configuration File: C:\oracle\ora90\network\admin\listener.ora

# Generated by Oracle configuration tools.

LISTENER =   (DESCRIPTION_LIST =     (DESCRIPTION =       (ADDRESS_LIST =         (ADDRESS = (PROTOCOL = TCP)(HOST = Q4E60KISR45DQ77)(PORT = 1521))       )

    )

  )

SID_LIST_LISTENER =   (SID_LIST =     (SID_DESC =     (GLOBAL_DBNAME = TEST.NHEMS.DB)     (ORACLE_HOME = C:\oracle\ora90)

    (SID_NAME = TEST)     )

  )

# TNSNAMES.ORA Network Configuration File: C:\oracle\ora90\network\admin\tnsnames.ora

# Generated by Oracle configuration tools.

TEST =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = Q4E60KISR45DQ77)(PORT = 1521))     )

    (CONNECT_DATA =       (SERVICE_NAME = TEST.NHEMS.DB)     )

  )

TEST.NHEMS.DB =   (DESCRIPTION =     (ADDRESS_LIST =       (ADDRESS = (PROTOCOL = TCP)(HOST = Q4E60KISR45DQ77)(PORT = 1521))     )

    (CONNECT_DATA = (SID = TEST))   )

# SQLNET.ORA Network Configuration File: C:\oracle\ora90\network\admin\sqlnet.ora

# Generated by Oracle configuration tools.

NAMES.DEFAULT_DOMAIN = TEST.NHEMS.DB NAMES.DIRECTORY_PATH= (TNSNAMES) Can anyone point out any inconsistences
within these files that might help clear up my problem. Appreciate it. If you need more info, please ask...
Bill Received on Sat Mar 30 2002 - 17:57:59 CST