OFSAA 5.2 FTP and PFT Application Install Using Exadata Fails (Doc ID 1447959.1)

Last updated on SEPTEMBER 27, 2013

Applies to:

Oracle Financial Services Funds Transfer Pricing - Version 5.2 and later
Oracle Financial Services Profitability Management - Version 5.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) - Version 7.2
Oracle Financial Services Analytical Applications (OFSAA) - Version 5.x

Checked for relevance on 27-Sept-2013.

Symptoms

On Oracle Financial Services Profitability Management (PFT) and Oracle Financial Services Funds Transfer Pricing (FTP) 5.2, when attempting to do run the Apps Installer on Exadata the following error occurs:

ERROR
[ 04/11/2011 00:26:23 ] FICMASTER Driver found: oracle.jdbc.driver.OracleDriver
[ 04/11/2011 00:26:23 ] FICMASTER URL found: jdbc:oracle:thin:@//my01-scan.test.mybank.com:1521/ofsaa1d
[ 04/11/2011 00:26:23 ] Ficmaster User found: OFSACONF
[ 04/11/2011 00:26:23 ] Solution setup for Database Type: ORACLE
[ 04/11/2011 00:26:23 ] Infodom Name: OFSA72
[ 04/11/2011 00:26:23 ] Fic Home: /app/reveleusofs
[ 04/11/2011 00:26:23 ] ficmaster url: jdbc:oracle:thin:@//my01-scan.test.mybank.com:1521/ofsaa1d
[ 04/11/2011 00:26:23 ] ficmaster driver: oracle.jdbc.driver.OracleDriver
[ 04/11/2011 00:26:23 ] ficmastuser: OFSACONF
[ 04/11/2011 00:26:23 ] ficmastpwd: **********

============================== EXCEPTION ==============================
[ 04/11/2011 00:26:23 ] Exception occured in File: <DashoA10*..> Class: <com.zerog.lax.LAX> Method: <main> Line: <-1>
java.sql.SQLException: Io exception: Connection refused(DESCRIPTION=(ERR=1153)(VSNNUM=186647040)(ERROR_STACK=(ERROR=(CODE=1153)(EMFI=4)(ARGS='(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.22.19)(PORT=1521))(CONNECT_DATA=(CID=(PROGRAM=)(HOST=__jdbc__)(USER=))null))'))(ERROR=(CODE=303)(EMFI=1))))
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
at oracle.jdbc.driver.OracleConnection.<init>(OracleConnection.java:404)
at oracle.jdbc.driver.OracleDriver.getConnectionInstance(OracleDriver.java:468)
at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:314)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at com.iflex.solutions.install.DatabaseInfo.install(DatabaseInfo.java:413)
at com.zerog.ia.installer.actions.CustomAction.installSelf(DashoA10*..)
at com.zerog.ia.installer.AAMgrBase.a(DashoA10*..)
at com.zerog.ia.installer.ConsoleBasedAAMgr.a(DashoA10*..)

Same connection information worked for Infrastructure install.

STEPS
The issue can be reproduced at will with the following steps:
1. Run FTP 5.2 application installer using the following connect string in Silent.props:

# Specify the JDBC Connection String for RAC
# For ex:
# jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=<host1>) (PORT=<port1>))(ADDRESS=(PROTOCOL=TCP)(HOST=<host2>) (PORT=<port2>))(CONNECT_DATA=(SERVICE_NAME=MYTST)))
# Mandatory if INSTALL_DB = 1
#RAC_JDBC_URL=jdbc:oracle:thin:@//my01-scan.test.mybank.com:1521/ofsaa1d
RAC_JDBC_URL=jdbc:oracle:thin:@//my01-scan.test.mybank.com:1521/ofsaa1d
#RAC_JDBC_URL=jdbc:oracle:thin:@(DESCRIPTION=(LOAD_BALANCE=on)(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.22.19) (PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=10.11.22.21) (PORT=1521))(ADDRESS=(PROTOCOL=1521)(HOST=10.11.22.20) (PORT=1521))(CONNECT_DATA=ofsaa1d)

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms