If, like me, you have suffered from ORA-29902 Error in executing ODCIIndexStart() routine errors where Spatial indexes are involved, the following might help you fix it. Read more »
Need to Compile a 32 bit Application on a 64 bit Linux System?
May 13, 2013 | Author: Norman
I have a small utility that I need to use from time to time. I wrote it back in 2009 when 32 bit systems were all the rage. It reads a certain type of data file and outputs lots of, ahem, interesting information about the contents. When I compiled it on my 64 bit laptop, it produced complete and utter rubbish! How did I fix it? Read more »
This Listener Problem is Driving Me Mad!
May 10, 2013 | Author: Norman
I have been looking at this far too long, and I’m stumped. I resolved a similar problem yesterday on another server. That was down to the ORACLE_HOME setting in listener.ora having a ’1′ in it rather than a ’2′. Took ages to spot that. Read more »
ORA-03262 While Dropping Empty Datafile
May 2, 2013 | Author: Norman
Tired of trying to drop empty datafiles from a tablespace, which you know is empty? Keep getting errors telling you the data file isn’t empty? Getting frustrated with the whole thing? Me too. This link has the reason and solution.
Internet Explorer Won’t Upload Files to MOS?
May 2, 2013 | Author: Norman
Are you forced to use Internet Explorer at work? Are you, like me, forced to use an old, insecure, broken version of IE at work, because it’s the Government Standard version? And are you, like me, unable to upload evidence files to My Oracle Support? Read more »
Statspack Snapshot Fails ORA-01400 Cannot Insert NULL …
May 1, 2013 | Author: Norman
Oh hum. An 11.2.0.3 Enterprise Edition production database has statspack taking a regular snapshot under the control of a dbms_scheduler job. For no apparent reason, the snapshot started failing with ORA-01400 Cannot insert NULL into PERFSTAT.STATS$SYSTEM_EVENT.EVENT. This was an interesting one to fix. Read more »
My Step-Father’s Cremation
April 25, 2013 | Author: Norman
Antonio Enrico Martini was cremated on 19th April 2013. He had been a chef for many years and one of his friends, whose name I shall add here when I remember it – read this Address to a chef when Enrico retired in 1987. The version below, was amended from the 1987 version. Both are based on Address to a Pudding by Rabbie Burns. Read more »
Swap 2 Values, in SQL, Without Using a Temporary Variable
April 24, 2013 | Author: Norman
Recently, I saw a mention of an interview question for SQL developers. It was something along the lines of:
There is a table with a sex column. It has been discovered that the values are swapped around and need to be corrected. How would you swap all ‘M’ values to ‘F’ and all ‘F’ values to ‘M’, while leaving the other values untouched, in one single SQL statement and without requiring the use of any temporary variables.
So, how would you do it? Here’s my example. Read more »
Ever deleted a Data File From a Running Database?
April 23, 2013 | Author: Norman
http://jarneil.wordpress.com/2013/04/23/recovering-from-rm-rf-on-a-datafile/ has all you need to know to help avert a total disaster. Tanel Poder, who knows these things, advises that the file should be quiesced or made read only before attempting the recovery.
Firefox Running Extremely Slowly?
April 5, 2013 | Author: Norman
Firefox starts off ok, but soon starts running slower and slower, until it eventually starts to time out on connecting to some pages. The error messages is “the server took too long to respond” however, Firefox might be telling porkies. Read more »
TNS-01189: The listener could not authenticate the user
March 19, 2013 | Author: Norman
Ever see this error? I have, just today. An interesting one to debug. I got there in the end though. Read more »
Setting Oracle Environment in Scripts
March 18, 2013 | Author: Norman
A quickie! How do you set the correct Oracle environment in scripts? Do you hard code? You better not. Read more »
Linux Command to Retrieve Hardware Serial Numbers etc
March 18, 2013 | Author: Norman
Ever needed to obtain the serial number (or other details) for a remote server? Couldn’t be bothered to walk/run/drive/fly all the way there just to read a sticky label on the back or bottom of said server? Read on then. Read more »
Bee Tragedy
March 3, 2013 | Author: Norman
Yesterday, Saturday 2nd March 2013, I went to check on my two bee hives. They were fine and healthy with plenty feed stock last time I checked. Read more »
Here be Dragons!
February 25, 2013 | Author: Norman
I took this photo in Scotland, along the Crinan Canal, back in March 2009. Anyone know what it is? Click the image for a full screen version. (Warning – it’s 4000px by 3000px and 5.6 Mb file-size. The original file-size is even larger – it’s almost 12Mb!) Read more »