Unable to use multi-threaded server (MTS)

From: <umagsaam_at_mtgnet.de>
Date: 1997/10/29
Message-ID: <878129959.29203@dejanews.com>#1/1

Hi,
we are trying to work with the multi-threaded server configuration for our databases on a UNIX system and are having problems.

Here is the MTS configuration from the initaudb.ora-file (AUDB is one of our databases): mts_dispatchers = "ipc,2" mts_dispatchers = "tcp,10" mts_max_dispatchers = 15 mts_servers = 1 mts_max_servers = 10 mts_service = AUDB mts_listener_address =
"(ADDRESS=(PROTOCOL)=tcp)(port=1521)(host=mtgultra))"

The entry in our tnsnames.ora-file is:
audb.world =
(DESCRIPTION =
  (ADDRESS_LIST =
    (ADDRESS =
(COMMUNITY = )
(PROTOCOL = TCP)
(HOST = mtgultra)
(PORT = 1521)

    )
  )
  (CONNECT_DATA=(SID = audb))
)

The listener.ora-file contains the following: LISTENER =
  (ADDRESS_LIST =
    (ADDRESS =
(PROTOCOL = TCP)
(HOST=mtgultra)
(PORT=1521)

    )
  )
  SID_LIST_LISTENER =
    (SID_LIST =
(SID_DESC =

        (SID_NAME = audb)
        (ORACLE_HOME = /usr/local/oracle/app/oracle/product/7.3.2)
        (GLOBAL_DBNAME = audb)
      )

    )
.
...

During the startup of the database the following messages are written to the ALERT-file: ... starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network protocol 'ipc'... starting up 10 dispatcher(s) for network protocol 'tcp'... Tue Oct 28 23:29:48 1997 could not connect to listener address: (ADDRESS=(PROTOCOL=tcp)(port=1521)(host=MTGULTRA)) dispatcher 'D000' encountered error connecting to listener 0 Tue Oct 28 23:29:49 1997 ...

This message occurs for each dispatcher (D000,..., D010). Furthermore every two minutes after startup the message ... could not connect to listener address: (ADDRESS=(PROTOCOL=tcp)(port=1521)(host=MTGULTRA)) ...

is dumped into the ALERT-file, so it looks like this: .
...
Wed Oct 29 11:10:14 1997
could not connect to listener address:
(ADDRESS=(PROTOCOL=tcp)(port=1521)(host=MTGULTRA)) Wed Oct 29 11:12:14 1997
could not connect to listener address:
(ADDRESS=(PROTOCOL=tcp)(port=1521)(host=MTGULTRA)) Wed Oct 29 11:14:14 1997
could not connect to listener address:
(ADDRESS=(PROTOCOL=tcp)(port=1521)(host=MTGULTRA)) and so on...

And for each dispatcher a trace-file is generated with the following message: ... network address used is
(ADDRESS=(PROTOCOL=tcp)(port=1521)(host=MTGULTRA)) network error encountered connecting to listener: TNS-12564: TNS:connection refused ...

If anybody got an idea, please send me an email to umagsaam_at_mtgnet.de with suggestions.
Thanks in advance.

-------------------==== Posted via Deja News ====-----------------------
      http://www.dejanews.com/     Search, Read, Post to Usenet

Received on Wed Oct 29 1997 - 00:00:00 CST