Solved

How to check OS version from Oracle

Posted on 2008-10-13
9
2,353 Views
Last Modified: 2013-12-19
How to check OS version from Oracle prompt? (Assume we have DBA privilege)
0
Comment
Question by:sachin_dba
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
9 Comments
 
LVL 4

Accepted Solution

by:
whsum earned 250 total points
ID: 22700709
Sqlplus: select BANNER from V$VERSION
0
 
LVL 6

Assisted Solution

by:peter991
peter991 earned 250 total points
ID: 22701261
Interesting question.
I belive you are looking for a table where the OS-version is saved?
It's quite easy to find the name of the OS but to get the exact version is tricky.

Workaround:
SQL>!uname -a



0
 
LVL 6

Expert Comment

by:peter991
ID: 22702544
Thanks!
0
 
LVL 4

Expert Comment

by:whsum
ID: 22707778
Hi dvx,

Realizing now, I overlooked the question!
0
 
LVL 1

Expert Comment

by:czuriaga
ID: 22708123
Another one:

!cat /etc/redhat-release


(or cat /etc/suse-release, or whatever)
0

Featured Post

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This article started out as an Experts-Exchange question, which then grew into a quick tip to go along with an IOUG presentation for the Collaborate confernce and then later grew again into a full blown article with expanded functionality and legacy…
How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
This video shows setup options and the basic steps and syntax for duplicating (cloning) a database from one instance to another. Examples are given for duplicating to the same machine and to different machines
This video shows how to recover a database from a user managed backup

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question