ORA-12154 Error Installing OFSAAI Patch When Service Name Used in DynamicServices.xml
(Doc ID 2597208.1)
Last updated on OCTOBER 23, 2019
Applies to:Oracle Financial Services Funds Transfer Pricing - Version 8.0.7 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.7 and later
Oracle Financial Services Profitability Management - Version 8.0.7 and later
Oracle Financial Services Asset Liability Management - Version 8.0.7 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
When installing an OFSAAI maintenance release or upgrading from a prior version, you get the following error for the database validation:
DB specific Validation Started ...
ERROR -> ORA-12154: TNS:could not resolve the connect identifier specified
DB specific Validation Completed. Status : FAIL
Environment check utility Status : FAIL
In the case where OFSAAI is already installed, the installer gets the connection details from the DynamicServices.xml in $FIC_HOME/conf and the DEFAULT_CONNECTION_URL references a Service Name instead of a SID. The Service Name is in the following format:
You do not understand why the installer cannot use this value to connect to the database successfully.
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