ORA-00230: operation disallowed: snapshot control file enqueue unavailable

To determine which job is holding the conflicting enqueue.

SELECT s.sid, username AS "User", program, module,
action, logon_time "Logon", l.*
FROM v$session s, v$enqueue_lock l
WHERE l.sid = s.sid
and l.type = 'CF'
and l.id1 = 0
and l.id2 = 2;

SID User Program Module Action Logon
--- ---- -------------------- ------------------------- ---------------- ---------

- Wait until the job creating the enqueue completes
- Cancel the current job and restart it once the job creating the enqueue completes
- Cancel the job creating the enqueue