Results 1 to 9 of 9
  1. #1
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Question Unanswered: Patches installed

    Hi.
    Is there any table/view that show the patches installed in the DB?
    Thanks!

    Manf

  2. #2
    Join Date
    Jan 2004
    Posts
    99
    selecting from the following view tells you what version your at.

  3. #3
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Originally posted by zaki_mtk
    selecting from the following view tells you what version your at.
    could you be more specific?

  4. #4
    Join Date
    Jan 2004
    Posts
    99
    my apologies I ment v$version

  5. #5
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86

    Wink

    Originally posted by zaki_mtk
    my apologies I ment v$version
    Yes, but I want to see smaller patches (I don't know how to call them)...
    For example: I have installed Ora817. Then I upgrade to 8174, that's what I see in the v$version view.

    Then, to correct some bugs I installed some patches (p1899297...), and this is what I need to see in order to confirm it's correctly installed.

    Thanks!

  6. #6
    Join Date
    Jan 2004
    Posts
    370
    If you are on Unix you can try using owhat.

    cd $ORACLE_HOME/bin
    owhat oracle

    This isn't too reliable since it depends on the developer who created the patch including this information - not all of them do it.

    It may still list some of the individual patches applied, which is better than nothing I guess.

  7. #7
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Originally posted by SkyWriter
    If you are on Unix you can try using owhat.

    cd $ORACLE_HOME/bin
    owhat oracle

    This isn't too reliable since it depends on the developer who created the patch including this information - not all of them do it.

    It may still list some of the individual patches applied, which is better than nothing I guess.
    Great! It works!
    Unfortunately Oracle guys didn't include that information in the patches I've installed...
    Thanks!!!!

    Manf

  8. #8
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    OUI shows what has been installed.

  9. #9
    Join Date
    Dec 2003
    Location
    Buenos Aires, Argentina
    Posts
    86
    Originally posted by anacedent
    OUI shows what has been installed.
    No, OUI doesn't show bugs patches.

Posting Permissions

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