My Oracle Support Banner

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)

Symptoms

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:

VALUE="jdbc:oracle:thin:@hostname.us.test.net:<port>/servicename.us.test.net" />

You do not understand why the installer cannot use this value to connect to the database successfully.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.