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

Dac 11g Preinstallation Requirements

Prerequisites for installing the DAC Client and Server:
1. Installaton of informatica
2. Download the file Oracle Business Intelligence Data Warehouse Administration Console
3. Create a repository user which will store the dac object

Informatica 9.1 Pre-installation Requirements on linux

1. Minimum P-4 processor or higher is required
2. Minimum 4gb ram or higher is required
3. Minimum 20gb hard disk is required
4. Linux distribution and version which supports the informatica installation
5. At least one database has to be installed
6. Temporary disk space is minimum 1gb for installer and minimum 2gb for informatica services
7. Create a system user account for installing informatica
8. We have to set up the Domain configuration repository
9. We have to determine the available ports for informatica
10. Set the environment variables
11. We have to set up a key stroke and file descriptor settings
12. We have to set up database parameters, users and table spaces before installing informatica.

Oracle Database 11g Pre-installation Requirements on linux

1. Minimum 1 GB of Ram , Recommended 2 GB or more
2. Swap size must be 1.5 times the size of the Ram
3. Minimum 1gb space of hard disk size is required for /tmp space
4. For software files minimum 4.35 gb of hard disk space is required
5. For data files 1.7 gb hard disk space is minimum
6. The minimum screen resolution for oracle database is 1024 x 768
7. The distribution and version of linux must be supported by the oracle database.
8. Required packages must be installed in the os before installing the database
9. Certain kernel parameter values must be changed before installing database.
10. Additional software requirements like oracle jdbc and oci drevirs has to be installed.
11. Create an user account for installing database.

PREREQUISITE STEPS FOR INSTALLING HYPERION 11.1.2.3 ON WINDOWS 7

1. Turn off UAC:

To turn off  UAC
1. Click Start, and then click Control Panel.

2. In Control Panel, click User Accounts.

3. In the User Accounts window, click User Accounts.

4. In the User Accounts tasks window, click Turn User Account Control on or off.

5. If  UAC is currently configured in Admin Approval Mode, the User Account Control message appears. Click Continue.
6. Clear the Use User Account Control ( UAC) to help protect your computer check box, and then click OK.

7. Click Restart Now to apply the change right away, or click Restart Later, and then close the User Accounts tasks window.

2. Enabling IIS Service:

GO TO – Start – Control Panel

Click on Uninstall a Program

Click on Turn Windows features on or off

Select Internet information services and click ok

Close it and restart the system

3. Adding host name and ip address in host file :

Go TO C:\WINDOWS\system32\drivers\etc
Open the ( host ) file with notepad and add system ip addresses and host name

4. Install dot net frame work 4.0
5. Install Microsoft mse 3.0
6. Install office 2010
7. Copy database folder into EPM 11.1.2.3 SOFTWARE extracted folder

Now start installation by right clicking on wizard file and open it in run as administrative mode