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.

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
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
22
23
24
25
26
27
28
29
30
   
       
Today