RE: Can't connect MTS from remote.
Wendry, My experience with MTS is that, by default, the listener uses an MTS connection. I wonder why you are not getting that. My init.ora file looks like this: mts_dispatchers = "(ADDRESS=(PROTOCOL=TCP)(HOST=ip_address))(DISPATCHERS=5)" local_listener = "(ADDRESS=(PROTOCOL=TCP)(HOST=ip_address)(PORT=1521))" mts_max_dispatchers = 10 mts_servers = 10 mts_max_servers = 100 and my listener.ora file looks like this: Fsldbdol0a1advwtw = (DESCRIPTION_LIST= (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=IPC) (KEY=EXTPROCdbdol0a1advwtw) ) (ADDRESS= (PROTOCOL=TCP) (HOST=ip_address) (PORT=1521) ) ) ) ) Note that I do not name my databases in the listener.ora file as the databases self-register with the listener via the local_listener line in the init.ora. My tnsnames file then looks like this: WTWT = # Shared connection (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (Host=ip_address) (Port=1521) ) ) (CONNECT_DATA= (SID=WTWT) ) ) WTWT_DEDICATED = (DESCRIPTION= (ADDRESS_LIST= (ADDRESS= (PROTOCOL=TCP) (Host=ip_address) (Port=1521) ) ) (CONNECT_DATA= (SID=WTWT) (SERVER = DEDICATED) ) ) My guess is that you still have something small not quite right. Tns connections can be the most exasperating thing to deal with. The smallest detail can kill you. Good Luck Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, December 31, 2003 7:54 AM To: Multiple recipients of list ORACLE-L Thanks for the answer Stephen, I can ping and tnsping the server, in fact my connection using dedicated server is working. But when I add initialization parameter for MTS in init.ora like I have mentioned before, the connections are always fail, looks like the listener can't redirect connection to a dispatcher or the dispatcher accept and immediately disconnect connection?? Since from lsnrctl services command the number of established connection with dispatcher shows increment even though the connection is failed. Btw, I set my oracle on Windows 2000 environment. Any other ideas about the problem here? Thank you all in advance. Regards Wendry. -Original Message- Karniotis, Stephen Sent: Tuesday, December 30, 2003 9:24 PM To: Multiple recipients of list ORACLE-L Generally, 12545 means that something in the connection string for shared environments is missing, the listener.ora, tnsnames.ora and sqlnet.ora contain conflicting parameters, or the init.ora MTS parameters do not match the listener.ora. I would make sure that you can ping the server remotely and that you can TNSPING the server as well. If not, your .ORA settings are inconsistent. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Wendry Sent: Tuesday, December 30, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: 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: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE y
RE: Can't connect MTS from remote.
Thanks for the answer Stephen, I can ping and tnsping the server, in fact my connection using dedicated server is working. But when I add initialization parameter for MTS in init.ora like I have mentioned before, the connections are always fail, looks like the listener cant redirect connection to a dispatcher or the dispatcher accept and immediately disconnect connection?? Since from lsnrctl services command the number of established connection with dispatcher shows increment even though the connection is failed. Btw, I set my oracle on Windows 2000 environment. Any other ideas about the problem here? Thank you all in advance. Regards Wendry. -Original Message- Karniotis, Stephen Sent: Tuesday, December 30, 2003 9:24 PM To: Multiple recipients of list ORACLE-L Generally, 12545 means that something in the connection string for shared environments is missing, the listener.ora, tnsnames.ora and sqlnet.ora contain conflicting parameters, or the init.ora MTS parameters do not match the listener.ora. I would make sure that you can ping the server remotely and that you can TNSPING the server as well. If not, your .ORA settings are inconsistent. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Wendry Sent: Tuesday, December 30, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: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: [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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen 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). -- 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: U
RE: Can't connect MTS from remote.
Generally, 12545 means that something in the connection string for shared environments is missing, the listener.ora, tnsnames.ora and sqlnet.ora contain conflicting parameters, or the init.ora MTS parameters do not match the listener.ora. I would make sure that you can ping the server remotely and that you can TNSPING the server as well. If not, your .ORA settings are inconsistent. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (313) 227-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Wendry Sent: Tuesday, December 30, 2003 8:54 AM To: Multiple recipients of list ORACLE-L Subject: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: [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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen 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).
Can't connect MTS from remote.
Dear all, II have set up MTS on my environment (oracle 8.1.6.0.0), but I cant 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).
