RCU Installation for OBIEE 11g

OBIEE 11g RCU Installation

Database Installation and Configuration:
If you installed database already on your machine, you can skip to section.

Before we starting the installation of RCU, we need to choose that which database we are going to use in our application. Here I am giving how to run RCU in Oracle database on our local machine. It is good to install Oracle Database enterprise or standard edition to take full advantage of database for datatypes like spatial data or features like OLAP. 

Prerequisites:
• Min of 4GB RAM required.
• Minimum of 10GB hard disk memory required.
• not use any directory name with space while installing/working with Oracle
DB and BI11g.

Installing RCU:
BI 11g is now standardized with Oracle fusion middleware and hence leverage database for metadata storage just like any other middleware product. So here we are going to install BI11g metadata schema on oracle database you just installed and configured. Same process can be leveraged to install metadata schema on other supported databases as well.
If you have not done already, please download BI11g installation files and RCU installation files. Please make sure all the zipped files have downloaded correctly and unzipped into a single folder.
We can download the software from below Download page:
https://www.oracle.com/technetwork/middleware/bi-enterprise-edition/downloads/bus-intelligence-11g-165436.html


Now we will start the installation of metadata schema using RCU.

From unzipped folder for RCU, run rcu.bat file to start the utility: rcu.bat file is located under rcuHome\BIN directory.

RCU utility will launch the GUI based wizard to guide you through the steps. Click Next to continue.
Select create from the below screen and click Next

In the below step Make sure database type is Oracle Database and enter following information to continue. 
For e.g:
Host Name: localhost 
Port: 1521 
Service Name: ORCL
Username: sys
Role: sysdba
Password:  YourPassword
since we are using oracle database, RCU will show a warning message that we can just ignore and can continue the installation.
Click OK to continue once RCU validates and initializes database configuration.
In the next step it will ask for the prefix to create the metadata schemas. By default it is showing 'DEV'. If we want to change the prefix we can  change it.
From the below window select appropriate schemas which we need to install.
I have selected only two which is showing in the screenshot

Click 'Next' from the above screen to create schema and the click 'OK' once RCU shows schema creation prerequisites check completed.
In the next step Enter password for both the schema as you like with the password conditions (such as alphabet, numeric and with special character) and click 'Next' to continue.
Click 'Next' with the above step to have RCU create the selected schemas
Click 'OK' to continue creation of tablespace.
Once tablespace created, click 'OK' to continue.

Now RCU will create required schema objects within the tablespace just created. So Click 'Create' with next step and continue
Click 'close' to finish RCU wizard once schemas are created successfully.
with the above step the installation of RCU is completed
Note:

Remember the password which we have given for all the  users/schemas so far and we will continue to use the same password. We will need this password for BI installation as well to let BI installer knows where the metadata schemas located and what is the password to connect to the schema. Now we can login to the oracle database and can whether that two schems (DEV_BIPLATFORM, DEV_MDS) is available.

Leave a Comments

Your browser doesn't support the canvas element - please visit in a modern browser.

(new shape)

OBIEE 11g Installation Guide

OBIEE 11.1.1.7.0 Step by Step Installation

This post will guide us through the  step by step installation of OBIEE 11.1.1.7.0. Here I don't find any difference in RCU installation between in previous version with this version. Still if you want to know the RCU installation steps click here

Step1:
Download the OBIEE 11g version from here or from oracle e-delivery site and extract all the four disk into a single folder and click setup.exe from the Disk1 Universal Installer window will start and will check for the initial set up and system requirement.


After the successful precheck the first step of our OBIEE 11.1.1.7.0 starts with the below window. Just Click 'Next'

Step2:
f you have oracle Support username and password then update then use that in this step or just select first option 'Skip Software updates' and click 'Next'

Step3:
Select the appropriate installation step here. I am going to install all the component of BI so selected here 'Enterprise Install' and then click 'Next'

Step4:
This step will just check operating system certification and physical memory. Just click 'Next' after the check passed through

Step5:
As It is a new installation, select the option 'Create New BI System' and type password for weblogic User.
Note: Save or remember the password because this is the password going to be used to access BI system, EM, Console and answers later on..
and then click 'Next'

Step6:
n this step we have to select the actual folder where we want to install BI 11g. So here I have created an folder in C:\ driver and selected here by browsing the home location in this window. Remaining boxes will be automatically filled once we selected the home location then click 'Next'
With the above window we will get warning like below screen. Just Click 'Yes and click 'Next' with the above screen

Step7:
n this step we would know what are the components going to be installed. If you are really going to user 'RTD' and Essbase Suite the leave it selected or Just uncheck with the below screen and click 'Next'

Step8:
n this step we have to select the database where we have installed our RCU. I have done in oracle database so selected the oracle database in database type

Connection String: dbservername:portnumber:servicename
BIPLATFORM Name: DEV_BIPLATFORM
BIPLATFORM Pwd: Admin123

Note: This username and password would be same which we have given when we installed RCU

Step9:
Same steps like the previous step but here with DEV_MDS username and password. After entering all the details just click 'Next'

