Friday, 20 April 2012

Oracle Business Intelligence Application 7.9.6.2 - Server Installation/Configuration on UNIX

This is an attempt to share notes on installation/configuration the Oracle Business Intelligence Application 7.9.6.2 on Unix Platform
Server Install
Prepare Server OS and install dependencies
·         Create OBIEE user and create required directories
·         Install java
Oracle Client
Quick install by extracting preconfigured client install and editing tnsnames.ora / Or Perform a clean install using oracle universal installer
tar xcfz /nfs/home/obiee/oraclient-configured.tgz and
Edit /u01/orasoft/oracle/product/11.1.0.6/client/network/admin/tnsnames.ora
OBIEE Install
Now run the UNIX check script and if successful then run the OBIEE installer
su -obiee
cd /nfs/home/obiee/biee_linux_x86_redhat_101341_1of1/RH_Linux/Server/Oracle_Business_Intelligence

$ ./UnixChk.sh /u01/OBIEE/OracleBI
SUCCESS!! - This machine is configured for Oracle BI EE 10.1.3.4

$ ./UnixChk.sh /u01/OBIEE/OracleBIData
SUCCESS!! - This machine is configured for Oracle BI EE 10.1.3.4


./setup.sh -console
-------------------------------------------------------------------------------
Browse or Enter the Installation Location: [/usr/local/OracleBI] /u01/OBIEE/OracleBI
Browse or Enter the Data Location: [/usr/local/OracleBIData] /u01/OBIEE/OracleBIData
[X] 1 - Basic: Minimum security. Installs Oracle Containers for J2EE (OC4J).
[X] 1 - Complete
All Oracle Business Intelligence components will be installed.
Browse or Enter the JDK Location (JAVA_HOME): [] /u01/daemons/java/
Administrator username: oc4jadmin
Administrator password: XXX
[X] 8 - English
After finishing installation go to http://hostname:9704/
Scripts to start and stop OBIEE Services
------
startobiee.sh for start obiee services

/u01/OBIEE/OracleBI/setup/sa-init.sh
cd /u01/OBIEE/OracleBI/setup
nohup ./run-sa.sh start64 &
nohup ./run-saw.sh start64 &
nohup ./run-sch.sh start64 &

stopobiee.sh for start obiee services

cd /u01/OBIEE/OracleBI/setup
nohup ./run-sa.sh stop
nohup ./run-saw.sh stop
nohup ./run-sch.sh stop

Informatica Install
Make sure /etc/hosts contains the DB and other OBI server information
su - obiee
cd /nfs/home/obiee/informatica-install/1of2/
./install.sh

Run through the install wizard in console - the following details the configuration required.
Choose Locale...
----------------
->1- English
CHOOSE LOCALE BY NUMBER: 1

->1- Install PowerCenter 8.6.1

PowerCenter License Key
Select the license key file: (DEFAULT: /home/obiee/license.key)
: /nfs/home/obiee/informatica-install/infa_linux_x86_64bit_861_2of2/Oracle_All_OS_Prod.key

Choose the installation directory:
INSTALL FOLDER IS: /u01/Informatica/PowerCenter8.6.1
IS THIS CORRECT? (Y/N): y

PowerCenter HTTPS Configuration
->2- Use a keystore generated by the installer
HTTPS Port Number: (DEFAULT: 8443):

Press Enter to run the install. Then setup the domain DB connectivity...
If installing the first (or only) OBI server in the environment, first create the domain. If installing the second OBI server in the environment, skip this step and join an existing domain.

