Cannot connect to a db that is running Oracle8i 8.1.7.4

From: Jeffrey Yee <jeffyee_at_hotmail.com>
Date: 12 Oct 2003 21:11:58 -0700
Message-ID: <ec4cec95.0310122011.74e4cda@posting.google.com>

Hi,

I have managed to connect to about 20 live databases, but only one database, I just cannot connect from client. Here are the steps that I took to try to connect to an Oracle8i 8.1.7.4 database.

Step 1

SQL> host ping 192.100.100.118

Pinging 192.100.100.118 with 32 bytes of data:

Reply from 192.100.100.118: bytes=32 time<10ms TTL=254
Reply from 192.100.100.118: bytes=32 time<10ms TTL=254
Reply from 192.100.100.118: bytes=32 time<10ms TTL=254
Reply from 192.100.100.118: bytes=32 time<10ms TTL=254

Ping statistics for 192.100.100.118:

Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate round trip times in milli-seconds:

Minimum = 0ms, Maximum = 0ms, Average = 0ms

Step 2

Configure the tnsnames.ora, as follow:

ABC =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = 192.100.100.118)(PORT = 1521))

    )
    (CONNECT_DATA =
      (SERVICE_NAME = abc)
    )
  )

Try the connection test, but get the following error message: ORA-12545: Connect failed because target host or object does not exist.

Step 3

Check on the listener, as follow:

LSNRCTL> status
Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.100.100.118)(PORT=1521)) STATUS of the LISTENER

Alias                     LISTENER
Version                   TNSLSNR for HPUX: Version 8.1.7.4.0 -
Production
Start Date                07-OCT-2003 01:41:03
Uptime                    6 days 10 hr. 22 min. 5 sec
Trace Level               off
Security                  OFF
SNMP                      OFF

Listener Parameter File
/u01/app/oracle/product/8.1.7/network/admin/listener.ora Listener Log File
/u01/app/oracle/product/8.1.7/network/log/listener.log Services Summary...

  ABC           has 1 service handler(s)
  ABC           has 3 service handler(s)
  minotaur              has 1 service handler(s)

The command completed successfully

From this information, I know that the host and port is correctly set in tnsnames.ora. I tried reconfiguring the tnsnames.ora to use "Oracle8 release 8.0 database or service", instead of "Oracle8i or later database or service", but I still get ORA-12545.

I tried the oracle error message manual, but it didn't help much.

Step 4

On the client machine, I did the following:

C:\ tnsping abc

TNS Ping Utility for 32-bit Windows: Version 9.2.0.1.0 - Production on 13-OCT-20
03 11:57:07

Used parameter files:
c:\oracle\ora92\network\admin\sqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.100.100.118)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = abc)))
OK (110 msec)

Step 5

The content of sqlnet.ora is as follow:

# SQLNET.ORA Network Configuration File: c:\oracle\ora92\network\admin\sqlnet.ora # Generated by Oracle configuration tools.

NAMES.DIRECTORY_PATH= (TNSNAMES) I'm totally confuse why I cannot connect to this particular database, as it's not over the firewall, and I can ping and tnsping the server & database. Can someone please do help. Thank you in advance.

Best Regards,
Jeffrey Yee Received on Sun Oct 12 2003 - 23:11:58 CDT