Oracle Business Intelligence Applications (OBIA) 11.1.1.10.3 is available for Download

Oracle has released the latest version of OBIA - Oracle Business Intelligence (BI) Applications 11.1.1.10.3.

What's New:

BI Applications with OBIEE 12c

ODI 12c

Look Oracle Blog Here for More Details

Upgrade Overview

Cheers!

Bose

Oracle Database 12c Step by Step Installation in Windows.

With this post, I am sharing oracle database 12c Release 2 installation in windows. I have downloaded Oracle Database 12c software which is around 2.8GB from oracle Site.

File Name: winx64_12201_database

Extract the software zip file and go to the extracted folder and double click on setup.exe file to start the DB installation.

Oracle Universal Installer checks the system prerequisite and will start the installation window. 

Uncheck 'My oracle Support' and click 'Next'

When it prompts the below window, Click 'Yes'

Select 'Create and configure a database' and click 'Next'

I have selected 'Server class' and clicked 'Next'.

Since I want to check all the feature of this database 12c, I installed with 'Server Class'. We could go with 'Desktop Class' which is light and easy. Server class is heavy and takes 6 GB disk space.

Select 'Single instance database installation' and click 'Next'

Select 'Typical Install' and click 'Next'

Select the Oracle Base folder if you have your folder to install Oracle DB 12c. I have 'DB12c' in D drive. If we select the base path, all the other path will be loaded automatically.

In this step, enter database password and remember it.

Check 'Create as container Database' and Keep pluggable DB. because pluggable DB is required for all our RCU installation required for OBIEE later.

Finally Click 'Next'

Installer will run the prerequisite checks..

With this step, We could save the response file which could be used to silent install for other environments.

Click 'Install'

It would take some time to complete the installation. 

Oracle DB installation is in progress....

Oracle DB 12c is successfully installed. Just click 'Close' to complete the installation.

Now check all the services and connect to DB. Ready to rock an roll :)

Cheers! Bose

Automating the BAR Backup in a script file in OBIEE 12c

Following script will be put into exportarchive.sh files and added to the cronjob in linux server to run and export archive file everyday for backup.

exportarchive.sh

================================================

#!/bin/bash

folderName= `date +%Y%m%d`

export SCRIPT_PATH=/obiee12c/scripts

export DOMAIN_PATH=/obiee12c/user_projects/domains/bi/bitools/bin

export EXPORT_DIR=/obishare/barbackup/migration

MAIL_TO=bose.obiee@gmail.com,xyz@gmail.com,abc@gmail.com

#MAIL_TO=bose.obiee@gmail.com,xyz@gmail.com,abc@gmail.com

mkdir -p $EXPORT_DIR/$folderName

echo "Running the export archive script"

echo "Exporting............................."

$DOMAIN_PATH/exportarchive.sh ssi $EXPORT_DIR/$folderName encryptionpassword=admin123 >> $EXPORT_DIR/$folderName/export.log

SUCCESS_COUNT=`grep "Export archive completed successfully" $EXPORT_DIR/$folderName/export.log | wc -l`

if  [ "${SUCCESS_COUNT}" -eq "l" ]

then

echo -e "Hi Team, \nThe export of BAR in `hostname` is completed and the export is available in ${EXPORT_DIR} \n\nThanks" | mail -s "BAR export is completed successfully in `hostname`" ${MAIL_TO}

else

echo -e "Hi Team, \nThe export of BAR in `hostname` is  not completed and the export log is available in ${EXPORT_DIR} \n\nThanks" | mail -s "BAR export has failed in `hostname`" ${MAIL_TO} -a $EXPORT_DIR/$folderName/export.log  ${MAIL_TO}

exit

fi

#Cleaning BAR files which are older than 7 days

find ${EXPORT_DIR} -name "20*" -type d  -mtime +7 -exec rm rf  {} \;

==========================================

How to tar/untar , zip/unzip a file or directory in Linux Server

