Sentinel: Oracle Critical Patch Update Oracle_Vulnarability_Patch_p4567846_9206p4567846_9206

Has Oracle patch p4567846_9206 been tested on Sentinel application?

There was a critical security patch released in mid October 2005 for Oracle. We have verified that the patch works with our software.

=======================

Critical patch

Note 333953.1
Oracle Critical Patch Update - October 2005

Description

A Critical Patch Update is a collection of patches for multiple security vulnerabilities. It also includes non-security fixes that are required (because of interdependencies) by those security patches.

There were some issues installing the patch. The method below was used and can help avoid some of the issues with the installing the patch.

1. Prior to applying it is a must to upgrade and or install the Opatch utility. The patch number for this utility is 2617419 and is available through metalink. Instructions for the patch are fairly straight forward however remember to put opatch in the path for oracle.
2. Once opatch is installed, unpack and install the critical patch (p4567846_9206_LINUX.zip) or (p4567846_9206_SOLARIS.zip). The command for installation is SUPPOSED to be opatch apply but on Linux use the perl script to invoke the script. The command used was: perl /opt/oracle/product/9.2/OPatch/opatch.pl apply.
3. Once the patch has completed, run the post installation scripts.

cd $ORACLE_HOME/cpu/CPUOct2005

sqlplus /nolog

sqlplus> connect / as sysdba

sqlplus> STARTUP

sqlplus> @catcpu.sql

sqlplus> QUIT

4. ALMOST THERE J Next fix the post installation script. There will be some invalid objects found that have to be fixed

cd $ORACLE_HOME/rdbms/admin

sqlplus /nolog

sqlplus> connect / as sysdba

sqlplus> @utlrp.sql

That is it.