Re: Verify Oracle Client version by checking OS files?

On Tue, 16 Mar 2004, Mladen Gogala wrote:

> One dirty trick would be to execute the following command:
> strings $ORACLE_HOME/bin/oracle|grep "XML Schema Processor version"

Some client installs don't have an Oracle binary, just a client library shared object. A similar method to the above for client-only installs would be:

strings $ORACLE_HOME/lib/libclntsh.so | grep '^Version [0-9]'

One challenge is that even if you find all copies of libclntsh.so on a host, there is no guarantee that they are each part of a complete install. The only real way to make sure is to try using each one (set ORACLE_HOME & LD_LIBRARY_PATH) Each install that has been completed to installer standard should have a line in the file /etc/oraInst.loc that says where the oraInventory(s) are located on the host. IIRC, Opatch.pl has some code you could probably crib to query any given oraInventory.

Of course, the existence of an oraInventory that says there is a client install somewhere does not guarantee that one exists and works.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton



>

>

> On 03/16/2004 11:56:26 AM, "Magaliff, Bill" wrote:

> >

> > Does anyone know of a way to verify which version of the client is installed

> > (on Unix/Linux, primarily) by checking one or more OS files? Trying to

> > automate an app install and need to validate Oracle version without querying

> > the database.

----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------