Vertically scaling the Java Host component in OBIEE 12c

You can change the number of Oracle Business Intelligence system components and managed servers to suit capacity requirements.

You should first configure shared files and directories for clustered components to use

1. Setting up shared files and directories

2. Set up global cache in em console

You can change the number of BI System components to suit capacity requirements.

Adding System Components:

You can add BI System Components to a computer when the system is stopped (offline).

Assumptions:

You must have appropriate file system permissions.

Ports are allocated from the Oracle Business Intelligence port range, unless otherwise specified.

Supported system component types are OBIPS (BI Presentation Server), OBICCS (Cluster Controller), OBIJH (BI JavaHost), and OBISCH (BI Scheduler).

OBIS is not scaled out because OBIS instances are managed as part of service instances.

You can only create two instances each of the component types OBICCS, OBISCH (one active, one passive). Therefore, if it is required to add another instance on another host, then an existing instance must first be removed.

Steps for Adding a System Component OBIJH :

1.       Now browse to $ORACLE_HOME/oracle_common/common/bin and run wlst.sh command

$ ./wlst.sh

2. Under wlst prompt run the below commands to add a new system component

wls:/offline> connect('weblogic', 'password', 't3://localhost:9600')

3. Now Run edit and start edit commands

4. Now run the below command to create system component

5. Save and activate the changes with below commands

6. Now start the servers using start.sh

7. Login to em console and check for the newly created component

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