Tuesday Aug 05, 2014

Upgrade PDBs - One at a Time (unplug/plug)

*** I have added an important change on May 26, 2015 ***
***      Please see below marked in YELLOW           *** 
********************************************************

Basically there are two techniques to upgrade an Oracle Multitenant environment:

In this post I will refer to the "One at a Time" approach and describe the steps. During some presentations, discussions etc people were left with the impression that it will be a very simple approach to unplug one or many PDBs from a CDB in lets say Oracle 12.1.0.1 and plug it into an Oracle 12.1.0.2 Container Database. Bingo, upgraded!

Well, unfortunately this is not true. In fact it is completely wrong.


If you want to upgrade via unplug/plug the following steps will have to be followed:

  • In CDB1 environment - e.g. Oracle 12.1.0.1 with an PDB1
    • In SQL*Plus: 
      • alter session set container=PDB1;
      • @$ORACLE_HOME_12102/rdbms/admin/preupgrd.sql
        (The output of the preupgrade.log will show you the location of the fixups)
      • @/u01/app/oracle/cfgtoollogs/CDB1/preupgrade/preupgrade_fixups.sql
        (If ORACLE_BASE is not set the files will be created under $ORACLE_HOME/cfgtoollogs instead of $ORACLE_BASE/cfgtoollogs)
      • exec dbms_stats.gather_dictionary_stats;
        (plus include all additional treatments recommended by the preupgrade.log)
      • alter session set container=CDB$ROOT; 
      • alter pluggable database PDB1 close;
      • alter pluggable database PDB1 unplug into '/stage/pdb1.xml';
      • drop pluggable database PDB1 keep datafiles;
        The reason why you will need to DROP the PDB afterwards is simply to cleanup leftovers in the CDB views. It is under observation if this is a bug or not. The information does not get removed to allow quick plugin again but the leftovers may cause plenty of trouble once you'll try to upgrade this CDB1 later on.
      • exit
        .
  • In CDB2 environment - e.g. Oracle 12.1.0.2
    • In SQL*Plus:
      • alter session set container=CDB$ROOT;
      • At this point we "could" do a Plug In Check but as the COMPATIBLE of the new CDB2 created as per recommendation with DBCA defaults to "12.1.0.2" the Plug In Check will result in "NO" - but obviously the plugin operation will work. Just for the records here's the procedure to check plugin compatibility
        • SET SERVEROUTPUT ON
          DECLARE
            compatible CONSTANT VARCHAR2(3) := CASE DBMS_PDB.CHECK_PLUG_COMPATIBILITY(
            pdb_descr_file => '/stage/pdb1.xml',
            pdb_name => 'PDB1')
            WHEN TRUE THEN 'YES' ELSE 'NO'
          END;
          BEGIN
          DBMS_OUTPUT.PUT_LINE(compatible);
          END;
          /

          .
          select message, status from pdb_plug_in_violations where type like '%ERR%';
          .
      • create pluggable database pdb1 using '/stage/pdb1.xml' file_name_convert=('/oradata/CDB1/pdb1', '/oradata/CDB2/pdb1');
      • alter pluggable database PDB1 open upgrade;
      • exit
    • On the command prompt:
      • cd $ORACLE_HOME/rdbms/admin 
      • $ORACLE_HOME/perl/bin/perl catctl.pl -c "PDB1" -l /home/oracle/upgrade catupgrd.sql
    • Back into SQL*Plus:
      • alter session set container=pdb1;
      • startup
      • @?/rdbms/admin/utlrp.sql
      • @/u01/app/oracle/cfgtoollogs/CDB1/preupgrade/postupgrade_fixups.sql
        (If ORACLE_BASE is not set the files will be created under $ORACLE_HOME/cfgtoollogs instead of $ORACLE_BASE/cfgtoollogs)
Of course this technique will work also with more than one PDB at a given time. You'll have to repeat the steps, and your upgrade call on the command line will look like this:

      • $ORACLE_HOME/perl/bin/perl catctl.pl -c "PDB1, PDB2" -l /home/oracle/upgrade catupgrd.sql

Well, not really unplug+plug=upgraded ;-)

-Mike 

PS: I did add a few pieces of information based on the excellent feedback given to me by Frank Kobylanski from the MAA Team - cheers, Frank!!! 

Friday Aug 01, 2014

New (some undocumented) Parameters in Oracle 12.1.0.2

Every release offers some surprises - even to myself ;-)

Right now Roy and I are in the final steps to refresh our big slide deck to the new layout, but more important, to have Oracle 12.1.0.2 information included as well (were necessary). So I did my usual "compare parameters" query between releases - getting unusual surprises this time.

This is the list of new parameters introduced with the patch set Oracle Database 12.1.0.2. Where applicable I have added the link to the doc.

But as you may recognize not all of them are explained in the doc ;-)

  • DBFIPS_140
    • Default: FALSE
    • DBFIPS_140 enables Transparent Data Encryption (TDE) and DBMS_CRYPTO PL/SQL package program units to run in a mode compliant to the Federal Information Processing Standard (subsequently known as "FIPS mode";)
  • COMMON_USER_PREFIX
    • Default: c##
    • Specifies a prefix that the names of common users, roles, and profiles in a multitenant container database (CDB) must start with. If COMMON_USER_PREFIX is set to an empty string, Oracle will not enforce any restrictions on the names of common or local users, roles, and profiles.
  • DB_PERFORMANCE_PROFILE <<updated Dec 16>>
    • Undocumented
    • See bug17861171, bug18406144 and bug19817284 - IORM feature on Exadata only
  • ENABLE_GOLDENGATE_REPLICATION
    • Default: FALSE
    • Controls services provided by the RDBMS for Oracle GoldenGate (both capture and apply services). Set this to true to enable RDBMS services used by Oracle GoldenGate
    • Introduced with Oracle 11.2.0.4 and Oracle 12.1.0.2
  • EXCLUDE_SEED_CDB_VIEW
    • Undocumented
    • Per feedback by the Multitenant team:
      • Default: TRUE
      • Setting this parameter to FALSE would return results for the seed database when querying against the CDB views
  • INMEMORY_CLAUSE_DEFAULT
    • Default: an empty string
    • Enables you to specify a default In-Memory Column Store (IM column store) clause for new tables and materialized views. If the INMEMORY_CLAUSE_DEFAULT parameter is unset or set to an empty string (the default), only tables and materialized views explicitly specified asINMEMORY will be populated into the IM column store. Setting the value of the INMEMORY_CLAUSE_DEFAULT parameter to NO INMEMORY has the same effect as setting it to the default value.
  • INMEMORY_FORCE
    • Default: DEFAULT
    • Allows you to specify whether tables and materialized view that are specified as INMEMORY are populated into the In-Memory Column Store (IM column store) or not. The default value is DEFAULT. When this value is in effect, the IM column store is populated only with tables and materialized views specified as INMEMORY. If OFF is specified, then even if the IM column store is configured on this instance, no tables or materialized are populated in memory.
  • INMEMORY_MAX_POPULATE_SERVERS
    • DefaultHalf the effective CPU thread count or the PGA_AGGREGATE_TARGET value divided by 512M, whichever is less.
    • Specifies the maximum number of background populate servers to use for In-Memory Column Store (IM column store) population, so that these servers do not overload the rest of the system
  • INMEMORY_QUERY
    • Default: ENABLE
    • Used to enable or disable in-memory queries for the entire database at the session or system level. This parameter is helpful when you want to test workloads with and without the use of the In-Memory Column Store (IM column store)
  • INMEMORY_SIZE
    • Default: 0
    • Sets the size of the In-Memory Column Store (IM column store) on a database instance. If a database does not have automatic memory management enabled, this parameter must be set to a nonzero value that reserves the amount of memory to use for the database's IM column store. The default value is 0, which means that the IM column store is not used. The database must be restarted after setting this parameter to enable the IM column store. The minimum size to which this parameter can be set is 100 MB.
  • INMEMORY_TRICKLE_REPOPULATE_SERVERS_PERCENT
    • Default: 1
    • Limits the maximum number of background populate servers used for In-Memory Column Store (IM column store) repopulation, as trickle repopulation is designed to use only a small percentage of the populate servers. The value for this parameter is a percentage of the INMEMORY_MAX_POPULATE_SERVERS initialization parameter value
  • OPTIMIZER_INMEMORY_AWARE
    • Default: TRUE
    • Enables or disables all of the optimizer cost model enhancements for in-memory. Setting the parameter to false causes the optimizer to ignore the in-memory property of tables during the optimization of SQL statements. This behavior can also be achieved by setting theOPTIMIZER_FEATURES_ENABLE initialization parameter to values lower than 12.1.0.2
  • PDB_LOCKDOWN
    • Undocumented
    • Per feedback by the Multitenant team:
      • Not functional in Oracle 12.1.0.2
  • PDB_OS_CREDENTIAL
    • Undocumented
    • Per feedback by the Multitenant team:
      • Not functional in Oracle 12.1.0.2
      • May be functional with a future PSU allwoing then OS user verfication/validation for PDBs

