This content has been marked as final. Show 4 replies
I hope you meant to set ODI_JAVA_HOME and not ODI_JAVE_HOME
Yes I am sorry I did set ODI_JAVA_HOME.
Please set ODI_JAVA_HOME as below and same provide in odiparams.sh/bat file
set ODI_JAVA_HOME=D:\Oracle\Middleware\jdk160_24 but not ODI_JAVA_HOME=D:\Oracle\Middleware\jdk160_24\jre\bin
I had similar issue on Windows..
1) I downloaded jrockit SDK.
2) Pointed JAVA_HOME to this installation
3) Extract the demo folder (i.e. under <ODI_HOME> as odidemo)
Start the agent.
Run ODI enter the details as described in http://download.oracle.com/docs/cd/E14571_01/integrate.1111/e12641/start_odi.htm.
Specify the Oracle Data Integrator connection details as follows:
Login name: Getting Started - ETL Project
Note that username and password are case sensitive.
Specify the Database Connection (Master Repository) details as follows:
This is the database user ID/login of the schema (database, library) that contains the ODI master repository
Password: Leave this field empty.
Driver List: Select Hypersonic SQL Driver from the list.
This driver is required to connect to the DBMS supporting the master repository.
Driver Name: org.hsqldb.jdbcDriver [This is different when populated by ODI]
jdbc:hsqldb:hsql://<<hostip>>:<port>:<sid> (if you have db installed on different box)