Frequently working in BI Administration, we would work on packing/unpacking the tar and zip files for installation, patching or packing the old files as backup. This command is handy and useful:

To Unpack/Untar the tar.gz file:

syntax: tar - xvzf <zip_or_tar.gz_file_Name>

e.g.: tar -xvzf  java8u251.tar.gz

The above command will untar  the java8u251.tar.gz file.

To Pack/Tar the file or directory:

Syntax: tar -cvzf <target_file_name> <source_file_Or_Directory_Name>

e.g.: tar -cvzf  jdk1.8_241.tar.gz  jdk1.8_241

How to unpack .zip file:

Unzipping in the same directory where the zip file is:

Syntax: unzip <Source_Zip_File>

e.g: unzip music.zip

Unzipping the file to a particular directory:

Syntax: unzip <source<zip_file> -d <target_directory_to_unzip>

e.g: unzip music.zip -d \home\music

How to pack .zip file:

zipping the directory:

Syntax: zip -r <target_zip_file_name> <Source_Directory>

e.g: zip -r music.zip /home/music

Zipping a file

zip names.zip names.txt

How to Unpack .zip file:

Unzipping the file to a particular directory:

Syntax: unzip <source<zip_file> -d <target_directory_to_unzip>

e.g: unzip music.zip -d /home/music

To unzip within the same directory, use the without -d

unzip music.zip

You can encrypt .zip with a password by passing the -e option:

zip -r -e music.zip /home/music

Verify file with the ls command:

ls -l music.zip

This is the meaning for each letter in -xvzf or cvzf 

• -x: Extract, retrieve the files from the tar file.
• -v: Verbose, list the files as they are being extracted.
• -c: Create, Create a tar or zip file
• -z: Zip, use gzip, zip or tar.gz to decompress the tar file.
• -f: File, the name of the tar file we want tar to work with. 

Cheers!

Bose

OBIEE 12c Client Tool step by step installation

Here is the steps on how to download and Install OBIEE 12c client tool installaton.

Download Link: 

https://www.oracle.com/in/middleware/technologies/business-intelligence-v12214-downloads.html

Go to Oracle Business Intelligence Developer Client Tool (12.2.1.4.0) section and download the client tool.

once Downloaded, Copy into a new folder and unarchive/unzip  the zip file.

Step1: 

Double click on the 'setup_bi_client-12.2.1.4.0-win64' file and the installation window will open

Step2:

Oracle Universal Installer Window will open. Just Click 'Next'

Step3:

Check the default selected folder is good to install or create your folder and select the folder here to install and click 'Next'

Step4:

The actual installation starts here. Just Click 'install' to install OBIEE Client 12c. 

Note: If you want to save the details, you could click and save the responsible file.

Step5: 

Installation will progress and completes the client tool installation. Just click 'Next'

Step6:

Click 'Finish' to complete the installation.

To Verify the client is installed in windows machine whether correctly or not, verify below

Start -> Programs ->  Oracle Business Intelligence Client.

Happy Blogging!

Cheers!

Bose

Use the validaterpd Utility to Check Repository Consistency

In a development a project, we are deploying RPD multiple times and checking the RPD consistency after each deployment would be task.

We could use the Oracle BI Server validaterpd utility to check the validity of all metadata objects in a repository in command prompt.

Running this utility performs the same validation checks as the Consistency Check Manager in the Administration Tool.

The validaterpd utility is available on both Windows (validaterpd.cmd) and Linux (validaterpd.sh) systems. 

The location of the validaterpd utility is:

$BI_DOMAIN/bitools/bin

Syntax

****************

The validaterpd utility takes the following parameters:

validaterpd {-R repository_name | -I input_file_pathname |-D MDS_XML_document_directory} [-P repository_password] {-O output_txt_file_name |-C output_csv_file_name | -X output_xml_file_name} [-8] [-F fixed_rpd_name|-E] [-S] [-B]

