11.5.10.2 : Package ICX_SEC getting invalid while applying the patch - 8977290
Hi Support,
We had seen an issue with the package ICX_SEC which was in invalid state, as initially we had seen there were 30 odd sessions with wait event "library cache pin" when further checked it was the package ICX_SEC which was in invalid state and was holding a lock by some or the other sessions which were not releasing the locks and this was the wftkn.msg sql that was running what we fetched from the patch log file. We went on to run this sql with the given parameters manually which also had error out , below are the details.
We had seen an issue with the package ICX_SEC which was in invalid state, as initially we had seen there were 30 odd sessions with wait event "library cache pin" when further checked it was the package ICX_SEC which was in invalid state and was holding a lock by some or the other sessions which were not releasing the locks and this was the wftkn.msg sql that was running what we fetched from the patch log file. We went on to run this sql with the given parameters manually which also had error out , below are the details.
Tagged:
0