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 

Thursday Mar 06, 2014

Free Webcast available now On Demand --- Upgrade and Migrate to Oracle Database 12c and Consolidate with Oracle Multitenant

Almost 90 minutes about Upgrade, Migrate and Consolidate to Oracle Database 12c with or without Multitenant Option.
Available now on demand. Just register yourself and watch it whenever it is convenient for you:

Register to receive the On Demand Link and Watch It!

-Mike 

Monday Mar 03, 2014

Upgrade Workshops in India in March 2014
REGISTER NOW!

*** Due to sick leave I won't be able to come to India  ***
*** I deeply appologize - hope to see you soon again *** 

 

It will be a tough trip as I will travel on my own with long distances in between the workshops but I'm really looking forward to my second trip to India to run 3 Upgrade, Migrate and Consolidate to Oracle Database 12c workshops in March 2014 in India.

Register as soon as possible as we have limited seat capacity:

Hope to see you soon :-)

-Mike

Wednesday Feb 19, 2014

Thank You for flying with "Hello Kitty" ;-)

Yesterday Roy and I flew directly after the workshop in Seoul to Taipeh in Taiwan. It's our first time in Taiwan - and the flight to Taipeh with EVA Airlines was quite surprising ;-) I didn't took a picture in the bathroom ... 

"Thank You for flying with Hello Kitty!".

-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

Wednesday Nov 06, 2013

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 ;-)


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

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!

Monday Jul 22, 2013

OTN Tour Latin America 2013

While Mike is in Shanghai for OOW, I'll be participating in the 2013 OTN Tour in Latin America. This week includes events in Panama, Costa Rica, and Mexico where I will have two sessions at each:

OTN Tour Header

Migrate and Consolidate your Databases using Data Pump

What ́s New in Database Upgrade

Both Mike and I will be participating in the August events in Uruguay, Argentina, and Brazil as well. But if you can't make it to these or other upcoming events, the slides are ready for download!

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 :-) 

Friday Apr 19, 2013

AIB - Allied Irish Banks - Upgrade Success

AIB LogoJust a quick note on Allied Irish Banks (AIB), a customer colleagues and I did work with on their upgrade and migration to Oracle Database 11.2  They've done a tremendous job and finally were present at OOW 2012 in San Francisco. Mina, my presales colleague from Oracle Ireland, gave me heads up about the short videos they've produced in SF with the AIB folks now being available on o.com.

1- Allied Irish Bank Transforms Business With Oracle

2- Allied Irish Bank Consolidates to an Oracle Private Cloud

-Mike

Thursday Sep 06, 2012

Upgrade and Migration Factory by Oracle Consulting

Oracle Consulting did launch a while ago the Oracle Consulting Migration Factory. The purpose of this offer is to support customers in large upgrade and migration projects with hundreds or thousands of databases. If you'll need this support in your projects please check out the Oracle Consulting Migration Factory page.

Please find more info in the Migration Factory White Paper.

Friday Aug 03, 2012

Ouch ... again OCM

Another customer, another upgrade - and again from Oracle Database 11.1.0.7 to Oracle Database 11.2.0.3. And again an OCM error during upgrade which is not very obvious to relate to OCM once you see the errors during upgrade.

While monitoring the database during upgrade with tail -f on the alert.log we've spotted this one here:

ORA-604: error occurred at recursive SQL level 3
ORA-904: "XDB"."DBMS_CSX_INT"."GUIDTO32": invalid identifier
XDB SGA reset to NULL.

Looks like some issue with XDB. But actually it is related to OCM and it seems that something gets created in the wrong order. Currently DEV is working on that issue - and the good message: after the upgrade has been completed everything is VALID. But it's one of those strange errors you might wonder about ...

This issue has been filed under:
Bug 13710092: ORA-00904: "XDB"."DBMS_CSX_INT"."GUIDTO32": DURING UPGRADE
and the bug is not public at the moment - but you could simply ignore that error.

- Mike

Wednesday May 02, 2012

Behaviour Changes Oracle 8i to 11.2 + New Features Oracle 11.2 + refreshed Upgrade and Migration Slides

We have uploaded refreshed and new slide sets:

Tuesday Apr 24, 2012

Some impressions from Seoul and Beijing

There was not much time left to walk around and take some pictures during our fully packed workshop week in Seoul and Beijing. But as I have my camera almost always in my pocket I took some pictures ... :-)


Seoul View


Seoul Food ... yes ... BEEF ... wonderfully thin sliced beef on the barbecue grid


Tumbling Seoul
(that's exactly how I felt in the mornung after our night at Peter, Paul and Mary's (see below)).


Modern Beijing ... very modern


Well ... or even more modern ...


There's always a traffic jam ... simply too many cars ... and some bycicles left as well


And if you don't know where to park your Lambo... no prob ... just park it in the middle of two pedestrian crosswalks on an intersection ... if you drive the right car policemen will simply ignore your intersting habbits ;-)

Tuesday Apr 03, 2012

New Slides - and a discussion about Dictionary Statistics

First of all we have just upoaded a new version of the Upgrade and Migration Workshop slides with some added information. So please feel free to download them from here.The slides have one new interesting information which lead to a discussion I've had in the past days with a very large customer regarding their upgrades - and internally on the mailing list targeting an EBS database upgrade from Oracle 10.2 to Oracle 11.2.

Why are we creating dictionary statistics during upgrade?

I'd believe this forced dictionary statistics creation got introduced with the desupport of the Rule Based Optimizer in Oracle 10g. The goal: as RBO is not supported anymore we have to make sure that the data dictionary has fresh and non-stale statistics. Actually that would have led in Oracle 9i to strange behaviour in some databases - so in Oracle 9i this was strongly disrecommended.

The upgrade scripts got hardcoded to create these stats. But during tests we had the following findings:

It's important to create dictionary statistics the night before the upgrade. Not two weeks before, not 60 minutes before your downtime begins. But very close to the upgrade. From Oracle 10g onwards you'd just say:

$ execute DBMS_STATS.GATHER_DICTIONARY_STATS;

This is important to make sure you have fresh dictionary statistics during upgrade for performance reasons. Tests have shown that running an upgrade without valid dictionary statistics might slow down the whole upgrade by factors of 2x-3x.

And it would be also a great idea post upgrade to create again fresh dictionary statistics when you've did suppress the stats creation during the upgrade process. Suppress? Yes, you could set this underscore parameter in the init.ora:

_optim_dict_stats_at_db_cr_upg=FALSE

to suppress the forced dictionary statistics collection during an upgrade. We believe strongly that (a) people using the default statistics creation process which will create dictionary statistics by default and (b) create fresh stats before upgrade on the dictionary. Therefore we find it save once you have followed our advice to use the underscore during upgrade. And we've taken out that forced statistics collection during upgrade in the next release of the database.

Please note: If you are using the DBUA for the upgrade it will remove underscore parameters for the upgrade run to improve performance - which is generally a good idea. So you'll have to start the DBUA with that call:

$ dbua -initParam "_optim_dict_stats_at_cb_cr_upg"=FALSE

-Mike

Wednesday Mar 28, 2012

Upgrade Workshop in Sydney - Recap

Late, but hopefully not too late, a big THANK YOU to everybody who did attend the Upgrade and Migration Workshop in Sydney at the Cliftons past week. You were a really good crowd, thanks for all your questions, the great conversations in the breaks, thanks to the local marketing team for the excellent organization - and we'll looking forward to see you next time again with all your databases then live on Oracle Database 11.2 

To download the slides please find them in the Slides Download Center to your right - or use the direct link to download the workshop slide deck.

And I really don't understand how you can go to daily work (or to a workshop) with such beaches nearby ... I would immediatelly change my job profile ;-) Honestly, Sydney is really a great place. Australia and New Zealand generally are wonderful places and we've met so many great people in Perth, Brisbane, Melbourne, Wellington, Sydney and during our travel in between. Just if there wouldn't be over 20 hours pure flight time in between Germany and Down Under ;-)

Hope to see you all again next time for 12c ;-)

-Mike

Monday Mar 19, 2012

Upgrade Workshop in Wellington - Recap

Wow! Wellington is really a wonderful city - except for the weather situation ;-) But it was the first time that Roy and me did arrive to a workshop with a ferry boat. We flew in on Friday to Christchurch (btw, this was the longest customs and border control I've ever went through - and I traveled to Israel by bus via Allenby Bridge from the West Bank some years ago - it took us two hours to go through immigration and customs in the night from Friday to Saturday) and drove up the Southern Island. Very nice :-) Great landscapes, great wines and great people!


I'f you'd like to download the slides please download them from the Slides Download section to your right.

And next time you'll have to ask more questions :-) Don't be this shy - Roy and me (usually) don't bite :-)

-Mike



Upgrade Workshop in Melbourne - Recap

Thanks to everybody who did attend at our Upgrade and Migration Workshop in Melbourne last Friday. First of all it was a Friday so we really appreciated your patience of staying until the very end :-) And then, yes we know, it was a full room. And we'd really like to thank you :-) It was a great day for Roy and me. And you were such a great crowd with many questions and excellent discussions during the breaks. Please have all successful upgrade and migrations. And feel free to get in touch directly with Roy and me if you have additional questions or if you'd like to become a reference.

Please feel free to download the slides from the Slides Download section to your right - or simply use that link here.

Ah, and sorry that neither Mark Webber nor Sebastian Vettel did win ... next time ;-)

-Mike

Thursday Mar 15, 2012

Upgrade Workshops in Perth and Brisbane - Recap

Thanks to everybody who did attend on Tuesday in Perth and today in Brisbane for the Database Upgrade and Migration Workshop in the Oracle offices. We hope you've enjoyed the day as we did enjoy it ;-) Feel free to contact us regarding your experiences, upgrade successes, pitfalls you have seen and miss in the slides etc. 

Slides - please don't forget to download them via this link here.

And for those who have asked for the component dependency presentation containing also a script (find it at the very end of the presentation) to drop an unused or accidentially created RAC option in a non-RAC database, you'll find that here.

Thanks and CU next time again ;-)

-Mike


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 :-)

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 :-)

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
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