OBIEE and Load Runner - part 2

UPDATED: See a HOWTO for OBIEE and LoadRunner here: /2009/10/01/performance-testing-obiee-using-hp-performance-center-a.k.a.-loadrunner/ This is …

Querying SQL Server from OBIEE running on Unix

A question that pops up on the OBIEE OTN forum quite often is how to use non-Oracle databases like MS SQL Server when the OBIEE server is running on a …

OBIEE and Load Runner - part 1

UPDATED: See a HOWTO for OBIEE and LoadRunner here Introduction LoadRunner is a tool from HP (bought from Mercury) that can be used to simulate user …

Unix script to report on OBIEE and OBIA processes state

Here’s a set of scripts that I use on our servers as a quick way to check if the various BI components are up and running. Because we split the …

What is OBIA…

Very good post by @lex giving a nice clear explanation of what OBIA (Oracle Business Intelligence Applications) is …

OBIEE performance monitoring and alerting with jManage

OBIEE’s Systems Management component exposes configuration and performance data through Java MBeans. As discussed in other posts these can be be …

How to find out what web application server is in use

If, for some reason, you need to check what web application server is in use for Presentation Services (as this chap needed to), you can use an add-in …

OBIEE Windows PerfMon counters

Yet another way to access the BI Management data discussed here - through Windows’ PerfMon tool. This will only work for installations where …

Mark Rittman’s OBIEE repository for DAC

Mark Rittman has an excellent article about querying the DAC repository database tables, including a downloadable RPD file. Being new to working with …

psservice - Windows command line goodness!

Our main servers are Unix and I’m as happy as a pig in muck at the command line, so when I’m working on Windows (where I’ve got a …

sawserver charts crash

By a strange co-incidence after following this thread on OTN forums about a BI crash and struggling to understand the actual problem, I think …

JConsole / JMX - followup

A few points to add to my previous posting on JConsole: As well as performance data, you have access to configuration data. Be aware that it is …

OBIEE admin tools & hacks

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 …

JConsole / JMX

[edit] See this post too [/edit] On an OBIEE server run [sourcecode language=“bash”] nohup obiee/systemsmanagement/runagent.sh & …

nqcmd and [nQSError: 27005] Unresolved column

I’m working on a scripted load test for OBIEE using nqcmd to run reports multiple times. I hit this interesting issue. Cut and pasting the …

Custom HTTP error page in OBIEE / OAS

It’s possible to change the error pages served up by OAS/Apache by using the ErrorDocument directive. This is widely documented. However, to get …

New releases

New releases this week - 10.1.3.4.1 of OBIEE, and 7.9.6 of OBIA. After a bit of scrabbling around found: “The 10.1.3.4.1 release of the Oracle …

OBIEE and F5 BIG-IP

We’ve got a setup of two OAS/Presentation Services boxes and two BI Server boxes, with load balancing/failover throughout. The Load Balancing of …

sawserver won’t start up - resolved

(See here and here for history) I edited the shell script which is eventually called by run-saw.sh to start the sawserver, …

sawserver won’t start (analytics: Servlet error java.net.ConnectException: Connection refused (errno:239))

We’re getting this error in the Presentation Services plug-in [analytics]. Log file: …