Wednesday Jun 01, 2011

Load plans - getting up and running

To get up and running with load plans there are a few things you'll need to do in order to execute them. One is to setup your agent, if you haven't got one, there is a useful ODI 11g OBE below that explains how to configure a standalone agent;

http://st-curriculum.oracle.com/obe/fmw/odi/odi_11g/Setup_ODI_Agent/Setup_ODI_Agent.htm

In ODI 11.1.1.5 there is also a change in the requirements on the database schema you use (for Oracle anyway), in that there is an additional execute privilege needed on DBMS_LOCK which is needed for load plans, see doc below;

http://download.oracle.com/docs/cd/E21764_01/integrate.1111/e12643/admin_reps.htm#ODIDG156

If you have not granted this privilege you will get the error 'PLS-00201: identfiier DBMS_LOCK must be declared' like below;

One you have granted the execute privilege on DBMS_LOCK to the work schema you are good to go and execute the load plans.

About

Learn the latest trends, use cases, product updates, and customer success examples for Oracle's data integration products-- including Oracle Data Integrator, Oracle GoldenGate and Oracle Enterprise Data Quality

Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
2
3
5
6
7
8
9
10
12
13
14
17
18
19
20
21
23
24
25
26
27
28
29
30
   
       
Today