ORA-01017: OAM - OIM Integration: idmConfigTool.sh -configOIM fails with oracle.ucp.UniversalConnectionPoolException (Doc ID 1400511.1)

Last updated on OCTOBER 09, 2016

Applies to:

Identity Manager - Version 11.1.1.5.0 and later
Information in this document applies to any platform.
**Checked for Relevance on 07-Sep-2013**

Symptoms

Trying to integrate OAM - OIM, when running:

./idmConfigTool.sh -configOIM input_file=OIMconfigPropertyFile.txt

the following error is shown in the "automation.log" file:

MDS DB Config- { (MDS DB Url,jdbc:oracle:thin:@SOADB1:1521:SOA01) (MDS DB Schema Username,FM03_MDS) }
Jan 24, 2012 5:02:11 PM oracle.iam.sso.config.io.MsgLogger logInfo
INFO: Starting initialization of MDS resources
Jan 24, 2012 5:02:19 PM oracle.iam.sso.config.io.MsgLogger logError
SEVERE: Error uploading notification handlers to mds db
Jan 24, 2012 5:02:19 PM oracle.iam.sso.config.io.MsgLogger logError
ALL: Error uploading notification handlers to mds db
oracle.mds.exception.MDSRuntimeException: MDS-00003: error connecting to the database
Exception occurred while getting connection: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.mds.internal.persistence.db.fcf.ConnectionManagerCallback.<init>(ConnectionManagerCallback.java:77)
at oracle.mds.persistence.stores.db.DBMetadataStore.checkRepositoryCompatibility(DBMetadataStore.java:875)
at oracle.mds.persistence.stores.db.DBMetadataStore.checkCompatibility(DBMetadataStore.java:1140)
at oracle.mds.persistence.stores.db.DBMetadataStore.<init>(DBMetadataStore.java:424)
at oracle.mds.persistence.stores.db.DBMetadataStore.<init>(DBMetadataStore.java:376)
at oracle.iam.sso.config.MdsHandler.initialize(MdsHandler.java:94)
at oracle.iam.sso.config.MdsHandler.transferToDBStore(MdsHandler.java:132)
at oracle.iam.sso.config.OimCfgTool.importNotificationHandlers(OimCfgTool.java:155)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.idm.automation.impl.oim.handlers.OIMIntegrationHandler.invokeOIMConfigTool(OIMIntegrationHandler.java:314)
at oracle.idm.automation.impl.oim.handlers.OIMIntegrationHandler.performConfigOIMOperations(OIMIntegrationHandler.java:153)
at oracle.idm.automation.impl.oim.handlers.OIMIntegrationHandler.execute(OIMIntegrationHandler.java:127)
at oracle.idm.automation.AutomationTool.executeOIMOperation(AutomationTool.java:630)
at oracle.idm.automation.AutomationTool.configOIM(AutomationTool.java:622)
at oracle.idm.automation.AutomationTool.parseCmdLine(AutomationTool.java:222)
at oracle.idm.automation.AutomationTool.main(AutomationTool.java:132)
Caused by: 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

at oracle.ucp.util.UCPErrorHandler.newSQLException(UCPErrorHandler.java:488)
at oracle.ucp.util.UCPErrorHandler.throwSQLException(UCPErrorHandler.java:163)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:911)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:857)
at oracle.ucp.jdbc.PoolDataSourceImpl.getConnection(PoolDataSourceImpl.java:851)
at oracle.mds.internal.persistence.db.JDBCConnectionManagerImpl.fetchConnection(JDBCConnectionManagerImpl.java:174)
at oracle.mds.internal.persistence.db.ConnectionManager.getConnection(ConnectionManager.java:347)
at oracle.mds.internal.persistence.db.fcf.ConnectionManagerCallback.<init>(ConnectionManagerCallback.java:49)
at oracle.mds.persistence.stores.db.DBMetadataStore.checkRepositoryCompatibility(DBMetadataStore.java:875)
at oracle.mds.persistence.stores.db.DBMetadataStore.checkCompatibility(DBMetadataStore.java:1140)
at oracle.mds.persistence.stores.db.DBMetadataStore.<init>(DBMetadataStore.java:424)
at oracle.mds.persistence.stores.db.DBMetadataStore.<init>(DBMetadataStore.java:376)
at oracle.iam.sso.config.MdsHandler.initialize(MdsHandler.java:94)
at oracle.iam.sso.config.MdsHandler.transferToDBStore(MdsHandler.java:132)
at oracle.iam.sso.config.OimCfgTool.importNotificationHandlers(OimCfgTool.java:155)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at oracle.idm.automation.impl.oim.handlers.OIMIntegrationHandler.invokeOIMConfigTool(OIMIntegrationHandler.java:314)
at oracle.idm.automation.impl.oim.handlers.OIMIntegrationHandler.performConfigOIMOperations(OIMIntegrationHandler.java:153)
at oracle.idm.automation.impl.oim.handlers.OIMIntegrationHandler.execute(OIMIntegrationHandler.java:127)
at oracle.idm.automation.AutomationTool.executeOIMOperation(AutomationTool.java:630)
at oracle.idm.automation.AutomationTool.configOIM(AutomationTool.java:621)
... 2 more
Caused by: oracle.ucp.UniversalConnectionPoolException: Cannot get Connection from Datasource: java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:368)
at oracle.ucp.util.UCPErrorHandler.throwUniversalConnectionPoolException(UCPErrorHandler.java:49)
.....

Changes

Follow the integration procedure listed in the documentation:

http://docs.oracle.com/cd/E21764_01/doc.1111/e15740/oim.htm#CACJDIDD

and

http://docs.oracle.com/cd/E21764_01/doc.1111/e15740/oim.htm#CACFCJHI

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms