Cannot reach remote Oracle instance using tnsping (newbie post)

#11

Spin wrote:

Quote:

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?

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

#12

Spin wrote:

Quote:

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?

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

#13

Spin wrote:

Quote:

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?

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

#14

"ddf" <oratune (AT) msn (DOT) com> wrote

On Nov 6, 1:29 pm, "Spin" <S... (AT) invalid (DOT) com> wrote:

Quote:

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

No, I did not think to do that (that's why I said I was a newbie). But now
that I did it, everything works!!!!!!!!! U R DA MAN!!!!!!! Thanks!!!!!!

#15

"ddf" <oratune (AT) msn (DOT) com> wrote

On Nov 6, 1:29 pm, "Spin" <S... (AT) invalid (DOT) com> wrote:

Quote:

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

No, I did not think to do that (that's why I said I was a newbie). But now
that I did it, everything works!!!!!!!!! U R DA MAN!!!!!!! Thanks!!!!!!

#16

"ddf" <oratune (AT) msn (DOT) com> wrote

On Nov 6, 1:29 pm, "Spin" <S... (AT) invalid (DOT) com> wrote:

Quote:

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

No, I did not think to do that (that's why I said I was a newbie). But now
that I did it, everything works!!!!!!!!! U R DA MAN!!!!!!! Thanks!!!!!!

#17

"ddf" <oratune (AT) msn (DOT) com> wrote

On Nov 6, 1:29 pm, "Spin" <S... (AT) invalid (DOT) com> wrote:

Quote:

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

No, I did not think to do that (that's why I said I was a newbie). But now
that I did it, everything works!!!!!!!!! U R DA MAN!!!!!!! Thanks!!!!!!

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Cannot reach remote Oracle instance using tnsping (newbie post)

comp.databases.oracle.misc comp.databases.oracle.misc

Re: Cannot reach remote Oracle instance using tnsping (newbie post) - 11-06-2008 , 03:54 PM

Re: Cannot reach remote Oracle instance using tnsping (newbie post) - 11-06-2008 , 03:54 PM

Re: Cannot reach remote Oracle instance using tnsping (newbie post) - 11-06-2008 , 03:54 PM

Re: Cannot reach remote Oracle instance using tnsping (newbie post) - 11-06-2008 , 03:54 PM

Re: Cannot reach remote Oracle instance using tnsping (newbie post) - 11-06-2008 , 03:54 PM

Re: Cannot reach remote Oracle instance using tnsping (newbie post) - 11-06-2008 , 03:54 PM

Re: Cannot reach remote Oracle instance using tnsping (newbie post) - 11-06-2008 , 03:54 PM