add

About Me

My photo
Oracle Apps - Techno Functional consultant

Sunday, August 12

OBIEE & BIP Installation Guide


1.      Installation Environment


Operating System
IBM AIX 6100-06-05-1115 (64 bit )
OBIEE
Oracle OBIEE 10.1.3.4.1
BIP
Oracle Business Intelligence Publisher 10.1.3.4.1 with Metalink patch 9017232
Application Server
Oracle Weblogic Server Enterprise Edition 11g R1 (10.3.3)
Java
JDK  1.6 (64bit)

2.      Requirements


1.      Root access on the IBM AIX server to create the appropriate user & groups for OBIEE access
2.      Weblogic Server to be installed and domain should be configured with a Admin Server and a managed Server.
3.      Administrative rights to the Weblogic servers where OBIEE & BIP is installed

3.      Pre-Installation Procedure

1.      Login to Server and created the OBIEE install group and users.
a.       Group : oinstall & user: oracle

2.      Create the OBIEE home folders at the locations where OBIEE has to install.
a.       OracleBI - ORACLE_BI_HOME  (ex: /u02/OBIEE/OracleBI)
OracleBIData - ORACLE_BI_DATA_HOME (ex: /u02/OBIEE/OracleBIData)
b.      This folder should be owned by OBIEE user and group created in previous step.
c.       Provide permission (775) to the OBIEE folders.

3.      Login to server as OBIEE user (oracle) to check the java version and ensure its greater than Java 1.5 (64 bit)
a.       Java –version

4.      Ensure the latest patch been applied on OS level (IBM AIX)
Refer: http://www-933.ibm.com/support/fixcentral/aix/selectFixes?release=6.1&function=release

5.      Download and extract the OBIEE 10.3.1.4.1 software at the preferred location and check for the existence of below file (As show in screen shot)
6.      Run the pre-check up scrip UnixChk.sh as OBIEE user (oracle) and ensure the output is successful. IF any failures, install the missing components on the OS. (Refer Appendix for notable issues)
a.       $ ./UnixChk.sh
7.      Ensure the ports are free (9700, 9701, 9702, 9703, 9704, 22791, 7000) using netstat
a.       netstat –an | grep 9704

4.      Installation Procedure

1.      Use X Manager / other X window utility to access the remote server
a.       export DISPLAY=<IP of client machine>:0.0
b.      Check the remote access using utilities like xclock, xhost
2.      Connect to the OBIEE server and run the setup.sh file from the extracted OBIEE location.
a.       $./setup.sh
3.      OBIEE Installation wizard will be activated and it continues as below and Press “Next >”
4.      Provide the OBIEE BI and OBIEE BI Data folder location (which been created in Pre-Installation procedure) and Select the “Basic” mode of installation type.
5.      Select the “Complete” as installation setup type.
6.      Select the JDK location and provider OC4J administrator password.
a.       Ensure JDK is greater than 1.5 (64 bit)
b.      No need to work on OC4J level configuration, as we are moving the EAR/ WAR from Oc4J to Weblogic. Only this password (OC4J) is need for the alternative approach to Weblogic.
7.      Click on “Next >” on the continuing screens:


8.      On Installation success screen, click on “Next >” on for continuing:
By default in Basic mode, OC4J (Oracle Container for J2EE) will be started.

5.      Configuration for Weblogic Environment

By default in Basic mode, OC4J (Oracle Container for J2EE) will be started. Since OBIEE is targeted to run on Weblogic server. Need to follow the below instructions:

1.      Stop the running OC4J using the command below:
a.       $> ./oc4j -stop
If any issues in stopping OC4J through command, use kill command:
b.      ps- ef | grep oc4j
c.       kill -9 <Pid of OC4J process>
d.      Note: Kill process of oc4j (ctl c) is not proper shutdown. Sometimes relevant process will be in locked state. To remove the depended task, need to remove persistence folder from <OBIEE_HOME>j2ee/home (ex: /u02/OBIEE/OracleBI/oc4j_bi/j2ee/home)

2.      Create a specific folders for storing the WAR files which has to be deployed to Weblogic console           
a.       Ex: /u02/Middleware/Oracle/OBIEE_WLS/Analytics ---- to Store analytics.war
b.      Ex: /u02/Middleware/Oracle/OBIEE_WLS/xmlpserver ---- to Store xmlpserver.war
c.       Copy the war file analytics.war from OBIEE folder to the above created folders.
                                                              i.      u02/OBIEE/OracleBI/oc4j_bi/j2ee/home/applications/analytics.war> to /u02/Middleware/Oracle/OBIEE_WLS/Analytics/ Folder
Note: No need to copy the xmlpserver.war file from the installed BIP, as need to install the patch.           

3.      XMLP Folder movement – this is needed for easy maintenance of XMLP report and isolating the OBIEE-OC4J (default) setup from the Weblogic server setup:
                                                              i.      Copy the entire folder xmlp from <BIP_HOME>/xmlp (ex: /u02/OBIEE/OracleBI/xmlp/> to local location at server /u02/Middleware/Oracle/OBIEE_WLS/OracleBI/xmlp)
--- This is needed for easy maintenance of XMLP report and isolating the OBIEE-OC4J (default) setup from the Weblogic server setup:

6.      Apply Patch for BI Publisher 10.1.3.4.0


