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

On 12 Mar 2002 09:47:47 -0800, timasmith_at_hotmail.com (Tim Smith) wrote:

>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

host = mybox on the server doesn't match 90.0.0.1 on the client

hth

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Tue Mar 12 2002 - 13:19:32 CST