Author Archives:
Astell & Kern – AK100 Review
Send article as PDF My wife bought me one of these because my old iRiver H340 has begun eating batteries. It’s on its third replacement now, plus I have more music than fits the H340′s hard drive. I do not buy Apple products, so any iWhatever (other than iRiver) was out of the [...]
Spatial Indexes and Oracle Errors. How to fix.
Send article as PDF 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.
Need to Compile a 32 bit Application on a 64 bit Linux System?
Send article as PDF 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 [...]
This Listener Problem is Driving Me Mad!
Send article as PDF 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.
ORA-03262 While Dropping Empty Datafile
Send article as PDF 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?
Send article as PDF 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?
Statspack Snapshot Fails ORA-01400 Cannot Insert NULL …
Send article as PDF 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.
My Step-Father’s Cremation
Send article as PDF 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 [...]
Swap 2 Values, in SQL, Without Using a Temporary Variable
Send article as PDF 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 [...]
Ever deleted a Data File From a Running Database?
Send article as PDF 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?
Send article as PDF 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.
TNS-01189: The listener could not authenticate the user
Send article as PDF Ever see this error? I have, just today. An interesting one to debug. I got there in the end though.
Setting Oracle Environment in Scripts
Send article as PDF A quickie! How do you set the correct Oracle environment in scripts? Do you hard code? You better not.
Linux Command to Retrieve Hardware Serial Numbers etc
Send article as PDF 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.
Bee Tragedy
Send article as PDF 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.