Oracle Bi Solutions

  • Subscribe to our RSS feed.
  • Twitter
  • StumbleUpon
  • Reddit
  • Facebook
  • Digg

Friday, 5 April 2013

OBI 11g - Linux Start Up Best Practice

Posted on 06:57 by Unknown

The whole idea of starting and stopping processes for OBI is nothing new.  Windows gets buy with a very simple system that most are familiar, but Linux can often pose as a challenge.  Since, I prefer to recommend Linux (*Nix) over Windows when it comes to OBI, especially with OBI 11g it is worth a quick post on automating the start-up of OBI 11g on a Linux box (modify this logic slightly in the next OBI 11g patch when UNIX is supported).
Getting down to it, as a best practice, I recommend starting all java and system components on boot of the server.  For a while there were arguments on whether to do this or not, but ultimately it boils down to maintaining as much of a hands-off approach as possible.  In the Linux world to launch the four (out-of-box) services that would be required to run OBI 11g, a user would basically need to log into the Linux OBI 11g server (or terminal in) to launch a terminal window for at a minimum of three of those components (WLS, WLS Node Manager, and OPMN). The fourth, the OBI Managed Server (handles the Java pieces), could be started from the WLS Admin Console which provides some benefit but it could also be started from a command line.  It should also go without saying, but I’ll state it any way, that the database containing the RCU created MDS and BIPLATFORM schemas should be up, pingable, and in good health before this script is launched.
Here is some basic script below to start your OBI 11g Linux environment on boot.  This is just the init.d script that you should copy, save to a linux text editor with a file name such as “OBI11gStartStop” (no extension) and load to the /etc/init.d/ directory, and load like any other init file. This blog post assumes that you have some familiarity with commands such as chkconfig as well as working with Linux directories and permission sets.
view sourceprint?
01.#!/bin/sh
02.# chkconfig: 345 99 8
03.# description: OBIEE11g and WLS auto start-stop script
04.#
05.# File is saved as /etc/init.d/obiee11gWLS
06.#
07.# Run-level Startup script for OBIEE
08. 
09.# set required paths
10.#export ORACLE_BASE=/u01/app/oracle
11.ORACLE_OWNR=obi11g
12.ORACLE_FMW=/u01/FMW
13.#export PATH=$PATH:$ORACLE_FMW
14. 
15.case "$1" in
16.'start')
17.echo -e "Starting Weblogic Server...."
18.su - $ORACLE_OWNR -c"$ORACLE_FMW/user_projects/domains/bifoundation_domain/startWebLogic.sh > /tmp/WLSStart.log 2>&1 &"
19.sleep 30
20.echo -e "Starting Node Manager..."
21.su - $ORACLE_OWNR -c "$ORACLE_FMW/wlserver_10.3/server/bin/startNodeManager.sh > /tmp/WLSNodeMgrStart.log 2>&1 &"
22.sleep 90
23.echo -e "Starting Managed Server: bi_server1..."
24.su - $ORACLE_OWNR -c"$ORACLE_FMW/user_projects/domains/bifoundation_domain/bin/startManagedWebLogic.sh bi_server1 http://OBI11G:7001 > /tmp/WLSMgdSvr.log 2>&1 &"
25.sleep 90
26.echo -e "Starting OPMN Components...."
27.su - $ORACLE_OWNR -c "$ORACLE_FMW/instances/instance1/bin/opmnctl startall"
28.sleep 120
29.;;
30.'stop')
31.echo -e "Stopping OPMN Components...."
32.su - $ORACLE_OWNR -c "$ORACLE_FMW/instances/instance1/bin/opmnctl stopall"
33.sleep 60
34.echo -e "Stopping Managed Server: bi_server1..."
35.su - $ORACLE_OWNR -c"$ORACLE_FMW/user_projects/domains/bifoundation_domain/bin/stopManagedWebLogic.sh bi_server1 http://OBI11G:7001 > /dev/null 2>&1 &"
36.sleep 30
37.echo -e "Stopping Weblogic Server...."
38.su - $ORACLE_OWNR -c"$ORACLE_FMW/user_projects/domains/bifoundation_domain/bin/stopWebLogic.sh > /dev/null 2>&1 &"
39.sleep 15
40.;;
41.restart)
42.$0 stop
43.$0 start
44.;;
45.*)
46.echo "Usage: 'basename $0' start|stop|restart|status"
47.exit 1
48.esac
49. 
50.exit 0
51. 
52.######################################
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Posted in OBIEE | No comments
Newer Post Older Post Home

