Reporting Refresh fails with ORA-20500, ORA-06512, and ORA-00054 (Doc ID 1493479.1)

Last updated on MAY 12, 2016

Applies to:

Oracle Health Sciences InForm - Version 4.5.0 to 5.0.3 [Release 4.5.0 to 5.0.0]
Information in this document applies to any platform.

Symptoms

 Complete refresh fails with:

ORA-20500: Refresh of materialized views failed for DBA<trial name>. ORA-00054: resource busy and acquire with NOWAIT specified
ORA-20500: Refresh of materialized views failed for DBA<trial name>. ORA-20500: Refresh of materialized views failed. See error stack for error.
ORA-06512: at "DBA<trial name>.REFRESH_PROCS", line 574
ORA-00054: resource busy and acquire with NOWAIT specified

Errors in file /u01/orabase/admin/<instance name>/bdump/<instance name>_j000_5621.trc:
ORA-12012: error on auto execute of job 173
ORA-20500: Refresh of materialized views failed. See error stack for error.
ORA-06512: at "DBA<trial name>.REFRESH_PROCS", line 145
ORA-20500: Refresh of materialized views failed. See error stack for error.
ORA-06512: at "<trial name>.REFRESH_PROCS", line 574
ORA-00054: resource busy and acquire with NOWAIT specified
ORA-06512: at line 1

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms