You get a call from your friendly DBA. He says the production database is up the spout, and it’s “that bee eye thingumy causing it”. What do you do now? All you’ve got to go on is a program name in the Oracle session tables of “nqsserver@MYSERVER (TNS V1-V3)” and the SQL the DBA sent you that if you’re lucky will look as presentable as this: The username against the SQL is the generic User ID that you had created for connections to the database from OBIEE.

Continue Reading

This error caught me out today. I was building a Linux VM to do some work on, and for the life of me couldn’t get the OBIEE Admin Tool to connect to the BI Server on the VM. The error I got when trying to define a DSN on the Windows box was: [nQSError: 12008] Unable to connect to port 9703 on machine 10.3.105.132 [nQSError: 12010] Communication error connecting to remote end point: address = 10.

Continue Reading

Oracle Application Server (OAS) is the Web and Application server typically deployed with OBIEE. There are several settings which by default may be viewed as security weaknesses. Whether realistically a target or not, it’s good practice to always be considering security and lock down your servers as much as reasonably possible. I adopt the default stance of having to find a reason to leave something less secure, rather than justify why it needs doing.

Continue Reading

Quick post as the snow’s coming down and I wanna go home … I’ve been working on building a VM based on OEL5.4 and OBIEE 10.1.3.4.1. After installing XE 10.2 I tried to fire my RPD up, but hit this: /usr/lib/oracle/xe/app/oracle/product/10.2.0/server/lib/libnnz10.so: cannot restore segment prot after reloc: Permission denied [nQSError: 46029] Failed to load the DLL /app/oracle/product/obiee/server/Bin/libnqsdbgatewayoci10g.so. Check if ‘Oracle OCI 10G’ database client is installed. If you trace the ‘stack’ back you find that it parses down to this nub of an error:

Continue Reading

Mucho kudos to Borkur Steingrimsson for getting the OBIEE admin tool working on Unix!

Continue Reading

Very interesting post by Kevin McGinley about CAF here: CAF = Migration Utility? Use Caution! It articulates better than I ever could reasons against using CAF particularly in a production environment. Since the tool came out I’d been struggling to get my head around it, convinced I was missing something. I still don’t profess to understand it properly, but Kevin’s article reassures me that I shouldn’t be losing too much sleep over it, especially given that it’s unsupported and won’t work with 11g.

Continue Reading

Short but sweet this one - a way of troubleshooting connectivity problems between analytics (the Presentation Services Plug-in, either j2ee servlet or ISAPI, a.k.a. SAWBridge) and sawserver (Presentation Services). For a recap on the services & flow please see the first few paragraphs of this post. Problems in connectivity between analytics and sawserver normally manifest themselves through this error message: 500 Internal Server Error Servlet error: An exception occurred. The current application deployment descriptors do not allow for including it in this response.

Continue Reading

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

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

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

(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

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

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

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

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

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

Christian Screen has done a nice video explaining the CAF installation, and has promised a deep-dive followup which I’m looking forward to. Click here for the article

Continue Reading

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

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

I honestly don’t dare click the “Did you mean” link ;-)

Continue Reading