-Mike

PS: Forgot to mention this one as a parameter which had been disappeared in Oracle 12.1.0.2:

  • PARALLEL_FAULT_TOLERANCE_ENABLED
    • Undocumented in Oracle 12.1.0.2
    • Disappeared in Oracle 12.1.0.2 but did exist in Oracle 12.1.0.1 

Tuesday Jul 29, 2014

Today the Upgrade Blog has its Fifth Anniversary :-)

Not sure if 5 is a lucky number :-)

But in fact today the Upgrade Blog "Upgrade Your Database Now!" has its fifth anniversary.

Well, there's not an update every day - and there are spans of silence for weeks when I'm either too busy (traveling most likely, writing etc) or when I feel there's not much important to say.  

So it's time to say THANK YOU to all our visitors and readers. I can't say exactly how many people have visited the blog so far as I have put up the Flag Counter only less than 3 years ago. And it does not count people logged into the Oracle network as our IT folks have blacklisted the Flag Counter for whatever reason (opened tickets never get a response). Guessing that we've had over 500,000 hits within the past 5 years. And almost 40,000 downloads of our "Upgrade, Migrate and Consolidate to Oracle 12c" deck. That it impressive. And the new version with new layout, new content and some corrections and enhancements will follow soon. 

So thanks to all of you for stoping by, coming back, commenting, sending mails, discussing and downloading our stuff - and we'll do our best to keep you updated on Database Upgrades and Migrations in the future, and serve you well with useful tech slide decks :-)

-Mike

Thursday Jul 24, 2014

Why "We'll wait for the 2nd release!" is a misconception ...

Oh, how often have I heard this phrase:

"We'll wait for the second release!"

And sometimes it makes me really anxious and angry at the same time when I hear that.

Anxious because it means that somebody has no strategy for the database upgrades/migrations and is just postponing necessary tasks to sometime in the future. Easy deal but not very clever

Angry because this is a way of thinking from the 90s/00s when Oracle had this "10.1", then later "10.2" strategy in database releases. But we are in 2014 now. And things have changed. Changed a lot in fact.

I'm probably not the only person who would love to see if we'd remove this "first" and "second" release tags. This has become obsolete with Oracle 11.1. We were telling customers officially that this is the brand new fantastic Oracle Database 11g release. But in fact it was - from the coding perspective - more or less a very stable 10g. In my workshops I did call it Oracle 10.3 with a marketing sticker on it. And as far as I can see the customer's I've had helped with going live on Oracle Database 11.1.0.7 were quite happy. Some really large shops still work with this release today with hundreds of databases in production.

But honestly most of the changes got introduced with Oracle Database 11.2. And not for a small number of customers this meant waiting for the first patch set (which since then has become a full release). Plenty of people went live with Oracle Database 11.2.0.2. But a lot of the remarkable changes got introduced not in Oracle 11.1 but in Oracle 11.2. Just remember things such as the move from Clusterware to Grid Infrastructure. But also minor things such as DEFERRED_SEGMENT_CREATION and plenty of optimizer news.

Now with Oracle Database 12c and the first patch set (full release) 12.1.0.2 I have heard this again - and I see it on the mailing list as well once a week:

"When will Oracle 12.2 be available?"

Well, that's the misconception. It's true, Oracle Database 12.1.0.2 has new features and extensions. But it has also many fixes over the already very stable Oracle 12.1.0.1. Why should anybody wait for Oracle 12.2 now? Because it's supposed to be THE SECOND release? Forget this - this is thinking from the old days.
We are in year 2014 now.

And then spend a minute to look closer to the Support Policy.

  • Oracle Database 11.2 will go out of Premier Support in 6 months. Yes!!! 6 months
  • And correct, we'll give everybody on Oracle 11.2.0.4 one full year of Extended Support for free
  • For Oracle 11.2.0.3 Extended Support will end 28-AUG-2015

That means if you plan to stay on Oracle 11.2.0.3/4 for a longer period you'll either have to calculate 20% extra of your support fee for the 2nd year of Extended Support. Or you prefer to "hope".

