Patch level for Database!
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 6 of 6

Thread: Patch level for Database!

  1. #1
    Join Date
    Apr 2005
    Posts
    19

    Patch level for Database!

    Hi All,

    I would like to know is there a way to determine Patch level for Database...

    We are on 9.2.0.5...with OS Sun Solaris/Linux/IBM AIX...
    Thank You for your time,

    Regards,
    a1_win

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    you already said your patch level? 9.2.0.5

  3. #3
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    You can always check the dba_registry to check the database patch...
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  4. #4
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    Quote Originally Posted by a1_win
    Hi All,

    I would like to know is there a way to determine Patch level for Database...
    Which patch are you talking about just database patch or E-business suite patch levels for the database?
    "What is past is PROLOGUE"

  5. #5
    Join Date
    Nov 2005
    Location
    Indianapolis
    Posts
    24

    Look at v$version

    Just log in to the database and select * from v$version.

    Hope that was what you were looking for.

  6. #6
    Join Date
    Jul 2000
    Posts
    147
    Try

    ./opatch lsinventory

    This will only work if you have OPatch install.
    Last edited by dba_dada; 11-04-2005 at 09:53 AM.

Posting Permissions

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



Click Here to Expand Forum to Full Width