Step10:
Just Select 'Auto Port Configuration' if you want to install with the default port numbers that oracle do the installation and then click 'Next'

Step11:
f we have oracle support email id we could mention with this step or just deselect the option click 'Yes' with the warning screen and click 'Next' with the below step


Step12:
With this step just click 'Install' so that the actual installation will be started with the below screen:


Step13:
Just watch the installation progress with this step
t take a while even the progress bar shows 100%. Post installation script might be take some time so be patient the steps will pass through.

Step14:
After successful installation the configuration steps will start. It takes a while to finish all the configuration so wait to finish and then just click 'Next' when the configuration shows 100%

Step15:
So actual installation and configuration are over with the above step. If you want to save the path details for middleware home, domain home and others click 'Save' with the below screen and save it in a file for reference. and the just click 'Finish' to complete the installation.

Now browse through the answers, EM and console and Play with BI.

Leave a Comments

Your browser doesn't support the canvas element - please visit in a modern browser.

(new shape)

Archival of old OBIEE RPD File

Archival of old OBIEE RPD File
Every time a modified RPD is promoted through weblogic or WLST and python scripts, a new version of the RPD file get’s created with a version number suffix (for example, SampleApp_bi001.rpd). This version number is incremented each time repository is uploaded. Depending on RPD modification changes, we have seen more than 100 versions of the RPD files in a year in DEV env.

Another major issue we noticed that after certain version number ( Oracle couldn’t provide settings where max version number is set), after promoting new RPD, the version number resets back to some random value and old RPD file get’s deployed.

To avoid old RPD getting deployed and to keep RPD folder (\\\instances\instance1\bifoundation\OracleBIServerComponent\coreapplication_obis1\repository)clean, I have developed a python script which keeps 3 latest versions of RPD and archives rest of the versions.

RPDArichival.py


import shutil
import os

# Change path of the source folder
path="/oracle/middle/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository"

source = os.listdir(path)

largest=None
smallest=None

# Calculate min and max version numbers of the RPD file
# RPD name SampleApp_BI0013.rpd

for files in source:
  if len(files) > 7:
          num=int(files[12:16])
   if largest is None:
        largest = num
    elseif num > largest:
        largest = num

    if smallest is None:
         smallest = num
   elseif num < smallest:
         smallest = num

# Initialize a counter to count number of files moved to archive folder

j=0
# Keeping latest 3 RPD version files
for i in range (smallest, largest-2):
    for files in source:
        if len(files) > 7:
          mmn=int(files[12:16])
         if i == mmn:
               j=j+1
               src = path +"/"+files
               dst = "/oracle/middle/instances/instance1/bifoundation/OracleBIServerComponent/coreapplication_obis1/repository/archive"+"/"+files
                shutil.move(src, dst)
print j, "files are moved"
 

Leave a Comments

Your browser doesn't support the canvas element - please visit in a modern browser.

(new shape)

OBIEE RPD Deployment Automation using WLST

OBIEE RPD Deployment Automation using WLST


Deploying OBIEE RPD using FMW Enterprise Manager is quite slower and time consuming if RPD deployments are frequent. OBIEE RPD deployment can be automated using OBIEE provided WLST (Weblogic Scripting tool ) and custom python scripts.

The python script (deployer.py ) calls WLST to performs below tasks:

  1. Connects to WLST
  2. Locks the System
  3. Uploads the RPD
  4. Commits Changes
  5. Restarts BI Services
deployer.py script:

#
# This scripts expects the following arguments:
#
# 1. wls.host (localhost)
# 2. wls.port (7001)
# 3. wls.user  (user1)
# 4. wls.password  (password1)
# 5. repository filename and location
# 6. repository password
# ===================================================================
 
import sys
import os
 
# Check that the arguments to this script are as expected.
# argv[0] is script name, [1]-[6] are the user parameters

argLen = len(sys.argv)
if argLen -1 != 6:
    print "ERROR: got ", argLen -1, " args."
    print "USAGE: wlst.cmd RPDUpload.py WLS_HOST WLS_PORT WLS_USER WLS_PASSWORD repository_location repository_password"
    print "   eg: wlst.cmd RPDUpload.py localhost 7001 weblogic welcome1 c:\SampleAppLite.rpd Admin123" 
    exit()
 
WLS_HOST = sys.argv[1]
WLS_PORT = sys.argv[2]
WLS_USER = sys.argv[3]
WLS_PW = sys.argv[4]
rpdlocation = sys.argv[5]
rpdpassword = sys.argv[6]

# Connect to the WLS Admin Server, so that the script then runs “online”
 
print 'Connecting to '+ WLS_HOST+ ':' + WLS_PORT + ' as user: ' + WLS_USER + ' ...'
 
connect(WLS_USER, WLS_PW, WLS_HOST+ ':' + WLS_PORT);

# Connect to the BIDomainMBean that controls the BI domain
# We will use this MBean to lock and then commit our config changes

print 'Connecting to Domain ...'
domainCustom()

cd ('oracle.biee.admin')

cd ('oracle.biee.admin:type=BIDomain,group=Service')

# define the MBean parameters and data types as arrays  
 
