Access Synchronization Fails With ORA-01017: invalid username/password; logon denied (Doc ID 1271626.1)

Last updated on JANUARY 15, 2017

Applies to:

Oracle Application Access Controls Governor - Version 8.5.1 and later
Information in this document applies to any platform.

Symptoms

In Oracle Application Access Controls Governor (AACG) , when attempting to run Data Synchronization,it completes immediately but status shows In Progress and grcc logs shows the following error occurs.

Error:

DEBUG [Thread-79] OdiSessionMonitor:96 *** error message: 1017 : 72000 : java.sql.SQLException: ORA-01017: invalid username/password;

logon denied

java.sql.SQLException: ORA-01017: invalid username/password; logon denied

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:283)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:278)
at oracle.jdbc.driver.T4CTTIoauthenticate.receiveOauth(T4CTTIoauthenticate.java:791)
at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:362)
at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:439)
at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:165)
at oracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:35)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:801)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:365)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:350)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnectionFromDriverManager(DriverManagerDataSource.java:314)
at oracle.odi.jdbc.datasource.DriverManagerDataSource.getConnection(DriverManagerDataSource.java:273)
at oracle.odi.jdbc.datasource.LoginTimeoutDatasourceAdapter$ConnectionProcessor.run(LoginTimeoutDatasourceAdapter.java:236)
at java.lang.Thread.run(Thread.java:619)

2010-12-03 10:13:41,020 DEBUG [Thread-79] OdiSessionMonitor:98 *** Session context: GLOBAL_GRC
2010-12-03 10:13:41,020 DEBUG [Thread-79] OdiSessionMonitor:100 *****************************
2010-12-03 10:13:41,023 DEBUG [Thread-79] LoadOdiEnvironment:480 Session status has changed to ERROR
2010-12-03 10:13:41,025 DEBUG [Thread-79] LoadOdiEnvironment:492 Datasource synch failed

Steps:

The issue can be reproduced at will with the following steps:

  1. Select data source of type EBS from Administration > Data Administration and run Access Synchronization.
  2. Job History shows completed with same start and end date/time.

Business Impact:
-----------------------
The issue has the following business impact:
Due to this issue, users cannot use AACG.

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