Thursday Jan 09, 2014

Oracle Database 12c for AIX, HP-UX IA and zLinux now available

It took a while ... but finally Oracle Database 12c is available for:

Oracle Database 12c Release 1
Standard Edition, Standard Edition One, and Enterprise Edition

-Mike

Tuesday Jan 07, 2014

Upcoming ASIA Upgrade to Oracle 12c workshops

.

Happy New Year to all of you and your families!!!

.

We have still a few remaining seats for the upcoming workshops in January 2014.

Oracle Database 12c Upgrade, Migrate and Consolidate Workshops


  • Singapore - Jan 21, 2014
    • Register Here!
      @Singapore Post Centre Theatrette - Level 5 - 10 Eunos Road 8 - Singapore 408600

  • Jakarta/Indonesia - Jan 22, 2014
  • Kuala Lumpur/Malaysia - Jan 23, 2014

Oracle's Global Server Technology Upgrade Development Group offers you an opportunity to attend this exclusive full day seminar on how to Upgrade, Migrate & Consolidate to Oracle Database 12c.

Oracle's latest generation of database technology has significant new features. It offers great potential for migrations and consolidation, making more efficient use of hardware and delivering major improvements in management efficiency.

In this seminar the Oracle Database Upgrade Development team will guide you through several different examples of upgrade, migration and consolidation techniques and strategies - shown with real world customer cases.

You will learn:
  • How to take full advantage of the new features and options in Database 12c
  • The changes and enhancements to the Oracle Database upgrade process
  • Best practices to upgrade and migrate successfully

So you may register asap and spread the word :-)
Looking forward to meet you there!

-Mike

Monday Dec 16, 2013

Why you shouldn't set OPTIMIZER_FEATURES_ENABLE

Roy today answered an interesting question on one of our internal mailing lists. And this reminds me to pick up that piece of information as we see this quite often on customer sites, especially after upgrades or migrations. People set OPTIMIZER_FEATURES_ENABLE (OFE) to revert the optimizer's behaviour to another pre-current release. That's what a lot of people think this parameter does.

But in fact this is not true. Even though our documentation states it:

OPTIMIZER_FEATURES_ENABLE acts as an umbrella parameter for enabling a series of optimizer features based on an Oracle release number.

For example, if you upgrade your database from release 10.1 to release 11.1, but you want to keep the release 10.1 optimizer behavior, you can do so by setting this parameter to 10.1.0. At a later time, you can try the enhancements introduced in releases up to and including release 11.1 by setting the parameter to 11.1.0.6.

In my experience the following is true:
Setting this parameter reverts the optimizer settings in terms of parameters - but we still use the new optimizer code from that release you are on now. And as far as I know nobody ever tests if switching back OFE will turn back to exactly the behaviour as it was known in the release OFE is now switched to. So it's simply guessing and assuming. But as code got changed there's very little chance to get back to the old behaviour. 

What people sometimes  experience:
Turning back OFE brings back good performance. This can happen. But if we act really really really precise than the performance should always be better with the optimizer running with the new settings - and not when the wheel is turned back. So in some cases this should be treated as a bug unless new behaviour leads to predictable worse results (such as more buffer gets etc). And I get so angry when Oracle Support people recommend to switch OFE to this or that setting to cure one or the otther misbehaviour. That's like throwing a big rock to kill a fly. 

But the real danger is described in the following note - and I'm pretty sure a lot of people are not aware of this:
Reverting the optimizer parametrization with OFE can turn back to misbehaviour which got fixed already in the current release. MOS Note:1581465.1 describes this pretty well.

And in addition regarding upgrades you may want to read this note here as well:
MOS Note: 1362332.1
Use Caution if Changing the OPTIMIZER_FEATURES_ENABLE Parameter After an Upgrade
(Thanks Roy!)

Recommendation:
Stay away from tweaking anything with OFE. Use Real Application Testing's SQL Performance Analyzer (SPA) to find out which plans get changed and use SQL Plan Management (SPM) to nail down misbehaving plans in 11g or 12c.

-Mike 

Friday Dec 06, 2013

INTERACTIVE Database 12c QUICK REFERENCE

The Oracle Database 12c Interactive Quick Reference is a nice little tool which may help you quickly to find a view you are searching for or to get more information about background processes in Oracle Database 12c.

Click through it:
Oracle Database 12c: INTERACTIVE QUICK REFERENCE

-Mike

Tuesday Dec 03, 2013

