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 Forums!
  • 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?

Share

How to tell what Oracle version is installed?

How to tell what Oracle version is installed?

(OP)
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

RE: How to tell what Oracle version is installed?

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

RE: How to tell what Oracle version is installed?

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]

RE: How to tell what Oracle version is installed?

(OP)
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

RE: How to tell what Oracle version is installed?

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!

Resources

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