I can't tell you when Oracle 12.2 will be available - and I don't care. Usually people wait for the first patch set anyways which gets releases based on experience from the past 3 databases releases roughly a year and a bit after the initial release. Just do the math and you'll see where you end up with this strategy.

My recommendations are:

  • Stop thinking about THE SECOND release
  • Evaluate Oracle Database 12.1.0.2 now - not tomorrow
  • Look at the Support Policy - you need to start your upgrades as soon as possible
-Mike 

 

 

Tuesday Jul 22, 2014

Oracle Database 12.1.0.2 is available!!!

Oracle Database 12.1.0.2 is available for download now. It is the most comprehensive patch set we've ever built. Look up the list of inclusions - and it includes the new marquee feature OracleDatabase In-Memory.

Three things important to mention:

  • It is a full release - no need to get Oracle Database 12.1.0.1
  • Even though it is a patch set it will be available on OTN and eDelivery - and Oracle Database 12.1.0.1 will be removed instantly
  • For now it is an Enterprise Edition install only - SE and SE One may follow later.
    Please see MOS Note:1905806.1 for further details.

And it contains a bunch of new things and improvements:

  • Oracle Database In-Memory
  • Oracle Big Data SQL
  • Oracle JSON Document Store
  • Oracle REST Data Services
  • Improvements to Oracle Multitenant
  • Advanced Index Compression
  • Zone Maps
  • Approximate Count Distinct
  • Attribute Clustering
  • Full Database Caching
  • Rapid Home Provisioning
Availability is for the following platforms right now:

Time to upgrade!!! 

-Mike

PS: Kudos to Morohashi-san for alerting me about the link to the internal MOS - exchanged the link address!
PPS: Updated entry on Sept 30 with links for MS Windows

Monday Jul 14, 2014

Deutschland ist Weltmeister!!!

No tech stuff this morning :-)

I'm still so exited. It was a true thriller yesterday with 127 minutes of suspense, fights and even blood - and chances on both sides. But overall I think Germany was the better team not only yesterday but throughout the entire tournament. Last time when Germany became Weltmeister (World Champion) in Italy in 1990 I was in Turkey on after-school-vacation celebrating a win over ... well, Argentina :-)

And this time I watched the match again with friends in an Italian restaurant in Munich - and the best team of the World Cup 2014 won over ... well, Argentina again :-) I'm still so exited :-)

And obrigado also to all the wonderful people in Brazil. In previous world cups often matches such as Honduras vs Switzerland had just a small crowd of people in the stadium. This time it seemed like a huge party :-) Obrigado, Brazil!

-Mike 

Monday Jul 07, 2014

Remote Cloning of Pluggable Databases
in Oracle Database 12.1.0.1

Cloning of Pluggable Database in Oracle Multitenant is a great feature and very useful. It had just a tiny flaw in Oracle Database 12.1.0.1: Remote cloning from one to another CDB fails

This will work flawless beginning with the first patch set Oracle 12.1.0.2 - but if you want to use that feature still in Oracle 12.1.0.1 you need to apply at least PSU3 or a single patch 18898403.

See the documentation

-Mike 

Back on Track :-)

No updates for almost 3 weeks? Well ... sometimes I need a bit of vacation as well ... and for sure I didn't board an airplane. Thanks for staying tuned and you'll see the next update within a few hours :-)

 -Mike

Monday Jun 16, 2014

DBUA can ignore Underscores with "keepHiddenParams"

The Database Upgrade Assistant (DBUA) by default will remove all underscores and events before actually doing an upgrade. This is expected behaviour as we believe that underscores or events were meant to treat misbehaviour of the database just in a specific release only. And in our experience a nice collection of underscores will at least make your upgrades run slower.

Now with Oracle Database 11.2.0.4 and Oracle Database 12.1.0.1 the DBUA has a new parameter which can be used during startup:

$> dbua -keepHiddenParams

Then it will keep the hidden/underscore parameters during and after the upgrade.

-Mike 

PS: Many thanks to Mr. Frank Becker for highlighting this to myself - I wasn't aware of it - screenshot is courtesy from Mr Becker as well 

Friday Jun 13, 2014

Upgrade Workshops in Bucharest, Athens and Warsaw

Finally travel time is not over yet. There are 3 more workshops Upgrade, Migrate & Consolidate to Oracle Database 12c due to happen within the next few weeks:
.