Starting up 252 PDBs automatically?

In my recent posting I have explained the startup of many PDBs at the same time.

But once you startup the container database CDB$ROOT the PDBs will stay in MOUNT status. So how do you start them during CDB$ROOT startup (or immediately afterwards) in an automatic fashion?

A startup trigger will do this job.

CREATE OR REPLACE TRIGGER startup_all_pdbs
AFTER STARTUP ON DATABASE

BEGIN

EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN';

END;

/

And of course you can use the EXCEPT command option to exclude one or more PDBs from the automatic startup.

CREATE OR REPLACE TRIGGER startup_all_pdbs_except_a_few
AFTER STARTUP ON DATABASE

BEGIN
EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN EXCEPT PDB100, PDB101';
END;
/

How does this work in an Oracle Real Application Clusters environment?
In an RAC environment you won't need the startup trigger as clusterware takes over this role of ensuring the automatic startup of a PDB on designated nodes within the CDB$ROOT's instances.

srvctl add service -db rac -service pdbrac_srv -pdb pdbrac -preferred "rac1,rac2"

A snipet from the crsctl status output will look like this:

   crsctl status resource -t
    :
   ora.rac.db
         1    ONLINE  ONLINE   rac-server01       Open,STABLE
         2    ONLINE  ONLINE   rac-server02       Open,STABLE
   ora.rac.pdbrac_srv.svc
         1    ONLINE  ONLINE   rac-server01       STABLE
         2    ONLINE  ONLINE   rac-server02       STABLE
    :

-Mike

Friday Nov 29, 2013

Starting up 252 PDBs in Oracle Multitenant

What happens when you start up 252 PDBs (Pluggable Databases) with the Oracle Multitenant Option for the first time?

Interesting question, isn't it? The expectation would be that this will happen within seconds as the SGA and therefore the shared memory segments are already allocated from within the CDB$ROOT (Container Database). But ...

The following happens:
It takes minutes ... hours .... In my tiny lab environment with just as little as 20 PDBs due to space constraints it takes over 30 minutes to startup 21 PDBs. Takashi Ikeda from Fujitsu Hokoriku Systems who did a great demo with the new Fujitsu M10 servers at OOW this year told me that it took over two hours to start up 252 PDBs for the first time.
Why is that?

Let's have a closer look into the alert.log during startup. After issueing the command:

ALTER PLUGGABLE DATABASE ALL OPEN;

I'd expect all PDBs to get started. With an EXCEPT PDB1, PDB2, PDB3 clause I could exclude some PDBs from this action. Now a look into the alert.log shows a very promising message:

I'm just wondering about the opening sequence of PDBs. I'd expect 1 ... 2 ... 3 ... 4 ... ... ... 21. But the "order" is 3 ... 10 ... 16 ... 15 ... 20 ... 21 etc. telling me that the Resource Manager is not active (which is a must if you take Multitenant serious).
OK, for that strange order there's an explanation:
The open action gets distrubuted to slaves so PDBs may opened in a random order.
Fuuny thing apart from that: I can access the PDB but the system seems to be really under heavy pressure. CPUs are all at 100%. What the heck is going on here in the background?

Well, XDB needs to be installed (at least that is what the message says). Strange, isn't it, as the PDB$SEED has XDB in it and all my PDBs got provisioned from it. The awkward thing here is that the XDB messages appear over 20 minutes AFTER the PDBs signaled the Opening message into the alert.log (see the time stamps above).

Now after exchanging a few emails with some very helpful people in development there's an explanation for the XDB messages as well. Actually it doesn't get really installed but the SGA needs to be initialized for XDB. And I'm guessing that this action takes a lot of resources plus may cause contention when many PDBs get opened at the same time. And there's optimization work going on right now meaning that a problem with port initialization within the PDB will get fixed in a future patch set. So this issue with the very long startups of PDBs because of XDB should disappear in 12.1.0.2 most likely :-)

Finally it took another while to get the PDBs really into OPEN mode. Even though they were showing OPEN before already in V$PDBS. But as the CPUs all went to 100% as XDB got installed/initiallized at more or less the same time in all PDBs you really can't do anything.

Finally ...

... all PDBs got opened and the command ALTER PLUGGABLE DATABASE ALL OPEN returned completed.

The good news:
It takes just this long during the initial startup of a newly provisioned PDB. And you may see this issue only when you try to open many PDBs at the same time. But have a close look into your alert.log if you'll spot the message after creating a fresh PDB.

