Tuesday Jan 13, 2015

New MOS Notes on Database Upgrades for 12c with or without Oracle Multitenant

Please find some new MyOracle Support (MOS) Notes about Database Upgrades to Oracle Database 12c, with or without Oracle Multitenant:

Credits for the CDB/PDB Notes go to my colleague, Krishnakumar Kunka  :-)

-Mike 

Monday Jan 12, 2015

Upcoming Upgrade Workshops Jan/Feb 2015

The new year will start with a good bunch of Upgrade, Migrate & Consolidate to Oracle Database 12c workshops in Japan, USA, Canada and Europe: 

January 20, 2015  
Tokyo,
Japan
Oracle Database 12c Upgrade Seminar
including Hands-On for Partners
by invitation only



February 04, 2015  
Irving (Dallas), TX
USA
Oracle Database 12c Upgrade Seminar - Dallas
Register
.

February 05, 2015  
Houston, TX
USA
Oracle Database 12c Upgrade Seminar - Houston
Register
.

February 09, 2015  
Bratislava,
Slovakia
Oracle 12c Database Upgrade Seminar - Bratislava
Register
.

February 10, 2015  
Budapest,
Hungary
Oracle 12c Upgrade Seminar Budapest
Register
.

February 10, 2015  
Reston, VA
USA
Oracle 12c Upgrade Seminar Reston
Register
.

February 11, 2015  
Atlanta, GA
USA
Oracle Database 12c Upgrade Seminar - Atlanta
Register
.
February 19, 2015  
Nürnberg,
Germany
Franconian User Group:
Oracle Database 12c Upgrade
17:30-21:00 Uhr - TU Nürnberg GSO - 
Raum WE.012 Wasertorstraße 10
Anmeldung
.

Friday Jan 09, 2015

Oracle 12.1.0.2 is now certified with Oracle EBS 12.2

Just copying this information from Steven Chang's blog: 

Please note that Oracle Database 12.1.0.2 is already certified with EBS 12.1. 

-Mike 

Wednesday Dec 31, 2014

Happy New Year 2015!!!

We would like to wish you and your families a Happy and Peaceful New Year 2015

-Mike 

PS: The picture doesn't show Roy and myself - these are Lilly and Bonzo! 

Tuesday Dec 30, 2014

Happy New Year, Complete with New Upgrade Workshops!

Oracle Database 12c Upgrade Workshop banner

With the New Year arriving in a couple of days, it is a good time to flip the page on the calendar and make plans to attend an Oracle Database Upgrade workshop! The first two workshops will be:

Denver on Wednesday, January 7 (register here)

Chicago on Thursday, January 8 (register here)

I hope to see you (and you...and you too!) at one of these events next week!

Tuesday Dec 23, 2014

Upgrading ORACLE RESTART from 11.2 to 12.1

First of all, Oracle Restart is deprecated in Oracle Database 12c. Deprecation means the product is still supported, you can open SRs, you'll get bug fixes - but we won't do further development of the product or feature.

But a customer (Thanks to Jaco de Graaf for bringing this to my attention!) had a question via the blog about the best approach to upgrade his Oracle Restart configuration from Oracle 11.2.0.3 to Oracle 12.1.0.2 - and apply the October PSU as well.

What is Oracle Restart?
Please find an overview here in the doc. 
.

How to upgrade your Oracle Restart configuration?
The standard way is simple: Choose "Upgrade" in the starting page of the Grid Infrastructure's OUI screen.
Grid Infrastructure OUI Upgrade Oracle Restart
You won't see anything saying "Upgrade Stand Alone Installation" or "Upgrade Oracle Restart" - but the general "Upgrade ..." option will cover this topic as well.
.

Upgrade Oracle Restart and include a PSU (Patch Set Update)?
This is a bit more tricky and as far as I see not documented entirely. But Jaco did open an SR and Support could help.

  1. Install 12.1 GI ‘software only’
  2. Patch that software set to the latest PSU (using: opatch apply ….-local)
  3. Remove the Oracle Restart configuration (using the ‘old’ 11.2 GRID_HOME)
    Please find a description on the excellent blog of my support colleague, Helmut Hutzler:
    http://www.hhutzler.de/blog/reconfigure-12-1-0-2-has-stack-running-11-2-0-4-database/
    or in MOS Note:986740.1
    It is important to mention that you need to use the 'old' GI Home to remove the Restart configuration - the MOS Note doesn't say this explicitlely.
  4. Reconfigure the Oracle Restart configuration (using the ‘new’ 12.1 GRID_HOME)
  5. Add all required items back to the Oracle Restart stack (ASM, Listener, databases).

Steps 3, 4, and 5 will require a bit of downtime. 
.

-Mike 

---

Added MOS Note 1584742.1Support Impact of the Deprecation Announcement of Oracle Restart with Oracle Database 12c on Feb 22, 2015

Friday Dec 19, 2014

Upgrade Workshops 2014 - Summary

2014 is almost over. Time for a quick review :-)

Roy and I would like to thank you for attending at our workshops throughout the globe. We've delivered more workshops than ever before. Most of them in Europe and Asia, but we did visit also South and Middle America, Australia and - well - the US of course. 

See here the full workshop map:

We delivered in 2014:

  • 62 workshops and conferences
  • for almost 4500 attendees
    • 13x in Asia/Australia
    •  5x in South/Mid America
    • 15x in the US and
    • 29x in EMEA
  • Many dedicated customer workshops
  • Several webcasts

Thanks again to all of you - it was a pleasure to meet with you all.

Have wonderful holidays and a successful start into 2015. Hope to see you all soon again and don't forget: Upgrade Now!!!

-Mike & Roy 

Wednesday Dec 03, 2014

Upgrade Webcast on Thursday, December 4!

CORRECTED LINK:
http://w.on24.com/r.htm?e=899022&s=1&k=04C11FDCF30A6B7255FA6EF05BEBD5BC 

Upgrade NOW! Banner

At this time of year the saying goes that it is better to give than to receive, and I am very excited to be GIVING a webcast about upgrade to Oracle Database 12c on Thursday, December 4 at 8:00 AM Eastern / 14:00 CET. Yes, that is TOMORROW. The registration link is right here (or click on the image above).

I will be talking about why to upgrade, how to upgrade, and also about some of the new features about which you may not have heard. There is still time to register and participate, so I hope to see you online!

Sunday Nov 30, 2014

VBOX Hands-on-Lab image - build your own :-)

Oh ... I know ... I promised to post all the details how I've build up our pretty straight forward Hands-On-Lab Roy, Carol, Cindy, Joe and I used at OOW and some other occasions to let you upgrade, migrate and consolidate databases to Oracle Database 12c and into Oracle Multitenant.

And well, some have emailed me already ... and I had this feeling that my schedule will be very tight after OOW. Even right now (Sunday evening) I'm already back at my second home, Lufthansa Senator Lounge at Munich Airport. Waiting for my flight to Rome in an hour or so. Honestly speaking I had really no time in the past weeks to sit down for 2 hours to write down all the steps to guide you through the rebuild. And I didn't want to throw just a few nuggets - my intention is always to get you detailed steps which really work and don't miss anything.

But I have very good news for all who are waiting for the HOL Image :-)
Roy is working hard (and I'm confident that he'll succeed) to get the image published on OTN within the next weeks. So please stay tuned. Even with the Christmas holidays coming up I'm tied into a schedule to visit Rome, Torino, Milan, Brussels, assist some customers in their final go-live-phase for Oracle Database 12c - and I'm really looking forward to that vacation.

Stay tuned - and thanks again for your patience :-)

-Mike 

Thursday Nov 27, 2014

New Slide Decks Uploaded:
Upgrade/Migrate/Consolidate to Oracle 12c and
Parallel Multitenant Upgrade Internals

It's time for a few updates and slide uploads :-) And thanks again to all the great people in Madrid earlier this week. It was a fantastic day - I enjoyed it a lot and wish you all successful upgrades and migrations :-)

