Search

OakieTags

more tags

Who's online

There are currently 0 users and 32 guests online.

Recent comments

Affiliations

Home » Monthly archive

May 2012

Farnham’s Seven Steps of Application Design

Submitted by mwf on Wed, 2012-05-16 18:31

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.

UKOUG 2012: Call for Papers

Submitted by harald on Wed, 2012-05-16 09:54

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 […]

Repairman Jack : Infernal…

Submitted by oraclebase on Wed, 2012-05-16 09:02

Infernal is the ninth book in the Repairman Jack series by F. Paul Wilson.

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… :)

UKOUG 2012...

Submitted by tkyte on Tue, 2012-05-15 17:15

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.

I've been a long time supporter of all of the user groups and their conferences and I can attest to the quality of the UKOUG event.  The conference is chock full of technical talks with hundreds of sessions to choose from.  There is something for everyone there.

OT: I want this (WordPress) theme

Submitted by martin.bach on Tue, 2012-05-15 14:30

Apologies for a completely non-technical blog item – feel free to skip!

However, if you have used a Mac SE like I have, running on System 6, then you’d love this WordPress theme I just discovered:

System 6 theme

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.

Index Rebuild – Does it use the Index or the Table ? (Nothing Touches Me)

Submitted by Richard Foote on Tue, 2012-05-15 06:37

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 [...]

UltraEdit 3.1 for Mac and Linux…

Submitted by oraclebase on Mon, 2012-05-14 21:16

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…

Cheers

Tim…

ORA-600 Troubleshooting Tool

Submitted by Timur Akhmadeev on Mon, 2012-05-14 15:27

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.

Job Interview…

Submitted by oraclebase on Mon, 2012-05-14 12:42

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. :)

Tale of a platform migration Solaris 10 SPARC 10.2.0.5 to Linux 11.2.0.2.6

Submitted by martin.bach on Mon, 2012-05-14 12:13

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.