And btw, just for the records: I was using Oracle Database 12.1.0.1 with Oct 2013 PSU in it.

-Mike

Tuesday Nov 26, 2013

DOAG Conference - Recap

This year's 2013 conference was the best DOAG Conference I have attended so far (and it was my 11th conference).  Actually due to the fact that I've had just one presentation (Working with Oracle Multitenant in the Real World - thanks to everybody coming by in the huge TOKIO room - that was really fun!) and a DOAG TV interview I've had enough time to see some other presentations. I did actually enjoy the Oak Table Stream in room SHANGHAI a lot - so many good stuff, I have really learned a lot.

So thanks to the organizers from the user group (and especially to Christian Trieb and his colleagues from DOAG for pushing this extra stream).

And in case you'd like to download the slide deck:
Working with Oracle Multitenant in the Real World

-Mike

Wednesday Nov 13, 2013

Why people don't patch and upgrade?!?

Please see the JAPANESE version of this blog post here!!

Discussing the topic "Why Upgrade" or "Why not Upgrade" is not always fun. Actually the arguments repeat from customer to customer. Typically we hear things such as:

  • A PSU or Patch Set introduces new bugs
  • A new PSU or Patch Set introduces new features which lead to risk and require application verification 
  • Patching means risk
  • Patching changes the execution plans
  • Patching requires too much testing
  • Patching is too much work for our DBAs
  • Patching costs a lot of money and doesn't pay out

And to be very honest sometimes it's hard for me to stay calm in such discussions. Let's discuss some of these points a bit more in detail.

  • A PSU or Patch Set introduces new bugs
    Well, yes, that is really true as there's no software containing more than some lines of code being bug free. This applies to Oracle's code as well as too any application or operating system code. But first of all, does that mean you never patch your OS because the patch may introduce new flaws? And second, what is the point of saying "it introduces new bugs"? Does that mean you will never get rid of the mean issues we know about and we fixed already? Scroll down from MOS Note:161818.1 to the patch release you are on, no matter if it's 10.2.0.4 or 11.2.0.3 and check for the Known Issues And Alerts.
    Will you take responsibility to know about all these issues and refuse to upgrade to 11.2.0.4? I won't.

  • A new PSU or Patch Set introduces new features
    Ok, we can discuss that. Offering new functionality within a database patch set is a dubious thing. It has advantages such as in 11.2.0.4 where we backported Database Redaction to. But this is something you will only use once you have an Advanced Security license. I interpret that statement I've heard quite often from customers in a different way: People don't want to get surprises such as new behaviour. This certainly gives everybody a hard time. And we've had many examples in the past (SESSION_CACHED_CURSROS in 10.2.0.4,  _DATAFILE_WRITE_ERRORS_CRASH_INSTANCE in 11.2.0.2 and others) where those things weren't documented, not even in the README. Thanks to many friends out there I learned about those as well. So new behaviour is the topic people consider as risky - not really new features. And just to point this out: A PSU never brings in new features or new behaviour by definition!

  • Patching means risk
    Does it really mean risk? Yes, there were issues in the past (and sometimes in the present as well) where a patch didn't get installed correctly. But personally I consider it way more risky to not patch. Keep that in mind: The day Oracle publishes an PSU (or CPU) containing security fixes all the great security experts out there go public with their findings as well. So from that day on even my grandma can find out about those issues and try to attack somebody. Now a lot of people say: "My database does not face the internet." And I will answer: "The enemy is sitting already behind your firewalls. And knows potentially about these things."
    My statement: Not patching introduces way more risk to your environment than patching. Seriously!

  • Patching changes the execution plans
    Do they really? I agree - there's a very small risk for this happening with Patch Sets. But not with PSUs or CPUs as they contain no optimizer fixes changing behaviour (but they may contain fixes curing wrong-query-result-bugs). But what's the point of a changing execution plan? In Oracle Database 11g it is so simple to be prepared. SQL Plan Management is a free EE feature - so once that occurs you'll put the plan into the Plan Baseline. Basta! Yes, you wouldn't like to get such surprises? Then please use the SQL Performance Analyzer (SPA) from Real Application Testing and you'll detect that easily upfront in minutes. And not to forget this, a plan change can also be very positive!
    Yes, there's a little risk with a database patchset - and we have many possibilites to detect this before patching.

  • Patching requires too much testing
    Well, does it really? I have seen in the past 12 years how people test. There are very different efforts and approaches on this. I have seen people spending a heck of money on external licenses or on project team staffing. And I have seen people sailing blindly without any tests just going the John-Wayne-approach.
    Proper tools will allow you to test easily without too much efforts. See the paragraph above. We have used Real Application Testing in so many customer projects reducing the amount of work spend on testing by over 50%.
    But apart from that at some point you will have to stop testing. If you don't stop you'll get lost and you'll burn money. There's no 100% guaranty. You will have to deal with a little risk as reaching the final 5% of certainty will cost you the same as it did cost to reach 95%. And doing this will lead to abnormal long product cycles that you'll run behind forever. And this will cost even more money.

  • Patching is too much work for our DBAs
    Patching is a lot of work. I agree. And it's no fun work. It's boring, annoying. You don't learn much from that. That's why you should try to automate this task. Use the Database's Lifecycle Management Pack. And don't cry about the fact that it costs money. Yes it does. But it will ease the process and you'll save a lot of costs as you don't waste your valuable time with patching. Or use Oracle Database 12c Oracle Multitenant and patch either by unplug/plug or patch an entire container database with all PDBs with one patch at one time in one task.
    We have customer reference cases proofing it saved them 75% of time, effort and cost since they've used Lifecycle Management Pack. So why don't you use it?

  • Patching costs a lot of money and doesn't pay out
    Well, see my statements in the paragraph above. And it pays out as flying with a database with 100 known critical flaws in it which are already fixed by Oracle (such as in the Oct 2013 PSU for Oracle Database 12c) will cost ways more in case of failure or even data loss. Bet with me?

