Software Deployment

Hi Owen,

Sounds odd, I've not looked at the 11g client but find it hard to believe that it doesn't include the tnsping command.

Until you get to the bottom of it you could use sqlplus.exe tool to prove connectivity. tnsping responses after all only prove that there is a listener, not necessarily that the DB is up and working....

Would be interested to find out what's happened to tnsping though!

From what I've read, this is most likely due to one of two things: either Oracle client is confused about the Oracle home, or the default $ORACLE_SID isn't in TNSNAMES.ORA.

no Ian, it's a different problem. tnsping.exe doesn't exist in c:\oracle\ora11g or any subfolders. why this would be I dont' know.
tnsping was a quick way for testing database connectivity (which is all I really care about in the client install - it's the DBA's job to make sure the database is up and running)
i'll google some more today, it was late and I just wondered if anyone here encountered this..
thanks!

OK I do see references to 11g and tnsping. So....maybe you need to customize with network utils? that seems stupid though. I did the str8 out of the box runtime install, hard to believe they'd leave it out of that; if so, congratulations Oracle, you saved about 50K out of a several hundred MB installation by leaving out a very useful tool. And while I'm at it, Oracle, thank you very little for not standardizing on Windows Installer, and using java even for your windows installations. Freakin' Oracle.

OK, go it. It's actually absent. Nice one, Oracle! LOL.

I was told by a client's senior Oracle DBA that they use Java because they're wedded to the "universal" part of the Universal Installer: they can essentially take the same code and run it on any platform. "Hah!" would be my response but there you are...