Thursday Feb 23, 2012

Upgrade Workshop in Bangkok - Slides

Thank you very much for the warm welcome today at the Upgrade and Migration Workshop in Bangkok. Roy and me are very happy to be finally here.

You can download the most recent version of the slides via this link:
Upgrade and Migration to Oracle 11.2 Workshop Slides

Have successful upgrades - and let us know your experiences with the upgrades and migrations!
And hope to see you next time again!

Monday Feb 20, 2012

Upgrade Workshop in Jakarta - Slides

Thanks to everybody today in the Upgrade and Migration Workshop in Jakarta. And thanks for all your questions during the breaks.

In order to download the most recent version of the slides (just refreshed them now during the lunch break) please find them here:
Upgrade and Migration to Oracle 11.2 Workshop Slides


Have successful upgrades - and don't even think about upgrading to Oracle 10g right now - Oracle 11.2.0.3 is the release you should upgrade to in the near future :-)

Friday Feb 17, 2012

Oracle 11g in Action: Real World Customer Experiences

31 minutes about customer who'd upgrade to Oracle Database 11g:


(and neither Prash nor me did choose the lady as teaser ;-) ...)

Wednesday Feb 15, 2012

Why is every patchset now a full release?

This question got posted by Naveen in the previous entry today - and I found it worth it to create a new blog entry as this question gets raised in nearly every 2nd workshop as well - so others might be interested as well.

Mike,

A question has been bothering me for a while and I thought I'll throw it out there. I didn't raise a support ticket, I knew what the response is going to be.

So here is the question. I have an 11g ORACLE HOME that was built as 11.2.0.1. Now if I want to upgrade to 11.2.0.2 or 11.2.0.3, I guess there is no easy way to upgrade the existing ORACLE HOME. Why didn't Oracle give the option to just apply a patch (opatch) and upgrade to 11.2.0.2 (or .3). For a customer to create a new ORACLE HOME is just a lot of work and breaks a lot of things. We have to copy over so many configs from the old home to the new home.

I'm sure there is a good reason, I'm just trying to understand what they are.

Thanks
Naveen

Naveen, thanks for your question. And the answer has many aspects.

Install into your existing ORACLE Home

First of all you can still install the new patch set (which is now a full release since Oracle 11.2.0.2) into your existing $ORACLE_HOME. But you'll have to detach your current home from the OUI's inventory first. Please see slide 41 of the Upgrade and Migration workshop deck. Please backup the contents of $ORACLE_HOME/dbs and $ORACLE_HOME/network/admin first as you'll have to copy them back later.

$ ./runInstaller -detachHome ORACLE_HOME=/u01/orahomes/11.2.0

Starting Oracle Universal Installer...

Checking swap space: must be greater than 500 MB. Actual 10047 MB Passed

The inventory pointer is located at /etc/oraInst.loc

The inventory is located at /u01/orabase

'DetachHome' was successful.

Once you've done that you'll install into your existing (old) directory.  And finally you'll copy back your dbs and network/admin files.

Why customers might use this procedure?

There are basically two reason why a customer chooses this strategy:
(a) Home naming conventions not allowing an Oracle 11.2.0.2 home and another Oracle 11.2.0.3 home
(b) Space issues
Both are valid reasons and therefore you can stay with the old strategy.

Why did we change from patchsets to full release patchsets?

Simple reason: Customers did ask us for a looooong time why we are delivering 3GB large patchsets instead of full releases. So we'd follow this wish. And second it will decrease the overall downtime when you'd install into your new Oracle Home. If you apply patchset software to your existing Oracle Home every Oracle process serviced by that home must be shut down as well - obviously including the database(s). And furthermore if something fails you'll have to restore your OUI's inventory plus all home contents - or reinstall your previous Oracle software.

Besides that we recommend to patch this home first with important one-offs (see links in MOS Note 161818.1) and the latest PSU or CPU. If you'd do that to your already emptied old home it will simply increase again your overall downtime.