Where:

repository_name is the name and path of the binary Oracle BI repository file that you want to validate.

input_file_pathname is the name and path of the XML input file that you want to validate.

MDS_XML_document_directory is the location of the input MDS XML documents.

repository_password is the password for the repository that you want to validate.

The repository_password argument is optional. If you don't provide the password argument, you're prompted to enter the password when you run the command. 

output_txt_file_name is the name and path of a text(.txt or .log) file where the validation results are recorded.

output_csv_file_name is the name and path of a csv file where the validation results are recorded.

output_xml_file_name is the name and path of an XML file where the validation results are recorded.

Examples

******************

The following example generates an output file called results.log that contains validation information for the repository called repository.rpd

You must provide the full path names to your repository files, both the input files and the output files, if they're located in a different directory.

./validaterpd.sh -R /home/bose/repository.rpd -O /home/bose/repository.log

Repository password: Type_Your_Repository_Password

The following example generates an output file called results.csv that contains validation information for the repository contained in the MDS XML documents located at C:\MDS_dir:

./validaterpd.sh -D C:\MDS_dir -C results.csv

Give password: my_rpd_password

Just run head -n10 of the output text, log, csv or XML file to see the first 10 lines of the results. We are good with the deployed repository if there is no errors.

$ head -n10 /home/bose/repository.log

Cheers!

Bose

Automated Cache purging in OBIEE 12c

In this post We are going to create a shell script which will purge all the cache in OBIEE. This file could  be scheduled in a cronjob OR added in informatica or ODI to run everyday once all the loads are completed or Run manually whenever you would like to run.

Step1: Create purgecache.txt file like below

Purgecache.txt
call SAPurgeAllcache()

Step2: Create a shell script to call the above file and clear the purge.

****************************************************************************************

#purgeCache12c file is created for clearing BI 12c cache#

#File Name - purgecache.sh

#!/bin/bash

#OBIEE12c Home Location

export MW_HOME=/OBIEE12c

#Location of the Purgecache script file

export SCRIPT_PATH=/OBIEE12c/scripts/purgeCache

# Timestamp for Log file creation

TIME_STAMP=`date '+%Y%m%d_%H%M'`

#Log File directory and filename creation

export LOG_FILE=$SCRIPT_PATH/purgecache_${TIME_STAMP}.log

#Mail Group that you want to send (Optional)

MAIL_LIST="#bisupport@oracle.com"

#Command to clear BI Server Cache

$MW_HOME/user_projects/domains/bi/bitools/bin/nqcmd.sh -d AnalyticsWeb -u weblogic -p weblogicpwd -s $SCRIPT_PATH/purgecache.txt -o $LOG_FILE;

# Finding Purge cache Line Count for Cache Clear success or Fail

line_cnt=`cat $SCRIPT_PATH/purgecache.txt|wc -l`

SUCCESS_FLG=`grep -E 'Operation SAPurgeAllCache succeeded' $LOG_FILE|wc -l`;

if [ $SUCCESS_FLG = $line_cnt ]

then

        echo "Cache Cleared Successfully " >> $LOG_FILE

        echo `hostname` >> $LOG_FILE

        mailx -s "Cache Clearance Successful on `hostname`" $MAIL_LIST < $LOG_FILE

else

        echo "Cache clearance Failed" >> $LOG_FILE

        mailx -s "Cache Clearance Failed on `hostname`" $MAIL_LIST << EOT

        GCWUAT Cache clearance Failed, please verify

EOT

fi

#Command to Delete the log files which is older than 5 days

find $SCRIPT_PATH/ -name "*.log" -type f -mtime +2 -exec rm -rf {} \;

**************************************************************************************

Note:

MW_HOME environment variable value should be updated based on you BI 12c environment.

You can test this script file by running manually once in your environment by the below command.

./purgecache.sh

Happy Blogging!

Bose