'ORA-12154: TNS:Could Not Resolve the Connect Identifier Specified' Running OFSAA Process on Server
(Doc ID 1486389.1)
Last updated on MARCH 10, 2023
Applies to:
Oracle Financial Services Profitability Management - Version 5.2 and laterOracle Financial Services Asset Liability Management - Version 5.2 and later
Oracle Financial Services Funds Transfer Pricing - Version 5.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Symptoms
After executing a process for Oracle Financial Services Profitability Management (PFT), Funds Transfer Pricing (FTP) and/or Asset Liability Management, the process fails to run. When you try running directly on the server using the command line from $FIC_DB_HOME/bin, you receive an ORA-12154: TNS:could not resolve the connect identifier specified error:
$ ./ofsrm OFSAAINFOD_200061_20120825_1 ALM TASK1 20120825 200061 USER1
[AESCryptorImpl.handleJVM]->INFO: JVM created successfully...
Log 4j System not available so messages with priority INFO or higher will be logged to this console
ClsUSmsConnect::ClsUSmsConnect, Forming Login Info statement
| strBatchId : OFSAAINFOD_200061_20120825_1 | strComponentId : ALM | Process ID : 200061 | User ID : USER1 |
Error(Oracle Financial Services Application error) (203105) Oracle drv_oci error:
OCI Function: [0] - olon(), orlon()
Oracle Error: [12154] - ORA-12154: TNS:could not resolve the connect identifier specified
Driver Function: drv_oci::Connect()
MB(AttachDB()) Error attaching to database: OFSAADB
The error prevents the process from executing on the server.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |