Oracle DBA, How To, Error, Cause and Action

ORA-00569: Failed to acquire global enqueue.

ORA-00569: Failed to acquire global enqueue.


Cause:


A prior error occurred on one of the instances in the cluster. Typically errors are caused by shared pool resource contention.



Action:


Check for and resolve prior errors on all instances in the cluster. If there is shared pool resource contention, increase the SHARED_POOL_SIZE, DML_LOCKS, PROCESSES, TRANSACTIONS, CLUSTER_DATABASE_INSTANCES and PARALLEL_MAX_SERVERS initialization parameters.

No comments:

Post a Comment

Thanks for your comment.