Friday Jun 06, 2014

Save Upgrade downtime: Upgrade APEX upfront

With almost every patch or release upgrade of the Oracle Database a new version of Oracle Application Express (APEX) will be installed. And as APEX is part of the database installation it will be upgraded as part of the component upgrades after the ORACLE SERVER component has been successfully upgraded to the new releases.

APEXBut the APEX upgrade can take a bit (several minutes or even more in some cases). Therefore it is a common advice to upgrade APEX upfront before upgrading the database as this can be done online while the database is in production (unless your databases serves just as an APEX application backend - in this case upgrading APEX upfront won't save you anything).

To upgrade Oracle APEX upfront you'll have to follow
MOS Note:1088970.1.

It explains that you'll have to:

  1. Determine the installation type by running this query:
    select count(*) from <SCHEMA>.WWV_FLOWS where id = 4000;
    whereas <SCHEMA> can be one of the following:
    FLOWS_010500 1.5.X 
    FLOWS_010600 1.6.X 
    FLOWS_020000 2.0.X 
    FLOWS_020100 2.1.X 
    FLOWS_020200 2.2.X 
    FLOWS_030000 3.0.X 
    FLOWS_030100 3.1.X  
    APEX_030200 3.2.X 
    APEX_040000 4.0.X
    APEX_040100 4.1.X
    APEX_040200 4.2.X

    If the query returns 0 then you'll need to run apxrtins.sql
    If the query returns 1 then you'll need to execute apexins.sql

  2. Download the newest APEX package and install it.

-Mike

Monday May 26, 2014

Boat Successfully Arrived at Oracle HQ

Wondering what you can transport with a Sikorsky S-64 SkyCrane? For instance you could fly a Trimaran from the Bay to Oracle's HQ and park it in the lake :-)

Credits go to Cindy Lim for the picture - and you may watch the entire arrival via this link:

-Mike

New interesting White Paper:
Oracle Multitenant Efficiency Study

There's a new White Paper available interesting for those who'd like to learn a bit more about the efficiency and the overhead of Oracle Multitenant in a fairly large environment:

http://www.oracle.com/technetwork/database/multitenant/learn-more/oraclemultitenantt5-8-final-2185108.pdf

-Mike

Tuesday May 13, 2014

More than one PDB in the same directory?

Can you create more than one pluggable database (PDB) within the same directory?
And how does the file naming work? Considering the fact each PDB's SYSTEM tablespace will be named system01.dbf by default the question is not trivial. 

This question got asked by a customer during one of the workshops in Switzerland last week. And the solution is straight forward. Thanks to Roy for trying it out yesterday at 170 km/h on our way back from Stuttgart :-)

Thanks :-)

-Mike 

Additional information:

Within ASM with OMF the file structure looks like this:

 1  select con_id, substr(file_name,1,90),tablespace_name from cdb_data_files
  2* order by 1

    CON_ID SUBSTR(FILE_NAME,1,90)                                                           TABLESPACE_NAME
