Listener Problem?

From: Fender <efender_at_ix.netcom.com>
Date: Tue, 8 Feb 2000 15:31:16 -0500
Message-ID: <87puf4$hu3$1@nntp4.atl.mindspring.net>

After making a couple successful connections with the Enterprise Management Tools, or anything else for that matter, all subsequent connections fail with an "ORA-12545: Connect failed because target host or object does not exist." If I restart listener with a "lsnrctl stop" "lsnrctl start" then I can make more connections, up to 4, then I have stop restart the listener again. Oracle 8i 8.1.5, HP-UX 11.0. Right now, this is just an inconvenience, but once we get closer to production, this could cause significant headaches. Here are my relevant .ora files. I used the db create assistant instead of creating this manually, for once. If anyone has any suggestions, they'd be appreciated.

Thanks,

Fender

initnookdb.ora

db_name = nookdb

instance_name = nookdb
service_names = nookdb
control_files =

("/u01/app/oracle/product/8.1.5/dbs/oradata/nookdb/control01.ctl", "/u02/oradata/nookdb/control02.ctl")
db_block_buffers = 8192
shared_pool_size = 178957000
large_pool_size = 58195968
java_pool_size = 20971520
log_checkpoint_interval = 10000
log_checkpoint_timeout = 1800
processes = 79
log_buffer = 163840
# audit_trail = false # if you want auditing
# timed_statistics = false # if you want timed statistics
# max_dump_file_size = 10000 # limit trace file size to 5M each

# If using private rollback segments, place lines of the following
# form in each of your instance-specific init.ora files:
# rollback_segments = (r01, r02, r03, r04)

# Global Naming -- enforce that a dblink has same name as the db it connects
to
global_names = true

# define directories to store trace and alert files

background_dump_dest = /u01/app/oracle/admin/nookdb/bdump
core_dump_dest = /u01/app/oracle/admin/nookdb/cdump
user_dump_dest = /u01/app/oracle/admin/nookdb/udump

db_block_size = 8192

remote_login_passwordfile = exclusive

os_authent_prefix = ""

mts_dispatchers = "(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)"
# Uncomment the following line when your listener is configured for SSL
# (listener.ora and sqlnet.ora)
# mts_dispatchers = "(PROTOCOL=TCPS)(PRE=oracle.aurora.server.SGiopServer)"

mts_dispatchers = "(protocol=TCP)(DISP=1)(mul=OFF)(pool=OFF)"
mts_max_dispatchers = 9
mts_servers = 1
mts_max_servers = 20

compatible = "8.1.0"

listener.ora

# LISTENER.ORA Configuration

File:/u01/app/oracle/product/8.1.5/network/admin/listener.ora
# Generated by Oracle Net8 Assistant

SAVE_CONFIG_ON_STOP_LISTENER = TRUE USE_PLUG_AND_PLAY_LISTENER = ON LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =

      (ADDRESS = (PROTOCOL = IPC)(KEY = nookdb))
      (PROTOCOL_STACK =
        (PRESENTATION = TTC)
        (SESSION = NS)
      )

)
(DESCRIPTION =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 128.1.1.10)(PORT = 1521))
      (PROTOCOL_STACK =
        (PRESENTATION = TTC)
        (SESSION = NS)
      )

)
)

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =

      (GLOBAL_DBNAME = nookdb)
      (ORACLE_HOME = /u01/app/oracle/product/8.1.5)
      (SID_NAME = nookdb)

)
)

sqlnet.ora

# SQLNET.ORA Configuration

File:/u01/app/oracle/product/8.1.5/network/admin/sqlnet.ora
# Generated by Oracle Net8 Assistant

SQLNET.EXPIRE_TIME = 1 NAMES.MAX_OPEN_CONNECTIONS = 5

tnsnames.ora

# TNSNAMES.ORA Configuration

File:/u01/app/oracle/product/8.1.5/network/admin/tnsnames.ora
# Generated by Oracle Net8 Assistant

NOOKDB =
  (DESCRIPTION =
    (SOURCE_ROUTE = OFF)
    (ADDRESS_LIST =

      (ADDRESS = (PROTOCOL = TCP)(HOST = 128.1.1.10)(PORT = 1521))
      (ADDRESS = (PROTOCOL = IPC)(Key = nookdb))

)
(CONNECT_DATA =

      (SID = nookdb)
      (ORACLE_HOME = /u01/app/oracle/product/8.1.5)

)
) Received on Tue Feb 08 2000 - 14:31:16 CST