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

OFSAAI Prerequisites on Linux

OS Type: RHEL 5.3 / 5.5 (Or) OEL 5.3 / 5.5 - 64 bit ( Two CPUs and 8 GB RAM)
Shell Type: korn shell (ksh)
Locale must be installed en_US.utf8 (For RHEL) en_US.ISO8859
Home directory would have ‘755’ UNIX permission.
Total file descriptor value=9216
Number of processes=4096
Unix user: demouser
Password: demouser
Home: /home/demouser
Infrastructure Application Server: Oracle Client 11g R2 (11.2.0.2.0) - 64 bit, Sun JRE Standard Edition 1.6.0_25 - 64 bit
Path eg: /oracle/oraclient/ora11cl/app/ora11cl/product/11.2.0/client_1
Unix User: oracle/oracle
Home: /home/oracle
Infrastructure Database Server: Oracle Database Enterprise Edition Release 11.2.0.2.0 - 64 bit
NLS_LENGTH_SEMANTICS = CHAR
NLS_CHARACTERSET = AL32UTF8
NLS_NCHAR_CHARACTERSET = AL16UTF16
Database:select * from v$parameter where NAME='open_cursors';
open_cursors value=200 (Min value)
Unix User: oracle/oracle
Home: /home/oracle
Infrastructure Web Server: Web logic 10.3.5.0 with JDK Standard Edition 1.6.0_25 - 64 bit
Unix User: oracle/oracle
Home: /home/oracle

Oracle Endeca Information Discovery Integration with the OBIEE 11g

Open Integrator and select File > New > Project from the menu bar

Select Load Data from OBI Server and click next

Select create a new project
Give the project name
click next

Provide endeca server host, port and domain name and click next

Provide obiee server connection details
Click connect to obi server
If the connection got succeed click next

Select the tables to import and click next

Click finish

Now we can see the obi connection and its details in navigator pane

Run the base line graph by expanding the graph folder
Open baseline.grf
Press the run button
This will load obi repository data into endeca domain

Login to endeca studio
Create a data source like above

Test the connection
 If the test succeed click ok

In the endeca studio create new discovery application with newly created data source

Oracle Networking:Listener.ora,Tnsnames.ora and sqlnet.ora

Listener.ora: 

The listener file contains server side network configuration parameters. It can be found in the ORACLE_HOME/network/admin/ directory on the server.

Tnsnames.ora:

 The tnsnames.ora file contains client side network configuration parameters. It can be found in the ORACLE_HOME/network/admin. This file will also be present on the server if client side connections are used on the server itself.

Sqlnet.ora: 

The sqlnet.ora file contains client side network configuration parameter. It can be found in the ORACLE_HOME/network/admin. This file will also be present on the server if client side connections are used on the server itself.

For client and server communication two files must be configured:

$ORACLE_HOME/network/admin/listener.ora on server side.
$ORACLE_HOME/network/admin/tnsnames.ora on client side.

To configure the server add the following to listerner.ora

Listenername=(address_list=(address=(protocol=tcp)(host=hostname)(port=1521)))
Sid_list_listenername=(sid_list=(sid_desc=(sid_name=<instance_name>)(oracle_home=/oracle_home)))

To configure the client add the following to tnsnames.ora

Tnsalies=(description
=address=(protocol=tcp)(host=hostname)(port=1521))(connect_data=(sid=dev)))

Listener commands:

$ lsnrctl start listenername
$ lsnrctl stop listenername
$ lsnrctl status listenername
$ lsnrctl service listenername
$ lsnrctl reload listenername
$ tnsping listenername