Troubleshooting EBS-BI integrated authentication can be a tiresome activity, so here’s a shortcut that might help. If you suspect the problem lies with EBS then you can leave OBIEE out of the equation. Login to EBS Use FireBug or Fiddler2 to inspect web traffic as follows: Click the BI link from EBS Should be first a request to EBS server, which returns 302 and redirects to http://<bi server>:<port>/analytics/saw.dll?Dashboard&acf=101507310 Record the value of acf (eg 101507310)

What’s going on here? The username/password is definitely valid, proved by the sqlplus connection. Configuring DAC in OBIA 7.9.5.1: [sourcecode] What can I do for you? 1 - Enter repository connection information 2 - Test repository connection 3 - Enter email account information 4 - Send test email 5 - Save changes 6 - Exit Please make your selection: 1 These are your connection type choices: 1 - MSSQL 2 - DB2 3 - Oracle (OCI8) 4 - Oracle (Thin) 5 - Keep current ( Oracle (Thin) )

This is a note-to-self really. When playing around with Oracle and something’s not working - RTFAL: Read The Flippin Alert Log! After resizing a VM I was getting this problem: [sourcecode] [oracle@RNMVM01 ~]$ sqlplus / as sysdba SQL*Plus: Release 11.2.0.1.0 Production on Sat Apr 24 17:44:44 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to an idle instance. SQL> startup nomount ORA-00845: MEMORY_TARGET not supported on this system SQL> [/sourcecode]

A faithful FireFox user for many users, I’ve been having a rather delightful rekindling of my old love for Opera recently. Back in the days, when I was a beardless bairn, I even paid for Opera I liked it so much. Then Firefox came along and Opera got dropped by the wayside like a teenage crush. Well Opera 10.5 was released recently and I’m liking it. I miss my Firefox extensions too much to switch entirely, but damn, Opera is FAST!

I’m doing my first ever conference presentation next month at the 2010 Rittman Mead BI Forum. My presentation is called Performance Testing OBIEE, which is something I’ve spent a lot of time working on over the last few months. I think the challenge is going to be distilling it all into a session that’s not going to overwhelm everyone or bore them to death! Well, actually, the challenge is going to be the presenting.

Spotted this when trawling through My Oracle Support. It’s pretty common knowledge anyway amongst people already familiar with hacking around with OBIEE, but worth recording for people coming along to it new. Doc ID 1068266.1 states: UDML is not supported in OBI 10g. in 11g, XUDML (the Oracle BI Server XML API) will be fully supported and documented.

I’ve been playing around with SQL Tuning Sets, and was trying to clear up my mess. To list all the tuning sets: [sourcecode language=“sql”] SET WRAP OFF SET LINE 140 COL NAME FOR A15 COL DESCRIPTION FOR A50 WRAPPED select name,created,last_modified,statement_count,description from DBA_SQLSET [/sourcecode] [sourcecode] NAME CREATED LAST_MODI STATEMENT_COUNT DESCRIPTION ————— ——— ——— ————— —————————————————————————————- sts_test_02 09-MAR-10 09-MAR-10 1 Test run 1 sts_test_01 12-FEB-10 12-FEB-10 1 an old STS test test test [/sourcecode]

JMX OBIEE’s Systems Management functionality exposes performance counters and the application’s configuration options through Java MBeans and optionally a protocol called JMX. It’s extremely useful, and is documented pretty widely : JConsole / JMX JConsole / JMX – followup Oracle BI Management / Systems Management MBeans PerfMon OBIEE MBeans and OC4J OBIEE performance monitoring and alerting with jManage In this article I’m going to discuss the use of JMX to access these counters remotely, and a possible security issue that’s present in the BI Management Pack manual.

We hit a very interesting problem in our Production environment recently. We’d made no changes for a long time to the configuration, but all of a sudden users were on the phone complaining. They could login to BI from EBS but after logging in the next link they clicked took them to the OBIEE “You are not logged in” screen. Our users login to EBS R12 and then using EBS authentication log in to OBIEE (10.

A new document has been published by Oracle, discussing ways of improving performance for OBIA 7.9.6 and 7.9.6.1. Its primary focus is around improving ETL performance. There’s some very interesting content including hardware sizing recommendations, and I’d strongly recommend anyone working with OBIA reads it. It’s called “Oracle Business Intelligence Applications Version 7.9.6 Performance Recommendations” and is available on My Oracle Support through Doc ID 870314.1