What's new? 

  • A refreshed version of our huge Oracle Database 12c "Upgrade, Migrate & Consilidate" slide deck. Now with 530 slides - kudos to Tom Kyte who gave me a lot of food for thought after his excellent talk at the DB TECH SHOWCASE 2014 TOKYO. I had to add a few slides later on making it now even harder to fit the content into a 1 day workshop :-)
    As usual see the Change Log at the end of the deck about what has been added/changed.
  • A new and extended version of Joe Errede's OOW talk about how an Oracle Multitenant Upgrade works. All details about the parallel upgrade, options and tweaks of catctl.pl. So kudos to Joe as he has build the basis for the slides - I reused many of them and added some stuff - and thanks to the (always) great audience at DOAG Conference in Nuernberg :-)
  •  A refreshed version of the Hitchhiker's Guide especially prepared for the (amazingly) huge audience at the DOAG Conference in Nuernberg (I was really impressed!!)
-Mike 

Monday Nov 17, 2014

Oracle Database 12.1.0.2 EE for HP, AIX and zLinux available

Last week the remaining ports for Oracle Database 12c 12.1.0.2 became available at the usual sources:

Thursday Nov 13, 2014

Incremental Statistics Collection improved in Oracle 12c

Traveling right now through Asia. It was Beijing for 32 hours, Toyko for 24 hours - and now we are running an internal 2-day workshop with colleagues from Korea, New Zealand, India and some other countries in Seoul. And yesterday I had the pleasure to listen to Tom Kyte to his optimizer talk at the OTN Conference in Tokyo. And I learned a lot - as always when having the chance to listen to Tom, Graham Wood and the other great experts.

Oracle Database 11.1 offered a great new feature: Incremental Statistics Collection which helped a lot to make stats collection on partitioned tables way more efficient. But it had a few flaws and it took a while to work as expected. And it had one side effect when you used it heavily: It stored tons of data in WRI$_OPSTAT_SYNOPSIS. We saw it on some databases at almost 300GB. 

Now the thing with such a huge WRI$_OPSTAT_SYNOPSIS can be: It gets a new partitioning layout during upgrades twice:

  • Upgrade from Oracle 11.1.0.x/11.2.0.1 to Oracle 11.2.0.2/3/4:
    • Change to Range.Hash Partitioning for WRI$_OPSTAT_SYNOPSIS
    • This can cause a lot of data movement.
  • Upgrade from Oracle 11.2.0.2/3/4 to Oracle 12.1.0.x:
    • Change to List-Hash Partitioning
    • This will cause not as much data movement as in the previous change

Tom explained yesterday that in Oracle Database 12c Incremental Statistics Collection has gotten a few excellent extensions making it more efficient: 

  • Smaller footprint on disk for synopses compared to previous releases
  • Incremental stats with partition exchange operations
  • Ability to define a stale percentage for existing partitions

The latter one is very interesting as it meant: Before Oracle Database 12c whenever you did change a single row within an existing partition during a recalculation of the Global Stats this particular partition need to be examined again - even though just one record has been changed - instead of still using the stored synopsis.

In Oracle Database 12c you can now define a stale percentage. First you'll have to enable it, second you can set a stale percentage by yourself - otherwise the default of 10% would apply - but only if it has been enabled. Otherwise the pre-12c default will be kept (and this is the behavior in Oracle Database 12c out of the box):

  • Switch incremental statistics on for a specific partitioned table:
    • SQL> exec DBMS_STATS.SET_TABLE_PREFS('SH','SALES','INCREMENTAL','TRUE'); 
  • Switch on the new 12c stale percentage feature globally:
    • SQL> exec DBMS_STATS.SET_DATABASE_PREFS('INCREMENTAL_STALENESS',
      'USE_STALE_PERCENT');
  • Change (only if desired) the stale percentage of default of 10%:
    • SQL> exec DBMS_STATS.SET_DATABASE_PREFS('STALE_PERCENT','12');
-Mike

Friday Nov 07, 2014

Sleeping Beauties - Upgrade to 11.2.0.4 can be slow

A customer from the US did contact me past week via LinkedIn and raised a question:

"Is it expected that my patch set upgrade from Oracle 11.2.0.3 to Oracle 11.2.0.4 takes over 3 hours?"

