A sad little passing last week, of the Oracle Support Blog and related tweets by Chris Warticki.
Last week Chris posted this comment on twitter
followed by this terse blog posting:
Support Blog: No longer available
By chris.warticki on February 12, 2010 4:08 PM Please use My Oracle Support Communities instead
I stumbled across this blog posting recently, and am reposting the link here as I’ve seen no mention of it elsewhere. This surprised me as with Exadata (and most new technologies) any snippet of news or tech insight gets blogged and tweeted multiple times over.
Any insight into Exadata is interesting as unlike all the other Oracle software which can be downloaded and poked & prodded, this is a physical box so we rely on blog postings and marketing (with a BS filter) to understand more about it.
In the following list, which two mind-mapping programs are rated best?
Now look at the actual numbers, and answer again
Different answer?
I can’t be the only one in this frantic world whose eyes are drawn to the pictures instead of words and leap to conclusions. It’s only because I use FreeMind and was surprised it scored so low …. and then realised it hadn’t. Looks like the HTML rendering isn’t the same here (FF3.6) as when the web page author wrote it.
There is a LOT written about performance. And this post is now adding to it. Some of it’s excellent, some of it less so. But a lot of it starts from a point so far down the process that unless you know the first bit, you’re going to raring off and end up chasing your tail or p###ing in the wind…. (pardon my french). Without a well structured approach that you understand and always follow you’ll hit on solutions by luck only.
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.
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.3.105.132; port = 9703. [nQSError: 12002] Socket communication error at call=: (Number=-1) Unknown
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.
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:
Mucho kudos to Borkur Steingrimsson for getting the OBIEE admin tool working on Unix!
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.
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. Please consult the application log for details.
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. Blogging is good for breaking out of this, as is, I’m now convinced, twittering. However, nothing beats meeting up with folk and discussing problems face to face, listening and learning from their experience.
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]
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. Within Oracle Fusion Middleware, WebLogic Server will be the application server and OBI EE 11g will be deployed and certified with WebLogic Server.
(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.
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.
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. Taking advantage of key virtualization technologies, the architecture can be used to consolidate multiple tiers onto a single system to help reduce cost and complexity. A short discussion of the performance characteristics of the architecture using a realistic workload also is included.
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). Arguments descend into minutiae of detail and flash vs DHTML - whilst the bigger picture gets lost.
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!
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:
(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:
