How to check Oracle version on HP-UNIX?


 
Thread Tools Search this Thread
Operating Systems HP-UX How to check Oracle version on HP-UNIX?
# 1  
Old 12-04-2013
How to check Oracle version on HP-UNIX?

Dear Gurus,

I am totally new to HP-UNIX.
Can you please help me that how can i check the detail version of Oracle on HP-UNIX.

My administrator give me command for linux as below.

select * from v$version;
(Login to the database using Sql*Plus and connect as Sys user.)

Please see attached file which is for Linux.
I required same result in HP-UNIX.

Please help me thanks.

Thanks
Adeel Imtiaz
How to check Oracle version on HP-UNIX?-linuxjpg
# 2  
Old 12-04-2013
Look carefully at the messages displayed just after the login prompt. You get the release number displayed clearly on the line after "Connected to:"

The output from your select looks pretty conclusive too. They all agree. What do you think you are missing?

Robin
# 3  
Old 12-04-2013
Dear Robin,

These screenshorts are from LINUX . I need to check the Oracle version on HP-UNIX.

Just need to know that is these commands will run on HP-UNIX just to verify the ORACLE version.

OR

There are some other commands Please confirm. Thanks

Adeel Imtiaz
# 4  
Old 12-04-2013
These are Oracle commands, so they will be the same whatever OS is running the database. You could even use them from a remote desktop (Windows even) if you wish. Open the connection to the database and you should see the appropriate output.



Robin
Login or Register to Ask a Question

Previous Thread | Next Thread

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

Finding Oracle form Version UNIX

I'm trying to find the version of the underlying Oracle forms from out Unix Server. I have tried frmcmp.sh -h but I get the error frmcmp.sh -h : not found Its a Unix Sun server running an oracle database Any ideas? (1 Reply)
Discussion started by: dbajtr
1 Replies

2. Shell Programming and Scripting

Check for the bit version of OS

Hi , Is there a command that i can use to check the bit version of the OS. I have a script that i need to run on all the unix flavors so how do i check for the condition say something like this if( 32 bit) { execute this } else { execute this (4 Replies)
Discussion started by: tcsprak
4 Replies

3. Solaris

Migrate unix version 8 to version 9

i have a program writing in PRO C which currently running in unix version 8 tie with oracle 8i, but in the future company gonna migrate this OS to version 9. Anything i have to prepare for my PRO C program to run in unix version 9? or anything would that impact my program couldn't run well? what... (2 Replies)
Discussion started by: lsy
2 Replies

4. Solaris

How to check version of Solaris?

Hi All, Looks a foolish question, but please can someone tell me the command to check version of Solaris OS? Thanks, Am (5 Replies)
Discussion started by: am_yadav
5 Replies

5. Solaris

Check version of Oracle

Hi All, Please advice me how i can check the Oracle version on my UNIX Solaris machine without logging in to oracle? Thanks, Am (1 Reply)
Discussion started by: am_yadav
1 Replies

6. Solaris

solaris oracle version

can i know what is the command to check the oracle version from sun solaris9 ? by the way can i know the command to check the processor type from sun solaris ? (2 Replies)
Discussion started by: Farbegas
2 Replies

7. UNIX for Dummies Questions & Answers

2 oracle version in unix application server

Hi, Ive got to 2 Oracle Versions in the application server. Currently running on 8.0.5, and I've recently installed 8.1.7. I would like to ask if it is possible upon restarting the server, to set the default environment to be pointing to 8.1.7 instead of 8.0.5? thnks (1 Reply)
Discussion started by: lucy
1 Replies

8. HP-UX

Oracle version in HP-UX

Hi How can a see Oracle Version and corresponding patch installed in HP-UX? When i use swlist or SAM i can't see it. Regards Gege (1 Reply)
Discussion started by: cgege
1 Replies

9. Programming

to check version to library

how to check the version of Library version of Program & version of file. while compile pro*c program, I got error like elf error: no string table if u have any suggestion then give me urgently. (1 Reply)
Discussion started by: dilipluhar
1 Replies
Login or Register to Ask a Question