Let me finally ask you some questions.

What cell phone are you using and which OS does it run? Do you have an iPhone 5 and did you upgrade already to iOS 7.0.3? I've just encountered on my iPhone 5 that the alarm (which I rely on when traveling) has gotten now a dependency on the physical switch "sound on/off". If it is switched to "off" physically the alarm rings "silently". What a wonderful example of a behaviour change coming in with a patch set. Will this push you to stay with iOS5 or iOS6? No, because those have security flaws which won't be fixed anymore.And I tell you how I have found out that: I have tested the alarm after updating to iOS 7.0.3 as I heavily rely on that feature. I don't test everything as my time and my resource won't allow that - but I usually check the most important things.

What browser are you surfing with? Do you use Mozilla 3.6? Well, congratulations to all the hackers. It will be easy for them to attack you and harm your system. I'd guess you have the auto updater on.  Same for Google Chrome, Safari, IE. Right?

-Mike



Wednesday Nov 06, 2013

JPOUG Tech Talk Next Week!

JPOUG Logo

Mike and I are really looking forward to our trip to Japan next week, not least because we will have the opportunity to visit the Japan Oracle User Group for a Tech Talk. You can find all of the details about this event here:

JPOUG Tech Talk, Tuesday, 12-NOV-2013

The topic for our talk will be "Different ways to Upgrade, Migrate, and Consolidate with Oracle Database 12c."We will discuss changes and enhancements to database upgrade, how to move into a multitenant database environment, and new features that make database migration easier and faster than ever.

Thank you to our friends at the JPOUG for making this event possible! 

How to SET TIMING ON for parallel upgrades to 12c?

Have you asked yourself how to get timings in an Oracle Database 12c upgrade for all statements?

When you run the parallel upgrade via catctl.pl, the parallel upgrade Perl driving script in Oracle Database 12c, you may also want to get timings written in your logfile during execution. As catctl.pl does not offer an option yet the best way to achieve this is to edit the catupses.sql script in $ORACLE/rdbms/admin as this script will get called all time over and over again throughout all steps of theupgrade run.

Just add these lines marked in RED to catupses.sql and start your upgrade:

Rem =============================================
Rem Call Common session settings
Rem =============================================
@@catpses.sql

Rem =============================================
Rem  Set Timing On during the Upgrade
Rem =============================================
SET TIMING ON;

Rem =============================================
Rem Turn off PL/SQL event used by APPS
Rem =============================================
ALTER SESSION SET EVENTS='10933 trace name context off'
;


-Mike

PS: This may become the default in a future patch set ;-)


Friday Oct 25, 2013

Nordics OTN ACE Tour 2013 - Recap

