Can't connect MTS from remote.

Dear all,

II have set up MTS on my environment (oracle 8.1.6.0.0), but I can’t connect through remote computers. The error is ora-12545 : target or host doesn't exists.

My init.ora regarding to MTS goes like this.

mts_dispatchers = "(PROTOCOL=TCP)(dispatchers=10)(sessions=20)"
mts_max_dispatchers = 25
mts_servers = 5
mts_max_servers = 30

I also add clause (SERVER = SHARED) on all tnsnames.ora files.

I have also tried to use 2 listener namely listener_mts which I set to port 1522, I use this especially to handle the MTS connection. So I add in my init.ora
Local_listener = mts1

And in my tnsnames.ora
mts1 =
  (DESCRIPTION =
    (ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server2000)(PORT = 1522))
    )
    (CONNECT_DATA =
(SERVICE_NAME = sheet.almi.net)
(SERVER = SHARED)

    )
  )
I still can't connect to the database with message of can't establish connection for this type of server. So I omit the (SERVER = SHARED) part. I can connect, but the connection is DEDICATED instead of MTS. I know this by querying SERVER column of V$session and there's no entry on V$circuit. V$shared_servers shows 5 entry.

Is there anyone has experience like I have? Please give me some input here. Thank you all in advance.

Regards,

Wendry.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wendry
  INET: wendry_yang_at_indo.net.id

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).