SEV1: During 12.1.1 upgrade adworker fails on gljim.odf with ORA-00054: resource busy and acquire w
Hi,
Upgrading from R11i to R12.1.1
During the R12 upgrade worker 1 failed it job on gljim.odf
Below is the error message.
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
occurred while executing the SQL statement:
ALTER TABLE GL.GL_IMPORT_REFERENCES STORAGE (FREELISTS 4)
AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above
Question:
We are about to finish our R12 upgrade only we are having 4000 jobs remaining, all of a sudden we are struck with gljim.odf.
can we kill the sessions of 'GL.GL_IMPORT_REFERENCES' and go ahead with the failed worker.
Below is the error message.
ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
occurred while executing the SQL statement:
ALTER TABLE GL.GL_IMPORT_REFERENCES STORAGE (FREELISTS 4)
AD Worker error:
Unable to compare or correct tables or indexes or keys because of the error above
Question:
We are about to finish our R12 upgrade only we are having 4000 jobs remaining, all of a sudden we are struck with gljim.odf.
can we kill the sessions of 'GL.GL_IMPORT_REFERENCES' and go ahead with the failed worker.
Tagged:
0