Go Job Hunting at the LQ Job Marketplace
Go Back > Forums > Linux Forums > Linux - Software
User Name
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.


  Search this Thread
Old 11-23-2006, 07:15 AM   #1
Registered: Nov 2004
Location: Mumbai
Posts: 80

Rep: Reputation: 15
Getting version of oracle from root user


I have one linux / solaris box on which oralce 9i is running.

now i am in root user. By using the unix script..i need to login oracle user and need to get the ourput like as follows

SQL*Plus: Release - Production

How to get the output like this through script from the root user. I am new in unix script.
So please help me on this.

Old 11-24-2006, 12:32 AM   #2
Senior Member
Registered: Jan 2005
Location: Canada
Distribution: ubuntu
Posts: 2,539

Rep: Reputation: 59
is there a man page for the command you use for this program? check it out, most will have a -v option to show the version. if not im sure it would be in a file somewhere where the program is installed. sorry ive never used it.
Old 11-24-2006, 01:10 AM   #3
Senior Member
Registered: Dec 2005
Location: Brisbane, Australia
Distribution: Slackware64 14.0
Posts: 4,124

Rep: Reputation: 164Reputation: 164
The following works on my system (Oracle 10g):
# su - oracle -c 'ORACLE_HOME=/u01/app/oracle/product/10.2.0/db_1 /u01/app/oracle/product/10.2.0/db_1/bin/sqlplus -V' | grep Release
SQL*Plus: Release - Production


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
xhost + as user oracle not working, need to see oracle install GUI enzo250gto Linux - Software 2 02-11-2007 11:27 AM
Can only use cdrecord as root, not user (Kernal Version 2.4.31 opto Linux - Newbie 3 09-17-2006 01:05 AM
Redhat Linux version to test Oracle Application 11.5 sanjeevkchopra Linux - Software 1 08-24-2006 07:00 AM
Changing Oracle user password will affect oracle db? sathyguy Linux - Newbie 1 02-11-2006 06:34 PM
Has anyone tried installing Oracle 10g database on RH9 version (intel 386)? mdslf Linux - Software 1 03-15-2004 02:51 PM

All times are GMT -5. The time now is 11:11 AM.

Main Menu
Write for LQ is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration