Oracle BI Application 11.1.1.10.2 Work Repository Connection Issue

Question

HI,

I am able to successfully installed OBIA 11.1.1.10.2 on my Linux Box and during the process of installation while creating RCU for OBIA, it was not recognizing the hostname in the jdbc connection string.

I tried giving it as localhost after which I was able to proceed with RCU process. Post installation I am trying to connect to Work Report and getting below error.

oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.

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

I am able to login to ODI Console and also from ODI studio I am able to connect to Master Repository.

I suspect it is because of my earlier parameter "localhost" which I had given during RCU process of OBIA.

Please let me know if there a fix for this.

When searching the Oracle Community I found below which has similar issue

How to enable detailed ODI Studio connection tracing? and how to troubleshoot a connection problem.

user8206283 · Answer

AH! Finally I was able to connect. The issue was in the Work Repository JDBC Connection String I has used host name and I was trying to access the hostname from my laptop(ODI Studio) and I did not updated hosts file with IP address of my sever

Gbenga Ajakaye · Answer

I'll suggest your go through this MOSC DOC:

OBIA 11g: Error:ODI-10182: Uncategorized Exception During Repository Access. ORA-00001: Unique Constraint (Doc ID 2016069.1)

user8206283 · Answer

Hi,

I guess it is some thing to do with External Authentication Framework,

Initially I thought this was an issue because localhost as value passed during configApps.sh step. After re-installing it again freshly I am still getting this error

oracle.odi.core.config.WorkRepositoryResourceFailureException: ODI-10182: Uncategorized exception during repository access.

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.

My server has fully qualified hostname given and I am able to start all the servers including database and am able to connect it.

Strange thing is I am able to connect to Master Repository using ODI Studio but not able to connect to Work Repository.

I am kind of struck here and not able proceed.

Need some help..

Steps:

1. Install Oracle Database 12c.

2. Execute RCU and Install OBIEE 11.1.1.9.0

3. Install ODI (Software Only)

4. Execute RCU and Install OBIA Software.

5. Apply Platform Patches

6. Perform ATG, FSM and BIACM, BIACM_IO updated using ./psa

7. Finally execute ./configApps.sh

8. Copied cwallet.sso and jps-config-jse.xml to ODI Studio and modified odi.conf file to use jps-config-jse.xml file.