The Nordics OTN ACE Tour 2013 with stops in Stockholm, Ballerup/Copenhagen and Oslo is over. A very intense week with plenty of excellent presentations from Lonneke Dikmans, Sten Vesterli, Tim Hall and others. I'm always impressed how much those people know and how good they present. It's such a great learning experience. And there's always some time to talk about weired things apart from the Oracle cosmos. So thanks a lot, folks - it was a pleasure to travel with you.

And many many thanks also to the people from ORCAN, DOUG and OUGN. Everything worked out so well. And thanks for the great gifts. the dinners, everything!!!

Of course a special thanks to all the people who went to my presentations. Hope you've enjoyed it - and sorry for any overtiming ;-) But as Tim said yesterday in the Shuttle Bus back to the airport: "45 min slots don't work out at all" :-) The final slide set about "Different Ways to Upgrade, Migrate and Consolidate into Oracle Database 12c including Oracle Multitenant, New Features and other stuff" can be downloaded via this link.

Hope to see you all again soon - and let me know once you have successfully upgraded to Oracle Database 12c or in case you'd like to become one of our Upgrade Reference Customers.

Cheers - Mike

PS: One thing I couldn't really understand - why is that thing below not labeled simply GRAPE JUICE??? And who's honestly drinking that?



Wednesday Oct 16, 2013

October 2013 PSUs and CPUs - News for 12c

Last night CET the most recent Patch Set Updates (PSU) and Critical Patch Updates (CPU aka SPU) got published on MOS. And there's a significant and remarkable change for Oracle Database 12c onwards. MOS Note: 1571391.1 - Patch Set Update and Critical Patch Update October 2013 Availability Document says:

2.1 Database Security Patching from 12.1.0.1 Onwards

Starting with Oracle Database version 12.1.0.1, Oracle only provides Patch Set Updates (PSU) to meet the Critical Patch Update (CPU) program requirements for security patching. Security Patch Updates (SPU) will no longer be available. Oracle has moved to this simplified model due to popular demand. The PSU is Oracle's preferred proactive patching mechanism since 2009.

For more information, see My Oracle Support Note 1581950.1, Database Security Patching from 12.1.0.1 onwards.

That's a real change. It's not harmful at all as our recommendation for years now is to apply PSUs as they contain not only the security patches but also the important fixes for critical issues. And apply them asap - the day we publish the Security Patch Advisory with some details is the day when external security experts go public as well with their findings.

MOS Note: 756671.1 - Oracle Recommended Patches -- Oracle Database will guide you to the databases patches for your platform. If you miss the PSU for Oracle Database 10.2.0.5 (the Pre-Release Announcement stated that there will be a PSU for 10.2.0.5) my personal understanding is: as Oracle 10.2.0.5 went out of Extended Support in July 2013 there won't be any October PSU released anymore.

And I'll apply the new 12.1.0.1 Oct13 PSU now to my Oracle Database 12c Multitenant environment as well :-)

Don't forget:
MOS Note: 224346.1 - OPatch: Where Can I Find the Latest Version of OPatch?
Find it via Patch Placeholder 6880880

-Mike

Thursday Oct 10, 2013

OOW 2013: Recap - Thanks a lot!!!

OOW 2013 is over for a while now. And yesterday we've received the session results from our talk and the HOL. And we have to say Thank You Very Much! For your time, for the great discussions, for your feedbacks. This is the highest session count we've had in the past years.

Generally my overall feeling this year was that database sessions were very well attended - and the two sessions I wanted to see in my limited spare time were already sold out. And we've really had so many great discussion at our booth 007 - and Joe was an excellent "double" as Daniel Craig was kept up with other stuff ;-)


Joe Errede and Carol Tagliaferri

So thanks again - and we hope to make you the VBox image for the lab available soon for download. In between please feel free to download the slides from the download center - or simply grab the big deck about Upgrade to Oracle Database 12c.

Furthermore let me introduce the new sections with White Papers making it easier to find them and the new Oracle Blogs section with blogs I fequently visit.

And finally here are some impressions from OOW 2013:


Adam Levine from Maroon 5


Matt Flynn and Adam Levine from Maroon 5


At the "Friends of Pythian" event - thanks to Alex Gorbatchov for the invitation :-)


Yes - and OOW happens every year in SF :-)

Cheers - Mike

Wednesday Sep 25, 2013

OOW 2013: Hands On Lab

Hello everybody,

 thanks a lot for your attendance at our Hands On Lab at OOW 2013 - glad that you've made it through our 4 HOL tasks :-) And sorry again for the slow laptops but that's not under our control.

