verify if oracle client installed on solaris 9

Hi Experts,
How to verify if oracle client is installed and connected to any dbs on solaris.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
This is a tough one to answer. I'm not sure of a way to guarantee 100%.

This is because of the Oracle Instant Client. This is a bare-bones stripped down client with no real installer/configuration. Add that with the JDBC Thin connect string and I can't think of any single file you can look for.

That said, for the installed part, MOST products run the oracle installer and have an inventory file. I'm not on *NIX right now so I can't remember the exact name/location.

If the clients are being used, I'm not sure how to verify this one either.


Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Devinder Singh VirdiLead Oracle DBA TeamCommented:
There are couple of ways,
cd $ORACLE_HOME ----- if directory exists, that means its installed,
use " . oraenv " 
If Oracle client is connected to a DB there should be:
1. Server process of Oracle on the client side
2. Entry in the Listener.log file on the server side

Installed Oracle client has entries in the inventory file (version, date)
also installaction file (protocol of the installation) and environment variables for the 'oracle user'
like ORACLE_HOME, NLS_LANG,  entry in the PATH variable (pointing to ORACLE_HOME/bin directory.
Many delicts ....
The Ultimate Tool Kit for Technolgy Solution Provi

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy for valuable how-to assets including sample agreements, checklists, flowcharts, and more!

johnsoneSenior Oracle DBACommented:
Look in the /var/opt/oracle directory.  If that directory exists and there is an oraInst.loc file in it, then the Oracle installer was run at some point.  That would be a pretty good indication that at least the client was installed.  You really cannot install much without getting the client installed.

Of course, as slightwv said, that will not account for instant client.
Please have a look at the following doc: 
If this is for something like security investigation, theen the so called clinet will have an ip address right ?
Just lookout for this ip address in the database's listener.log. If there was some successful database connection happened from this client, one entry along with the ip address will be recorded in listener.log
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.