Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

Error when connecting to Repository from ODI Studio (ODI-26130: Could not connect to repository)

3190209Mar 20 2016 — edited Mar 22 2016

Hello Experts:)

I'm trying to setup ODI environment for my university project.

I have windows 2008 R2, I've installed ODI 12c and Oracle DB EE also 12.

According to requirements, I have created Pluggable Database on Oracle DB, database name is pdbfmw.

I have created repository basing on this instruction: http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/odi/odi_12c/odi12c_mst_wrk_repos/odi12c_mst_wrk_repos.html#section1s1

Only difference is that service name of database is sid of this pluggable db - pdbfmw. Rest of settings has been left default (as on this instruction). Creation of repository was succesfull.

Now I'm trying to connect to repository from ODI Studio, here are settings I'm trying (also based on that instruction):

Przechwytywanie.PNG

And when I'm trying to choose Work Repository, here is what I receive (ODI-26130: Could not connect to repository) :

oracle.odi.core.config.MasterRepositoryResourceFailureException: 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.SQLException: ORA-01017: invalid username/password; logon denied

When I change sid in URL to "pdbfmw", error is (ODI-26130: Could not connect to repository) :

oracle.odi.core.config.MasterRepositoryResourceFailureException: 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.SQLException: Listener refused the connection with the following error:

ORA-12505, TNS:listener does not currently know of SID given in connect descriptor

It says, that SID is not know, but I have just created repository in that db, so I don't get what I'm doing wrong here.

Sorry for such a long post, but I wanted to give full description of a problem.

Could you please advice?

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 23 2023
Added on Mar 20 2016
6 comments
6,524 views