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

From: Tim Smith <timasmith_at_hotmail.com>
Date: 12 Mar 2002 09:47:47 -0800
Message-ID: <a7234bb1.0203120947.2b7b11ef@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)

1. Oracle database parameter service_name = new8i

Any ideas - thanks!

Tim Received on Tue Mar 12 2002 - 11:47:47 CST