Cannot reach remote Oracle instance using tnsping (newbie post)

From: Spin <Spin_at_invalid.com>
Date: Thu, 6 Nov 2008 14:29:59 -0500
Message-ID: <6nh0rpFlgr91U2@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
Received on Thu Nov 06 2008 - 13:29:59 CST

Original text of this message