Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Oracle 19 EE RU -patch: Is there a way datapatch could be run without the auto recomp at the end?

We have a 19 RAC env, where we have several dbs, and in this env there is one annoying db where datapatch often hangs (for many hours) in recomp. Not always, but often - some RU datapatches have gone normally (for example Oct23, Jan24) but some do not (Jul23, Apr24). We've had several SRs open about this, but no real resolution. So we have to ctrl-end the datapatch, fix the problematic object where the hangup -issue occurs (MDSYS.SDO_GEOMETRY) and do recompiling by hand (utlrp). After this the db is ok, but of course patch registry show wrong status (END),

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center