DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Getting the Oracle Version

  1. 09-29-2004, 10:58 AM #1
    Chintz
    Chintz is offline Member
    Join Date
    Dec 1999
    Posts
    217

    Getting the Oracle Version

    I am on a HP-UX server. How would I check the version of the Oracle Software installed? I want a detailed Version level information. I know there is a command that one can go to the $ORACLE_HOME/bin directory and type a command and that returns the version and patch level.
    Your input is highly appreciated.

    Chintz
    Reply With Quote Reply With Quote
  2. 09-29-2004, 11:37 AM #2
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    not sure if you can from command line in unix


    but select banner from v$version will get (first line)
    Reply With Quote Reply With Quote
  3. 09-29-2004, 12:55 PM #3
    Chintz
    Chintz is offline Member
    Join Date
    Dec 1999
    Posts
    217
    To query v$version, one has to log in to a database.
    The question I have is at the Oracle Software level. I know the software loaded is Oracle 8.1.7, but I want to check as to what is the patch level, is it 8.1.7.0 or 8.1.7.4?

    -Chintz
    Reply With Quote Reply With Quote
  4. 10-10-2004, 10:55 PM #4
    Felix
    Felix is offline Junior Member
    Join Date
    Sep 2000
    Location
    Singapore
    Posts
    32
    goto the oraInventory directory and there you will find logs, then open the last file and in this file you will have the information of all the compnents patched or installed with the version at its end of all components.
    Felix
    DBA
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width