PATCHING

Oracle 19c: Datapatch stuck: Unable to acquire sqlpatch global lock in EXCLUSIVE mode

After a session got stuck/failed or process got killed somehow, we are getting an error trying to re-run datapatch. Checking if we have a rogue process, we can see the old PID still there: We killed, but still the same,no progress. This case we had to kill the sqlpatch pid, and after this, datapatch completed... » read more

Datapatch -verbose fails with: PLS-00201: identifier ‘SYS.UTL_RECOMP2’ must be declared

We are running datapatch on a Windows environment after a BP patching, but it was failing with: For the fix, we applied solution suggested on: 12.1: datapatch -verbose Fails with Following Error”PLS-00201: identifier ‘UTL_FILE’ must be declared” (Doc ID 2265408.1):