Of course, no - this is not expected

This is the upgrade stats gathered post upgrade with utlu112s.sql:

SQL> @?/rdbms/admin/utlu112s.sql ; .
Oracle Database 11.2 Post-Upgrade Status Tool 10-31-2014 10:05:29
Component Current Version Elapsed Time
Name Status Number HH:MM:SS
Oracle Server  
. VALID 11.2.0.4.0 02:46:19
JServer JAVA Virtual Machine
. VALID 11.2.0.4.0 00:08:34
[..]
Final Actions
. 00:00:00
Total Upgrade Time: 03:06:47

No, this is not really expected. So we tried to nail down the root cause finding out these statements in the upgrade script c1102000.sql are causing the trouble:

194 -- wri$_optstat_histhead_history2.
195 execute immediate
196 q'#create unique index i_wri$_optstat_hh_obj_icol_st on
197 wri$_optstat_histhead_history (obj#, intcol#, savtime, colname)
198 tablespace sysaux #';
199
200 execute immediate
201 q'#create index i_wri$_optstat_hh_st on
202 wri$_optstat_histhead_history (savtime)
203 tablespace sysaux #';
204 end;
205 /

It's index rebuilds on histogram tables. And the customer has a large amount of stats data in his database as the default stats retention is 31 days.

Obviously the index rebuild is not done very efficiently (not done in parallel, no nologging clause). Those things can happen and sometimes this may not cause any issues. But in this case it lead to over 2 hours for just those index rebuilds.  

Luckily my colleague Cindy is an excellent resource for such things - after asking our team I've got the reply that this is tagged with a bug number and code fix already got checked in (under review right now):

bug19855835:
Upgrade from 11.2.0.2 to 11.2.0.4 is slow 

-Mike

PS: Credits go to Tan for bringing this to my attention - and sorry for the inconvenience! 

Thursday Nov 06, 2014

Beijing, Seoul - and OTN Tour Tokyo - just in one week

Uhhh ... next week will be a tough traveling experience. 19870 km (12347 mi), all in cattle class on 4 different airlines.

Picture rights remain at The New York Times

I tried to avoid Lufthansa as they canceled recently flights I heavily relied on - with no reason! And there's still a huge risk of announcing just their 9th strike within a year and a bit.

But I'm really looking forward to the workshops, to see all the colleagues, customers and of course some great friends. Roy and I will do two internal two-day workshops in Beijing and Seoul with each more than 50 participants - and we'll include a nice hands-on-experience as well. And mid-week I'll head out to Tokyo to present at the DB TECH SHOWCASE 2014 - which is part of the OTN ACE Tour.

CU soon - thanks!!!

-Mike 


Wednesday Nov 05, 2014

Premier Support for Oracle 11.2 will end soon ...
Upgrade to Oracle Database 12c now!

Most customer and partners know it already - but still these days I get emails about upgrading from Oracle 10.2 to Oracle Database 11.2.0.4. Well, I have stopped arguing with people as there may be a reason to invest money and resources into a release which will go out of Premier Support in less than 3 months.

Some clarifications:

  • End of Premier Support means that Oracle will not offer fixes for new issues unless an extra-cost offer called Extended Support has been purchased. But you'll still get Sustaining Support until you'll stop working on the release. For a description what terms such as Premier Support, Extended Support and Sustaining Support mean please refer to the Lifetime Support Policy.
    .
  • For Oracle Database 11.2.0.4 - the Terminal (final) Patch Set for Oracle Database 11.2 - Oracle will waive (no extra cost, no action required) the first year of Extended Support to every customer with a valid support contract. Premier Support for Oracle Database 11.2 will still end on Jan-31, 2015, but you'll get Extended Support for Oracle Database 11.2.0.4 for one additional year at no extra cost. You can extend the Extended Support for Oracle Database 11.2.0.4 by a maximum of two additional years until 31-JAN-2018 - but then at the usual extra cost. 
    This information can be found in MOS Note:742060.1.
    .
  • For Oracle Database 11.2.0.3 Oracle will waive also Extended Support, but as Extended Support for Oracle Database 11.2.0.3 will end on 27-AUG-2015 no bug fixes will be available (including PSUs, SPUs and BPs) after that date. There's no offer to extend Extended Support for Oracle Database 11.2.0.3 upon that date.
    This information can be found in MOS Note:742060.1.
    .
  • For Oracle Database 11.2.0.2 there's no such Extended Support offering available.
    This information can be found in MOS Note:742060.1.
    ..
  • For Oracle Database 11.2.0.1 there's no such Extended Support offering available.
    This information can be found in MOS Note:742060.1.
    .

If you are interested in more details about Upgrade, Migrate and Consolidate to Oracle Database 12c please see the refreshed version (31-OCT-2014) of our slide deck available via the Slides Download Center to your right. 

-Mike 

Friday Oct 31, 2014

Utrecht holds the new EMEA record now!
Plus: Updated Slide Deck

OMG ... 154 people in an Database Upgrade/Migrate/Consolidate to Oracle Database 12c workshop! That's the EMEA record so far for workshop attendance rates for our workshops in the past 7 years. I'm really impressed. Really!!! And you were such a great audience. I've had plenty of fun, lots of good discussions during the breaks and after the workshop.

As the auditorium room at the Oracle location in Utrecht fits just 120 people the local marketing folks had the idea of asking Jost if he can stream the workshop to another room. The other option would have been to reject a lot of registered persons. And the streaming went quite well. I've never done this before and I hope it was still ok. But as the other room cross the hallway had daylight windows, fresh air and more space it seemed to be ok for most attendees :-)

I promissed also a new version of the slide deck - and here it is ready for download. Only 522 slides this time ;-) But I just added two new ones. You may check the log at the end of the deck for recent changes.

