ORA-01017 and Fatal Failed Error Connecting to Atomic Schema When Running Batches on DB 12.2 or DB 19c
(Doc ID 2412630.1)
Last updated on JANUARY 15, 2024
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.5 and laterOracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Oracle Financial Services Asset Liability Management - Version 8.0.5 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Symptoms
Cash Flow Edit, Allocation, Transfer Pricing, or Asset Liability Management batches failed to connect to Atomic Schema after new installation or upgrade on Oracle 12.2 or 19c,
When checking the tasks in the batch, it is found that there are some errors running the task, shown in the $FIC_DB_HOME/bin/nohup.out:
ERROR
Successfully Connected to Config schema.
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: ofsaaatm
FATAL : Failed Connecting to Atomic Schema.
Memory fault(coredump)
Step to Replicate:
1. Run any any allocation, transfer pricing, asset liability management, or cash flow edit process.
2. Errors happened on batch process, launched directly on the user interface, and launched directly on the command line.
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 |