0 comments:

Post a Comment

Subscribe to: Post Comments (Atom)

Popular Posts

  • Upper Function
    In Oracle/PLSQL, the  upper function  converts all letters in the specified string to uppercase. If there are characters in the string that ...
  • OBIEE 11g Hide/Show Sections based on Dashboard Prompt
    allow a user’s interaction to hide/show certain sections of a dashboard. In this particular case the user wanted to choose either ‘Quarterly...
  • [OBIEE11g] - OBIEE Dashboard for Informatica Metadata Reporting
    The metadata that Informatica Power Center 8 retains in its repository can be exposed via OBIEE reports and dashboards. This metadata includ...
  • [ODI] - Frequently Asked Questions (FAQ)
    Here is a list of FAQs about Oracle Data Integrator 1) What is Oracle Data Integrator (ODI)? 2) What is E-LT? 3) What components make up Ora...
  • OBIEE 11g not showing new dashboard in the drop down menu
    When creating New dashboard in  OBIEE 11g, I have faced with issue that dashboard name did not show up in drop down dashboard menu. 1. When ...
  • Data Modeling: Schema Generation Issue with ERwin Data Modeler 7.3
    We are using Computer Associate’s ERwin Data Modeler 7.3 for data modeling. In one of our engagements, we are pushing data model changes to ...
  • Installation Informatica Powercenter 9.1 on Oracle Enterprise Linux 5.6
    Ingredients: Program Version Filename Oracle Express 11G 11.2.0 oracle-xe-11.2.0-0.5.x86_64.rpm SQL Developer 3.0 sqldeveloper-3.0.04.34-1.n...
  • Informatica Powercenter Workflow Manager Repository Navigator docking float issue
    In case you’re also experiencing where your Repository Navigator is not dock or attached and it seems just floating within Workflow Manager ...
  • [OBIEE11g] - Creating Dashboard Traversing Through Graph
    The general requirement asked for by customers is that they want to Click on the Main Dashboard Page’s Graph and be transferred to the other...
  • OBIEE 11g - Query Limit
    Query limit and number of minutes a query can run per physical layer database connection, follow the below steps. > Login to Repository u...

Categories

  • BI Publisher
  • DAC
  • DataWarehouse
  • Hyperion
  • Informatica
  • OBIEE
  • ODI
  • Oracle Applications EBS 12.1.3
  • Oracle Database
  • PL/SQL
  • SQL
  • Unix/Linux

Blog Archive

  • ▼  2013 (500)
    • ►  November (8)
    • ►  October (1)
    • ►  July (4)
    • ►  June (9)
    • ►  May (15)
    • ▼  April (24)
      • OBIEE 11g - Migration steps in OBIEE11g
      • Column Indent Background Color Changing in Pivot T...
      • Oracle Data Integrator 11.1.1.7 installation on Linux
      • OBIEE 11g -- Daily Catalog Backup Script Linux
      • Disabling Right Click on OBIEE with javascript
      • DAC Error Message – No Physical folder information...
      • Informatica PowerCenter Server Status URL
      • Informatica Error Calling PMREP or PMCMD – Librari...
      • Configure Informatica Integration Services to Cons...
      • OBIEE 11g Pre-Requisites Kernel Failure
      • OBIEE 11g on DHCP Assigned Network
      • OBIEE 11g - Linux User and Groups Setup for OBI11g...
      • OBIEE 11g - MDS or BIPLATFORM Schema Password Chan...
      • OBI 11g - Linux Start Up Best Practice
      • SQL Fiscal Calendar Build Script
      • Hyperion - Desable (UAC) Before Installing Oracle...
      • OBIEE 11g - Upgrade RPD to Latest Oracle BI 11g Ve...
      • OBIEE 11g - Stopping Oracle BI 11g on Windows with...
      • OBIEE 11g - Known issues
      • OBIEE 11g - In-place upgrade of a scaled-out BI do...
      • OBIEE 11g - In-place upgrade from 11.1.1.6 to 11.1...
      • OBIEE 11.1.1.7 New Features
      • OBIEE 11.1.1.7 - Where are all my Right Click opti...
      • OBIEE 11.1.1.7 is available
    • ►  March (43)
    • ►  February (73)
    • ►  January (323)
Powered by Blogger.

About Me

Unknown
View my complete profile