Cannot Change Password for Atomic User as Account Keeps Locking
(Doc ID 2394252.1)
Last updated on JANUARY 23, 2024
Applies to:
Oracle Financial Services Funds Transfer Pricing - Version 6.1.1 and laterOracle Financial Services Profitability Management - Version 6.1.1 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 7.3.3.0.0 and later
Oracle Financial Services Asset Liability Management - Version 6.1.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Symptoms
In Oracle Financial Services Analytical Applications (OFSAA), when attempting to change the atomic user password in System Configuration > Database Details, the atomic user account becomes locked before you can change the password. The error below is output to the application layer SMSService.log:
[UMMLOG] Apr 8,18 23:25:59 : [DACDATABASEGATEWAY][BIND VARIABLES DDL Query for debug] : [ select METADATA_KEY ,LOCALE_DESCRIPTION from REV_LOCALE_HIER where VERSION_NO = 0 and METADATA_KEY like 'HPFTRL:%:ND' and upper(METADATA_LOCALE) = 'EN_US'] On URL: jdbc:oracle:thin:<deleted> Driver: oracle.jdbc.driver.OracleDriver Metadata Required : false
[UMMLOG] Apr 8,18 23:25:59 : [CONNECTIONPOOL]No connections in free pool. Creating new connection.
[UMMLOG] Apr 8,18 23:25:59 : [DACCONNECTIONPROVIDER]Error getting connection from pooljava.sql.SQLException: ORA-01017: invalid username/password; logon denied
Followed by:
[UMMLOG] Apr 8,18 23:30:15 : [DACDATABASEGATEWAY][BIND VARIABLES DDL Query for debug] : [ select METADATA_KEY ,LOCALE_DESCRIPTION from REV_LOCALE_HIER where VERSION_NO = 0 and METADATA_KEY like 'HPFTRL:%:ND' and upper(METADATA_LOCALE) = 'EN_US'] On URL: jdbc:oracle:thin:<deleted> Driver: oracle.jdbc.driver.OracleDriver Metadata Required : false
[UMMLOG] Apr 8,18 23:30:15 : [CONNECTIONPOOL]No connections in free pool. Creating new connection.
[UMMLOG] Apr 8,18 23:30:15 : [DACCONNECTIONPROVIDER]Error getting connection from pooljava.sql.SQLException: ORA-28000: the account is locked
[UMMLOG] Apr 8,18 23:30:15 : [DACCONNECTIONPROVIDER]
java.sql.SQLException: ORA-28000: the account is locked
You may also get an error deploying the web server like the one below:
<BEA-149205> <Failed to initialize the application "<Infodom>" due to error weblogic.application.ModuleException: java.sql.SQLException: ORA-28000: The account is locked.
As a result of this issue, you cannot change the atomic password for OFSAA.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |