1

I have Windows Server 2008 R2 with Oracle Client 11.1.0.7.0 client installed. TNSPing to 100% available databases (accessible from other machines, i.e. I can do TNS ping to these databases from other machines) returns me following error: TNS-12535: TNS:operation timeout. At the same time I can telnet to database host/port and see that proper tnsnames file is being used. Environment variables are configured as appropriate (ORACLE_HOME, TNS_ADMIN, Path). Also I can connect via telnet using service/host name + port - so this is unlikely a firewall issue.

After enabling Oracle client logging I can see following error related details in tnsping.trc:

snlinGetAddrInfo: enrty
snlinGetAddrInfo: getaddrinfo() failed with error 11001
snlinGetAddrInfo: exit



The only strange/suspicious thing about this machine is that it had multiple versions of oracle client installed (10, 11.1, 11.2) - removal of all versions apart from 11.1 & reinstall/repair of 11.1 haven't resolved this issue. Also it seems to me that v10 of client was not removed properly - it disappeared from Programs and Features, but files in installation folder had not been deleted.

Any advice on what to check / how to resolve this issue?

Improve this question
6
  • What is the status of the listener?
    – Andrew Brennan
    Commented Apr 15, 2014 at 15:27
  • Not sure how to check this. This is on a client side? I can't find lsnrctl.exe in my client folder... Please provide more details on how to check this if possible.
    – Mike
    Commented Apr 15, 2014 at 15:41
  • Though I guess listener is a server side thing and the fact that I capable to do TNSPing to the same database from another machine(s) confirms that listener status is OK.
    – Mike
    Commented Apr 15, 2014 at 15:47
  • If you can connect from another machine then you need to say that in your question. It is very important info.
    – Andrew Brennan
    Commented Apr 16, 2014 at 12:54
  • 1
    Being able to tnsping doesn't rule out a firewall problem. When you actually establish a real connection with a client the connection gets handed off and a random return TCP port is assigned. I've seen it cause firewall issues in the past
    – Philᵀᴹ
    Commented Apr 23, 2014 at 23:32

3 Answers 3

Reset to default
1

I know it is too late for the OP but here some advice to tackle such a problem:

The error message says that the clients sends but does not get a response. Most of the time it is a firewall problem.

  1. The windows getaddrinfo function is described here. Error number 11001 is WSAHOST_NOT_FOUND and is described here:

    Host not found.
    No such host is known. The name is not an official host name or alias, or it cannot be found in the database(s) being queried. This error may also be returned for protocol and service queries, and means that the specified name could not be found in the relevant database.

    Linux/Unix error numbers can found in the appropriate header files.

  2. I don't know if that windows error message is is the reason for your error. Even if you can access the listener port with telnet that does not mean that there is no firewall problem. I you used share servers or an oracle RAC with a scan listener the database will try to connect to a server by a different prot that can be blocked by a firewall.

  3. TNS ping does only contact the listner. So first you should check if the tnsping arrives at the server. Can you see it in the listner.log file? Check if you use the right tnsname.ora file by adding the connect string with a completely new tns-name and do a tnsping to this new tns-name. Do you get the same error message?

  4. If you want to remove all your Oracle installations on a windows server you can do that by hand. Remove all the directories and registry entries. Look for appropriate advice.

Improve this answer
0

You could try following this http://www.oracle-base.com/articles/misc/manual-oracle-uninstall.php guide. Worked for me in the past (sometimes).

Other than that you, if you have access to the computer running the DB you could try checking the logs there (see 2nd post https://community.oracle.com/thread/913826) if there is anything going in from your pc.

lsnrctl.exe is a server-component used to control the TNSlistener .

Improve this answer
0
0

connect to the database machine and check if the firewall is disabled,if not diasble the firewall using the below command as root user

service iptables status(used to check the firewall status) service iptables stop(used to disable the firewall)

Improve this answer

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.