Q

tnsping timing out when trying to connect

I installed Oracle 10g server on a Dell desktop. I have no trouble seeing the database instance on the server. But when I try to connect with the laptop, tnsping times out.

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)

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

Dig deeper on Oracle database installation, upgrades and patches

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

0 comments

Oldest 

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:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close