July 21, 2009

OBIEE admin tools & hacks

Filed under: hack, mbeans, nqcmd, obiee, performance, sawping, sawserver, unix — rmoff @ 09:28

As a kid I loved the idea of lego where you can disassemble and reassemble something from the ground up. As soon as I got my hands on a computer it was the same. You can have your Acorn Archimedes with its games, where do I find the sprites and sound files behind it? Likewise Microsoft Word, let me at the VBA underneath to hack it around and see what else it can do.

With that in mind I’ve enjoyed discovering bits of the “underbelly” of OBIEE from manuals, blogs and a few SRs I’ve raised.

Here’s my list so far, please feel free to add to it in the comments and correct any errors or missing credits 🙂

Oracle BI Management data
This server-based performance and diagnostic data can be access through several methods:


Credit: http://obiee101.blogspot.com/2009/07/obiee-perfmon-performance-monitor.html

Go to http://%5Bserver%5D:%5Bport%5D/analytics/saw.dll?perfmon and you’ll get the Performance Monitor. This is the same data that’s used by the BI Management Pack and is accessible through the jmx agent


An alternative to jconsole is to access the Oracle BI Management MBeans through oc4j. @lex has details here

Windows perfmon

More details in separate post here


The same data as through perfmon above, full details here: jmx agent


jManage is an open-source tool that can also be used to access the MBeans:
See this post for information
Credit: http://tipsonobiee.blogspot.com/2009/07/sawping.html

C:\OracleBI\web\bin>sawping.exe -help
sawping [-p port] [-s host] [-v (verbose mode)] [-q (quiet mode)] [-h]C:\OracleBI\web\bin>sawping.exe -s myPSserver.company.net -v
Server alive and well

NB not got this working yet on unix:

obiee/web/bin64 $./sawping64
/usr/lib/hpux64/dld.so: Unable to find library ‘libsawcomm643r.so’.

Found in [OracleBI Home]/web/bin (or Bin64)

Great little command line tool. We’re using it for some crude load testing (get a bunch of logical-SQL statements and use unix scripting to fire them in parallel at the BI Server) as well as monitoring of the BI Server (“pinging” it regularly with some small logical-SQL to make sure it responds correctly)
Found in [OracleBI Home]/server/Bin (or Bin64)

(UNIX only, duh)
What it says on the tin – validates your Unix environment is suitable for OBIEE

Usage: UnixChk.sh [-b] [-s | ]

Support asked me to run this, you’ll find it in [OBIEE home]/server/Bin

Usage: ./diagcap.sh -d [-p] [-h]
-d : directory that info will be stored
The directory must be empty
-p : absolute path to Oracle BI root directory
May be omitted if the SAROOTDIR
environment variable is set
-h : show this help message

It collects all the config files and log files from your environment into a TAR archive, which you can then send to support.

Not OBIEE as such, but interesting for the truly nosy. This is a unix (HP) tool which you use to invoke a program and then get low-level diagnostics on what it’s up to. Most of the output may be gobbledegook to all but the hardcore programmer, but it does sometimes pick out if a library file is missing etc.
For example to invoke nqqserver in run-sa.sh:

tusc -vfe ${ANA_BIN_DIR}/nqsserver 2>&1 &

Administration Tool
Maybe not so unknown, but has front-end for monitoring clusters which I liked

The AdminTool can also be fed a script via the command line, see details here

Other stuff
This is a list of binaries that might or might not be of interest and that I plan to have a play with at some point

NB obiee/setup/sa-init64.sh and common.sh scripts might need running first to set the environment variables correctly.


  • cryptotools – used for generating keys for authentication between obiee/delivers/xmlp
  • sawmigrate – for migrating from older versions of OBIEE?


  • equalizerpds – For equalising RPDs prior to merging as part of an upgrade process Reference
  • ErrorMsgCheck (directory) – not sure
  • nqerrormsgcompiler – not sure

ErrorMessageCompiler [] []

  • nqlogviewer – For parsing BI server logs. Can be useful for clustered instances?
  • nqschangepassword – For changing of RPD user passwords
  • nqscripthostexec – not sure

Usage: nqscripthostexec Memory fault(coredump)

  • nqsshutdown – To shut down a BI Server via DSN reference (see here)
  • nqsudmlcli – something to do with UDML?
  • nqudmlexec – executing UDML against the RPD
  • nqudmlgen – generating UDML from an RPD
  • nqxudmlexec – executing XML formatted UDML against the RPD
  • nqxudmlgen – generating XML formatted UDML from an RPD
  • openssl – OpenSSL command line
  • sametaexport – Oracle Database Metadata Generator. See Oracle Business Intelligence Server Administration Guide and Venkat’s blog
  • saschinvoke – invoke Delivers jobs & iBots (see here)
  • schconfig – Scheduler [Delivers] configuration program
  • schshutdown – Shutdown Scheduler remotely?

In Googling these various binaries I found an excellent PDF from Andreas Nobbmann’s presentation in Brighton earlier this year: Scripting OBIEE – Is UDML and XML all you need?

Another useful page is here: http://gerardnico.com/wiki/dat/obiee/executable_files/start


1 Comment

  1. At one place everything, cool.

    Comment by Srinivas Malyala — July 29, 2009 @ 22:32

RSS feed for comments on this post.

Sorry, the comment form is closed at this time.

Create a free website or blog at WordPress.com.

%d bloggers like this: