Info Imply@Ravi: OFSAA

Saturday, May 6, 2017

OFSAAI-7.3 – Oracle Financial Services Analytical Application Infrastructure : Installation Steps

OFSAA PRE-REQUISITES
1. Oracle Database
2. database user to store OFSAA configuration
3. JDK 1.6.0_17
4. WebLogic Server 10.3

CREATING DATABASE USER TO STORE OFSAA CONFIGURATION

Grant unlimited table space privileges to user created

User must have the following privileges
grant create SESSION to ofsauser;
grant create PROCEDURE to ofsauser;
grant create SEQUENCE to ofsauser;
grant create TABLE to ofsauser;
grant create TRIGGER to ofsauser;
grant create VIEW to ofsauser;
grant create MATERIALIZED VIEW to ofsauser;
grant olap_user to ofsauser;
grant select on SYS.V_$PARAMETER to ofsauser;

CREATING USER which stores all the data and specific metadata for the application(s) being installed.

Install JDK 1.6.0_17

click next

click done

Install WebLogic Server 10.3

click next

click continue

click next

click done

Create weblogic domain by running config.sh under ( $MW_HOME/wlserver_10.3/common/bin)

click next

click create

click done

POPULATE INSTALLATION CONFIGURATION XML In the pre configuration process of Infrastructure installation populate the “OFSAAI_InstallConfig.xml” using “XML_Utility.jar” file.

The XML utility helps you to populate the “OFSAAI_InstallConfig.xml” with the required interaction parameters in a gui mode installation. To create a new “OFSAAI_InstallConfig.xml” do the following

1. Run “XML_Utility.jar” under OFSAAI Installation kit directory by executing “java –jar XML_Utility.jar”.

Context name = ofsaai

click create xml

Log4j.xml configuration

Edit the log4j.xml file as below

CREATING .PROFILE

save and exit

run the .profile

INFRASTRUCTURE INSTALLATION

Create JDBC in domain with JNDI as jndi/FICMASTER

Login to WebLogic Server Administration console (default port 7001) http://hostname:port/console

Select Data Sources under JDBC in Services section

Click on New button on right side

Enter JDBC Name, JNDI Name, Database
Click next

Select the database driver and
Click next

Click test configuration

click finish

CREATING GRID LINK DATA SOURCE

CLICK ON SERVICES->DATA SOURCES -> NEW -> GRID LINK DATASOURCE

click next

Click next and then click test

If the test was successful click finish

INSTALLING OFSAAI 7.3 INFRA STRUCTURE

If the ‘Setup.sh GUI ‘ command was not executed and hits an elf error, Open the Setup.sh file with a text editor and add /bin/ksh at the top of the file

change the user shell into korn shell and again run the setup file

Accept the license agreement and click next

click next

click install

click next

click done

Create EAR & WAR file by running $OFSAA_HOME/ficweb/ant.sh set ANT_HOME to $OFSAA_HOME/ficweb/apache-ant-1.7.1

Start OFSAAI Server by running $OFSAA_HOME/ficapp/ common/FICServer /bin/ reveleusstartup.sh (when prompted for system password, enter configuser schema password)

click install

click next

click finish

click save

Restart the weblogic server and again login to the console and deploy the services.
Test OFSAA application by accessing URL http://hostname:port/ofsaai/login.jsp