Batch file for clearing OracleBIServer cache OBIEE 11g on windows

1. Open a text file and paste the below code

call sapurgeallCache();

2. Save the file as purgecache.txt and place it into the location  %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\

3. Now open another text file and paste the below code

@echo off

set ORACLE_HOME=C:\oracle\middlewarehome\Oracle_BI1

set ORACLE_INSTANCE=C:\oracle\middlewarehome\instances\instance1

set ORACLE_BI_APPLICATION=coreapplication

set JAVA_HOME=C:\oracle\middlewarehome\instances\instance1

set ESSBASEPATH=%ORACLE_HOME%\clients\epm\Essbase\EssbaseRTC

call %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\bi-init.cmd

call %ORACLE_HOME%\bifoundation\server\bin\nqcmd -d coreapplication_OH829890363 -u weblogic -p welcome1 -s %ORACLE_INSTANCE%\bifoundation\OracleBIApplication\coreapplication\setup\purgecache.txt

pause

Here 

coreapplication_OH829890363 : DSN name 

4. Save the file as purgecache.bat

5. Double click the bat file and it will clear the cache

Batch file for copying files from windows to linux without prompting for username and password

General syntax for copying a file from windows to linux:

1. On windows open command prompt and issue below command

here servername : linux host name or ip address

2. It will ask for username and password and ones they provided connects to linux machine

3. Issue below command to copy a file from windows to linux





It will copy 1.txt file to linux machine

4. To copy multiple files issue the below command






It will copy all the files to linux machine

Note1: Top copy files from a directory , first navigate to that directory in command prompt and then ftp to linux machine and then issue put and mput commands

Note2: Through ftp we can copy files only.

Batch file for copying files from windows to linux without prompting for username and password:

1. Open a text file on windows and paste the below code in it

@echo off

REM Make a text file with username , password and ftp command

echo username>> test.txt

echo password>> test.txt

echo mput * %1>> test.txt

echo quit>> test.txt

REM Ftp to linux machine by passing the test.txt file

ftp -n -s:test.txt servername

REM Deleting the test.txt file

del test.txt

pause

Here 

username : user name of the linux machine

password: password of the linux machine

servername : linux machine host name or ip address

2. Save the file with .bat extension

3. Double click the bat file and it will copy the files to linux machine

How To Disable Sort And Move Columns Functionality In Dashboards OBIEE

To Disable Sort and Move Columns, follow the steps below:

1. Create the Analysis.
2. Go to Results.
3. Click on 'Edit Analysis Properties'.
4. In the Analysis Properties Page, click on Interactions tab.
5. Uncheck the options: 'Move Columns', 'Sort Columns' and Click OK

6. Sort is now disabled

Steps for migrating OBIEE 11g to OBIEE 12c (Bundle Migration)

1. Install and configure obiee 12c
2. Generate bi-migration-tool.jar file in obiee 12c as below
$ cd $ORACLE_HOME/user_projects/domains/bi/bitools/bin
$ ./migration-tool.sh package bi-migration-tool.jar
3. Copy the generated bi-migration-tool.jar file to the obiee 11g server
4. Export the bundle on obiee 11g server as below

5. Copy the exported bundle file "obiee1.jar" to the obiee 12 server
6. Stop all the servers and services on obiee 12c before starting the import using stop.sh command
7. Import the bundle into 12c server as below
$ cd $ORACLE_HOME/user_projects/domains/bi/bitools/bin

We need the enter the rpd password and we will get a succeed message ones migration got completed successfully
8. Start the servers and services using start.sh command

Shell script for getting an Alert Mail if the Disk Usage reaches 90% of space Linux

Prerequisites:

Any one of the below mail utility must be present on the linux server

1. sendmail

2. mail

3. mutt

4. ssmtp

5. telnet

1. Below script will send an alert mail if the disk usage space of a directory in linux server reaches 90%

In this script I used "mail" utility for sending alert mails

ADMIN="lravikumarvsp@gmail.com"

ALERT=90

