INSTALLATION DOCUMENTS BY RAVI

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

















9 comments:

  1. Hi Ravikumar,

    May i know, which operation system we need to use to install ofsaai.

    ReplyDelete
    Replies
    1. Operating System:
      Oracle Linux / Red Hat
      Enterprise Linux
      Oracle Linux Server release 5.3 up to 5.10 - 64 bit
      Oracle Linux Server release 6.0 and above - 64 bit
      Note: Same versions of RHEL is supported

      Oracle Solaris:
      Oracle Solaris v5.10 Update 9 (9/10 s10s_u9wos_14a)
      SPARC sun4v - 64 bit
      Oracle Solaris v5.11

      IBM AIX:
      AIX 5.3 (ML 12*) - 64 bit
      AIX 6.1 (ML 07*) - 64 bit

      Delete
  2. Regardless of whether you have your own particular application or utilize an application builder benefit, you are in supreme control of what and when you can refresh your application. website to android app

    ReplyDelete
  3. Anyway the product to see PDF documents is for nothing out of pocket and comprehensively introduced on numerous PCs. change-pdf-text.com

    ReplyDelete
  4. The battles of the financially avoided originate from obstructions and reasons as access, social and social elements, pay, instruction and numerous potential arrangements of others. East Coast Financial of Central Florida

    ReplyDelete
  5. but there usually isn't a charge of interest until you actually withdraw money from the funds. Fill out a check Step by Step Guide (USA)

    ReplyDelete
  6. Now that they're so ubiquitous, there's a new question to wrangle with, and that's the matter of how cryptocurrencies are handled in the divorce process. cryptocurrence processing

    ReplyDelete
  7. Hi
    I have followed the steps by you while installing OFSAA 7.3 on OEL 6.5 machine.
    However my weblogic server's default port is 7001
    and while creating context i have given IP port as 7001 and context name as myapp
    But when after deploying the ear files as mentioned when i tried to access the URL
    http://linux2:7001/myapp/login.jsp
    it gives me error

    Error 404 not found.

    What could be the issue? Could you please guide me, I am new to OFSAA and its installation.

    ReplyDelete
  8. I am able to connect to OFSAAI Screen with SYSADMN but after login in I found the connected tab is emptye/ it shows connected to undefined.
    what could be the error? I am using FICMASTER

    ReplyDelete

SQL query to find whether OdiSendMail is configured or not ODI 12c

In the SQL developer connect to the ODI work repository user (Ex: DEV_ODI_REPO) and run the below query. select SCEN_NAME,TASK_NAME3,DE...