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

"Spin" <Spin_at_invalid.com> wrote in message news:6nh0rpFlgr91U2_at_mid.individual.net...
> 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
>
>

On the client what is in the tnsnames.ora file and the sqlnet.ora files Jim Received on Thu Nov 06 2008 - 15:50:22 CST