---------- -------------------------------------------------------------------------------- ---------------
         1 +DA1/CDBUPGR/DATAFILE/system.394.845632641                                       SYSTEM
         1 +DA1/CDBUPGR/DATAFILE/users.475.845632685                                        USERS
         1 +DA1/CDBUPGR/DATAFILE/undotbs4.448.845632683                                     UNDOTBS4
         1 +DA1/CDBUPGR/DATAFILE/sysaux.392.845632651                                       SYSAUX
         1 +DA1/CDBUPGR/DATAFILE/undotbs2.393.845632679                                     UNDOTBS2
         1 +DA1/CDBUPGR/DATAFILE/undotbs1.471.845632657                                     UNDOTBS1
         1 +DA1/CDBUPGR/DATAFILE/undotbs3.478.845632681                                     UNDOTBS3
         2 +DA1/CDBUPGR/F7B70DCBF2D4ECEAE0437A28890AE4D8/DATAFILE/sysaux.472.845632655      SYSAUX
         2 +DA1/CDBUPGR/F7B70DCBF2D4ECEAE0437A28890AE4D8/DATAFILE/system.398.845632647      SYSTEM
         3 +DA1/CDBUPGR/F6A142792168D540E0437A28890A4707/DATAFILE/system.493.845643325      SYSTEM
         3 +DA1/CDBUPGR/F6A142792168D540E0437A28890A4707/DATAFILE/sysaux.468.845643325      SYSAUX
         3 +DA1/CDBUPGR/F6A142792168D540E0437A28890A4707/DATAFILE/soets.452.845643325       SOETS
         4 +DA1/CDBUPGR/F7B9BDC2AEC4411EE0437A28890A2B81/DATAFILE/system.491.845643937      SYSTEM
         4 +DA1/CDBUPGR/F7B9BDC2AEC4411EE0437A28890A2B81/DATAFILE/sysaux.488.845643937      SYSAUX
         4 +DA1/CDBUPGR/F7B9BDC2AEC4411EE0437A28890A2B81/DATAFILE/soets.484.845643937       SOETS
         5 +DA1/CDBUPGR/F7B9CA6B92804A56E0437A28890A2721/DATAFILE/system.485.845644149      SYSTEM
         5 +DA1/CDBUPGR/F7B9CA6B92804A56E0437A28890A2721/DATAFILE/sysaux.490.845644149      SYSAUX
         5 +DA1/CDBUPGR/F7B9CA6B92804A56E0437A28890A2721/DATAFILE/soets.487.845644149       SOETS
         6 +DA1/CDBUPGR/F7B9D727715B5B4AE0437A28890AB3D9/DATAFILE/system.486.845644363      SYSTEM
         6 +DA1/CDBUPGR/F7B9D727715B5B4AE0437A28890AB3D9/DATAFILE/sysaux.483.845644363      SYSAUX
         6 +DA1/CDBUPGR/F7B9D727715B5B4AE0437A28890AB3D9/DATAFILE/soets.481.845644363       SOETS
         7 +DA1/CDBUPGR/F7B9E3D23CFC67F1E0437A28890A5A68/DATAFILE/system.453.845644575      SYSTEM
         7 +DA1/CDBUPGR/F7B9E3D23CFC67F1E0437A28890A5A68/DATAFILE/sysaux.482.845644575      SYSAUX
         7 +DA1/CDBUPGR/F7B9E3D23CFC67F1E0437A28890A5A68/DATAFILE/soets.467.845644575       SOETS
         8 +DA1/CDBUPGR/F7B9F051E81B7892E0437A28890AD3A3/DATAFILE/system.465.845644785      SYSTEM
         8 +DA1/CDBUPGR/F7B9F051E81B7892E0437A28890AD3A3/DATAFILE/sysaux.455.845644785      SYSAUX
         8 +DA1/CDBUPGR/F7B9F051E81B7892E0437A28890AD3A3/DATAFILE/soets.479.845644785       SOETS
         9 +DA1/CDBUPGR/F7BA2D0F2F17A755E0437A28890A72C6/DATAFILE/system.464.845645805      SYSTEM
         9 +DA1/CDBUPGR/F7BA2D0F2F17A755E0437A28890A72C6/DATAFILE/sysaux.500.845645805      SYSAUX
         9 +DA1/CDBUPGR/F7BA2D0F2F17A755E0437A28890A72C6/DATAFILE/soets.498.845645805       SOETS
        10 +DA1/CDBUPGR/F7BA3A179DAFB12FE0437A28890ABBF3/DATAFILE/system.499.845646023      SYSTEM
        10 +DA1/CDBUPGR/F7BA3A179DAFB12FE0437A28890ABBF3/DATAFILE/sysaux.504.845646023      SYSAUX
        10 +DA1/CDBUPGR/F7BA3A179DAFB12FE0437A28890ABBF3/DATAFILE/soets.502.845646023       SOETS
        11 +DA1/CDBUPGR/F7BA46A1A6B7B9C2E0437A28890AE021/DATAFILE/system.503.845646233      SYSTEM
        11 +DA1/CDBUPGR/F7BA46A1A6B7B9C2E0437A28890AE021/DATAFILE/sysaux.508.845646233      SYSAUX
        11 +DA1/CDBUPGR/F7BA46A1A6B7B9C2E0437A28890AE021/DATAFILE/soets.506.845646233       SOETS
...


Friday May 09, 2014

LOCATION UPGRADE +++ Hamburg +++ May 15, 2014

My colleagues did an awesome job inviting so many people to our workshop in Hamburg next week. Therefore Marketing now moved it from the Oracle Office in HH to the following address:

PRIVATHOTEL EGGERS
Rahlstedter Straße 78
22149 Hamburg

Registration will start at 9am, workshop begin is at 9:30am - and we'll end straight at 4:30pm to catch our flight back to Munich. So please try to stay in time ;-)

Looking forward to see you all next week :-)

- Roy & Mike 

New Slides + Workshop Recap:
Luxembourg, Brussels, Vienna, Geneva & Baden

The first 5 of a long workshop run are over. Thanks for coming in, your patience for hundreds of slides and plenty of new (and some old) stuff. I really enjoyed seeing you and talking to you in Luxembourg, Brussels, Vienna, Geneva and Baden in the last 3 weeks.

And credits go to my colleagues Bernd Jodocy, Johan Vanden Bossche, Erwin Sulzgruber, Roger Wullschleger, Christiane Schlüter and all the others for setting up the events so well, did the inviations, assisted before, during and after the workshops - and gave me taxi rides between airports and locations. Thanks again for your great support!!!

I will try to follow up with the questions as soon as possible (if not done already). And - as promissed - here is the new slide deck:

Upgrade, Migrate & Consolidate to Oracle Database 12c

We've had an incredible 16000 downloads in the past 8 weeks - that's almost as much as in the 8 months before since 12c hit the streets. So I'd guess MANY are interested in how to upgrade, migrate and consolidate to 12c ;-)

Thanks again and if you have additions to the slides, please feel free to let us know!

-Mike 

PS: I deeply appologize again for the faulty HOL setup in Vienna. I gave my colleague Erwin a hard time - and he has sent out a workaround to you so you can complete the lab by yourself. Sorry again!!! 

Tuesday May 06, 2014

Upgrade Workshops - Locations

Dear all,

unfortunately somebody has missed to add the locations to the registrations page - and if you follow the Google Maps links you may drive apparently to a McDonalds burger place instead of the correct location (at least they'll offer free WLAN).

So please find the updated locations here - and enter the registration by clicking on the location/date directly.

I appologize for any inconvenience.
Hope to see you soon!

-Mike 

Wednesday Apr 23, 2014

"Mr. Upgrade" on DOAG.TV

Mike may be too humble to post this himself, so I will point out that the Oracle user group in Germany (DOAG) has published a video of an interview with Mike about upgrade to Oracle Database 12c. The interview is in German, so if you speak the language, please enjoy:

DOAG.TV screenshot

Those who  are inclined to view the video may also want to pay attention to the announcement about upgrade workshops in Germany. See Mike's blog entry about our upcoming events for more information!

Thursday Apr 17, 2014

Avoid Poor Performance and Wrong Results in 11.2.0.4

One of the best notes in MOS got refreshed last night for Oracle Database 11.2.0.4. It has not only information about performance bugs but also about the worst and meanest category of issues, wrong query result bugs. Those are the ones I call the "sleeping beauties" as you as a DBA usually won't recognize them. It is recognized at the application level when the result of a report is incorrect or instead of 4 rows just 3 rows get delivered in the output. Therefore you should be highly aware of those and add this note to your bookmarks.

MOS Note 1645862.1Things to Consider Before Upgrading to 11.2.0.4 to Avoid Poor Performance or Wrong Results

And in case you don't want to move to Oracle 11.2.0.4 but searching for information and known issues in Oracle 11.2.0.3 or Oracle 11.2.0.2 then please find the corresponding documents:

  • MOS Note: 1320966.1 Things to Consider Before Upgrading to 11.2.0.2.x to Avoid Poor Performance or Wrong Results
  • MOS Note: 1392633.1 Things to Consider Before Upgrading to 11.2.0.3 to Avoid Poor Performance or Wrong Results
-Mike

Monday Apr 14, 2014

Upcoming UPGRADE Workshops in Europe - Register Now

There will be a lot of travel within the next few weeks. So please keep your fingers crossed that Lufthansa pilots don't go on strike for their ridicolous goals again. And I hope to see you in one of our upcoming workshops within the next weeks somewhere in the below cities.

Click on the date/location to the RIGHT to register, see location and agenda etc. 

CU soon :-)

- Mike and Roy 

Friday Apr 11, 2014

Why cows can fly! Believe it or not ...

