Home:ALL Converter>Can not tnsping but can sqlplus connect

Can not tnsping but can sqlplus connect

Ask Time:2013-02-01T00:32:32         Author:user1205746

Json Formatter

I have a question hopefully someone could explain it to me. I have an Oracle 11g installed properly on the server. From a workstation, I have installed the oracle client which tnsname.ora pointed to the Oracle database. I can ping to the server where oracle db was installed. I can sqlplus connect to the database and I can even connect to the database programmatically using C#. However, I can not tnsping to it. I got error Message 3511 not found when trying to do so. So my question is: in what scenario tnsping is used and how do I make tnsping works? In other word, if my tnsping does not work but I still can connect to the database programmatically using C#, what are the concerns that I should be worrying about? I am new to Oracle.. Thanks!

Author:user1205746,eproduced under the CC 4.0 BY-SA copyright license with a link to the original source and this disclaimer.
Link to original article:https://stackoverflow.com/questions/14630607/can-not-tnsping-but-can-sqlplus-connect
user1205746 :

I have tried to do the following actions without success although they are the most popular answers to similar scenario similar to mine.\n\n1) Set Oracle_Sid to my oracle sid\n2) Set Oracle_Home to my oracle home directory\n\n\nWhat I did to solve the issue:\n\n1) Uninstall oracle client\n2) Reinstall the oracle client with the newest version 11.2.xx. \n\n\nI believe, re-installing the oracle client of earlier version would just work as well. \nHowever, since I have to re-install the client, I might want to get the newest version. \nThe cause is probably improper installation at the first time as we have an disk image of pre-installed application to automatically prep a new computer. \nNot able tnsping does not seem to impede with other Oracle operations (at least not that I know of). \n\nIf someone knows what is the limitation of not able to tnsping but can sqlplus connect, ping... , I would appreciate if you could share.",
2013-02-08T18:39:03
yy