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\sq lnet.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 Nov 6, 1:29*pm, "Spin" <S... (AT) invalid (DOT) com> wrote:
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

On Nov 6, 1:29*pm, "Spin" <S... (AT) invalid (DOT) com> wrote:
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

On Nov 6, 1:29*pm, "Spin" <S... (AT) invalid (DOT) com> wrote:
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

On Nov 6, 1:29*pm, "Spin" <S... (AT) invalid (DOT) com> wrote:
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

"Spin" <Spin (AT) invalid (DOT) com> wrote

Jim

"Spin" <Spin (AT) invalid (DOT) com> wrote

Jim

"Spin" <Spin (AT) invalid (DOT) com> wrote

Jim

"Spin" <Spin (AT) invalid (DOT) com> wrote

Jim

Spin wrote:
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@x.washington.edu (replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org