ODI Connection Error
1008394May 12 2013 — edited May 20 2013I have installed ODI version 11.1.1.5 version(Demo version or RCU not installed) in my Windows 7 machine.
I have Oracle 11g installed in my machine.
I want to create the master and work repositories in the Oracle 11g ver of my machine.
JDK I'm using is 32 bit JDK jdk1.6.0_45.
SID of Oracle 11g of my machine is orcl22.
ODI pwd I'm using is "SUNOPSIS"
User of oracle 11g of my machine on which I want to create master repository is "MASTER"
=======================================
Entries in odiparams.bat
set ODI_MASTER_DRIVER=oracle.jdbc.OracleDriver
set ODI_MASTER_URL=jdbc:oracle:thin:@localhost:1521:ORCL22
set ODI_MASTER_USER=MASTER
set ODI_MASTER_ENCODED_PASS=gxfpqkz074jeaCpL4XSEFzxoj8E0p
REM #
REM # User credentials for agent startup program
REM #
set ODI_SUPERVISOR=SUPERVISOR
set ODI_SUPERVISOR_ENCODED_PASS=fJya.vR5kvNcu9TtV,jVZEt
REM #
REM # Work Repository Name
REM #
set ODI_SECU_WORK_REP=WORKREP
REM #
REM # Java virtual machine
REM #
set ODI_JAVA_HOME=C:\Program Files\Java\jdk1.6.0_45
================================================
While trying to create master repository I'm getting below error.
ODI-26130 Could not connect to repository
oracle.odi.core.config.MasterRepositoryResourceFailureException: org.springframework.jdbc.CannotGetJdbcConnectionException: Could not get JDBC Connection; nested exception is java.sql.SQLException: Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection
at oracle.odi.core.repository.Repository.getMasterRepository(Repository.java:79)
at oracle.odi.core.OdiInstance.createMasterRepository(OdiInstance.java:491)
at oracle.odi.core.OdiInstance.<init>(OdiInstance.java:544)
at oracle.odi.core.OdiInstance.createInstance(OdiInstance.java:521)
at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.testConnection(SnpsDialogLoginDetail.java:1365)
at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.jButtonTest_ActionPerformed(SnpsDialogLoginDetail.java:1051)
at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.connEtoC6(SnpsDialogLoginDetail.java:274)
at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail.access$4(SnpsDialogLoginDetail.java:272)
at com.sunopsis.graphical.dialog.SnpsDialogLoginDetail$IvjEventHandler.actionPerformed(SnpsDialogLoginDetail.java:161)