For those who wanted to download the slides please use the slides from our OOW talk as it contains almost all of the slides we've showed during the lab. And in case you want to get the full set of over 500 slides about Upgrade, Migration and Consolidation to Oracle Database 12c please find them in the Slides Download Center to the right.

Thanks again and all the best!

- Carol, Cindy, Joe, Roy and Mike

Monday Sep 23, 2013

OOW 2013: Different Ways to Upgrade to 12c

Today is our talk:
Different Ways to Upgrade, Migrate and Consolidate into Oracle Database 12c
We've had over 300 preregistration so we hope to see you there in Moscone 102 at 3:15pm on Monday, Sept 23.

And you can download the slides for today's talk via this link.

And please find us after the talk in the Exhibition Area in Moscone South at booth SL-007 in the left corner of the area - it's just the first booth at the corner.

Thanks :-)

-Mike

Monday Sep 16, 2013

Oracle Database 12c pre-upgrade scripts and JAVAVM

This is a great example of why you should always review the README file when upgrading to a new release. Here is an issue that we found during customer beta testing, and that you will want to be aware of if you are upgrading to Oracle Database 12c and do not have the JAVAVM component in your database. The following text has been added to the 12.1 Readme under Section 1.1:

TITLE: Pre-Upgrade Tool Does Not Generate Output Logs

The pre-upgrade tool, preupgrd.sql, is not able to create a directory to
store the output files if the JAVAVM component either does not exist in the
database registry or is set to INVALID or OPTION OFF (reference Bug
14614756). For example:

SQL> @/tmp/preupgrd
Loading Pre-Upgrade Package ...
WARNING: Failed to open preupgrade.log for write access
   script will generate terminal output only
WARNING: Failed to open preupgrade_fixups.sql for write access
   script will not generate fixup scripts.

Results of the checks are located at:
*** Scripts/Logs are not being Generated *** preupgrade.log

The workaround is to manually create the output directory before running
preupgrd.sql by executing the following steps:

1. If ORACLE_BASE is defined in the environment settings, either create a
directory $ORACLE_BASE/cfgtoollogs/<db-unique-name>/preupgrade or create a
directory $ORACLE_HOME/cfgtoollogs/<db-unique-name>/preupgrade.

2. To get <db-unique-name>, use the following query:

   SELECT value FROM V$PARAMETER WHERE NAME = 'db_unique_name';

   Note that <db-unique-name> used in the directory path is case sensitive.

3. Rerun the preupgrd.sql tool.

As you can imagine, your upgrade will be smoother if you are aware of issues like this before you upgrade instead of running into them on your go-live weekend!

Thursday Aug 29, 2013

Focus on Database Upgrade at OpenWorld 2013

If you are going to Oracle OpenWorld in September, you might be overwhelmed by the sheer number of sessions throughout the week. ForOracle OpenWorld Logo those with an interest in database upgrade, I have prepared a Focus on Database Upgrade listing that lays out the sessions, demos, and hands-on lab for this area. Here is the listing thus far (NOTE: the list of sessions could change, so please check the document link at the start of OOW for the most current information!).

GENERAL SESSIONS

Monday, Sep 23, 2013

General Session: Oracle Database 12c—Engineered for Clouds and Big Data
Andrew Mendelsohn, Oracle
10:45 AM - 11:45 AM Moscone North - Hall D GEN8229
CONFERENCE SESSIONS

Monday, Sep 23, 2013

Consolidating Databases with Oracle Database 12c
Bryn Llewellyn, Oracle
Patrick Wheeler, Oracle
12:15 PM - 1:15 PM Moscone South - 102 CON8707
Different Ways to Upgrade, Migrate, and Consolidate with Oracle Database 12c
Mike Dietrich, Oracle
Roy Swonger, Oracle
Carol Tagliaferri, Oracle
3:15 PM - 4:15 PM Moscone South - 102 CON8176
Mission-Critical Banking Systems Migration to Oracle Exadata: Lessons Learned
Jason Reinhardt, CBA
Sohan Demel, Oracle
3:15 PM - 4:15 PM Moscone South - 308 CON9239
Database Migration Best Practices and Oracle Migration Factory
Ronald Carter, UBS
Bharat Patel, Oracle
4:45 PM - 5:45 PM Moscone South - 252 CON6054

Wednesday, Sep 25, 2013

Upgrade-Ready for Oracle Database 12c
Michelle Malcher, DRW Holdings
11:45 AM - 12:45 PM Moscone South - 236 CON7695
Upgrade with Oracle Database 11g’s SQL Plan Management: Best Practices from Bank of America
DEEPAK BANG, BANK OF AMERICA
William Rice, Bank of America Merril Lynch
Zimin Chai, Oracle
11:45 AM - 12:45 PM Moscone South - 305 CON6938
The Important Things DBAs Should Do Before and After an Oracle Database Upgrade
Julian Dontcheff, Accenture Oy
5:00 PM - 6:00 PM Moscone South - 236 CON1715

Thursday, Sep 26, 2013

Under the Hood of Pluggable Databases
Alex Gorbachev, The Pythian Group Inc.
11:00 AM - 12:00 PM Moscone South - 305 CON7593
Cross-Platform Database Upgrades with Oracle GoldenGate
Sharmila Kamath, Oracle
Nalin Sahoo, Oracle
2:00 PM - 3:00 PM Moscone South - 305 CON4286
DEMOS
Oracle Database 12c Unicode Migration Moscone South, Left - SL-019
Upgrade to Oracle Database 12c Moscone South, Left - SL-007

Friday Aug 23, 2013

Pictures from the OTN Tour 2013

Some very nice pics from the OTN South Leg 2013 in Uruguay, Argentina and Brasil taken mostly by the user group photographers :-) 

Thanks and credits to those who took the pictures :-)

OTN Tour 2013 - Argentina

OTN Tour 2013 - Uruguay

OTN Tour 2013 - Brazil

- Mike

Wednesday Aug 14, 2013

Muchas gracias, Buenos Aires :-)

Again, thanks a lot to everybody who did attend to our Lab at the OTN Tour 2013 in Buenos Aires, Argentina, and/or to Roy's talk about Data Pump in Oracle Database 12c and my presentation about News in Database Upgrades to Oracle Database 12c on August 7. It was our pleasure to meet and work together with you. And thanks to the local folks of ArOUG organizing such a great event and taking care on us.

And - on another note - the person who did accidentally take one of our 64GB thumb drives at the Hands-On-Lab may please send it back to Oracle Argentina (Juana Manso 1069 - Piso 7 -- CP C1107CBS  -- Buenos Aires) - and the local folks will forward it via office mail to Roy's office. Just make sure you state that it is meant for Roy Swonger at Oracle USA in Nashua :-) Thanks in advance :-)

In case you would like to download other English  presentations from the OTN Tour 2013 event in Buenos Aires or other cities please find them here:

S1: Joel Perez - New features in Oracle Database 12c
S2: Alex Gorbachev - 12c: Under The Hood of Pluggable Databases
S3: Alex Gorbachev - Benchmarking Oracle I/O Performance with ORION
S4: Alex Gorbachev - Hadoop for Oracle Database Professionals
S5: Joel Perez - New Features 12c: Pluggable Databases & Recovering Tables from RMAN Backups
S6: Joel Perez - New Features 12c: RMAN: Cross-Platform Transporting Databases using RMAN Backup sets
S7: Mike Dietrich/Roy Swonger - What's New in Database Upgrade?
S8: Roy Swonger - Migrate and Consolidate our Databases to the Latest generation of Database Technology using Data Pump
S13: Hernán Petitti - What's New in Oracle VM Server for x86
S14: Hernán Petitti - Why Choose Oracle Linux for your Oracle stack
S15: Dana Singleterry - ADF Mobile: Developing for iOS and Android with ADF & Java

S17: Ultan Obroin - Building Better Applications User Experiences with the Oracle Fusion Applications User Experience Design Patterns
S19: Bruno Borges - What WebLogic 12c Has to Offer to Boost Your Productivity
S20: Bruno Borges - What’s new in Java EE 7
S21: Tim Hall - PL/SQL: Stop Making The Same Performance Mistakes
S22: Tim Hall - Analytic Functions : The Oracle Developers Best Friend
S23: Gustavo Gonzalez - Still on Oracle EBS 11i? Why You Should Upgrade Now Instead of Wait and See
S24: Gustavo Gonzalez - How Oracle E-Business Suite R12.2 Gives a New Ground for ADF Developments

Just on the side: Buenos Aires is really a spectacular city :-) Below you'll find some city impressions ...



-Mike


Wednesday Aug 07, 2013

Muchas gracias, Montevideo :-)

Muchas gracias to everybody who did attend our Hands-On-Lab on Monday and Roy's presentation yesterday at the OTN Tour 2013 in Montevideo. And thanks a lot to our hosts, Edelweiss, Nelson, Paolo and Daniel from the UYOUG. You were so nice, so helpful, so hospitable - it made this event and our stay a very special thing!

As usual you can download the slides from the Slides Download Center to the right (scroll down a bit, please).

And as I enjoyed Montevideo a lot here are a few impressions:

-Mike

Saturday Aug 03, 2013

OTN Tour South America: Uruguay, Argentina & Brazil

I really don't look forward to a 20 hour trip in coach from Munich to Montevideo, Uruguay. But I'm looking forward to meet and see many tech folks in Montevideo, Buenos Aires and Sao Paolo during the next week. Roy and I will deliver a Hands-On-Lab in Montevideo on Monday and in Buenos Aires on Wednesday. Plus presentations on Tuesday, Thursday and finally Saturday in Sao Paolo. Well, and our colleagues in Brazil have taken the chance to schedule 3 customer visits in Rio and Sao Paolo on Friday in between :-) After this week I will need a few days off :-)

Here's the link to the event on August 5 and 6, 2013 in Montevideo, Uruguay.

Then we'll move on with the ferry boat crossing the Rio Della Plata to Buenos Aires for August 7 and 8, 2013.

And finally we'll be in Sao Paolo on August 10, 2013.

So again, here's the overview:

CU there :-)
-Mike

Wednesday Jul 31, 2013

Thanks to our User Groups in Panama, Costa Rica, and Mexico!

I just have a few moments in the airport to say "Thanks!" to the Oracle User Groups in Panama, Costa Rica, and Mexico for a great series of events last week. Your hospitality was wonderful, and I appreciate the work that goes into organizing and running events like these.

And thanks especially to everybody who  came to learn about the variety of topics: Database Upgrades, Oracle Database 12c, Hadoop, EBS, Enterprise Manager, and more.

Great audience at the OTN Tour in Mexico City

Mike and I are looking forward to the OTN Tour events next week in Montevideo, Buenos Aires, and São Paulo! 

Monday Jul 29, 2013

Very cool videos about Upgrade to Oracle 12c

Sometimes it is by far easier to watch a few short videos instead of reading an entire book :-)

So enjoy watching Roy talking about Upgrades and Migrations to Oracle Database 12c in short videos covering also the new Upgrade and Migration features in Oracle Database 12c.

.

Chapter 1 - Upgrading is Universal

Chapter 2 - Minimizing Risk and Downtime

Chapter 3 - Leveraging Consolidation to ease Migration

Chapter 4 -Why Upgrade?

Chapter 5 - Automating the Upgrade Process

-Mike


Wednesday Jul 24, 2013

OOW Shanghai - Slides for the Migrate+Consolidate Talk


What a huge venue! My talk Migrate and Consolidate onto Oracle Database 12c was scheduled today in the BLUE HALL. I did walk around before to see where the room is located and how big it is. Actually "room" is the wrong word. It is more like a concert hall. But usually the problem with such big venues is: if you have just a small number of people showing up you feel pretty alone on the stage. I was thinking of bringing the guy on top of this blog entry with me - but that wasn't necessary :-)

Blue Hall OOW Shanghai

Luckily many people came by today. I did count approx 150. All very keen to see how you can upgrade, migrate and consolidate onto Oracle Database 12c works. Please feel free to download the slides in Chinese from the link below:

Migrate and Consolidate onto Oracle Database 12c (Chinese Version)

If you would like to get the slides in English as well please take the huge slide deck:

Upgrade, Migrate & Consolidate to Oracle Database 12c

It contains the same content and much more.

Thanks for visiting today - it was a pleasure for me. And thanks for the excellent discussions at the end!

-Mike



Tuesday Jul 23, 2013

OOW Shanghai - Slides for Hands-On-Lab (HOL)

Dear all,

thanks for your participation on the Hands-On-Lab for Upgrade and Plugin to Oracle Database 12c today at OOW Shanghai 2013. It was a pleasure for me to work with you and my colleagues from Oracle China. And please forgive us the slowness of the machines. When I did shutdown the VBox images after the session I realized that some noncdb_to_pdb.sql scripts were still recompiling. 


You'll be able to download the slides:

谢谢 - Mike


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
« April 2014
SunMonTueWedThuFriSat
  
2
3
4
5
6
9
10
12
13
15
16
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
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