Info Imply@Ravi: OBIEE12C

Showing posts with label OBIEE12C. Show all posts

Friday, June 23, 2017

PERFORMANCE TUNING OBIEE 12C

Please find the steps below to increase the performance of obiee 12c :

1. Tuning Hogging and Stuck Threads

Hogging and stuck threads are generated by the managed servers from time to time and system health changes from OK to Warning at which point performance is slow.

If the server gets too many Hogging Threads/Stuck Threads it will transition to critical status, performance will be poor and application will fail.

So it is recommended to increase the threshold to avoid long running threads to be considered stuck and also to improve the performance.

These values can be modified in the WLS console under Tuning section of managed and admin servers.

Go to summary of servers

Click on Admin Server

Under configuration tab click on Tuning

Change the parameters as below

Click on Save and then Click on Activate Changes

Like this Increase the parameters for Managed servers also

Restart the obiee servers using stop.sh and start.sh

2. Increasing the connection pool capacity in data sources

Allows more pre-established connections to exist reducing connect time to the database which improves performance.

Need to update in weblogic console.

Click on Services and then Click on Data Sources

Click on Data Source Name and then under Configuration tab click on Connection Pool

Change the Maximum Capacity value from minimum value to 500

Click on Save and then Click on Activate Changes

Like this increase the value for remaining data sources also.

3. Tuning Heap usage and Java Virtual Memory (JVM)

Based on Oracle recommendations need to increase the heap usage to increase the amount of available memory to JVMs that the weblogic servers will use and test performance.

By default the obiee configuration for 64 bit linux will allocate a minimum heap of 256 MB and a maximum heap of 1024 MB.

Allocate 8192 MB to both minimum and maximum heap size.

To change the Java arguments modify the below line:

Bi server heap size :

Browse to $ORACLE_HOME/user_projects/domains/bi/bin and backup the file setStartupEnv.sh and then edit setStartupEnv.sh and update the parameter values inside the section “${STARTUP_GROUP}” = “BISUITE-MAN-SVR”

Admin Server heap size :

Browse to $ORACLE_HOME/user_projects/domains/bi/bin edit setStartupEnv.sh and update the parameter values inside the section “${STARTUP_GROUP}” = “AdminServerStartupGroup”

Startup parameters for servers without any associated STARTUP_GROUP :

Browse to $ORACLE_HOME/user_projects/domains/bi/bin edit setStartupEnv.sh and update the parameter values inside the section “${STARTUP_GROUP}” = “ ”

4. Tuning weblogic server node manager java heap size

In BI 12c , Weblogic Server Node Manager is monitoring not only weblogic managed servers but also BI System Components.

When starting all the BI processes using start.sh , Node Manager may take longer time to start, so it is recommended to increase the java heap size of Node Manager.

Browse to $ORACLE_HOME/oracle_common/common/bin , take the backup of the file commBaseEnv.sh and edit MEM_ARGS parameter values in the file commBaseEnv.sh

To higher values according to available physical memory on the system

5. Improve performance of exporting large data set via excel

OBIEE supports native Excel format which reduces the exported file size.

In order to improve to excel download time , the following tuning steps for the java host process should be performed

Browse to $ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH and take the backup of file config.xml and then edit the config.xml file by modifying InputStreamLimitInKB value.

Browse to $ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH and take the backup of file xdo.cfg and then edit the file xdo.cfg by adding the below tag

<property name=”xlsx-keep-values-in-same-column”>true</property

6. Unattended sessions auto time out

What we have been noticing is that users who fire long running queries and maybe out of frustration , “X” out of the application. By doing so , the Teradata SQL query from the report does not get terminated.

Teradata does not know that these users have closed their browsers.

We are adding a parameter in OBIEE that will send a terminate signal to Teradata when users “X” out.

Oracle recommends adding the parameter below to the instanceconfig.xml file to fix this

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

And add the below tag

7. Increasing size of the cache directories

Need to increase the size of the server cache directories as they were getting filled up on a regular basis.

Browse to $ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIS and edit NQSConfig.INI to add and change the size of cache directories.

8. Adding stuck threshold parameter in bridgeconfig.properties file

Browse to $ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig and open bridgeconfig.properties and add the parameter “oracle.bi.presentation.sawconnect.ConnectionPool.MaxConnections=512” and save it and restart bi server

Saturday, June 17, 2017

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

Sunday, June 11, 2017

How To Disable Sort And Move Columns Functionality In Dashboards OBIEE

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

Create the Analysis.
Go to Results.
Click on 'Edit Analysis Properties'.
In the Analysis Properties Page, click on Interactions tab.
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