Thursday Oct 25, 2012

Where's Gangnam?

When somebody did mention "PSY" during a dinner at OOW this year with customers and colleagues from Korea I was completely clueless. I even didn't understand correctly who or what "PSY" is. I did forget about that until last week as a German online magazine did report on over 500 mio youtube hits for "Gangnam Style". Well ... I didn't know that I've almost missed a global phenomenon. And now I've learned that the song is omnipresent in Korea (and not only here) - and Gangnam is a really nice (and expensive) quarter of Seoul :-) not that far away from my hotel.

And if you need some rest during your lunch break you may watch these youtube vids - but don't blame me if you don't get the song out of your head anymore ...

And NO - that's not the type of music I'd usually listen to!!!

OTN APAC Tour 2012: Bangkok, Thailand - RECAP

Thanks to everybody who did attend at the OTN APAC Tour in Bangkok on Monday, Oct 21. It was a pleasure for me to be back in Bangkok again even though I didn't have much time again due to my overnight flight to Seoul after the workshop.

But thanks for your questions - I will follow up as soon as I'm getting back home. And thanks to Francisco Alvarez, Oracle ACE Director from New Zealand, for inviting me. It was a pleasure presenting together with Francisco, Kamran Nagayev, Oracle ACE Director from Azerbaidjan and Tanakorn Tavornsasnavong from Bangkok. I have learned a lot during that day.

Mike Dietrich, Francisco Alvarez Munos, Kamran Agayev

In case you'd like to download my presentations from this day please find theme via this link. You may access the other slides on either the local OTN page or get them directly from Francisco's blog and Kamran's blog (and you'll find a lot of excellent and helpful articles there as well).

And many thanks to the local OTN group organizing the entire event so well :-) 

Hope to see you soon again :-)

Friday Oct 19, 2012

Migration of a database from 32bit to 64bit

Database migrations from an 32bit environment to an 64bit environment keeping the same platform architecture (e.g. moving an Oracle 10.2.0.5 database from MS Windows XP 32bit to MS Windows Server 2003 64bit) does not happen that often anymore. But still we see them getting done. And there are a few things to note when doing such a move.

First of all the important question is:
Will you upgrade your database as part of this move - Yes or No?

If you say "Yes" then you are almost done with that topic as we will take care of that bitnes move during the upgrade. The only thing you have to take care is OLAP in case you are using OLAP Option with Analytic Workspaces (AW) by yourself. Those store data in Binary LOBs - and in order to move AWs from 32bit to 64bit you have to export your AWs prior to the move - and import them later on. People who don't use OLAP don't have to take care on this. In that case you'll have to drop AWs after the export - please see MOS Note:386990.1 for further details.

But if you say "No" (meaning: no upgrade actions involved - you keep your database version) then you have to make sure to invalidate all packages and stored code in the database before you shutdown your database in the 32bit environment and prior to moving it over. And the same rule as above for OLAP applies once you use the OLAP Option.

In the source environment:

startup upgrade;    -- [or startup migrate; -- for Oracle 9i]
@?/rdbms/admin/utlirp.sql
shutdown immediate

In the destination environment:

startup upgrade
@?/olap/admin/xumuts.plb --Only if OLAP Option is installed
@?/rdbms/admin/utlrp.sql

The script utlirp.sql will invalidate all packages and stored code, utlrp.sql will recompile - and xumuts.plb will rebuild the OLAP Analytic Workspaces in case you have the OLAP Option installed.


Tuesday Oct 16, 2012

OTN APAC Tour 2012: Bangkok, Thailand - Oct 22, 2012

Roy had done some of the South America OTN Tour 2012 dates earlier this year in Peru and Chile. And I'm looking forward to present next Monday, October 22nd, 2012, on the OTN Tour 2012 in Bangkok, Thailand. The event will be held at the Eastin Grand Hotel in Bangkok.

Register today for the OTN APAC Tour 2012 in Bangkok, Thailand!

Presentations will include:

Plus presentations  about Security, RMAN and other topics by Francisco Alvarez and others. Please find the complete agenda here.

Looking forward to meet you on Monday - CU there :-)

Monday Oct 08, 2012

OOW 2012:
Slides Download

Hm ... you might ask yourself why there are no Oracle Database 12c slides available for download, neither in the OOW 2012 content system nor on our blog (and I believe nowhere else).

Simple reason: As long as Oracle Database 12c is not released and available we are not allowed to offer slides for download. Therefore people were simply taking pictures during the 12c sessions with their phones, iPods and cameras. Roy took a nice shot:


Sorry for that - we'll make the content available as soon as Oracle Database 12c gets released.

In between you can download our OOW 2012 talk Database Upgrades on Steroids: Real Speed, Real Customers, Real Secrets as PDF (3.4MB) - but the 12c content is currently not in that PDF. But a lot of information applies to your source database and/or to any upgrade - so it still might be helpful. And unfortunately the same 12c rule applies to the slides guiding you through our Hands-On-Lab on Tuesday.

Thanks :-)

OOW 2012:
Kings of Leon & Pearl Jam - Appreciation Event

June 15, 1992 - that was actually the day when Pearl Jam played their first concert in Serenadenhof in my hometown, N├╝rnberg. Oups ... that's over 20 years ago ... ;-)

So I was so happy to get a ticket to this year's OOW 2012 appreciation event on Treasure Island. Every year it amazes me over and over again how the organizers manage it logistically to bring almost 40,000 people to and back from the island. Food was ... I would say fairly ok ... and beer (as always) is not - actually even though I'm not a beer drinker I wouldn't call it beer

Kings of Leon did start. I like them a lot and owe their 2008 album Only By Night. That was a good start to warm up the crowd.

And then Pearl Jam took over - and ... wooooooow ... they are such a great live band. First of all as far as I understood they were donating the money they've got for that gig to an NGO. And Eddie Vedder's voice is simply striking ... I had shivers running down my spine. They played a good excerpt of their +20 years career closing down with Alive at the very end. It seemed to everybody that the band had real fun playing there - and it was sooooo good. Thanks a lot to the person who did organize me a ticket :-)

Catching my bus back to my hotel area down at Fisherman's Wharf worked well - but I must have fallen asleep 5 minutes after we've left the parking lot. The next thing I did recognize was the bus driver pushing the breaks at Northpoint. What a wonderful night ...

Thursday Oct 04, 2012

OOW 2012:
Under the Bridge ;-)

Just some impressions ...


Remember SF's landmark, Golden Gate bridge? Well ...


Moon over Bay Bridge

OOW 2012:
Deutsche Messe on their SAP Database Upgades

This Sunday Andreas Ellerhoff from Deutsche Messe (German Trade Fair) did report about Deutsche Messe's SAP/Oracle database upgrades to Oracle Database 11.2 and their improvements in comparison to Oracle Database 10g. Presentation was well attended and attendees I've talked to later on gave very positive feedback.

Download the slides here as PDF (2.6MB)

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
« October 2012 »
SunMonTueWedThuFriSat
 
1
2
3
5
6
7
9
10
11
12
13
14
15
17
18
20
21
22
23
24
26
27
28
29
30
31
   
       
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