So thanks again - it was my pleasure to spend the day with you. And I hope next time, when I'll ask "Who's live on Oracle Database 12c" that I will see way more fingers going up :-)!!!

-Mike



Thursday Oct 23, 2014

Maintenance Windows is too small? Autotask Jobs fail

Since Oracle Database 10g we have automatic maintenance jobs in the database running. Since Oracle Database 11g (and the same applies to 12c) we have:

  • Weekday Jobs being able to get executed from 10pm until 2am on MON-FRI
  • Weekend Jobs being able to get executed from 6am until 2am on SAT-SUN

A support colleague contacted me a while ago asking why at his customer the jobs don't start anymore as they have set the duration for weekdays to 15 minutes. You may adjust the window generally by yourself with:

  • exec DBMS_SCHEDULER.SET_ATTRIBUTE('MONDAY_WINDOW','DURATION',numtodsinterval(2,'hour'));

But in this particular case only changing the default setting of _autotask_min_window=14 helped. That ensured that - once the job window was set to as little as 15 minutes that Automatic Maintenance Jobs still get executed. Once you adjust your Maintenance Windows making them really small ensure that you'll adjust this little underscore as well.

-Mike 

ORA-20000 Unable to gather statistics concurrently: Resource Manager is not enabled
ORA-06512: at "SYS.DBMS_STATS"

We are running a great training this week in Munich, called TECH CHALLENGE for Oracle people only. And one group hit the below issue so I thought I should share this as it is very likely it will happen with the upgrade to Oracle Database 12c in your environment as well.

During the run of catctl.pl or DBUA you may get an error saying:

ORA-20000: Unable to gather statistics concurrently:
Resource Manager is not
enabled.

ORA-06512: at "SYS.DBMS_STATS"

Even worse, the upgrade will fail and exit in phase 68 of the parallel upgrade.
This issue is new with Oracle Database 12.1.0.2 and is logged as bug19664340 

Reason why this happens:
It seems to be "somebody" has switched statistics gathering with Oracle Database 12.1.0.2 to CONCURRENT.

Workaround:

  1. SQL> exec dbms_stats.set_global_prefs('CONCURRENT', 'FALSE');
  2. Reset it after upgrade with
    SQL> exec dbms_stats.set_global_prefs('CONCURRENT', 'TRUE');
  3. Enter SQL*Plus in your 12c environment [even if you had used the DBUA]
  4. Restart your database in upgrade mode
    SQL> startup upgrade
    SQL> exit
  5. cd to $ORACLE_HOME/rdbms/admin
  6. $ORACLE_HOME/perl/bin/perl catctl.pl -l /home/oracle/upgrade -p 68 catupgrd.sql
    The "-p" option will restart the parallel upgrade now at phase 68. 

I also would like to thank Jason Arneil, who's Blog Post helped me a lot! 


Since Feb 23, 2015, there's a generic one off patch available on top of Oracle 12.1.0.2:

Patch 19664340: ORA-20000: UNABLE TO GATHER STATISTICS CONCURRENTLY: RESOURCE MANAGER IS NOT ENA

And please see also the COMMENT section with the comments by Arun Gupta - thanks a lot, Arun!

-Mike 

Monday Oct 20, 2014

Thanks for coming to the Upgrade Workshops in Dublin & Belfast - special thanks to my friends at LUFTHANSA

Thanks to everybody who came to our Upgrade/Migrate/Consolidate to Oracle Database 12c on Oct 14/15 in Dublin and Belfast. You were great audiences, I had plenty of fun, excellent deep dive discussion during the breaks and afterwards during the customer visits day on Thursday.

And very special thanks to my colleagues from Oracle Ireland, especially Mina and Kelly-Marie, but also all the others who were involved in the events and visits and made it happen so smoothly. Everything worked perfectly well except for things not in our hands (such as the massive train delay on the way back from Belfast).

Just in case you'd like to get the slides I'd recommend to download the deck via this link here:
Upgrade, Migrate & Consolidate to Oracle Database 12c

And VERY SVERY PECIAL THANKS to my dear friends at Lufthansa. Mina dropped my off at the airport on Thursday, I wanted to check in and hand over my luggage to the assistant - "Oh sorry, your direct flight to Munich has been canceled". Wonderful news. Dublin must have bad Karma for my travel plans as I've got locked in during the ash cloud some 4.5 years ago. 

Now my friends at Lufthansa have rebooked me to a very early morning flight for Friday, but with a stopover in Frankfurt (which is not my favorite airport at all). Anyhow, a call with Oracle Travel showed my a flight option that same night with KLM via Amsterdam to Munich. So I called Lufthansa again just finding out that Lufthansa refused to rebook me to that flight. Why? Because the first leg to Amsterdam is operated by Air Lingus - and "Lufthansa has no agreement with Air Lingus".  I told them that I don't care if they have an agreement or not, it's myself getting grounded it Dublin for no reason. But no chance. Even though the lady on the Senator hotline asked her supervisor and his manager (and I really thanked her a lot as she really tried it).

Simple calculation Lufthansa is doing:

  • Flight costs for the KLM flight to Munich: 730 Euro
  • Total costs for Mike staying another night in Dublin: 100 Euro for the hotel, a few bucks for the dinner and maybe the max fine of 250 Euro (which you can claim back only when you involve a lawyer or a service such as FlightRight). Summing up to a max of 400 Euro. Way cheaper to let him stay another night in Dublin at an airport hotel and make him get up at 4 in the morning to catch the flight to Frankfurt.
And, to make my experience even more valuable Lufthansa added 45 mins of delay to my leg from FRA to MUC, a flight distance of 35 minutes including take off and landing. I felt so good afterwards, so valued as a customer who flies roughly 5 or 6 times around the globe per year with this airline. 
Thanks you very much, Lufthansa!!! I made it home on Friday at 12:30pm - instead of 21:45pm on Thursday. Lovely, isn't it?

 -Mike

Wednesday Oct 15, 2014

PSU October 2014

October 14, 2014 Oracle released a new Patch Set Update. And as usual we strongly recommend that you'll apply it as soon as possible to your databases.  

There's one fix for JAVA in it which requires to either take the database down or do some other actions. Please find a detailed description here: 

  • Eric Maurice’s security blog:
    https://blogs.oracle.com/security/entry/october_2014_critical_patch_update
    "Due to the nature of the fixes required, Oracle development was not able to produce a normal RAC-rolling fix for these issues. To help protect customers until they can apply the Oracle JavaVM component Database PSU, which requires downtime, Oracle produced a script that introduces new controls to prevent new Java classes from being deployed or new calls from being made to existing Java classes, while preserving the ability of the database to execute the existing Java stored procedures that customers may rely on."
  • MOS:1929745.1 - "Oracle JavaVM Component Database PSU"
-Mike 

Tuesday Oct 07, 2014

Upcoming UPGRADE Workshops in:
Netherlands, Ireland, Northern Ireland, Spain and Belgium

Wow ... another OOW is over ... I have returned well but a bit jetlaged on Saturday from San Fransciso. It was a pleasure to meet with so many great customers, partners, Oracle ACEs, geeks and of course colleagues from all over the world.

And I'm still surprised how little DBAs and managers are aware of the upcoming end of Premier Support for Oracle Database 11.2 and still believe in "The 2nd Release Only". But I'll write something about this later this or next week.

And as soon as my time allows (most likely in the 2nd half of October) I will publish also the details about how to setup the HOL by yourself as we are not allowed to distribute it because of the patch sets included into it. 

Anyhow, back in reality (still on vacation today) let me offer you the final seats for the upcoming UPGRADE, MIGRATE & CONSOLIDATE TO ORACLE DATABASE 12c workshops in the following weeks: 

In case you'll miss links I'll update the blog post as soon as I get them.

-Mike 

Wednesday Oct 01, 2014

OOW2014 - Upgrade in a Multitenant Environment

On Sept 30, 2014 at Oracle OpenWorld, Joseph Errede gave his excellent talk about all the tech details in catctl.pl focusing on what happens when you upgrade a multitenant environment. The presentation is very technical explaining many of the switches of catctl.pl. If you'd like to get the slides please find them either in the Slides Download Center to the right or directly via this link:

-Mike 

Tuesday Sep 30, 2014

OOW2014 - Presentation and Hands.On.Lab

Thanks to everybody for coming by yesterday evening to our talk about Upgrade, Migrate and Consolidate to Oracle Database 12c. It was really a pleasure to speak in front of so many interested people :-)

If you'd like to download the slides please access them via the Slides Downloads Center to your right - or via this direct link: OOW 2014: Upgrade, Migrate, Consolidate to Oracle Database 12c

Or you may get the huge +500 slide deck covering all the different options and much more about Oracle Database 12c here: Upgrade, Migrate & Consolidate to Oracle Database 12c

hands on lab - oow 2014 - upgrade

And thanks to everybody who did show up for the Hands-On-Lab in the Nikko Hotel's Bay View room. Please be aware that you have to be at the room at least 10 minutes before lab starts. Otherwise the open seats will be given away by the door keepers. Not our idea, and we've just learned about it yesterday So please keep that in mind for the 3 remaining labs.

If you'd like to download the lab instructions get the via this link: 

And I'll promise I'll post instructions on how to setup the lab by yourself as we are not allow 

-Mike 

Friday Sep 26, 2014

Oracle Database 12.1.0.2 for MS Windows is available

Finally Oracle Database 12.1.0.2 for MS Windows is available for download from OTN, eDelivery and MOS:

-Mike

Best Practices for Patching -- learn more at OOW!

Although upgrade and patching are truly two very different processes, they both fall into the same general category of planned maintenance and are often associated with each other. So, it seems relevant to point out yet another important talk at OpenWorld in San Francisco:

Database Patching Best Practices II [CON7748]

  • Tuesday, Sep 30, 5:00 PM - 5:45 PM - Moscone South - 104

Building on a highly popular session from Oracle OpenWorld 2013, this session further explores ways to help you maintain and patch your database systems most efficiently. Learn about patch testing best practices, techniques for minimizing downtimes, how to best roll out patches in cloud environments, and more. The presentation also shares the latest Oracle Database 12c features and tooling to help ease patching processes. 

This is a great time and place to hear from the patching gurus who can tell you how to maintain your systems with minimal downtime and how to take advantage of some tools, techniques, and information about which you might not be aware. Hope to see you there! 

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
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
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