Here is a snippet I wrote on the oracle-l list today before I remembered that I’m a blogger now. To see the whole thread in context (potentially including someone telling me I’ve got it all wrong later today or in the future) the subject was OT: sheltered little world i live in -> NODB?
Someone opined about where a DBA would start designing. That person might be right about some DBAs. Here is approximately what I wrote (only fixing some typos and grammar, I think.):
gee whiz. I think people think of me as a DBA. re: “That’s true that DBA would start designing application from database.” (sic.)
Larry Constantine has written some excellent books about information systems design. Many of my ideas are well explained in those books.
Just a quick note about the Call for Papers for the upcoming UKOUG 2012 annual conference to be held on 3rd to 5th December in Birmingham. I have been a speaker for the last 5 years and I think this is a very valuable conference about Oracle technology in Europe. If you want to be […]
Another family tragedy has the effect of reuniting Jack with his brother Tom, the judge. It turns out Tom is not as squeaky clean has he appears and needs Jack’s help for something less than legal. As you can probably guess by now, it all turns sinister and mystical…
The call for papers for the UKOUG 2012 conference ends in less than three short weeks! If you were planning on going to the conference (and even if not) - you should consider submitting a paper.
Apologies for a completely non-technical blog item – feel free to skip!
Unfortunately I can’t use it as most of the source code I’m posting is too wide.
I can almost hear the characteristic SuperDrive noise when reading one of my floppy disks. A moment of nostalgia.
A common question that gets asked is does Oracle access the index itself or the parent table during an index rebuild to extract the necessary data for the index ? Thought it might be worth a blog post to discuss. Now if the index is currently in an UNUSABLE state, then Oracle clearly can’t use the existing [...]
I’ve been using the beta versions of UltraEdit 3.1 for Mac and Linux for a while, but I only noticed today the production version has been released. I normally get email updates, so I figure this one must have got directed to spam by accident.
Anyway, I’m now rockin’ the latest version on both platforms. Happy days…
I’ve just noticed that the new HTML MOS introduced a nice addition to the old ORA-600/ORA-7445 Error Look-up Tool: now there is a new ORA-600 Troubleshooting Tool (if the link is not opened automatically for you try refreshing the page with F5 – works for me in Chrome).
Within a few minutes it allows you to upload a generated trace file and then automatically redirects you to the search results based on the error reported in the trace. The tool should be useful to those who don’t know what to do with the trace. It also allows you to save the results in a “report”. It’s definitely a very nice addition to the MOS functionality.
I went for a job interview today… (pause while Debra Lilley picks herself off the floor)
It’s probably been about 8 years since I’ve had a formal interview like this. I admit I was a little nervous going in, but it turned out to be pretty good fun.
It started with a 1 hour written exam. It’s been about 20 years since I’ve written more than a signature with a pen, so having to write with a pen for 1 hour was pretty terrifying. I’m not big on remembering syntax (that’s what the manuals are for ), but hopefully I showed that I understood what was going on. Some of the questions could have been answered with “Read this: www.oracle-base.com/articles/….”. Pity that wasn’t an option.
This is as much a note to myself how to do this in the future as it is something hopefully worth reading for you. The requirement has been precise as always: migrate a database from 10.2 on SPARC to 11.2 on Linux. In the process, go from Veritas to ASM and make it quick!
I like short briefings but this was too short. Since the database was reasonably large I opted for the transportable tablespace approach, however I now think that a massively parallel impdp with network_link could have saved me quite a bit of time.
The following is by no means the complete story, but hopefully gives you an idea how to do these things. Always check, and document, then test (rinse and repeat). Only when proper signoff is received should you try such a process in production. Remember to script it and have at least one clean run of the scripts! This process is not super-quick, if you have low downtime requirements then consider Streams or better: Golden Gate for the process.