X

Oracle Customer Engineering & Advocacy Lab (CEAL) Blog covers BI Tech, EPM, BI Cloud and EPM Cloud.

OBIEE 11.1.1 - Tuning Guide Script v1

The obiee tuning guide available here https://blogs.oracle.com/proactivesupportEPM/entry/wp_obiee_tuning_guide lists a number of checks for optimization.

The script attached here //cdn.app.compendium.com/uploads/user/e7c690e8-6ff9-102a-ac6d-e4aebca50425/f4a5b21d-66fa-4885-92bf-c4e81c06d916/File/861e8391c6334e32f4038fc42b47b8c7/checkobieetuningguidev4_01_2014.zip automates these checks. It is only reading from the obiee server and it will not modify any values. The script outputs the current values, that you can compare with the recommended ones.

 Usage:
* copy the python script and tuningGuide.properties in a folder on the obiee server. This machine contains an oracle_common/common/bin/wslt.sh (.cmd)
* Modify tuningGuide.properties

WLUsername  weblogic console administrator username
WLPassword  weblogic console administrator password
WLstUrl  weblogic WLST url to connect to weblogic console. Example: t3://adminserver:7001
httpdconf  Location of Oracle Http Server httpd.conf file (if no OHS, leave default). Example: /oracle/user_projects/epmsystem1/httpConfig/ohs/config/OHS/ohs_component/httpd.conf
sslconf Location of Oracle Http Server SSL configuration file. Example: /oracle/user_projects/epmsystem1/httpConfig/ohs/config/OHS/ohs_component/ssl.conf
mod_wl_ohsconf Location of Oracle Http Server weblogic proxy plugin configuration file. Example: /oracle/user_projects/epmsystem1/httpConfig/ohs/config/OHS/ohs_component/mod_wl_ohs.conf
tcp_fin_timeout Unix tcp parameter. Example: /proc/sys/net/ipv4/tcp_fin_timeout
tcp_max_syn_backlog Unix tcp parameter. Example: /proc/sys/net/ipv4/tcp_max_syn_backlog
limitsconf Unix tcp parameter. Example: /etc/security/limits.conf
solarissystem /etc/system
essbase_cfg  Location of essbase.cfg file. Example: /oracle/biee/instances/instance1/Essbase/essbaseserver1/bin/essbase.cfg
essbase_application_log  Location of the Essbase application log you want to check. Example: /oracle/biee/instances/instance1/diagnostics/logs/Essbase/essbaseserver1/essbase/app/BISAMPLE/BISAMPLE.log

OHS or Essbase values are ignored if not found.

Unix config values are ignored when windows server is detected.

* Launch the script from the folder containing the properties file. Open a shell:

export ORACLE_HOME=/oracle/Middleware/Oracle_Home

$ORACLE_HOME/oracle_common/common/bin/wlst.sh CheckObieeTuningGuidev4_01-2014.py

* Review the output

Be the first to comment

Comments ( 0 )
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.Captcha
Oracle

Integrated Cloud Applications & Platform Services