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):
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?