Re: MTS not workin ??

ibrahim.dogan_at_lowes.com (Ibrahim DOGAN) writes:

> VERSION
> -----------------
> 8.1.7.0.0

> irm2:/home/oracle/network/admin-> lsnrctl services
>
> LSNRCTL for IBM/AIX RISC System/6000:
> Version 8.1.7.0.0 - Production on 20-AUG-2003 10:45:33
>
> (c) Copyright 1998 Oracle Corporation. All rights reserved.
>
> Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=irm2)(PORT=1521))
> Services Summary...
> PRACTICE has 1 service handler(s)
> DEDICATED SERVER established:1 refused:0
> LOCAL SERVER
> The command completed successfully
> -------------

Hmh ..., lsnrctl should show us a dispatcher entry as follows:

,----

|   first         has 4 service handler(s)
|     DEDICATED SERVER established:0 refused:0
|       LOCAL SERVER
|     DISPATCHER established:0 refused:0 current:0 max:254 state:ready
|       D002 <machine: eos, pid: 3309>
|       (ADDRESS=(PROTOCOL=tcp)(HOST=eos)(PORT=32832))
|     DISPATCHER established:0 refused:0 current:0 max:254 state:ready
|       D001 <machine: eos, pid: 3307>
|       (ADDRESS=(PROTOCOL=tcp)(HOST=eos)(PORT=32831))
|     DISPATCHER established:0 refused:0 current:0 max:254 state:ready
|       D000 <machine: eos, pid: 3305>
|       (ADDRESS=(PROTOCOL=tcp)(HOST=eos)(PORT=32829))

> NAME VALUE
> ~~~~~~~~~~~~~~~~~~~~ ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
> mts_dispatchers (PROTOCOL=TCP)(DISPATCHERS=3)
> mts_servers 5
> mts_max_servers 20
> mts_max_dispatchers 5
> mts_sessions 33
> mts_circuits 38
> mts_service PRACTICE
> mts_listener_address [NULL]
> mts_multiple_listeners FALSE

Looks good for me. What tells you your alert_*.log file. I get the following line by specifying mts_dispatchers:

,----
| starting up 3 dispatcher(s) for network address | '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... `----

Maybe you will find there additional hints.

Harald Received on Wed Aug 20 2003 - 11:19:16 CDT