Category: OBIEE

  • Check Node Manager Script

    Hi Again, I just knocked up this nodemanager check script that you can run as a cron job making sure the Weblogic Java NodeManager is running and if not email you. See below for the script. The script can be changed if you use a script based nodemanager, if you change ‘jps’ for ‘ps -ef’…

  • Adding Colour to Solaris 10

    I have spent hours trolling the net looking for a definitive guide on how to make colours (color if you are from the US) work in Solaris 10. By default colour isn’t enabled but once you know how it is relativity easy to get it to work. The first step is to download a number of new…

  • Informatica Backup Script

    Hi, Its been a while since I posted, today a wrote a quick script that will take a backup of Informatica .rep file and store it in a specified location. The script works in any Unix/Linux based system if you create a cron job for how often you want to take the backup the script…

  • OBIEE .lok .DAT files

    Came across this issue today took me an age to work out what was wrong then I knocked up a couple of finds and boom all sorted. Anyway the below is more for self reference in case I come across it again. Other Errors that can be encountered are or To resolve the above issues, clear below .lok…

  • DAC Restart Script

    Hi, Just thought I would share the script I wrote to restart your DAC server in the event of a crash, this can be helpful during the night as there is no need for a manual restart. I used a cron job to check to see if the process is running every 5min. Any improvements…

  • Import Users from Weblogic to OBIEE 11G and Increase the log level:

    Import Users from Weblogic to OBIEE 11G and Increase the log level:.   Found this useful today as I couldn’t remember how to show Online users.   Paz

  • OBIEE Performance Tuning Part 3

    For the final part of this guide we will take a look at some of the changes that can be made to the database to achieve better performance. The parameters I recommend changing are listed below;   Implementing these changes reduced my report timings further showing a clear increase in performance. Results: Time after changing instanceconfig.xml against Database changes 1. 1m44s      43s…

  • OBIEE Performance Tuning Part 2

    For the second part of my OBIEE Tuning guide we will look at the instanceconfig.xml and changes that can be made here. As stated in my previous post I dont believe in cache when performance tuning as it can lead to false results, in that respect make sure cache is turned off in OBIEE Enterprise Manager, the…

  • OBIEE Performance Tuning Part 1

    This is part one of my OBIEE Tuning guide. In this post we will look at some of the parameters that should be set at NQSConfig.ini in order to achieve maximum performance  First things first to run a valid test I ran the same report each time, after I had applied changes rebooted all database and OBIEE services…