Last month I wrote about a problem that Informatica as part of OBIA was causing us, wherein an expired database account would bring Oracle down by virtue of multiple connections from Informatica. I raised an SR with Oracle (under OBIA support), who after some back-and-forth with Informatica, were told: This is not a bug. That the two error messages coming back from Oracle are handled differently is the result of a design decision and as such not a product fault.

Continue Reading

This problem, which in essence is bad behaviour from Informatica bringing down Oracle, is a good illustration of unintended consequences of an apparently innocuous security setting. Per our company’s security standards, database passwords expire every 90 days. When this happens users are prompted to change their password before they can continue logging into Oracle. This applies to application user IDs too. It appears that Informatica 8.6.1 HF6 (part of OBIA 7.

Continue Reading

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)

Continue Reading

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

Continue Reading

Why did this make me think of the OBIA upgrade documentation?? ;-) via I think this summarizes everything.. [Update December 18, 2013: The lady in the picture is Kathy Sierra]

Continue Reading

The latest point release of Oracle Business Intelligence Applications, 7.9.6.1, has been released and is available for download from here (direct link to download). The version.txt reports the version as: Build: 7.9.6.1.100609.2038 Release Version: Oracle Business Intelligence Applications 7.9.6.1 Package: 100609.2038 No updated documentation library yet through, so can’t nosey through the release notes. The docs that come with the download are labelled 7.9.6 and dated April 09 so don’t look like they’ve been updated either.

Continue Reading

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 stack across servers, there are different scripts called in combination. On our dev boxes we have everything and so the script calls all three sub-scripts, whereas on Production each server will run one of: BI Server Presentation Server & OAS Informatica & DAC The scripts source another script called process_check.

Continue Reading

We’re upgrading from OBIA 7.9.5 (Financials - GL) to OBIA 7.9.6. Our reasons are for support (7.9.5 does not support Oracle 11g) and minor functionality additions. Our architecture is: HP-UX 64 bit Itanium (11.31), Oracle 11g (11.1.0.7), separate ETL server, 4x OBIEE servers (2x BI, 2xPS). We have no customisations in the ETL except something for budgets, which is superseded in 7.9.6. This post is a semi-formed articulation of my frustrations encountered during an initial run through of the upgrade in a sandbox.

Continue Reading

I keep hitting this error when setting up OBIA. I suppose it’s what it says on the tin, but Googling it didn’t match so I’m posting this so next time I hit it I remember :-) Repository Error ([REP_51821] Failed to connect from Integration Service (pmserver) to repository Oracle_BI_DW_Base running in exclusive mode.) The cause is the Repository Service having OperatingMode set to Exclusive. This is necessary for some of the setup operations like restoring the pre-built Repository, but if you forget to switch it back the Integration Service will suddenly stop working.

Continue Reading

I’m starting on an upgrade from OBIA 7.9.5 to 7.9.6 and wading through the two main docs: 7.9.6 Upgrade guide 7.9.6 Installation guide It would be nice if Oracle could come up with some less confusing terminology. It seems that not only is the whole product of OBIA referred to as OBIA (see @lex’s posting for a good explanation), but that the sub-components which are not-OBIEE-or-DAC-or-Informatica is also OBIA, c.f. page 6-1 of the Upgrade guide “[…]upgrade your Oracle BI Applications environment to the current version.

Continue Reading

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.

Continue Reading

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 Business Intelligence Enterprise Edition introduces no new features.” Though there are some new bits and pieces for Publisher For 7.9.6 OBIA, there’s no New Features document :( By piecing together the “What’s New in This Release” for each document you can build up a picture (eg in the Upgrade Guide there’s reference to changes for the doc relating to a new version of Informatica), but it would be nice to have it all in one place:

Continue Reading

We’re getting problems with an instance of Informatica / out-of-the-box OBIA on a new set of servers. When we run the execution plan we get this error soon after starting: MAPPING> DBG_21075 Connecting to database [TNSENTRY], user [MYUSER] MAPPING> CMN_1761 Timestamp Event: [Tue Mar 24 18:56:33 2009] MAPPING> CMN_1022 Database driver error… CMN_1022 [ Database driver error… Function Name : Logon ORA-12537: TNS:connection closed Database driver error… Function Name : Connect

Continue Reading