Objective :

As the admin server , managed server and presentation server components are three pillars in the OBIEE system , the document shows steps that may enhance the startup performance of OBIEE server on production environment.

Note:

Please make sure to backup the whole environment (oracle home directory on OBIEE server) , prior start applying the action plan below

Action Plan :

The following steps may enhance the startup performance of the OBIEE server :

1-Increase Admin Server Java Heap :

cd /app/oracle/middleware/oracle_home/user_projects/domains/bi/bin

cp setDomainEnv.sh setDomainEnv.sh.bkup

 

edit setDomainEnv.sh :

alter the following line :

set WLS_MEM_ARGS_64BIT=-Xms2048m -Xmx2048m

 

2-Increase the managed server java heap

In the left pane of the console, expand Environment > Servers.

In the Servers table, click the name of the server instance you want to configure.

On the Configuration tab, click Server Start. In the Arguments field,

specify the Java option to increase the heap size:

-Xms2048m -Xmx2048m

 

-Enter the weblogic user password twice in the bottom of the page

-Save

-Activate Changes

 

3-It is advisable that OBIEE prd (current repository) should be trimmed to include only the required necessary semantic objects (on 3 layers) , failing to do so will affect the server

Using prunrpd utility command to delete unwanted objects :
https://docs.oracle.com/middleware/12212/biee/BIEMG/GUID-630B6ED6-2D17-4A77-AA12-B195676B1CF7.htm#GUID-630B6ED6-2D17-4A77-AA12-B195676B1CF7

startup do to having to load all the objects and relations :

-open the obiee admin client in online mode

-save the rpd as a copy (to a safe backup place with the correct timestmap)

-remove the un-necessary repository objects

-check consistency , make sure there are no errors

-save & exit

-Restart all services using the command lines : stop.sh and start.sh:

cd /app/oracle/middleware/oracle_home/user_projects/domains/bi/bitools/bin

./start.sh

./stop.sh