Skip to main content
ExLibris

Knowledge Assistant

BETA
  • Subscribe by RSS
  • Back
    Aleph

     

    Ex Libris Knowledge Center
    1. Search site
      Go back to previous article
      1. Sign in
        • Sign in
        • Forgot password
    1. Home
    2. Aleph
    3. Knowledge Articles
    4. Command to show me Oracle Critical Patch Updates on server

    Command to show me Oracle Critical Patch Updates on server

    1. Last updated
    2. Save as PDF
    3. Share
      1. Share
      2. Tweet
      3. Share
    1. Additional Information
    • Article Type: General
    • Product: Aleph
    • Product Version: 20

    Description:
    Is there a command which will show me what Oracle Critical Patch Updates are present on a server?

    Resolution:
    login as the oracle unix user, then:
    > sqlplus / as sysdba
    run the following in a sqlplus session:

    set line 200 pause off
    col action_time for a28
    col action for a10
    col namespace for a9
    col version for a10
    col id for 99999999
    col comments for a20
    select * from registry$history order by 1;

    Additional Information

    cpu, patch level


    • Article last edited: 10/8/2013
    View article in the Exlibris Knowledge Center
    1. Back to top
      • Command to export particular fields from all records
      • Commands for running indexing jobs from the command line.
    • Was this article helpful?

    Recommended articles

    1. Article type
      Topic
      Language
      English
      Product
      Aleph
    2. Tags
      1. 20
      2. contype:kba
      3. Prod:Aleph
      4. Type:General
    1. © Copyright 2025 Ex Libris Knowledge Center
    2. Powered by CXone Expert ®
    • Term of Use
    • Privacy Policy
    • Contact Us
    2025 Ex Libris. All rights reserved