Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Cannot connect to a db that is running Oracle8i 8.1.7.4

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

From: Jack Wang <nospam_at_nospam.com>
Date: Mon, 13 Oct 2003 07:18:52 GMT
Message-ID: <wlsib.13653$Pe5.11810@edtnps84>


Does target database start? Can you connect locally without listener?

"Jeffrey Yee" <jeffyee_at_hotmail.com> wrote in message news:ec4cec95.0310122011.74e4cda_at_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
>
> 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
Received on Mon Oct 13 2003 - 02:18:52 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US