Hai
I have configured MTS .My INIT.ORA and tnsnames.ora file configurations are
given below.




Parameters added for MTS in INIT.ora File
=========================================

MTS_DISPATCHERS="(PROTOCOL=TCP)(DISPATCHERS=4)(CON NECTIONS=250) \
(MOHAN=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(PORT= 1528)(HOST=mohan-2k))))"

MTS_MAX_DISPATCHERS =16
MTS_SERVERS =2
MTS_MAX_SERVERS =10


I connected to shared server where oracle database resides ,but unable to connecting from client
via net8

example:
========
when creating service name like MTS_M with shared server and hostname=mohan-2k,port no=1528 via

Net8 on client machine i got the below message


If select oracle8i service name in net 8
================================ ========
Attempting to connect using userid: system
The test did not succeed.
ORA-12520: TNS:listener could not find available handler for requested type of server

There may be an error in the fields entered,
or the server may not be ready for a connection.




If select (oracle 8 or previous) SID in net 8:
==============================================
Initializing first test to use userid: scott, password: tiger
Attempting to connect using userid: scott
The test did not succeed.
ORA-12519: TNS:no appropriate service handler found

There may be an error in the fields entered,
or the server may not be ready for a connection.


At server where oracle database resides i had the below query that indicates my database is

shared server mode

sql> conn system/manager_m@demo;
connected.



SQL> select server,username,status from v$session;


SERVER USERNAME STATUS
--------- ------------------------------ --------
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE
DEDICATED ACTIVE

SERVER USERNAME STATUS
--------- ------------------------------ --------
SHARED SYSTEM ACTIVE

12 rows selected.



afterthat i had execute the below query,but the network status showing "wait"


SQL> SELECT NETWORK,STATUS FROM V$DISPATCHER;

NETWORK
-------------------------------------------------------------------------

STATUS
----------------
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1104))
WAIT

(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1105))
WAIT

(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1106))
WAIT


NETWORK
-------------------------------------------------------------------------

STATUS
----------------
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1107))
WAIT



This is my LISTENERS STATUS
===========================:


Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\>LSNRCTL

LSNRCTL for 32-bit Windows: Version 8.1.6.0.0 - Production on 08-MAY-2003 10:15:
20

(c) Copyright 1998, 1999, Oracle Corporation. All rights reserved.

Welcome to LSNRCTL, type "help" for information.

LSNRCTL> START MOHAN
Starting tnslsnr: please wait...

TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Production
System parameter file is D:\Oracle\Ora81\network\admin\listener.ora
Log messages written to D:\Oracle\Ora81\network\log\mohan.log
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(P
ORT=1528)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mohan-2k)(PORT=1528)))
STATUS of the LISTENER
------------------------
Alias MOHAN
Version TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Produc
tion
Start Date 08-MAY-2003 10:15:26
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File D:\Oracle\Ora81\network\admin\listener.ora
Listener Log File D:\Oracle\Ora81\network\log\mohan.log
Services Summary...
DEMO has 1 service handler(s)
The command completed successfully


LSNRCTL> status LISTENER
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mohan-2k)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias LISTENER
Version TNSLSNR for 32-bit Windows: Version 8.1.6.0.0 - Produc
tion
Start Date 08-MAY-2003 10:21:13
Uptime 0 days 0 hr. 4 min. 10 sec
Trace Level off
Security OFF
SNMP OFF
Listener Parameter File D:\Oracle\Ora81\network\admin\listener.ora
Listener Log File D:\Oracle\Ora81\network\log\listener.log
Services Summary...
demo has 5 service handler(s)
The command completed successfully
LSNRCTL>


LSNRCTL> SERVICES MOHAN
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mohan-2k)(PORT=1528)))
Services Summary...
DEMO has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
The command completed successfully
LSNRCTL> SERVICES
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mohan-2k)(PORT=1521)))
Services Summary...
demo has 1 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
The command completed successfully





LSNRCTL> SERVICES LISTENER
Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=mohan-2k)(PORT=1521)))
Services Summary...
demo has 5 service handler(s)
DEDICATED SERVER established:0 refused:0
LOCAL SERVER
DISPATCHER established:1 refused:0 current:1 max:250 state:ready
D003 <machine: MOHAN-2K, pid: 1560>
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1107))
DISPATCHER established:1 refused:0 current:1 max:250 state:ready
D002 <machine: MOHAN-2K, pid: 1556>
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1106))
DISPATCHER established:0 refused:0 current:0 max:250 state:ready
D001 <machine: MOHAN-2K, pid: 1552>
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1105))
DISPATCHER established:0 refused:0 current:0 max:250 state:ready
D000 <machine: MOHAN-2K, pid: 1548>
(ADDRESS=(PROTOCOL=tcp)(HOST=mohan-2k.nirbeeja.com)(PORT=1104))
The command completed successfully




Please any one where i made mistake.It Should be greatful shall i get need full solution

Thanks in advance

Mohan