And this is the reason why we recommend:
Always install into a new Oracle home beginning with Oracle Database 11.2 - don't erase your old home to reuse it unless there's no significant need for that procedure.

Tuesday Feb 14, 2012

Upcoming Workshops in Jakarta, Singapore and Bangkok

Next week will be again a travel week - and it means going from deep frosty winter into "warmer" areas of the world. But we are really looking forward to meet you in Jakarta, Singapore and Bangkok. And in case you just read this now there are still seats open as far as I know :-)

Friday Feb 10, 2012

Note:1389592.1 Public - Speed Up xTTS

As we have already mentioned in our recent workshops the MOS Note:1389592.1 is public now:

  • MOS Note:1389592.1
    Reduce Transportable Tablespace Downtime using Cross Platform Incremental Backups

This technique currently works for migrations to Linux64 and is supported by Oracle Support for Exadata migrations only. It utiliuzes RMAN incremental backups to reduce the large amount of downtime it takes to copy and convert the datafiles cross Endianness.

Two requirements must be met to use this new functionality:

  • Oracle 11.2.0.2 plus Exadata BP12 (patch 12982245)
  • One-off patch 13340675 contains the RMAN extension and is currently available on top of BP12 on Oracle 11.2.0.2

Let me know if you have further questions - and this restriction on Oracle 11.2.0.2 with BP12 applies to the intermediate instance you'll use to roll forward your converted incremental backups only. Source might be Oracle 10.2 whereas target might be also an Oracle 11.2.0.3 installation.

Saturday Feb 04, 2012

Nuremberg Sausage???

I'll try almost all food wherever I am in the world (except for Scorpios-on-a-Stick, Sheep Penis and such stuff). But I didn't try this in our hotel in Rio:

No offense - but Nuremberg (or in German: Nürnberg) is my hometown - and Nürnberger Bratwürste look a little bit different. If you'd ever visit Germany and you'll have to chance to see Nürnberg you might order "Drei im Weggla" (three [sausages] in a bread bun) and every Franconian will understand you ;-)


But still Roy and me had some fun at the breakfast buffett ;-)

Obrigado :-)

Thanks a lot to everybody who did visit our workshops in Sao Paulo and Rio de Janeiro in the past days. And actually our "Thank You" or Obrigado! can't express how Roy and me felt in the past days. I believe I've never felt so welcome - you all, customers, partners and Oracle folks were simply great. Thanks a lot for that. We've had a great time - and we hope you had some fun as well and enjoyed the hands-on lab as well.

Let us know if anything with your upgrades does not run as desired - or if all worked out well. And also if you'd like to try the "Turbo xTTS" technique. The note got published last night and I'll write something about it in the upcoming weeks.

So we hope to see you again - maybe in 2014 during the World Cup ;-) I'll push Murilo to setup another series of workshops by then ;-)

And thanks a lot for all your comments and feedbacks - we really appreciate that!!

Obrigado!!!

PS: Sorry for the typo in obrigado - and thanks to all who'd let me know ;-)

Wednesday Feb 01, 2012

Upgrade Workshops in Sao Paulo and Rio

Thanks to everybody who did attend today at our Upgrade and Migration Workshop in Sao Paulo and Rio de Janeiro. We hope that you'd enjoy the day and the hands-on exercise :-)

And please feel free to download the most recent version of the slides with many hidden slides included we couldn't show at the workshop today.

Obrigado!

About

Mike Dietrich - Oracle Mike Dietrich
Senior Principal Technologist - Database Upgrade Development Group - Oracle Corporation

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

Contact me either via XING or LinkedIn

Search

Archives
« February 2012 »
SunMonTueWedThuFriSat
   
2
3
5
6
7
8
9
11
12
13
16
18
19
21
22
24
25
26
27
28
29
   
       
Today
Slides Download Center
OOW Slides Download
Visitors since 17-OCT-2011
White Paper and Docs
Oracle Blogs
Workshops
Viewlets and Videos
This week on my Rega/iPod/CD
Workshop Map
Upgrade Reference Papers