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?
slightwv (䄆 Netminder)Connect With a Mentor 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.

Devinder Singh VirdiConnect With a Mentor Lead Oracle DBA TeamCommented:
There are couple of ways,
cd $ORACLE_HOME ----- if directory exists, that means its installed,
use " . oraenv " 
schwertnerConnect With a Mentor Commented:
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 ....
Never miss a deadline with

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

johnsoneConnect With a Mentor Senior 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.
yuzhConnect With a Mentor Commented:
Please have a look at the following doc: 
AnandConnect With a Mentor Commented:
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
All Courses

From novice to tech pro — start learning today.