Re: Unable to use multi-threaded server (MTS)

Did you start the listener????

On Wed, 29 Oct 1997 umagsaam_at_mtgnet.de wrote:

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

Max Chern, Unix Software Engineer     |  Voice: 818-296-5014
EarthLink Network, Inc.               |  Fax:   818-296-5113
maxchern_at_earthlink.net                |  3100 New York Dr., Ste 201
http://www.earthlink.net/             |  Pasadena, CA 91107