Create or Join Domain
->1- Create New Domain (If you are installing PowerCenter for the first time or you want to create a new ->1- Oracle
->1- Default
Database URL: (DEFAULT: host_name:port_no):dbserver:1521
Database user ID:infodom
Database user password: <db password>
Database service name: (DEFAULT: servicename):PRODOBI
Domain name: (DEFAULT: Domain_PRODOBI01):
Domain host name: (DEFAULT:PRODOBI01):
Node name: (DEFAULT: node01_PRODOBI01):
Domain port no: (DEFAULT: 6001):
Domain user name: (DEFAULT: admin):
Domain password:: <domain passwd>
Confirm password:: <domain passwd>
Create Repository Service (Y/N) (DEFAULT: Y):
Configure minimum and maximum port numbers? (Y/N) (DEFAULT: N)

If installing the second OBI server in the environment, join an existing domain...
Join Existing Domain (If you are installing PowerCenter on multiple machines and you already created a domain on name: (DEFAULT: Domain_ PRODOBI02): Domain_ PRODOBI01
host name: (DEFAULT: PRODOBI02): PRODOBI01
port no: (DEFAULT: 6001):
user name: (DEFAULT: admin):
password: (DEFAULT: ): <domain passwd>
Configure Informatica - Repository and Integration Service
Click Create -> Repository Service
Service Name: PROD_Repository_Service
Location: Domain_PRODOBI01
License: License_PRODOBI01
Node: node01_PRODOBI01
DatabaseType: Oracle
CodePage: UTF-8 encoding of Unicode
ConnectionString: PRODOBI
DBUser: infarep
DBPassword: <db password>
TablespaceName: <leave blank>
Creation Mode: Select Create new repository content

Click create and if successful a series of sql statements should appear as the repository is created
Now change the mode from Exclusive to Normal to allow the creation of the Integration Service in the next step.
Select PROD_Repository_Service
In Properties -> General Properties, click Edit and change Operating Mode? From Exclusive to Normal
Click OK and allow the restart of the service if prompted.
Click Create -> Integration Service
Service Name: PROD_Integration_Service
Location: Domain_PRODOBI01
License: License_PRODOBI01
Node: node01_PRODOBI01
Domain for Associated Repository Service: Domain_PRODOBI01
Associated Repository Service: PROD_Repository_Service
Repository User Name: admin
Repository Password: <informatica admin password>
Data Movement Mode: Unicode
Primary Node: node01_PRODOBI01 UTF-8 encoding of Unicode
Enable Service: Check Enable the Integration Service after creation

If there are issues during the Integration Service setup try a clean shutdown and then startup of Informatica
The next part of the install involves copying files from Windows -> Linux (and vice versa). One way to do this is using WinSCP, an easier way is to share the drive and mount it on the Linux machine.
As root user

mkdir /windows
mount -t cifs -o username=administrator, password=<admin passwd> //172.172.9.43/C$ /windows/

Login back with obiee user

Restoring the Informatica Repository content
Copy repository

cp - r windows/OracleBI/dwrep/Informatica/Repository/Oracle_BI_DW_Base.rep
/u01/Informatica/PowerCenter8.6.1/server/infa_shared/Backup

·         Select PROD_Repository Service
·         Change General Properties - Operating Mode to Exclusive,
·         Restart the service when asked
Now delete contents from repository
·         Actions -> Delete Contents
·         Username/pass is the admin user set during installation of Informatica Server
Now Restore Contents in repos
·         Actions -> Restore Contents
·         Select Oracle_BI_DW_Base.rep
·         Check "Restore as new" and click OK
Now restore operating mode
·         Select PROD_Repository Service
·         Change General Properties - Operating Mode to Exclusive
Copy src and lookup files from Informatica (Windows) to Linux
cp -r /windows/OracleBI/dwrep/Informatica/SrcFiles/*
/u01/Informatica/PowerCenter8.6.1/server/infa_shared/SrcFiles/

cp -r /windows/OracleBI/dwrep/Informatica/LkpFiles/*
/u01/Informatica/PowerCenter8.6.1/server/infa_shared/LkpFiles/

Set custom properties on Integration Service
·         ServerPort = 4006
·         overrideMpltVarWithMapVar = Yes
·         DisableDB2BulkMode = Yes

DAC Install
Copy the files from the Windows DAC install to Linux
cp -r /windows/orahome/10gR3_1/bifoundation/ /u01/dac/

Move the linux .sh files to the correct location and archive the windows .bat files
cd /u01/dac/bifoundation/dac/
mv unix_script_bkp/* .
mkdir windows_script_bkp
mv *.bat windows_script_bkp/

Edit dac_env.sh and set the following...
INFORMATICA_SERVER_HOME=/u01/Informatica/PowerCenter8.6.1
DAC_PMCMD_PATH=${INFORMATICA_SERVER_LOCATION}/server/bin
export PATH=${PATH}:${DAC_PMCMD_PATH}:${INFORMATICA_SERVER_HOME}/server
export INFA_HOME=${INFORMATICA_SERVER_HOME}
export INFA_DOMAINS_FILE=${INFORMATICA_SERVER_HOME}/domains.infa
export INFA_CMD_STYLE=8

Edit config.sh and comment out the export JAVA_HOME=%JAVA_HOME% (if already set in/etc/profile/obiee.sh) and run ./serverSetupPrompt and answer following  
1 - Enter repository connection information
3 - Oracle (OCI8)
Please enter TNS Name
> PRODOBI
Please enter DB Driver (Optional)
>
Please enter DB URL (Optional)
>
Please enter Table owner name
> dac
Please enter Password
> XXX
2 - Test repository connection
Connecting to repository...
Connection was successfully established!
5 - Save changes
6 - Exit

I hope you find this blog useful, I will cover the client installations in future blog.

 

No comments:

Post a Comment