Oracle Critical Patch Update July 2005
Release Notes for Oracle Database Server Version 9.2.0.6
Release Date: July 12th, 2005
Note: You are required to read the Advisory
and Pre-installation
notes for Critical Patch Update - July 2005
before you proceed.
CONTENTS
Introduction
Requirements
Bugs Fixed by this patch
OPatch information
Patch Installation Instructions
Patch Deinstallation Instructions
Database Server Patch for Oracle Critical Patch Update July 2005 is an opatch installable bundle for components in the data server and client.
This patch should be applied to the Oracle home for the Database.
This
document guides your through the Installation, Post Installation Actions and
optionally, De-Installation steps required for Oracle Critical Patch Update
April 2005 Database Server Patch. Failure to carefully read and
understand these steps may result in your applying a patch that can cause your
Oracle Installation to malfunction, including interruption of service and/or
loss of data.
If you do not meet all of the following requirements, please log an iTAR, so
that an Oracle support analyst may review your situation. The Oracle
analyst will help you determine if this patch is suitable for you to apply to
your system. We recommend that you avoid applying any temporary patch
unless directed by an Oracle Support Analyst who has reviewed your system and
determined that it is applicable.
Requirements
Your system configuration (Oracle Server version and patch level, OS Version)
must exactly match those listed below.
Patch
for Base Bug: 4392392
Patch for Platforms: Sun SPARC
SOLARIS, Linux, HP-UX, HP Tru64, AIX
Product Version:
9.2.0.6
Product Patched:
RDBMS, CONTEXT, NETWORK, SDO, Modplsql ( 3.0.9.8.5 )
You must have Perl 5.00503 (or later) installed under the ORACLE_HOME, or
elsewhere within the host environment. OPatch is no longer included in patches
as of 9.2.0.2. Refer to the following link for details on Perl and OPatch: Doc
ID 189489.1
Bugs Fixed by this patch
4392396:SECURITY BUGS FIXED IN CPUJUL2005.
4199440:SECURITY BUGS FIXED IN CPUAPR2005.
4392392:MLR ON TOP OF 9.2.0.6 FOR CPUJUL2005
4017526:MERGE LABEL REQUEST - MLR ON TOP OF 9.2.0 FOR SECURITY ROLLUP
4193295:MLR ON TOP OF 9.2.0.6 FOR CPUAPR2005
4049345:EFFORT REPRESENTATIVE BUG - OHS_CPU_1 FOR 9.2
2701372:DTDS AND SOAP (SEC ALERT 65)
3949307:SHARED SERVER PROCESS GOT HEAP ERROR KGHALO4 AND ORA-600[510]
OPatch information
For further details regarding OPatch,
see Metalink article Doc
ID: 283369.1 OPatch Documentation
Prior to the Install Phase, following checks are performed
Conflicts with other patches
Conflicts with subset patches (existing patch is a subset of the patch being installed)
If a conflict is found, please abort the install and
contact Oracle Support Services
If a subset is found, please continue the install, as all fixes for the subset
patch are included in the patch being installed. The subset patch(s) will
be automatically rolled back prior to the installation of the new patch.
You must use OPatch version 1.0.0.0.53 or later.
It can be downloaded from Metalink with
Patch#2617419. (The minimum version of OPatch required is 1.0.0.0.53)
If the Oracle inventory is not setup correctly this utility
will fail. To check accessibility to the inventory you can use the command
% opatch lsinventory
Patch Installation Instructions
Please
review the ‘Known Issues’ section in the Pre-installation
notes for Critical Patch Update - July 2005
before proceeding with the patch
installation.
(Note 311062.1:Oracle CPUJul2005 Pre-Installation for Oracle Database Server)
To apply this patch, you must shutdown all instances and listeners
associated to the ORACLE_HOME being updated.
The following executables must be present in the $PATH: make, ar, ld, and nm.
Set your current directory to the directory where the
patch is located and then run opatch by entering the following command:
cd 4392392
opatch apply
If you encounter any errors, please refer to the ‘Known Issues’ section in the Pre-installation notes for Critical Patch Update - July 2005.
Post Installation Instructions
Start up all database instances running out of the ORACLE_HOME being patched in
MIGRATE mode.
For each database instance running out of the ORACLE_HOME being patched,
connect to the database using Sqlplus as sysdba and run catcpu.sql as follows -
cd
$ORACLE_HOME/cpu/CPUJul2005
sqlplus>
connect / as sysdba
sqlplus>
STARTUP MIGRATE
sqlplus>
@catcpu.sql
sqlplus>
SHUTDOWN
Inspect the logfile for any errors. If you have encountered
any errors, please refer to the ‘Known Issues’
section in the Pre-installation
notes for Critical Patch Update - July 2005.
If catcpu.sql reports any Invalid Objects, Oracle recommendes that you compile the invalid objects using the following;
(Please
note that for large numbers of objects, this compilation step can take some
time.
If this
patch is being applied through the Enterprise Manager console, you will be
prompted to run this compilation script. )
cd
$ORACLE_HOME/rdbms/admin
sqlplus>
connect / as sysdba
sqlplus>
STARTUP
sqlplus>
@utlrp.sql
You can check for any invalid objects by executing following statement;
sqlplus> select OBJECT_NAME from DBA_OBJECTS where status = 'INVALID';
Patch Deinstallation Instructions
To
de-install the patch, set your current directory to the directory where the
patch is located and then run opatch by entering the following command:
cd 4392392
opatch rollback -id 4392392
If you encounter any errors, please
refer to the ‘Known Issues’ section in the Pre-installation
notes for Critical Patch Update - July 2005.
Post
Deinstallation Instructions (Note: Follow post deinstallation
instructions only if post-install instructions were followed)
Start up all database instances running out of the
ORACLE_HOME being patched in MIGRATE mode.
For each database instance running out of the ORACLE_HOME being patched,
connect to the database using Sqlplus as sysdba and run catcpu_rollback.sql as
follows -
cd
$ORACLE_HOME/cpu/CPUJul2005
sqlplus>
connect / as sysdba
sqlplus>
STARTUP MIGRATE
sqlplus>
@catcpu_rollback.sql
sqlplus>
SHUTDOWN
Inspect the logfile for any errors. If you have encountered any errors, please refer to the ‘Known Issues’ section in the Pre-installation notes for Critical Patch Update - July 2005 .
If
catcpu.sql reports any Invalid Objects, Oracle recommendes that you compile the
invalid objects using the following;
(Please
note that for large numbers of objects, this compilation step can take some
time.
If this
patch is being applied through the Enterprise Manager console, you will be
prompted to run this compilation script. )
cd
$ORACLE_HOME/rdbms/admin
sqlplus>
connect / as sysdba
sqlplus>
STARTUP
sqlplus>
@utlrp.sql
You can check for any invalid objects by executing following statement;
select OBJECT_NAME from DBA_OBJECTS where status = 'INVALID';