Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ODI Connection Error

1008394May 12 2013 — edited May 20 2013
I 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)
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 17 2013
Added on May 12 2013
7 comments
4,500 views