10.1.0.4 patchset 2 catcpu.sql slop

w2k3 server std ed, 32 bit.
Oracle 10g R1, 10.1.0 patchset 3 applied (10.1.0.4)

While running the 10.1.0.4 patchset 2 post-installation script (catcpu.sql) against a newly created database there were a rather large amount of ORA-00955 (457) and ORA-02303 (63) errors.

These can sometimes be ignored, but basically, this means having to compare the previous definitions of the objects against the new definition on a line by line basis in order to determine if in fact the object definition has changed. This is a huge waste of time, IMHO.

I was thinking of rather than taking that approach, of manually dropping all of these objects prior to re-running catcpu.sql and examining the results (HUGE hammer approach).

this is in testing in a db with no users.

yeah, I could just ignore the patchset and stick with 10.1.0.4 patchset 1. we've hit an issue covered by 10.1.0.4 patchset 2 so I'd rather get the bugfix out there than wait for the next iteration.

just trolling for some thoughts before I vent into an iTAR.

Paul

--
http://www.freelists.org/webpage/oracle-l