Re: Cannot reach remote Oracle instance using tnsping (newbie post)

Spin wrote:
> Gurus,
>
> I'm an Oracle newbie. I installed 10g database on one Windows server and
> 10g client on another Windows server. I have TCP/IP and Windows networking
> connectivity between these two servers. However, from the remote server I
> cannot reach the Oracle database (ORCL) on the database server. It's using
> the default port of 1521. Attached is my troubleshooting and the
> tnsnames.ora file on the remote server. Note that on the Oracle database
> server itself, I can tnsping successfully to the Orcl database.
>
> ----From Oracle client server----
>
> C:\>ping oracle1
>
> Pinging oracle1.alpha.local [192.168.1.110] with 32 bytes of data:
>
> Reply from 192.168.1.110: bytes=32 time=3ms TTL=128
> Reply from 192.168.1.110: bytes=32 time<1ms TTL=128
> Reply from 192.168.1.110: bytes=32 time<1ms TTL=128
> Reply from 192.168.1.110: bytes=32 time<1ms TTL=128
>
> Ping statistics for 192.168.1.110:
> Packets: Sent = 4, Received = 4, Lost = 0 (0% loss),
> Approximate round trip times in milli-seconds:
> Minimum = 0ms, Maximum = 3ms, Average = 0ms
>
> C:\>tnsping orcl
>
> TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on
> 06-NOV-2
> 008 14:20:20
>
> Copyright (c) 1997, 2005, Oracle. All rights reserved.
>
> Used parameter files:
> C:\oracle\product\10.2.0\client_1\network\admin\sqlnet.ora
>
> TNS-03505: Failed to resolve name
>
> ----From Oracle Database server----
>
> C:\>tnsping orcl
>
> TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on
> 06-NOV-2
> 008 14:19:48
>
> Copyright (c) 1997, 2005, Oracle. All rights reserved.
>
> Used parameter files:
> C:\oracle\product\10.2.0\db_1\network\admin\sqlnet.ora
>
>
> Used TNSNAMES adapter to resolve the alias
> Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST =
> ORACLE1.
> alpha.local)(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED)
> (SERVICE_NAME =
> orcl)))
> OK (30 msec)
>
> Thoughts?

Follow ddf's response but also, in your SQLNET.ORA file, you can trace a TNSPING as demonstrated in Morgan's Library (www.psoug.org) under NET SERVICES by setting:

tnsping.trace_directory=<Null, logfile_location> and
tnsping.trace_level=<off, admin, support, user>

-- 
Daniel A. Morgan
Oracle Ace Director & Instructor
University of Washington
damorgan_at_x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org