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).
