ODI Oracle Data Integrator EE

ODI-26017 Running Loadplan

2011-06-26T01:19:00.001-07:00

If you will at he screen it says it can’t run DBMS-lock:

Ask your DBA to run this as SYS:

grant execute on DBMS_LOCK to snpm1;
grant execute on DBMS_LOCK to snpw1;

(Change the users to your master and work repository)

Till Next Time

ODI Import Knowledge Module File location

2011-06-23T03:10:00.001-07:00

My ODI studio got messed up, couldn’t find the knowledge modules anymore. Default import location is: <ODI_HOME>\oracledi\xml-reference

Till Next Time

OBIEE ODI Lineage setup

2011-06-22T08:40:00.001-07:00

When setting up a OBIEE ODI Lineage RPD you might get the following error:

ODI-50036: Error creating V_LINEAGE_HIERARCHY Table. Check the logs.

The error might fool you. It means that your (work) repository schema doesn’t have the right to create a view.

Ask your DBA to run the following script:

grant create view to snpm1;
grant create view to snpw1;

Till Next Time

ODI Setting up the DEMO environment 11g

2011-06-16T23:36:00.001-07:00

Lost some time figuring out why my ODI demo environment as described in http://download.oracle.com/docs/cd/E14571_01/integrate.1111/e12641/install.htm woudn’t start. It turns out there are several versions on OTN. (Thanks Wilco for helping me!). You need the on from the companion disc for 11g:

Till Next Time

Running ODI studio on a 64 bits windows machine

2011-06-09T10:24:00.001-07:00

So you installed everything, try to run the ODI studio and you get:

“Unable to launch the Java Virtual Machine”…

The problem is, that ODI studio needs a 32 bit version Java Virtual Machine.

So install a 32 bit JDK.

you still will get a

you first need to edit odi.conf file:

Go to $ODI_HOME\oracledi\client\odi\bin folder
and open odi.conf file:

edit the line SetJavaHome C:\Program Files\Java\jdk1.6.0_24 to your 32 bit javahome:

et voila:

Why is this happening?

You have to realize that ODI Studio is a client component, developed for a “normal” client. 'Ideally' Client components have no place on server……..

Till Next Time

ODI11g Installing the developers version

2011-06-09T10:09:00.001-07:00

After starting the insatller you might need to define the JDK home:

Let’s start with a developers installation

Enter a new location in your default ORACLE home:

Connect to you repository DB: (The one you made with the RCU)

Enter the SUPERVISOR password:

And we are ready:

add the icon to you taskbar:

And start the studio:

Till Next Time

ODI on widows 64bit

2011-06-09T08:12:00.001-07:00

Be sure you download the 64 bit version:

(for all platforms)

X86 means 32 bits!

Till Next Time

ODI Repository Creation

2011-06-09T08:01:00.001-07:00

Download and unzip the RCU (Repository Creation Utility)

Navigate to ..\ofm_rcu_win_11.1.1.5.0_disk1_1of1\rcuHome\BIN and start RCU.BAT

Enter the database creditential, remember the password is CaSe sensitive.

Check the ODI, set the prefix to DEV

Set the password and try to remember them somehow!

Set the custom variables:

and write them down!!

Till Next Time

ODI change character set repository

2011-06-09T07:32:00.001-07:00

What if you forgot to set the character set during install. Just do “ALTER DATABASE CHARACTER SET AL32UTF8; “ and you are ready to go.

Till Next Time

ODI Installing the repository DB

2011-06-09T06:31:00.001-07:00

If you install a new DB for the ODI respository, be sure the chararter set is: AL32UTF8

Till Next Time

Welcome to ODIEE 101

2009-02-03T01:30:00.000-08:00

Hi,
My name is John Minkjan and I'm a pricipal BI-consultant at CIBER in the Netherlands.
I reserverd a couple of ...101 blogspots. At the moment I'm mostly active on OBIEE101.
I will start posting here as soon as my focus in back on to Oracle Data Intigrator.

Till Next Time

John