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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).