Staging and Applying Patches and Patch Sets

Applying a patch or patch set is the process of installing the staged, or locally stored, patch files in the Oracle home on the server. You must specify patching credentials before you can stage and apply a patch or patch set using Enterprise Manager.

To stage and apply patches and patch sets using the Patching wizard:

1. From the Database Home page, click Software and Support.

   The Database Instance: instance_name page appears.

2. In the Database Software Patching section, select Apply Patch.

   The Select Patches page appears.

3. Click Add Patches to search for new patches to apply.

   The Search and Select Patches page appears.

4. Choose the option Search My Oracle Support. In the Search section, accepts the default values for Product Family, Product, Release, and Patch Type. From the Platform list choose the name that matches your installed operating system, for example, Linux x86. After you have made your selections, click Go.

   You can optionally limit your search further by choosing different values for Product Family, Product, Patch Type, and Language, and then clicking Go.

   The available patches table at the bottom of the page is populated with the patches that satisfy your search criteria.

5. (Optional) Select a patch or patch set and click View to view the patch details.

   
   Description of the illustration patch_select2.gif
   
   

6. Select a patch or patch set and start the Patching wizard by clicking Select in the top right corner of the page.

   The first page of the Patching wizard, the Select Patches page, appears.

7. If the patch or patch set you selected in Step 6 does not appear in the Patches table, then click Add Patch and repeat the search to locate the patch. When the patch or patch set you have selected is displayed in the Patches table, click Next.

   The Credentials and Schedule page appears.

8. Enter the credentials for the operating system user that is performing the patching operation. If you have configured Preferred Credentials, then you can choose the Use Preferred option.

   For the Schedule Type option, use the default value of One Time (Immediately). Optionally, you can choose to schedule the patching for a later time using the One Time (Later) option. Click Next to continue.

   The Review page appears.

9. Review the information on this page. If any of the information is incorrect, then you can click Back to return to a previous page and make corrections.

10. At the bottom of this page is a warning regarding the behavior of Enterprise Manager Database Control during the patching operation. Read this warning, and then select the option Select the check box to accept this warning and continue. Until you select this option, the Finish button is disabled.

    After you accept the warning option, click Finish to submit the job that patches the database.

    The Deployment Procedure Manager page appears.

11. To view the progress of the recently submitted patching operation, click the link in the Run column, PATCH_STANDALONE_ORACLE_DB_SYS_2009-06-19_08-13-54.

    The Procedure Completion Status page appears, which contains information about the procedure being run, the steps involved, the completion status of each step, the job details, and the OMS log for this procedure.

    As part of the patching procedure, the database instance and Database Control are shut down and then restarted. After they have restarted, you must log in again and navigate to the Procedure Completion Status page to check the status.

12. (Optional) After you have reviewed the status of each step, you can click Refresh to update the display if the procedure has not yet completed. If any of the steps has a status of Failed, you can click the name of the Step, for example Stage Patches, to drill down to information explaining the cause of the failure.

    When you have finished viewing the results, click Done.

    You are returned to the Deployment Procedure Manager: Procedure Completion Status page.

13. Click the Database tab to return to the Database Home page.