Very good post by @lex giving a nice clear explanation of what OBIA (Oracle Business Intelligence Applications) is http://siebel-essentials.blogspot.com/2009/06/can-you-describe-oracle-bi-applications.html This should be made a sticky on the OBIA forum in my opinion. It’s clear from postings on the forum that an awful lot of people don’t understand what OBIA is or how it sits with OBIEE. I even attended a course last week in which the Oracle trainer stated that OBIEE included ETL and DW schemas, and stuck to this when challenged.

OBIEE’s Systems Management component exposes configuration and performance data through Java MBeans. As discussed in other posts these can be be accessed through several different ways: JConsole (see also here) oc4j Windows PerfMon (although I guess this isn’t actually using MBeans/JMX?) saw.dll?perfmon BI Management Pack Since it’s a standard java technology being used we can in theory use anything that is designed for monitoring mbeans via jmx. Doing some Googling I discovered jManage.

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 for FireFox called HttpFox to inspect the HTTP headers. 1. Install HttpFox (and obviously Firefox if you don’t have it already!) 2. Open the HttpFox window (Tools -> HttpFox -> Toggle HttpFox) 3. Click the Start button in the HttpFox window 4. Navigate to your OBIEE home page

I found this post very interesting: Paul Graham : Maker’s Schedule, Manager’s Schedule (originally found here) It was one of those mini-revelations when I found something that greatly resonated and explained an inexplicable frustration I find in the workplace sometimes. I wonder how applicable it can be to a large corporation though, rather than a start-up where it’s given that people are allowed to be bolshy with their meetings? ;-)

We routinely change Oracle passwords as part of security best-practice, I keep hitting this and keep forgetting why! :-) [sourcecode language=‘sql’] ALTER USER DAC_REPO IDENTIFIED BY 1KoBe3RH REPLACE YlR94tqp [/sourcecode] Error report: SQL Error: ORA-00922: missing or invalid option 00922. 00000 - “missing or invalid option” *Cause: *Action: Someone better qualified than me can explain why but I suspect it’s the leading number in the new password. Quoting the passwords then works fine:

One of my little gripes with Metalink is its purporting to be helpful when it’s blatantly not. Here’s one: Now which is more likely, on Metalink 3; that I’m searching for sawserver (integral component to OBIEE), or sqlserver?!

Yet another way to access the BI Management data discussed here - through Windows’ PerfMon tool. This will only work for installations where your OBIEE server is running on Windows. You should be able to run PerfMon locally or remotely. Standard practise would be not to run it locally on a Production machine :-) To run PerfMon go to Start->Run and enter perfmon, or navigate Start -> Settings -> Control Panel -> Administrative Tools -> Performance

Mark Rittman has an excellent article about querying the DAC repository database tables, including a downloadable RPD file. Being new to working with RPDs I thought it would be good practise to explore this as well as hopefully get some useful information about our current ETL deployment. I downloaded the RPD to c:\OracleBI\server\Repository and opened it up in the Admin tool (Administrator/Administrator). First off I changed the connection pool to point to my DAC repository database, having setup a TNS entry for it first.

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 test OBIEE install) I like to stick with the CLI where possible. PSService is one of those tools that I instinctively reach for without realising it. Combined with Launchy, it’s even better. Simply put, you can control windows services from the command line.

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 I’ve encountered it myself! I’ve got a test install of OBIEE running on my Windows XP laptop, and whilst building a report in Answers got this: ](http://2.bp.blogspot.com/_RCx_EVJpczQ/SmiDrEorbbI/AAAAAAAAGcg/OPGwTLXXg8k/s1600/crash1.png)[ was: szAppName : sawserver.exe szAppVer : 10.1.3.4 szModName : kernel32.dll szModVer : 5.1.2600.3119 offset : 000097a3 Going to the sawserver log at c:\OracleBIData\web\log\sawlog0.