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
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
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
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
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
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
Be sure you download the 64 bit version:
X86 means 32 bits!
Till Next Time
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
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
If you install a new DB for the ODI respository, be sure the chararter set is: AL32UTF8
Till Next Time
Posts
All Comments