A colleague of mine, Murilo from Oracle Brasil talked about our roles at Oracle (but this applies to any other software company in the market I'd guess).

Do you believe in flying cows?

  • Sales
    In Sales you'll sell a customer that cows can fly
  • Presales
    The presales consultant will have to do a presentation showing the ROI, TCO and KPIs of flying cows. She or he may have also a screenshot demo in Powerpoint showing flying cows. 
  • Consulting
    The consultant is the person to install the flying-cow piece of software at the customer site and embedd it into the customer's environment. Unfortunately the poor consultant finds out that in this environment cows actually don't fly well. In fact, cows don't fly at all. So the consultant may raise an SR before going home.
  • Support
    The SR gets into the queue of a Support engineer somewhere in the world. The Support engineer wonders about this SR as she or he has never heard of flying cows before. So she/he takes a look into the doc. And there's nothing mentioned about flying cows. But the doc doesn't say anything about "cows can't fly" so a testcase will be required from the customer or the consultant to show the non-flying cows. Poor Support engineer: she/he can't even file a bug for it as the doc doesn't say anything about the flying-cow-feature. 

Guess how that story will end?
Does it sound familiar to you? To me it does ... a bit ;-)
And I'm glad that I'm working in Development :-)

So you may watch this tiny little video in your spare time ...

-Mike

PS: Thanks to Murilo - and I phrased it in my own words as I still burst out laughing and crying at the same time when thinking about our conversation :-) But credits go to him - obgrigado!!!

PPS: No offense to anybody in any role in a software company ... 

Tuesday Apr 08, 2014

COLLABORATE 2014: Upgrade Slides for Download

Roy today presented about Upgrade Best Practices to Oracle Database 12c including moving into the world of Multitenant and Pluggable Databases at COLLABORATE 2014 in Las Vegas.. And the slides can be downloaded via this link:

COLLABORATE 2014 - Database Upgrade to Oracle 12c

-Mike 

Monday Apr 07, 2014

OUGN - Great Conference!!! Download the Slides

The cruise is over :-) And what an excellent event. Congratualations to Alice, Frank, Øyvind and all the other great people from the OUGN. I had plenty of fun, met great people - and here are the slides for the two presentations I gave:

  • Hitchhiker's Guide to Oracle Database Upgrades
    This slide deck will give an overview about how to approach a database upgrade project, the risk and costs of not upgrading and the news in the Upgrade space for Oracle Database 12c upgrades

  • What's New in Data Pump in Oracle 12c
    This overview about general Data Pump best practices highlights also all new Oracle Database 12c features with Oracle Data Pump such as the new COMPRESSION_ALGORITHM and its benefits, new TRANSFORM clause and the "killer feature" Full Transportable Export.

Hope to see you all next year again - and hopefully we'll have a again a quiet sea :-)

-Mike 

Tuesday Apr 01, 2014

Going to Norway for the OUGN Conference

I'm back in business after being out for almost two weeks. And tonight I will fly out to Oslo in Norway to participate in the OUGN Spring Conference 2014. It's my first user group conference in Norway and it will be very special as it will happen on a ship. No escape :-)

And Lufthansa's pilots did a great job in making my travel another nice Lufthansa surprise package. Due to the upcoming 3 day strike my flight to Oslo got canceled last night at 18:25h - as if Lufthansa wouldn't know about the strike days before (it got announced last week). But I could rearrange my travel and now I'll fly out a day earlier. I still feel very sorry for all the families and travelers getting stuck somewhere close to the Easter holidays. All LH Hotlines ("cold"line or "dead"line would fit better) where broken yesterday. Even the Senator "hot"line was out of order. As if my favorite airline wouldn't have known upfront that people WILL HAVE TO CALL when they cancel 3800 flights.

Anyway, I'm looking forward to this great event in Norway. Preparing myself right now with some great tunes of two of my all time favorite Jazz musicians from Norway, Jan Garbarek (saw him playing live several times) and  Ketil Bjørnstad.

My presentation will be:

CU soon :-)

-Mike 

Thursday Mar 20, 2014

I won't be able to come to India in March :-(

I assumed that it will become a tough trip to India this time in March with 3 workshops on 3 days in 3 different cities. But it became even tougher before. Unfortunately due to sick leave I won't be able to fly to India next week. I deeply appologize as I was really looking forward to my 2nd visit to India. 

Our next option: Roy will do it. But this is not possible as it takes at least 5 working days to acquire a Business Visa for India. Therefore our team's disaster recovery solution won't work either. 

The local teams will deliver the content on their own. I'm pretty sure that will work out very well.
Hope to see you next time ...

-Mike 

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
« July 2015
SunMonTueWedThuFriSat
   
4
5
7
8
10
11
12
15
16
18
19
21
22
23
25
26
27
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