objs = jarray.array([],java.lang.Object)
strs = jarray.array([],java.lang.String)

# Invoke the lock operation from the BIDomainMBean
# (equivalent to the Lock and Edit Configuration button in 
# Enterprise Manager

print 'Locking the domain ...'

invoke('lock',objs,strs)

# Read the name of the first instance from first entry 
# in the BIInstances property within the BIDomainMBean
# (initially returned as an array, first value selected)

biinstances = get('BIInstances')
biinstance = biinstances[0]

# Connect to the corresponding BIInstanceMBean

print ('Connecting to BIInstance MBean')

cd ('..')
cd (biinstance.toString())

# Retrieve the name of the MBean for managing the 
# BI Server configuration

biserver = get('ServerConfiguration')

# Connect to the ServerConfigurationMBean for this BI Server

cd ('..')
cd (biserver.toString())

# Now prepare for the RPD upload
# Prepare arrays for parameters and datatypes
# Load the parameters with the RPD name and password
# Then invoke the uploadRepository within the ServerConfigurationMBean

print ('Uploading repository ...')

argtypes = jarray.array(['java.lang.String','java.lang.String'],java.lang.String)
argvalues = jarray.array([rpdlocation,rpdpassword],java.lang.Object)

invoke('uploadRepository',argvalues,argtypes)

# Now go back to the BIDomainMBean and commit the change
# (equivalent to the Activate Changes button in Enterprise Manager)

print ('Committing the update ...')

cd('..')
cd('oracle.biee.admin:type=BIDomain,group=Service')
objs = jarray.array([],java.lang.Object)
strs = jarray.array([],java.lang.String)

invoke('commit',objs,strs)

print ('Now restarting the instance, to pick up the new RPD file')

print 'Connecting to BIInstance MBean ...'
cd ('..')
cd (biinstance.toString())

# The BIInstanceMBean controls the overall status of
# the Oracle instance, and if directed to stop or start
# will stop/start all components together

print 'Getting instance status ...'

# ServiceStatus property in BIInstanceMBean returns
# the current status of the instance

servicestatus=get('ServiceStatus')
print 'BIInstance MBean; ServiceStatus: ' + servicestatus

# Stop action, if invoked, will stop entire instance

print 'Calling stop ...'
objs = jarray.array([], java.lang.Object)
strs = jarray.array([], java.lang.String)
invoke('stop', objs, strs)
servicestatus=get('ServiceStatus')

print 'BIInstance MBean; ServiceStatus: ' + servicestatus

# Start action will start the instance, and pick up
# the configuration change (the new RPD file path)

print 'Calling start ...'
objs = jarray.array([], java.lang.Object)
strs = jarray.array([], java.lang.String)
invoke('start', objs, strs)
servicestatus=get('ServiceStatus')

print 'BIInstance MBean; ServiceStatus: ' + servicestatus

print 'RPD Upload now complete!'

exit()

Leave a Comments

Your browser doesn't support the canvas element - please visit in a modern browser.

(new shape)

Lord SAN’s MONEY SPELL services is worth every penny! I honestly don’t know what I would have done without Lord SAN. Even as a manager at my place of work, My daily expenses is more than my in-come therefore subjecting my and my kids to hunger, and sometimes without internet and light went off. I had no choice but to come to this money temple where LORD SAN did a money ritual spell that has turned me to the richest woman in my family linage. I just bought another house for my first daughter as her marriage gift. I have stopped working over 5 months ago since I started getting money from this money spell LORD SAN did for me. I get bundles of dollars twice a week. I do not need my husband anymore he can go to hell with his child support that he never pays.contact email moneytemple@outlook.com You can also Call/Whats App:+447482854279 You can also visit his website:https://thetempleofmoney.com/ 

Reply

EFFECTIVE AND POWERFUL LOVE SPELL CASTER AND LOTTERY SPELL DR.OJOKASPELLTEMPLE@GMAIL. COM OR WHATSAPP HIM :+2348144172934  I am sharing this testimony to partners suffering in their relationships because there is an enduring solution. My husband left me and our 2 kids for another woman for 3 years. I tried to be strong just for my kids but I could not control the pains that torment my heart. I was hurt and confused. I needed a help, so i did a research on the internet and came across a site where I saw that Dr. Ojoka a spell caster, can help get lovers back. I contacted him and he did a special prayer and spells for me. To my surprises, after some days, my husband came back home. That was how we reunited again and there was a lot of love, joy and peace in the family. You can as well contact Dr. Ojoka , a powerful spell-caster for solutions on his contact dr.ojokaspelltemple@gmail. com or directly on Whats App: +2348144172934

Reply

We need your help with supplies. Our family is out of sanitizers and we can't find any in the usual places. I can get surgical masks at https://freelytrade.com Please sell your extra supplies there? We'll pay whatever the fair going rate is for it! You'll save our lives and our neighbourhood today! Stay safe Meridith

Reply

Hi I am Hiren Patel. Basically, I am Computer Engineer with some sort of crazy interest in playing around with the new technology and tools. I believe that innovation is the most important thing that drives our life.

Copyright © 2020 Hiren Patel . All rights Reserved.