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 successfullyHere 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 outI 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
Join the conversationComment
Share
Comments
Results
Contribute to the conversation