Dec 3, 2009

UKOUG TEBS 2009

This was my first UKOUG TEBS, in fact my first conference I’d ever attended! I was quite unsure what to expect, but three days later I can safely say it was invaluable. The variety of presentations and expertise being shared was impressive, and it was great to hear people sharing and discussing their ideas and opinions around the subjects I work with each day. Working in isolation is not a good idea, one can develop a blinkered or bunker mentality.

Continue Reading

Nov 25, 2009

OBIEE application servers, now and future

Oracle have published an interesting doc 968223.1, entitled “Enterprise Deployment of Oracle BI EE on OC4J and App Servers”. It details the differences between OC4J and OAS which is useful for the current versions of OBIEE. It then also gives a useful heads-up – that WebLogic becomes the App server of choice in the next version of OBIEE All of this changes in OBI EE 11g where several projects will become absolutely dependent upon an App Server.

Continue Reading

Nov 25, 2009

SoOotW and sweep

(Sorry for the lame title, but it gives me an excuse to put this picture in :) ) I was really pleased by the response I got from my posting about The state of OBIEE on the web, knowing that it’s not just me goes a long way to keeping my blood pressure down. The OTN forum is still an unbalanced mix of tosh (is this guy for real?) with the occasional insightful and interesting post or idea such as this really neat one from Joe Bertram about using multiple presentation services on top of the same RPD to give different interfaces to different end devices.

Continue Reading

Nov 17, 2009

Resolved: sawserver : Error loading security privilege /system/privs/catalog/ChangePermissionsPrivilege

Whilst installing OBIA 7.9.6.1 I hit this problem when firing up Presentation Services (sawserver): Error loading security privilege /system/privs/catalog/ChangePermissionsPrivilege. A quick search on the forums threw up two posts suggesting a corrupted WebCat. Since I’d got this webcat fresh out of the box I was puzzled how it could be corrupted. I did a bit more tinkering (including nosying around in the sawserver log), before realising it was indeed corrupt, and that I was indeed a muppet.

Continue Reading

Nov 12, 2009

Deploying Oracle Business Intelligence Enterprise Edition on Sun Systems

A very interesting new PDF from Sun on deploying OBIEE has been published, with discussions on architecture, performance and best practice. This Sun BluePrints article describes an enterprise deployment architecture for Oracle Business Intelligence Enterprise Edition using Sun servers running the Solaris Operating System and Sun Storage 7000 Unified Storage systems. Designed to empower employees in organizations in any industry—from customer service, shipping, and finance to manufacturing, human resources, and more—to become potential decision makers, the architecture brings fault tolerance, security, resiliency, and performance to enterprise deployments.

Continue Reading

Nov 11, 2009

#Fail: My Oracle Support

Metalink was retired this weekend and made way for the new My Oracle Support system. It didn’t go as smoothly as it could have done. This post is going to be a bit of a rambling rant. Ultimately people, including me, don’t like their cheese being moved (not unless there’s a really runny piece of Camembert at the end of it). That makes it a bit more difficult to discuss because some of people’s complaints will just be geeks being stubborn (and boy, can geeks be stubborn).

Continue Reading

Nov 6, 2009

OBIEE clustering - specifying multiple Presentation Services from Presentation Services Plug-in

Introduction Whilst the BI Cluster Controller takes care nicely of clustering and failover for BI Server (nqsserver), we have to do more to ensure further resilience of the stack. A diagram I come back to again and again when working out configuration or connectivity problems is the one on P16 of the Deployment Guide. With this you can work out most issues for yourself through simple reasoning. Print it out, pin it to your wall, and read it!

Continue Reading

Nov 3, 2009

Advanced Googling for OBIEE information

Want to find all PDFs from Oracle about OBIEE? There’s some interesting ones that this turned up on Oracle’s public FTP. In particular: BI EE Environmental and Multi-User Development Migration Processes Securing Oracle BI Enterprise Edition (There’s also PowerPoint files on there including this one but Google doesn’t seem to index them) You can use Google’s Advanced Search page to build similar queries: You can also use Google Alerts so that any time a new entry matching your search criteria is added in Google’s index you get notified of it either by email or on an RSS feed:

Continue Reading

Nov 2, 2009

Experts

A brilliant posting here from Jonathan Lewis on the subject of Experts. He in turn is quoting Chen Shapira: “DBAs are under a lot of pressure not to be experts.”. Read the sentence again, as it took me a minute to figure out. He’s writing in the context of an Oracle DBA but I think it’s equally applicable to those working with an looking after installations of OBIEE et al.

Continue Reading

Oct 30, 2009

The state of OBIEE on the web

An advance footnote I’ll start this by saying why I think things are how they are, and then I’ll get to the meat of my article. OBIEE in its current incarnation (v10.1.3) is a mature product. All the big bugs have been caught and fixed. All the known quirks are well documented. All the missing features are known. All the clever workarounds have been found. All the neat little hacks have been explored.

Continue Reading

Oct 22, 2009

Troubleshooting OBIEE and ORA-12154: TNS:could not resolve the connect identifier

A frequent question on the OTN OBIEE forum is how to fix this error: [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. The error is simply OBIEE reporting that it tried to connect from the BI Server to an Oracle database and the Oracle client returned an error. Distilling it down gives us this error:

Continue Reading

Oct 21, 2009

Critical Patch Update - OBIEE vuln CVE-2009-1990

October’s Oracle Critical Patch Update Advisory has been released. There are two vulnerabilities (CVE-2009-1999, CVE-2009-1990) listed under Oracle Application Server for “Component” Business Intelligence Enterprise Edition and one (CVE-2009-3407) for “component” Portal. CVE-2009-1999 is OBIEE and “Fixed in all supported versions. No patch provided in this Critical Patch Update.”. CVE-2009-3407 looks like only OAS (not OBIEE), up to versions 10.1.2.3 and 10.1.4.2. CVE-2009-1990 is OBIEE and is the main vuln of interest.

Continue Reading

Oct 16, 2009

BI Server hung - nQSError 14054 / 15001 / 23005

Watch out if you are using init blocks in your RPD. We hit a bug (#9019374) recently that caused BI Server (10.1.3.4) to hang. The init block in question should have returned a date to update a repository variable, but because of badly-written SQL and abnormal data in the source table actually returned a null value. BI Server evidently didn’t like this null being inserted somewhere where it shouldn’t have and understandably logged :

Continue Reading

Oct 16, 2009

Heads up - Critical Patch Update affecting OBIEE

The Critical Patch Update Pre-Release Announcement for October has been published. The pre-release is advance notice of the affected software prior to release of the quarterly Critical Patch Update. It is published on the Thursday prior to the patch releases (which was postponed by a week because of OOW). It looks like if you’re running OBIEE 10.1.3.4.0 or 10.1.3.4.1 through OAS 10.1.2.3.0/10.1.3.4.0/10.1.3.5.0 then you should check back next Tuesday 20th for details.

Continue Reading