2011-07-11

This is my experience with the Patch 12311357 – 11.2.0.2.2 Patch Set Update Standalone grid infrastructure.

In my precedent post, article I have shown how to apply the Patch 12311357 in RAC environment.

1- Backup the database:

First of all, it-s recommended to backup your database with RMAN.

2- Update the Opatch version;

Make sure you have updated the Opatch with the latest version.

You can find the latest version in MOS document ID: 6880880

As grid user:

3- OCM Configuration:

4- Validation of Oracle Inventory

Before beginning patch application, check the consistency of inventory information for GI home and the database home to be patched. Run the following command as respective Oracle home owner to check the consistency.

5- Patch Grid home:

You can have the following issue if you try this command:

as a root user:

issue:

To fix the issue:

Now, run again the same command to patch the grid infrastructure home:

As a root user:

6- Patch Oracle database home:

Make a copy of the OPatch directory.

As oracle user:

Create the Oracle configuration file:

As root user:

As Oracle user:

Make sure the database instance is down;

You may face the following error, when you try to patch the Oracle database home

As Oracle user:

To fix the issue, you should run the following command:

AS Oracle user:

6- Mutex Patch:

You may face the following issue:

As a grid user:

To fix the issue, you need to stop Oracle Restart.

As a grid user:

Now mutex patch for database home:

As oracle user:

7- Test:

Assure that the important resources are ONLINE:

As a root user, reboot the server to check:

init 6

Check with grid user if the resources are ONLINE after server reboot;

As a grid user:

Hope it helps,

Wissem

Show more