INSTALLATION DOCUMENTS BY RAVI

Showing posts with label OFSAA. Show all posts
Showing posts with label OFSAA. Show all posts

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 next


















click next


















click done

Install WebLogic Server 10.3



























click next


















click next



































click continue


















click next



















click next


















click next


















click next


















click done

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






















click next


















click next


















click next


















click next


















click next


















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















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 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 next















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














USER NAME = SYSAUTH
PASSWORD = welcome1



























Give the password you want and click ok
New Password = admin123














Click ok and re login with new password















click save

















  Opatch reports 'Cyclic Dependency Detected' error when patching ODI   Issue: When applying a Patch Set Update (PSU) to WebLogic Se...