Oracle Critical Patch Update – July 2007

Last Friday, on a test box, I installed the July 2007 – Oracle Critical Patch Update.

The target database is a 10.2.0.3 running on Oracle Enterprise Linux 4. No CPU has yet been installed on this database.

I went through the following error while installing the CPU:

[oracle@orcltest 6079591]$ opatch napply ./6079591 -skip_subset -skip_duplicate
Invoking OPatch 10.2.0.3.0

Oracle interim Patch Installer version 10.2.0.3.0
Copyright (c) 2005, Oracle Corporation. All rights reserved..

Syntax Error… Unrecognized Command or Option: failed to parse arguments “unknown option ‘-skip_subset'”
Please use the option ‘opatch -help’ to get correct syntax

OPatch failed with error code 14

It turns out I read through the readme file a bit too fast, and skipped the following section:

  • 3.2 OPatch Utility Information

3.2 specifies to use OPatch utility release 10.2.0.3.2 or later.

The OPatch 10.2.0.3.2 can be downloaded from Oracle Metalink with patch 4898608.

I strongly suggest to read the July 2007 CPU readme file carefully since there is also new stuff as:

If you have already installed CPUJan2007, CPUApr2007, or CPUApr2007 CPU merge patch, the patch needs to be rolled back first.

Also, a new database CPU patch format is being introduced with the July 2007 CPU, the new format, napply CPU (pronounced “n apply CPU”).

This means, no more:

opatch apply

Use:

opatch napply ./6079591 -skip_subset -skip_duplicate.

Useful links for July’s CPU:

Oracle Critical Patch Update – July 2007

Critical Patch Update Availability Information for Oracle Server and Middleware Products

Critical Patch Update – Introduction to Database Napply CPU Patches

Using Enterprise Manager to achieve grid automation with deployment procedures

Nice to have links for Oracle CPU’s:

Security Technology Center

RSS feed for Oracle Security Alerts

DataCenter Automation and Configuration Management

Advertisements
  1. #1 by abdul on June 7, 2008 - 9:10 am

    hi,
    anybody can u tell me the steps of the opatch utility
    thanks and regards

  2. #2 by ERSAN on June 27, 2008 - 2:40 pm

    Hi,
    these are the steps.

    1. Go to metalink.oracle.com – Patch site and download related CPU patch. (For example CPU OCT2007 Patch 6394981)

    2. Unzip on to your system
    3. Shutdown the database, listener, other processes

    4. Point to the right environment

    . ./setup_env INSTANCE_NAME

    . oraenv

    5. Include Opatch in the patch

    export PATH=$ORACLE_HOME/OPatch:$PATH
    add /usr/ccs/bin to your PATH and
    Make sure /usr/ccs/bin is the path and it is before /usr/ucb
    6. point to your patch unzip directory

    cd /xxx/software/10.2.0/patches/6394981

    opatch napply -skip_subset -skip_duplicate

    7.now upgrade the db.

    cd $ORACLE_HOME/cpu/CPUOct2007
    sqlplus /nolog
    SQL> CONNECT / AS SYSDBA
    SQL> STARTUP
    SQL> @catcpu.sql
    SQL> QUIT

    If catcpu.sql reports any Invalid Objects, run the following commands:
    cd $ORACLE_HOME/rdbms/admin
    sqlplus /nolog
    SQL> CONNECT / AS SYSDBA
    SQL> STARTUP
    SQL> @utlrp.sql
    You can check for any invalid objects by executing following statement:

    Regards
    Ersan Cam
    CIBC Financial
    ersan.cam@gmail.com
    Toronto, Canada

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: