OraFAQ Forum: Unix » How to determine Oracle versions

Home » Infrastructure » Unix » How to determine Oracle versions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

How to determine Oracle versions [message #97679]

Thu, 07 November 2002 08:07

Brian
Messages: 38
Registered: October 1999

Member

Hello,

I would like to write a version detection script to
find out the Oracle versions installed on a lot of
UNIX systems.

How do I determine what versions of Oracle are installed
on a particular system (for this example, assume AIX).

I know that /etc/oraInst.loc exists, and points me to
another directory, but I would like some help to
determine a list of installed Oracle versions on an
AIX system and if there is a way to determine the
versions programmatically.

Thanks in advance.

Report message to a moderator

Re: How to determine Oracle versions [message #97686 is a reply to message #97679]

Tue, 12 November 2002 07:24

Sanjay
Messages: 236
Registered: July 2000

Senior Member

SQL> select version from v$instance;

VERSION
-----------------
8.1.7.4.0

or at the command prompt do

% $ORACLE_HOME/bin/svrmgrl command=exit | grep "Release"

Oracle Server Manager Release 3.1.7.0.0 - Production
Oracle8i Enterprise Edition Release 8.1.7.4.0 - 64bit Production
JServer Release 8.1.7.4.0 - 64bit Production

The 2nd entry is what you are interested in I beleive...or even better, use a different grep.

Good luck.

Report message to a moderator