Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

How to tell what Oracle version is installed?

JazzGeek (IS/IT--Management) (OP)
12 Oct 07 10:59
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 (Programmer)
13 Oct 07 15:40
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 (TechnicalUser)
14 Oct 07 10:59
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:

CODE

SQL*Plus: Release 9.2.0.7.0 - Production on Sun Oct 14 08:54:53 2007

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


Connected to:
Oracle9i Enterprise Edition Release 9.2.0.4.0 - 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:

CODE

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.

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

JazzGeek (IS/IT--Management) (OP)
14 Oct 07 11:32
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 (TechnicalUser)
15 Oct 07 11:38

Quote (Seb):

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...

Quote (Mufasa's First Rule):

One test is worth 100 expert opinions.
smile

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

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close