Determine Oracle Server or Oracle Client Installation

sdruss
sdruss used Ask the Experts™
on
In my shop we have several Solaris bash shell scripts that help with database procedures/maintenance.  One of the things that we rely on, is the condition on a particular box, whether the database server software or client software is installed.  Via the script what would be a good way to determine whether I have a server or client installed on a particular Solaris box?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
David FavorFractional CTO
Distinguished Expert 2018

Commented:
Simple way will be to run the which on various executables.

If a path is returned, then the executable is installed, so you'll run which on both your client + server executables.
Senior Oracle DBA
Commented:
I don't believe that which would be a definitive answer.  That would mean it is installed and on the path.

For Solaris, I would look for the /var/opt/oracle directory.  There should be a file named oraInst.loc in that directory.  If that directory is there, then there is likely an Oracle install on the machine.  Not totally definitive, as if you know a few tricks you can put that in a different place, but it should be pretty close.

If you are using instant client instead of the full client install, it will be almost impossible to determine if it is installed or not.
Geert GOracle dba
Top Expert 2009

Commented:
I wrote a few scripts to monitor an oracle  server
part of this is the use of oracle client

after much pains, I simply copy the instant client to the same path on all my servers and refert to it
the instant client doesn't require an installation

that's the easiest way to not depend on any other items installed on a server an no need to check
off course, you need the script to use the hardcoded path of the instant client

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial