Ask the Expert

tnsping timing out when trying to connect

Greetings Maria. I installed Oracle 10g server on a Dell desktop -- the installation and database creation went without issues. I have no trouble seeing the database instance on the server. But when I try to connect with the laptop, tnsping times out. I have no problem pinging the server from the client.

Here is the lsnrctl stat output on the server:

LSNRCTL for 32-bit Windows: Version 10.2.0.2.0 - Production on
16-FEB-2007 11:46:52

Copyright (c) 1991, 2005, Oracle.  All rights reserved.

Connecting to
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=Natasha)(PORT=1521)))
STATUS of the LISTENER
------------------------
Alias                     LISTENER
Version                   TNSLSNR for 32-bit Windows: Version 10.2.0.2.0
- Production
Start Date                16-FEB-2007 10:33:43
Uptime                    0 days 1 hr. 13 min. 9 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File
C:oracleproduct10.2.0dbnetworkadminlistener.ora
Listener Log File         C:oracleproduct10.2.0dbnetworkloglistener.log
Listener Trace File
C:oracleproduct10.2.0dbnetworktracelistener.trc
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=Natasha)(PORT=1521)))
  (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\.pipeEXTPROC0ipc)))
Services Summary...
Service "PLSExtProc" has 1 instance(s).
  Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
Service "ldev" has 1 instance(s).
  Instance "ldev", status READY, has 1 handler(s) for this service...
Service "ldevXDB" has 1 instance(s).
  Instance "ldev", status READY, has 1 handler(s) for this service...
Service "ldev_XPT" has 1 instance(s).
  Instance "ldev", status READY, has 1 handler(s) for this service...
The command completed successfully
Here is the tnsping output on the client:
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on
16-FEB-2007 11:51:29

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
C:oracleproduct10.2.0clientnetworkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact 
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = natasha)(PORT = 1521))) (CONNECT _DATA = (SERVICE_NAME = ldev)))
TNS-12535: TNS:operation timed out
I am using a Netgear router WGT624 v3. The same client has no issue making a VPN connection to the outside world (true for server too).
TNS Ping Utility for 32-bit Windows: Version 10.2.0.1.0 - Production on
16-FEB-2007 11:51:57

Copyright (c) 1997, 2005, Oracle.  All rights reserved.

Used parameter files:
C:oracleproduct10.2.0clientnetworkadminsqlnet.ora

Used TNSNAMES adapter to resolve the alias Attempting to contact 
(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 10.10.101.124)(PORT = 1521))) (C ONNECT_DATA = 
(SERVICE_NAME = fheadev9))) OK (210 msec)

    Requires Free Membership to View

This error usually indicates that the TCP/IP protocol cannot resolve a host name. You may have a syntax error in your tnsnames.ora file, specifically in the ADDRESS parameters. Your tnsnames.ora file on the client you are attempting to connect from should look similar to this:
ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = server_a)(PORT = 1521))
    (CONNECT_DATA = (SERVICE_NAME = orcl)
    )
  )
Obviously, you must replace ORCL in the example above with your service name as well as the other details such as port and host. The most likely cause of this error is that the HOST name is incorrect or misspelled. If the HOST name is correct, confirm that this host exists by typing 'nslookup hostname' at the operating system command prompt. If the host does exist and your attempt to connect still fails, add the HOST name and IP address into your local hosts file and attempt to connect again. If this still fails, try replacing the HOST name in your tnsnames.ora file with the server's IP address and attempt to connect again.

If these suggestions do not resolve your problem, you should turn on Oracle Net tracing to gather further information that may assist in troubleshooting. Read the Oracle Database 10g Release 2 (10.2) Net Services Administrator's Guide.

This was first published in February 2007

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: