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

That worked - is there a general issue with mixing MTS and dedicated across versions on the same server?

Tim

gcaulton_at_sympatico.ca (Greg Caulton) wrote in message news:<ee30ffc.0203190856.24648db5_at_posting.google.com>...
> 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 Sun Mar 24 2002 - 12:50:53 CST