Chapter 12: Managing Oracle Database Software

This chapter describes how to keep your Oracle software up-to-date with patch releases.

Approximately 1 hour

Topics

This tutorial covers the following topics:

Place the cursor over this icon to load and view all the screenshots for this tutorial. (Caution: This action loads all screenshots simultaneously, so response time may be slow depending on your Internet connection.)

Note: Alternatively, you can place the cursor over an individual icon in the following steps to load and view only the screenshot associated with that step. You can hide an individual screenshot by clicking it.

Before you perform this tutorial, you should:

1.

Complete Chapter 2: Installing Oracle Software and Building the Database OBE

2.

Complete Chapter 3: Getting Started with Oracle Enterprise Manager OBE

3.

Complete Chapter 4: Configuring the Network Environment OBE

4.

Complete Chapter 5: Managing the Oracle Instance OBE

5.

Complete Chapter 6: Managing Database Storage Structures OBE

6.

Complete Chapter 7: Administering Users and Security OBE

7.

Complete Chapter 8: Managing Schema Objects OBE

8.

Complete Chapter 9: Performing Backup and Recovery OBE

9.

Complete Chapter 10: Monitoring and Tuning the Database OBE

Back to Topic List

Determining Your Oracle Software Environment

To select the appropriate patch for your environment, determine the following:

What version of the Oracle Database software are you using?
What is your Oracle Home location?
What is your hardware configuration?

1.

You can determine your Oracle database version by navigating to the Enterprise Manager Database Home page. The version is listed under the General section.

 

2.

The Oracle Home is the operating system location of your Oracle installation. To determine this location, click View All Properties.

 

3.

The Oracle Home is listed on the View All Properties page. Click the Oracle Home link.

 

4.

The Oracle Home directory page is displayed. On this page, you can view the file directory of your Oracle home, along with the installed product components and time of installation. Return back to the home page by clicking the Database tab.

 

5.

Click the host link to access information about your hardware configuration.

 

6.

The Host page appears listing your operating system, hardware platform, IP address, number of CPUs, memory size and disk space. Note your operating system and platform. Click Database to return to your Database Home page.

 

Back to Topic List

Setting Your My Oracle Support Login Credentials

You can configure your My Oracle Support Login Credentials in Enterprise Manager as follows:

1.

Click Setup on your Database Home page.

 

2.

The Setup page is displayed. Click Patching Setup to access the Patching Setup page.

 

3.

Enter your own My Oracle Support (formerly MetaLink) username and password. Click Apply.

 

4.

Your My Oracle Support credentials have been successfully set up.

Click Database to return to your Database Home page.

 

Back to Topic List

Configuring the Software Library

You must configure the software library before you can stage or apply patches as follows:

1.

Click the Software and Support tab.

 

2.

In the Deployment Procedure Manager section, click the Deployment and Provisioning Software Library link.

 

3.

The Provisioning page appears. Click the link for the Administration subpage.

 

4.

Scroll down to the Software Library Configuration section. Click Add.

 

5.

The Add Software Library Location page appears. In the Software Library directory location field, enter the name of the directory where the patches are stored (/home/oracle for example).Click OK.

 

6.

You receive a confirmation message. Click the Database link to return to the Database Home page.

 

 

Back to Topic List

Staging and Applying Patches and Patch Sets

In this section you learn how to download or stage patches. You also learn how to apply a staged patch.

Perform the steps listed below to stage and apply a patch:

1.

Access the Software and Support page. Click Apply Patch in the Database Software Patching section.

 

2.

The Select Patches page appears. Click Add Patches to search for new patches.

 

3.

The Search and Select Patches page appears. Select Search My Oracle Support. Click Go.

 

4.

Available patches appear in the table at the bottom of the page. Optionally, click View to view the patch details. Note that the list of available patches you see may differ from our example.

 

5.

To invoke the Patching wizard, select the patch and click Select in the upper right section of the Search and Select Patches page.

 

6.

Ensure that the patch you have selected appears in the Patches table and click Next.

 

7.

The Credentials and Schedule page appears. Enter the credentials for the operating system user or select Use Preferred if you have configured Preferred Credentials. Review the Schedule information and modify as necessary. Click Next.

 

8.

The Review page appears. Review the infromation on this page and click Back to return to previous pages to make changes. Note the Enterprise Manager Database Control warning at the bottom of the page. Select "Select the check box to accept this warning and continue" after reviewing the warning information.

 

9.

The Review page is refreshed and the Finish button is available. Click Finish to submit the patching job.

 

10.

The Deployment Procedure Manager page appears. Click the link in the Run column to view the progress of the patching operation..

 

11.

The Status page appears containing information about the steps being executed. If any of the steps
has a status of Failed, you can click on the name of the step to drill down to information explaining the cause of the failure.

 

12.

As part of the patching procedure, the database instance and Enterprise Manager Database Control are shut down and restarted. You must log in to Enterprise Manager Database Control once it has restarted. Navigate to the Procedure Completion Status page to check the status of the patching procedure.

 

Back to Topic List

In this tutorial, you learned how to:

Determine your Oracle environment, including software version, file location, and hardware configuration.
Set the environment for staging a patch.
Applying a patch.

Back to Topic List

Place the cursor over this icon to hide all screenshots.