OFSAAI 220.127.116.11 Install Fails with ORA-12154 When Using Failover JDBC Connection String
(Doc ID 2595836.1)
Last updated on OCTOBER 22, 2019
Applies to:Oracle Financial Services Analytical Applications Infrastructure - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
When attempting to install the OFSAAI 22.214.171.124 maintenance release by running OFSAAIUpgrade.sh, the install fails during the Env Check utility with the error below:
DB specific Validation Started ...
ERROR -> ORA-12154: TNS:could not resolve the connect identifier specified
DB specific Validation Completed. Status : FAIL
In this case, the environment is configured for failover and the DEFAULT_CONNECTION_URL in the DynamicServices.xml has the format below:
<PARAMETER NAME="DEFAULT_CONNECTION_URL" VALUE="jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=ON)(ADDRESS=(PROTOCOL=tcp)(CONNECT_DATA=(SERVICE_NAME=<SERVICE NAME>)))"/>
You expect the installer to support a failover setup.
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