Chapter 11: Managing Oracle 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?
Where 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 Oracle MetaLink Login Credentials

You can configure your Oracle MetaLink 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 MetaLink username and password. Click Apply.

 

4.

Your MetaLink credentials have been successfully set up.

Click Database to return to your Database Home page.

 

Back to Topic List

Staging the Patch Release

In this section you learn how to download or stage patches.

Perform the steps listed below to stage the patch release:

1.

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

 

2.

On the Search by Criteria page, input your version number and product information. Click Search.

 

3.

If there are no patches for this release, you will receive an error message.

 

Back to Topic List

Installing the Patch Release

After you have downloaded the latest patch or patch set release, you can install it. Prior to installing the patch, you should shut down your database instances, listeners, and dependent applications, and back up your current Oracle home installation. You can apply the patch by unzipping the downloaded file and running the Oracle Installer.

1.

Review the ReadMe included with the patch release for patch-specific installation instructions.

2.

Shut down all dependent applications.

 

3.

Shut down your database instances.

 

4.

Optionally, shut down the database listener.

 

5.

Shut down Enterprise Manager processes.

 

6.

Apply the patch by following the instructions in the ReadMe file.

 

7.

Restart the database instance(s).

 

8.

Start the listener if you shut it down in step 4.

 

9.

Start the Enterprise Manager processes.

10.

Start your applications and notify users.

 

 

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.