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

How to download Oracle Software directly in Servers using wget.sh file | How to download using wget.sh file

I often wonder that how do we download GB size of oracle softwares and move it server and Install the same until I get to know how simple is that downloading any size of software using wget.sh shell script file directly in server.

Steps are very Simple. But as a first thing, Create/Have an Oracle account for You!

Step1:

Either Oracle eDelivery or Support.oracle.com, get the wget.sh file for the software that you would like to download

Download .sh and move the file to server where you want to download.

Step2:

Open shell scripts or command prompt just run the below command

[$] ./wget.sh

enter your username: bose.obiee@gmail.com + enter

[type your password] + enter

Note:

i. Enter the same username and password which you used to download the software

ii. After entering the username, just enter it 

iii. Second line will be blank but enter the oracle account password and click enter

iv. Check if you have proper privileges with read+write+execute permission in the target directory             when you are downloading.

If it is a bigger a software then it would take sometime based on the network speed in server and will complete the download.

Happy Blogging!

Bose

OBIEE 12c Lift and Shift

When we are doing the lift and shift of OBIEE 12c, We would be copying the entire OBIEE 12c installed directory to the new server. 

When we are doing this change, We have to complete prerequisite check first and then we have to update the hostname and IP Address of the new server in the following locations in OBIEE 12c files.

Following are the file locations and file names for two Node clustered Servers:

Node1

Update the IP address in startup.properties file in the following locations.

/OBIEE12C/user_projects/domains/bi/servers/bi_server1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server3/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server5/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBICCS/obiccs1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIJH/obijh1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIPS/obips1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBISCH/obisch1/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIS/obis1/data/nodemanager

Update IP address of the new server in nodemanager.properties file in below location

/OBIEE12C/user_projects/domains/bi/nodemanager

Update IP address of the new server in  config.xml file in below location

/OBIEE12C/user_projects/domains/bi/config

Update IP address of the new server in admin.conf  file in below location

/OBIEE12C/user_projects/domains/ohs/config/fmwconfig/components/OHS/instances/ohs1

Update IP address of the new server in wsm-ccw-config.xml file in below location

/OBIEE12C/user_projects/domains/bi/config/fmwconfig

Node2:

Update the IP address in startup.properties file in the following locations.

/OBIEE12C/user_projects/domains/bi/servers/bi_server2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server4/data/nodemanager

/OBIEE12C/user_projects/domains/bi/servers/bi_server6/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBICCS/obiccs2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIJH/obijh2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIPS/obips2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBISCH/obisch2/data/nodemanager

/OBIEE12C/user_projects/domains/bi/system_components/OBIS/obis2/data/nodemanager

Update the IP address in nodemanager.properties file in the following location.

/OBIEE12C/user_projects/domains/bi/nodemanager

Update the IP address in config.xml file in the following location.

/OBIEE12C/user_projects/domains/bi/config

Update the IP address in  admin.conf file in the following location.

/OBIEE12C/user_projects/domains/ohs/config/fmwconfig/components/OHS/instances/ohs2

Update the IP address in wsm-ccw-config.xml file in the following location.

/OBIEE12C/user_projects/domains/bi/config/fmwconfig

Cheers!

Bose

OBIEE 12c BIPLATFORM / MDS Account Password Expired or Account locked

I have recently come across an issue where few of our BI components went down and while stopping/restarting the services, It prompts for weblogic User Name and Password and also failing to start the services.

I have started analyzing the AdminServer log files in OBIEE 12c where I found the issue details like

[jdbc:oracle:thin:@//biapp:1521/bidev]

caused by java.sql.SQLException: ORA-28001: the password expired.

Then I understand that the supporting schemas like MDS, BIPLATFORM, IAU, OPSS and etc., accounts are expired in database. Here is the steps that how I have resolved that.

Step1: Connect to oracle database as a sys user and run the below query to get the expired accounts.

SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE ACCOUNT_STATUS LIKE 'EXPIRED%';

Above query will result all the expired account details.

OR

SQL> SELECT USERNAME,ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME LIKE 'DEV_%'

Above query will result all the accounts starting with the name 'DEV_'

 

If you see the above screenshot, 6 accounts are expired. Lets start fixing it.

Step2: First we have to get the existing password for the expired accounts. For that run below query.

SQL> SELECT USERNAME, PASSWORD FROM DBA_USERS WHERE USERNAME = 'DEV_BIPLATFORM';

This query will give the password for only DEV_BIPLATFORM account. same like, get the password for all the accounts.

Step3: Reset the password for the account

SQL> ALTER USER DEV_BIPLATFORM IDENTIFIED BY 'Admin123';

Step4: (Optional: If any account is locked)

SQL> ALTER USER DEV_BIPLATFORM ACCOUNT UNLOCK;

Step5: Disable Password expiry

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Note:

If you need to know the Profile name , then Please run the below Query:

SYNTAX: 

SELECT PROFILE FROM DBA_USERS WHERE USERNAME = '<USERNAME>';

E.G: 

SELECT PROFILE FROM DBA_USERS WHERE USERNAME = 'DEV_BIPLATFORM';

OBIEE 12c File Locations

If you wonder, where are RPD, Catalog and all the other locations in OBIEE 12c. Here is the path to few files:

Live RPD Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/bidata/service_instances/ssi/metadata/datamodel/customizations

Catalog Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/bidata/service_instances/ssi/metadata/content

To Start, Stop or Start and Deploy RPD BI Sevices [start.sh, stop.sh, status.sh, datamodel.sh]:
[ORACLE_BI_HOME]/user_projects/domains/biee/bitools/bin

To Start/ Stop Weblogic Server, NodeManager 
[startNodeManager.sh, stopNodeManager.sh, stopWeblogic.sh, startWeblogic.sh]:
[ORACLE_BI_HOME]/user_projects/domains/biee/bin

InstanceConfig.xml Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/OBIPS

NQSConfig.INI Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/OBIS

ssl Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/biconfig/core/ssl

ODBC.ini Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/bienv/core

obis.properties Path:
[ORACLE_BI_HOME]/user_projects/domains/biee/config/fmwconfig/bienv/OBIS

Catalog Manager:
[ORACLE_BI_HOME]/bi/bifoundation/web/catalogmanager

Cheers!
Bose