"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 MAY 17, 2018

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 (OracleDbmsLock.java:193)
  at oracle.odi.runtime.agent.locks.OracleDbmsLock.lock (OracleDbmsLock.java:101)
  at oracle.odi.runtime.agent.loadplan.RepositoryUtil.acquireLock (RepositoryUtil.java:1988)
  at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.doStartLPExecution (LoadPlanProcessor.java:664)
  at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor.access $ 000 (LoadPlanProcessor.java:112)
  at oracle.odi.runtime.agent.loadplan.LoadPlanProcessor $ 1.run (LoadPlanProcessor.java:480)
  at java.util.concurrent.Executors $ RunnableAdapter.call (Executors.java:511)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call (OdiJob.java:73)
  at oracle.odi.runtime.agent.execution.job.OdiJob.call (OdiJob.java:73)
  at java.util.concurrent.FutureTask.run (FutureTask.java:266)
  at java.util.concurrent.ThreadPoolExecutor.runWorker (ThreadPoolExecutor.java:1142)
  at java.util.concurrent.ThreadPoolExecutor $ Worker.run (ThreadPoolExecutor.java:617)
  at java.lang.Thread.run (Thread.java:745)




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