Monday May 27, 2013

The MAGIC Questions

Almost every week Roy, Carol and I receive one or more emails in the following style:

"Hey, we (or my customer) plan(s) an upgrade to Oracle 11g. We (or the customer) wants zero downtime. Currently we (or they) are on AIX with Oracle 10g (and someold  9i) databases. Can we get an advice please?"

or another one here ...

"Upgrade from 8i to 11g. The customer's database is 28 TB (quite big!). Downtime is 5-6 hours. It's on AIX. And it's an it's an Oracle EBS database"

Well, in both cases we lack a lot of useful information - or sometimes things are almost impossible or simply wishful thinking. So we have a collection of (we call them) The Magic Questions. Once those are answered upfront it is way easier to give a helpful advice.

  • Will you exchange the hardware?
  • Will you change to a new OS version?
  • Will you change to an entire new OS architecture?
  • Will you change the database characterset?
  • Do you plan to consolidate (schema/database/...)?
  • Number of databases you plan to upgrade or migrate?
  • Size of database(s)?
  • Exact source and target Oracle versions?
  • Maximum allowed downtime per database?
  • Fallback requirements?
  • Test environment available? Testing tools?
  • Does a performance baseline exist?
  • Changes required to enable new features?
  • RAC/Grid Infrastructure already in use or planned?

Once we get the answer and (even more helpful) a sheet describing the entire landscape in more detail we will be able to give some advice.

-Mike

Tuesday May 21, 2013

Back Home ...

Now finally back from my short trip to Johannesburg, South Africa. Flying out Monday overnight, returning Friday morning after another overnight flight (all Eco). But thanks to Turkish Airlines - including the short stop-over in Istanbul was worth it as the seating comfort in Turkish's economy class is far better than Lufthansa's - as is the food and especially the entertainment system, the service ... almost everything. And luckily the Turkish Airline's employees didn't go on strike in Thursday :-)

But after running now 6 internal Oracle Database 12c: Upgrade, Migrate and Consolidate workshops in the US and in EMEA I've learned a lot from our over 180 participants doing the full Hands-On part of the workshop.

I'm really looking forward to the release date :-) 

About

Mike Dietrich - Oracle Mike Dietrich
Master Product Manager - Database Upgrade & Migrations - Oracle Corp

Based near Munich/Germany and spending plenty of time in airplanes to run either upgrade workshops or work onsite or remotely with reference customers. Acting as interlink between customers/partners and the Upgrade Development.

Follow me on TWITTER

Contact me via LinkedIn or XING

Search

Archives
« May 2013 »
SunMonTueWedThuFriSat
   
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
22
23
24
25
26
28
29
30
31
 
       
Today
Oracle related Tech Blogs
Slides Download Center
Visitors since 17-OCT-2011
White Paper and Docs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers