Sunday, June 26, 2011

ODI-26017 Running Loadplan

image

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

Thursday, June 23, 2011

ODI Import Knowledge Module File location

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

image

Till Next Time

Wednesday, June 22, 2011

OBIEE ODI Lineage setup

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.

image

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

Thursday, June 16, 2011

ODI Setting up the DEMO environment 11g

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:

image

Till Next Time

Thursday, June 9, 2011

Running ODI studio on a 64 bits windows machine

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

image

“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 image

you first need to edit odi.conf file:

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

image

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

image

et voila:

image

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

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

image

Let’s start with a developers installation

image

Enter a new location in your default ORACLE home:

image

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

image

Enter the SUPERVISOR password:

image

And we are ready:

image

add the icon to you taskbar:

image

And start the studio:

image

Till Next Time

ODI on widows 64bit

Be sure you download the 64 bit version:

image (for all platforms)

X86 means 32 bits!

Till Next Time

ODI Repository Creation

Download and unzip the RCU (Repository Creation Utility)

image

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

image

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

image

Check the ODI, set the prefix to DEV

image

Set the password and try to remember them somehow! Knipogende emoticon

image

Set the custom variables:

image

and write them down!! Knipogende emoticon

Till Next Time

ODI change character set repository

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

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

image

Till Next Time