Re: Cannot connect to a db that is running Oracle8i 8.1.7.4

Jeffrey Yee wrote:

>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
>
>Copyright (c) 1997 Oracle Corporation. All rights reserved.
>
>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
>
>

My guess is that SQLNET.ORA on this database has a domain name or other entry that requires
that your TNSNAMES.ORA contain something like abc.<domain_name> to make the connection.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)