How to tell what Oracle version is installed?

[JazzGeek]

Hi All, I have 10 Unix boxes (solaris 10) with oracle on them.

However, no one knows if it's Oracle Databases, Client or Application server.

Is there some way I can tell if the Oracle Application Server is installed? How about an Oracle client?

I'm stuck! Thank you for your help!

SJ

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[cc82394]

May not be the best way, but at least to see if it's a database try:

ps -ef | grep ora
ps -ef | grep LISTENER

Hope this helps.

Patrick

 

[SantaMufasa]

JazzGeek,

When you invoke SQL*Plus and connect to an Oracle database server (regardless of whether you use the GUI SQL*Plus or the text-based SQL*Plus), it confirms both the client and the server versions in the banner heading:

SQL*Plus: Release [B][I]9.2.0.7.0[/I][/B] - Production on Sun Oct 14 08:54:53 2007

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to:
Oracle9i Enterprise Edition Release [B][I]9.2.0.4.0[/I][/B] - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.4.0 - Production

Once you are connected to the server, you can confirm server-version implementations of your software with this command:

SQL> select * from v$version;

BANNER
----------------------------------------------------------------
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 64bit Production
PL/SQL Release 9.2.0.4.0 - Production
CORE    9.2.0.3.0       Production
TNS for Solaris: Version 9.2.0.4.0 - Production
NLSRTL Version 9.2.0.4.0 - Production

SQL>

Let us know if this is useful.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]

 

[JazzGeek]

Thanks for the info. Does this also work with Oracle Application Server?

Also, what about the Oracle Client version?

Thank you again

SB

Sebastian Jazzer
MCSE 4.0 & 2000, Network+, A+, Web Developer

 

[SantaMufasa]

Does this also work with Oracle Application Server?...what about the Oracle Client version?

Notice, in my example above, that the client version is the first chunk of information to display.


Also...

One test is worth 100 expert opinions.

Mufasa
(aka Dave of Sandy, Utah, USA)
[I provide low-cost, remote Database Administration services: www.dasages.com]