message=$(df -h | awk -v ALERT="$ALERT" '

    NR == 1 {next}

    $1 == "abc:/xyz/pqr" {next}

    $1 == "tmpfs" {next}

    $1 == "/dev/cdrom" {next}

    1 {sub(/%/,"",$5)}

    $5 >= ALERT {printf "%s is almost full: %d%%\n", $1, $5}

')

if [ -n "$message" ]; then

  echo "$message" | mail -s "Alert: Almost out of disk space" "$ADMIN"

fi

2. Below script will send an alert mail if the disk usage space of the root partition in linux server exceeds 90%

#!/bin/bash

CURRENT=$(df / | grep / | awk '{ print $4}' | sed 's/%//g')

THRESHOLD=90

if [ "$CURRENT" -gt "$THRESHOLD" ] ; then

    mail -s 'Disk Space Alert' lravikumarvsp@gmail.com << EOF

Your root partition remaining free space is critically low. Used: $CURRENT%

EOF

fi

How to enable Auto-Complete search for Prompts OBIEE Analysis

To enable auto-complete for prompts add the below tag in instanceconfig.xml file

1. Navigate to the below path

OBIEE 12c :

$ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/

OBIEE 11g :

$MW_HOME/instances/instance1/config/OracleBIPresentationServicesComponent/coreapplication

2. Open the instanceconfig.xml file

3. Add the below in <ServerInstance></ServerInstance> tag

<Prompts>

<MaxDropDownValues>1000</MaxDropDownValues>

<AutoApplyDashboardPromptValues>true</AutoApplyDashboardPromptValues>

<AutoSearchPromptDialogBox>true</AutoSearchPromptDialogBox>

<AutoCompletePromptDropDowns>

<SupportAutoComplete>true</SupportAutoComplete>

<CaseInsensitive>true</CaseInsensitive>

<MatchingLevel>MatchAll</MatchingLevel>

<ResultsLimit>1000</ResultsLimit>

</AutoCompletePromptDropDowns>

</Prompts>

4. Save and close the file

5. Restart the obiee components

6. Login to OBIEE with the Admin user

Go to My Account 

Change Prompts Auto-Complete to “On”

Click OK

7. Now check in the prompts auto search will work

STEP BY STEP CLOUDERA HADOOP INSTALLATION WITH 4 NODES ON LINUX

1. Setting prerequisites on linux server
2. Downloading and installing cloudera manager
3. Installing Hadoop

 Setting prerequisites on linux server:

1. Login to linux server as a root user
2. Stop iptables using below command
#chkconfig  --list iptables       
#chkconfig  --level 0123456 iptables off
3. Disable firewall
#service iptables stop
4. Edit the /etc/hosts file and add all the 4 nodes information in it
# vi /etc/hosts

5. Install jdk1.6 or jdk1.7 and set java home and path variables
6. Install python and all its packages
# yum install python*

Note : Like above prepare all the 4 nodes

Downloading and installing cloudera manager:

1. Download the cloudera manager software by using wget command as below
# wget  http://archive.cloudera.com/cm4/installer/latest/cloudera-manager-installer.bin
2. Give full permissions to the downloaded software
3. Start the cloudera manager installation by running the command as below
# ./cloudera-manager-installer.bin
4. In the cloudera manager read me screen click next

5. In the cloudera manager license screen click next

6.  To accept the license click yes

7. In the oracle binary code license agreement screen click next

8. To accept the license click yes

9. In the installing screen we can see the cloudera manager installation progress

10. In the next step screen find the cloudera manager login details and click ok

11. In the finish screen click ok to complete the installation

Installing Hadoop:

1. Now we are going to install hadoop using cloudera manager
2. Login to cloudera manager , default user name and password is "admin"

3. For cluster environment select cloudera enterprise trail or cloudera standard and click continue

4. Review the distribution screen and click continue

5. In the specify hosts for cdh screen, specify the hostnames and ip addresses of the nodes we want to add in the cluster

6. Add all the nodes and click on search to check whether nodes are ready or not and then click continue

7. Select the packages we want to install and click continue

8. Select the latest cdh4 release and click continue

9. Select none for impala and soir as they are going to consume lot of ram, we are not installing them now. If we have more ram we can select them also.

10. Leave default for cloudera agent and click continue
11. Provide the root user details and click continue

12. Cloudera hadoop cluster installation starts now

13. After successful completion of cluster installation click continue

14. In the next screen choose the service we want to install for cluster and click continue

15. In the next screen check which services will be install on which node and click continue

16. Select the database type and provide the database details and click on test connection

17. If all the connections got succeeded click continue

18. In the next screen review all the configurations and click continue

19. All the services will start now and it will take some time

20. When all the services were started successfully click continue

21. We will get the success screen now

22. Now login as user 'admin' in Cloudera manager and we can see our clusters running successfully in our environment