Processes Fail With 'ORA-01017: invalid username/password; logon denied' on 19c Database With RAC / Failover Setup
(Doc ID 2809941.1)
Last updated on FEBRUARY 15, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6.6.0 and laterOracle Financial Services Funds Transfer Pricing - Version 8.0.6.6.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.6.6.0 and later
Oracle Financial Services Profitability Management - Version 8.0.6.6.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Profitability Management (PFT)
Symptoms
All batch processes are failing with a fatal error and no logs are generated. As an example a Transfer Pricing Engine task fails with the following error when run via command line:
| strBatchId : <Infodom>_<Batch Name>_20210726_6 | strComponentId : Transfer Pricing Engine | Process ID : 284622 | User ID : XXXXXXX | AS_OF_DATE : 07/26/2021
successfully read all database details
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
OCI Function: [0] - olon(), orlon()
Oracle Error: [1017] - ORA-01017: invalid username/password; logon denied
Driver Function: drv_oci::Connect()
MB(AttachDB()) Error attaching to database: atomic
Memory fault
You verified the following already:
- PASSWORD_VERSIONS = 10G 11G 12C in DBA_USERS
- Refreshed the atomic password using the user interface
- tnsnames.ora points to the correct server and database
You still get the same invalid password error.
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 |