Using Oracle Update Advisor in Oracle FPP Local Mode

Understand how to use the Oracle Update Advisor in Oracle FPP Local Mode to evaluate the current Oracle home and download the patched gold image.

  1. Register a user for the Oracle Update Advisor on the Oracle FPP Local Mode system.
    $ rhpctl manage updateadvisor -registeruser -ssousername abc.xyz@example.com -csinumber 18890944
    Enter user "abc.xyz@example.com" REDACTED: *****
    mbcluster-1: Audit ID: 91
    Registering user to Oracle update advisor ...
    Successfully registered user to Oracle update advisor.

    Note:

    You must specify the Customer Support Identifier (CSI) to be able to download the patched gold image.
  2. Evaluate the current patches applied to your Oracle home, generate patched image, and get recommendations for the best patching strategy from Oracle Update Advisor.
    $ rhpctl evaluate patch -path /u01/app/oracle/product/19.26.0/dbhome_1 -updatelag LATEST -generateimage
    Performing software health check for home "/u01/app/oracle/product/19.26.0/dbhome_1".
    Request to check the software health status and recommendation for the home "/u01/app/oracle/product/19.26.0/dbhome_1"
    Request id: 20055
    Check back after estimated time: "2h" using below command.
    rhpctl query patch -requestid 20055
  3. Check the request status after the estimated time.
    $ rhpctl query patch -requestid 20055
    Software health status : "RED"
    Software health comment : "More than one cycle behind your policy.."
    Software Type : "DB"   
    Current version : "19.26.0.0.0"   
    Recommended version : "19.28"
    Image is available to download. Please download it using below command. 
    rhpctl download image -requestid 20055 -downloadlocation <location>
  4. Download the patched gold image.
    $ rhpctl download image -requestid 20055 -downloadlocation /tmp
    Downloading image ...
    Downloaded "1,304,788,992" bytes so far, continuing download...
    Downloaded "2,941,796,352" bytes so far, continuing download...
    Downloaded "4,370,695,489" bytes so far, continuing download...
    Image download succesfully at location "/tmp".
  5. Patch the Oracle Database home or Oracle Grid Infrastructure home by following the steps described in Performing Patching Using Oracle FPP Local Mode.

    Note:

    When you use Oracle FPP Local Mode with Oracle Restart, you can patch the Oracle Database home but not the Oracle Grid Infrastructure (Oracle Restart) home.