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

On Nov 6, 1:29 pm, "Spin" <S..._at_invalid.com> 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?
>
> --
> Spin

Did you think to copy the same tnsnames.ora file from the server to the client, and put it in the proper location? All evidence indicates your client tnsnames.ora file does not contain an entry for orcl.

David Fitzjarrell Received on Thu Nov 06 2008 - 14:40:00 CST