My Oracle Support Banner

"ODI-1551: Failed to acquire dbms_lock with an SQL exception" Error when Executing an ODI 12c Load Plan (Doc ID 2392778.1)

Last updated on AUGUST 09, 2021

Applies to:

Oracle Data Integrator - Version and later
Information in this document applies to any platform.


The following error is observed in the Oracle Data Integrator (ODI) 12c Agent log file after executing a Load Plan:

ODI-1551: Failed to acquire dbms_lock with an SQL exception 'ORA-06550: line 1, column 7:
PLS-00201: the identifier 'DBMS_LOCK' must be declared
ORA-06550: line 1, column 7:
PL / SQL: Statement ignored
' Check if the database user of the XXXXX work repository has the EXECUTE privilege in the DBMS_LOCK package.
  at oracle.odi.runtime.agent.locks.OracleDbmsLock.acquireLockHandle (
  at oracle.odi.runtime.agent.locks.OracleDbmsLock.lock (
  at oracle.odi.runtime.agent.loadplan.RepositoryUtil.acquireLock (
  at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.doStartLPExecution (
  at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.access $ 000 (
  at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor $ (
  at java.util.concurrent.Executors $ (
  at (
  at (
  at (
  at java.util.concurrent.ThreadPoolExecutor.runWorker (
  at java.util.concurrent.ThreadPoolExecutor $ (
  at (




To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.