Re: Client connect gets ORA-12545: Connect failed for Oracle 8i listener

init.ora - try commenting out mts e.g.

#mts_dispatchers = "(protocol=TCP)"

the default may cause problems

Greg

timasmith_at_hotmail.com (Tim Smith) wrote in message news:<a7234bb1.0203120947.2b7b11ef_at_posting.google.com>...
> Hi,
> I have an issue with the following, works fine on the server - here
> is what I did (TIA):
>
> 1) Oracle 8.1.7 installed on Sun server.
> There is an existing 7.3.2 installation on the server
> 2) Listener restarted by the Oracle 8i installation user
> 3) sqlplus user/pass_at_new8i succeeds as any user on the server
> 4) Client Oracle 8i installed with universal installer
> 5) Test under net8 assistant has the error:
>
> ORA-12545: Connect failed because target host or object does not exist
>
> 6) tnsping new8i or tnsping80 new8i both come back with OK
>
>
> Configuration follows, names have been changed to protect the innocent
> 7) Server listner.ora:
> LISTENER =
> (ADDRESS_LIST =
> (ADDRESS =
> (COMMUNITY = )
> (PROTOCOL = TCP)
> (HOST = mybox)
> (Port = 1521)
> )
> (ADDRESS =
> (COMMUNITY = )
> (PROTOCOL = TCP)
> (HOST = mybox)
> (Port = 1526)
> )
> )
> STARTUP_WAIT_TIME_LISTENER = 0
> CONNECT_TIMEOUT_LISTENER = 0
> TRACE_LEVEL_LISTENER = OFF
> LOG_DIRECTORY_LISTENER = /export/home/oracle
> SID_LIST_LISTENER =
> (SID_LIST =
> (SID_DESC =
> (SID_NAME = heat)
> (ORACLE_HOME = /disk/app/oracle/product/8.1.7)
> )
> )
>
> 8) winnt client tnsnames.ora
> new8i.org.com =
> (DESCRIPTION =
> (ADDRESS_LIST =
> (ADDRESS = (PROTOCOL = TCP)(HOST = 90.0.0.1)(PORT = 1521))
> )
> (CONNECT_DATA =
> (SERVICE_NAME = new8i)
> )
> )
>
> 9) client sqlnet.ora
> NAMES.DEFAULT_DOMAIN = org.com
> SQLNET.AUTHENTICATION_SERVICES= (NTS)
> NAMES.DIRECTORY_PATH= (TNSNAMES)
>
> 10) Oracle database parameter service_name = new8i
>
> Any ideas - thanks!
>
> Tim
Received on Tue Mar 19 2002 - 10:56:15 CST