1.      The latest Patch for 10.1.3.4.0 is available in Metalink under the Patch ID 9017232(UPDATE FOR BI PUBLISHER ENTERPRISE 10.1.3.4.1).
a.       Download the patch 9017232 which is in zip format from Oracle Metalink.
b.      Extract the zip file in to xmlp Server location, created in Step 1. (Ex: /u02/Middleware/Oracle/OBIEE_WLS/xmlpserver/) which is downloaded in previous step.
c.       In xmlpserver folder (<extract xmlpserver.war. Now this war file has to be unpacked. To do this run the following command in CMD. (ex)
                               $ cd /u02/Middleware/Oracle/OBIEE_WLS/xmlpserver
                               $ jar -xvf xmlpserver.war

            Here /u02/Middleware/Oracle/OBIEE_WLS/xmlpserver are the local folder into which the downloaded zip has been extracted. Once extract is done, delete xmlpserver.war.
Once unpacked, it creates the application structure. Go to WEB-INF folder and open the xmlp-server-config.xml file. Search for <resource> tag. In the file path provide the repository folder in <BIP_HOME>.
  <?xml version="1.0" encoding="UTF-8"?>
  <xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp">
                   <resource>
                     <file path="<BIP_HOME>/xmlp/XMLP"/>
                   </resource>
  </xmlpConfig>

Ex: as per instructed folder:
  <?xml version="1.0" encoding="UTF-8"?>
  <xmlpConfig xmlns="http://xmlns.oracle.com/oxp/xmlp">
                   <resource>
                     <file path=”/u02/Middleware/Oracle/OBIEE_WLS/OracleBI/xmlp "/>
                   </resource>
  </xmlpConfig>
 
Ensure the folder structure of BIP home (xmlp) contains the defaults report file as shown below: ”/u02/Middleware/Oracle/OBIEE_WLS/OracleBI/xmlp”
 
 

7.      Deploy the xmlpserver WAR files in Weblogic Environment

1.      Login to Weblogic console (http://<IP/DNS of Weblogic Server>:port/console)
2.      Click on Deployments.
3.      Click on Lock & Edit. And Click on Install.
4.      Provide the path of ‘xmlpserver’ as shown in the screen shot. And check the xmlpserver radio button and click NEXT. 
Ex: xmlpserver located after extracting patch:  /u02/Middleware/Oracle/OBIEE_WLS/xmlpserver

5.      Select the option ‘Install this deployment as an application’ and click NEXT.

6.      Select the Managed Server and click NEXT.

7.      Click on Next.
8.      Click on Next.

9.      Click on FINISH & SAVE.

10.  The following message should be displayed on the screen. Then click on Activate changes.
11.  The following message should be displayed.
12.  Click on Deployments. Click on Lock & Edit. And select xmlpserver Application and click on Start and select ‘servicing all requests’



13.  Click on YES.
14.  Following message will be displayed.


The BIP Application can now be accessed using the URL
http://<IP_address>:<port_no>/xmlpserver

8.      Deploy the analytics WAR files in Weblogic Environment

Follow the same procedure as mentioned in Step: Deploy the xmlpserver WAR files in Weblogic Environment  and select the war file from the location /u02/Middleware/Oracle/OBIEE_WLS/Analytics/analytics.war

9.      Deploying Report

Refer the attached BIP Webservice document at Appendix.

10.  Testing URL’s

1.      The BIP Application can now be accessed using the URL
    http://<IP_address>:<port_no>/xmlpserver

2.      The OBIEE Console can be accessed using the URL
http://<IP_address>:<port_no>/analytics

11.  Appendix

1.      Troubleshooting Tips
Ø  While running UnixChk.sh in OBIEE installation at IBM AIX 64 bit OS, there might be message as Host name not found try again
Cause of the Problem
The problem happened due to Oracle bug. The error returned while invoking hostname command. UnixChk.sh script should return success about hostname check but due to Oracle bug it is searching for /etc/resolv.conf file and then DNS entry. Though from command line we can easily resolve hostname by entry inside /etc/hosts file. For example, ping hostname and hostname command work fine.

Solution of the Problem
By default, first attempt to resolve names through the DNS/BIND, then NIS and the /etc/hosts file. The /etc/netsvc.conf file may specify a different search order. The environment variable NSORDER overrides both the /etc/netsvc.conf file and the default ordering. Services are ordered as hosts = value, value, value in the /etc/netsvc.conf file where at least one value must be specified from the list bind, nis, local. NSORDER specifies a list of values.

But here due to -n it is using DNS entry. So ensure that /etc/resolv.conf file exist in your machine and ensure that you have your DNS entry inside this file.
Or manually edit the UnixChk.sh script and remove -n from the host -n.

Ø  While starting the BIP / OBIEE , if any errors as below, ensure the JDK version and fix the issue with other version (greater than 1.5+):

2011-11-16 23:24:30.322 NOTIFICATION J2EE JSP-0008 Unable to dispatch JSP Page
: Exception:oracle.jsp.provider.JspCompileException: <H3>Errors compiling:/u02/O
BIEE/OralceBI/oc4j_bi/j2ee/home/application-deployments/xmlpserver/xmlpserver/persistence/_pages//_login.java

package oracle.jsp.runtime does not exist
package javax.servlet.http does not exist
package com.orionserver.http does not exist

No comments: