The task was simple… Oh yes, hello by the way. It has been a while since I’ve posted! Anyways, like I said, the task was simple. Migrate an Oracle 10.1.0.3 32-bit database on one server to 10.2.0.3 64-bit on another server, and do it with only 1 hour of downtime.
Author: Steve Karam
Steve Karam, the Oracle Alchemist, is an Oracle Certified Master with over 15 years of DBA and database architecture experience with multiple RDBMS and NoSQL platforms, server and storage systems, and development frameworks.
The Oracle 11g Result Cache
I just wanted to take a minute to point any of my readers (hears crickets chirping) to a great article on the DBA-Oracle site regarding the Oracle 11g Result Cache. Take the time to have a read, it’s filled with great information, comparisons, and commentary. As always, make sure to
Say Goodbye to LIKE, and Hello to Oracle Text
Don Burleson recently posted a great article on using Oracle Text indexes to make up for the horrible performance issues caused by ‘%LIKE%’ queries on large blocks of text. I have personally been enjoying keyword searching CONTEXT indexes for quite some time through its various incarnations as the Context Option,
Log Buffer #60: a Carnival of the Vanities for DBAs
It has been a long time since I have posted on here (work and all, sorry about that), and so when I was asked to do another Log Buffer, it sounded like a great way to get back into the swing of things. Not to say work is light; on
Oracle Parameters You’d Love to See
Have you ever just WISHED that a parameter existed in Oracle? I know I have, and old coworkers of mine have long joked about the need for things like the “fix_database.sh” script. So I ask you, what parameters would you just LOVE to see show up by Oracle 20rr (Really
SCD: Slowly Changing Dimensions or Schroedinger’s Cat Dilemma?
In the world of theoretical physics there is a theoretical cat owned by Erwin Schroedinger. This famously fickle feline posed a problem: he could not decide if he was alive or dead. In the Schroedinger’s Cat thought experiment, a living cat is placed in a box with a nefarious device.
Socket Based Licensing for Standard Edition
I ran across this article today on Oracle’s new strategy for Standard Edition and Standard Edition One licensing. As a consultant, there are times when I have to tackle licensing questions, though I usually try to stay away from it and let Oracle’s salespeople do that job. However, I found
Patching from 10.2.0.1 to 10.2.0.3
I’m not a big fan of ignoring errors with OUI (we all have our horror stories), and so when I ran across this one I was loathe to ignore or cancel: Error in invoking target ‘all_no_orcl ipc_g’ of makefile Now, an experienced Oracle installer/patcher/troubleshooter/slave knows full well that most of
The Shining – Feel Good Movie of the Year
If you’ve ever seen the movie The Shining, you have to see this trailer! The story, so I hear, is that a film student did this for a contest called Trailer Park. The goal is to take a movie and create a trailer for that movie that makes it seem
It’s been a while!
Hello everyone…I know I haven’t posted in quite a while, and I’m not about to start now. Things have been extremely busy lately, starting with my 10g RAC course aboard the Carnival Glory on a 7-day Caribbean cruise (more on that later). So I will be posting again soon, and