Short note to record this, as Google drew no hits on it. Windows XP machine with existing Oracle 11.1 client installation, all working fine. Installed Oracle 11.2 XE, and started getting these errors: [sourcecode] C:\Windows\System32>tnsping DBNAME TNS Ping Utility for 32-bit Windows: Version 11.2.0.2.0 - Production on 26-SEP-2011 11:01:11 Copyright (c) 1997, 2010, Oracle. All rights reserved. Used parameter files: C:\app\userid\product\11.1.0\client_1\network\admin\sqlnet.ora Used TNSNAMES adapter to resolve the alias Message 3513 not found; product=NETWORK; facility=TNS OK (20 msec) [/sourcecode]

I noticed in Ed Stevens’ blog posting here that some sourcecode he’d posted had certain lines highlighted. Wordpress provides the sourcecode tag for marking up sourcecode in blog posts. For example: cd /some/random/folder ls -l # do not run this next line! is much better presented as: [sourcecode language=“bash”] cd /some/random/folder ls -l # do not run this next line! [/sourcecode] by wrapping it in [sourcecode] tags I’ve known about the language=‘xx’ attribute that you can use with the tag, but Ed’s posting prompted me to check on the syntax and it turns out there a few tweaks one can use.

If you only read one blog post this month, read James Morle’s eloquent attack on the term “Best Practice”. I’m very excited to be joining RittmanMead next month! I’m looking forward to working with some of the industry’s most respected experts.

In Oracle 11g, the DBMS_STATS procedure GATHER_SCHEMA_STATS takes a parameter ‘options’ which defines the scope of the objects processed by the procedure call, as well as the action. It can be either GATHER or LIST (gather the stats, or list out the objects to be touched, respectively), and AUTO, STALE or EMPTY (defining the object selection to process). GATHER on its own will gather stats on all objects in the schema GATHER EMPTY / LIST EMPTY is self-explanatory - objects with no statistics.

When using preupgrade to upgrade an existing Fedora 14 installation to Fedora 15, the following two errors were encountered: Failed to fetch release info No groups available in any repository The box sits on a network behind a proxy out to the web. The resolution was to make sure that environment variables http_proxy and https_proxy are set: [sourcecode language=“bash”] export http_proxy=http://user:password@proxyserver:port export https_proxy=http://user:password@proxyserver:port [/sourcecode] Make sure you do this from the user from which you run preupgrade.

Excel may send chills down the spine of us when we hear users talking about its [ab]use, but it has its place in the toolset. For my money, it is a very good tool for knocking out graphs which look decent. Of course, rrdtool is my geek tool of choice for dynamic long-term graphing, but when doing scratch PoC work, I normally fall back to Excel. One thing which has frustrated me over time is, well, time, and Excel’s handling thereof.

Here’s a quotation that I’ve just read and wanted to share. It is all part of a BAAG approach to troubleshooting problems, performance in particular. From Greg Rahn (web|twitter) on oracle-l: There are always exceptions, but exceptions can be justified and supported with data. Just beware of the the silver bullet syndrome… The unfortunate part […] is that rarely anyone goes back and does the root cause analysis. It tends to fall into the bucket of “problem…solved”.

Blogging from Oracle itself about OBIEE has always been a bit sparse, certainly in comparison to that which there is for core RDBMS. It’s good to see a new blog emerge in the last couple of months from OBI Product Assurance, including some nice ’n spicy detailed config/tuning info. Find it here: http://blogs.oracle.com/pa/. There’s a couple more OBI blogs from Oracle, but both are fairly stale: Implementing Oracle BI & EPM Solutions - Rob Reynolds OBIEE Ramblings Oracle BI Foundation (thanks Daan for pointing this one out)

OK, a bit tired on a Monday morning, and so a bit sarcastic. I’ve not really fallen off my chair, but I am shocked. I honestly didn’t think it would happen. Oracle have finally released OBI 11g for HP-UX Itanium: In other news, patchset 10.1.3.4.2 for OBI 10g was released today, I wonder if/when we’ll get an HP-UX Itanium version? The download page has it conspicuous by its absence even from “Coming Soon”:

Have you defined CLIENT_ID in your OBIEE RPD yet? You really ought to. As well as helping track down users of troublesome queries, it also tags dump files with the OBIEE user of an offending query should the worst occur: For details, see: Identify your OBIEE users by setting Client ID in Oracle connection Instrumenting OBIEE for tracing Oracle DB calls