I just downloaded and installed the Critical Patch Update April 2007
$ lsnrctl stop ... The command completed successfully $ sqlplus / as sysdba SQL> shutdown immediate ... ORACLE instance shut down. SQL> quit $ cd /tmp/5901891 $ ORACLE_HOME/OPatch/opatch apply ... Finish at Wed Apr 18 10:28:17 CEST 2007 $ lsnrctl start ... The command completed successfully $ sqlplus / as sysdba SQL> startup ... Database opened. SQL> @?/cpu/CPUApr2007/catcpu SQL> @?/rdbms/admin/utlrp
The logfile of opatch is $ORACLE_HOME/cfgtoollogs/opatch/opatchdate.log and the logfile of the catcpu is APPLY_sid_date.log. ORA-02303 can be safely ignored.
SQL> select * from dba_registry_history
ACTION_TIME
------------------------------
ACTION
------------------------------
NAMESPACE
------------------------------
VERSION
------------------------------
ID
----------
COMMENTS
------------------------------
18-APR-07 10.38.09.565465 AM
CPU
SERVER
10.2.0.3.0
5901891
CPUApr2007
SQL> select count(*) from dba_objects where status='INVALID';
COUNT(*)
----------
0
Successfully applied 😎