Welcome to the Oracle Database Upgrade blog!!!

Glad that you'd find your way to my Oracle Database Upgrade Blog :-)

"Uhhh ... yet another blog ..." you might think. But the intention is to give you the most recent database upgrade tech news and findings. Discuss with you about best practices. And offer you access to upgrade workshops we are running right around the world - at no extra cost.

So I hope to see you more often - and maybe we'll meet one day in one of our workshops in person.

Enjoy - thanks and kind regards
Mike

Comments:

Hi Mike, Attended one of your 11g Upgrade workshops and found it to be highly informative, and would encourage anyone to get along to one of these. Testing 11gR1 now. having to use 2 underscore parameters due to regressions introduced - both marked as 11gR2. Could be better. jason.

Posted by jason arneil on July 29, 2009 at 07:15 AM CEST #

Hallo Herr Dietrich,
Anfrage: beim Upgrade von 11.2.0.1 auf 11.2.0.3
wurden alle Werte von Oracle Connection Pooling
auf Default-Werte zurückgesetzt.
Die Konfiguration musste neu aufgebaut werden.
Ein automatiches Start der Prozesse
wurde auch nicht durchgeführt.
Ist das irgendwo beschrieben ?
Gruß
Peter

Posted by Peter on May 16, 2013 at 01:27 PM CEST #

Hallo Herr Peter,

ich habe diverse Dokumente in MOS gefunden, die ueber das Thema "Connection Pool" beim Upgrade schreiben. Ohne genauere Kenntnis der Thematik kann ich Ihnen aber keine Auskunft geben. Haben Sie eine SR Nummer, die Sie mir zumailen koennen?

Danke und VG
Mike Dietrich

Posted by Mike Dietrich on May 21, 2013 at 11:37 AM CEST #

Thank you

Posted by LAMOTTE on June 27, 2013 at 10:16 AM CEST #

Hi Mike,

Thanks a lot for the interesting workshop today in Brussels; it gave us a brief and clear view in some topics regarding upgrade, migrating strategies....

FCN or Bayern? I hope you wear the correct shirt tonight.

Posted by guest on April 29, 2014 at 07:59 PM CEST #

I wore my regular shirt - but as you may have seen from the current league standings it may have been the wrong decisions ... :-(

But good luck for Belgium for the World Cup - the team is good enough to surprise everybody and make it under the top-4 teams :-)

Thanks for your feedback!!!

Mike

Posted by Mike on May 06, 2014 at 01:12 PM CEST #

Hell'o Mike,
Thanks again for the upgrade day in Brussel the 29th of April. From that time I heard that Bayern lost 4-0... Ouch!
I have a question about a work project. We have bought 2 exadata (1/4 and 1/8) X4 generation. All our servers are windows based with microsoft cluster and we'll have to migrate and upgrade (we have a panel of 9, 10, 11 DB version) most database into exadata. The contact we have here in Belgium for Oracle said that he'll ask Johan Vandenbosch to come see us. He mention that project might interest you and that he'll ask you aswell. Did you heard about anything? (More informations by email if you need some.)
Greetings and keep the very good work.

Posted by guest on May 09, 2014 at 08:27 AM CEST #

Hi,
Thanks a lot for the interesting workshop yesterday in Warsaw in Poland; it gave us a brief and clear view in some topics regarding upgrade and migration. This was the first workshop organized by Oracle have been to.

Posted by Lukasz on July 16, 2014 at 12:32 PM CEST #

Lukasz,

thanks a lot - I did enjoy the day as well :-)

Cheers, Mike

Posted by Mike on July 16, 2014 at 04:02 PM CEST #

We have a two node rac version 10.2.0.4 running on red hat linux x86_64. We want to upgrade the OS to RHEL 5 and the database to 11.2.

We want to do a rac rolling upgrade. We are told by Oracle support that we should complete the upgrade on both nodes within 24 hours or it is likely we will encounter criticat problem. Our system engineers are telling us that it takes 2 to 3 days to upgrade each node from rhel 4 to rhel 5 eventhoug we know this could be done in 2 to 3 hours.

Any suggestions ?

My name is Harvey Jefferson i work for acxiom corporation and i attended one your upgrade workshops a few years ago.

Thanks for any help

Posted by guest on September 10, 2014 at 09:45 PM CEST #

Harvey,

this is more a question for support than for myself ;-)

Actually I don't believe that you can do a rolling upgrade from 10.2 RAC to 11.2. As far as I know 11.1 would be the min requirement to do such a thing (and you'd still need additional patches). You may check our (not-updated-anymore) slide deck about 11.2 upgrades in the Slides Download Center for the MOS Notes about Rolling RAC Upgrades to 11.2.

One of the reasons this won't work is the desupport of OCR/Voting on RAW in 11.2.

My question nr. 1 would be: Are you staying on the same hardware or will you get a new cluster for the move? If the latter is true than my proposal would be:
- configure your new RAC with the latest patches/PSUs
- install 11.2.0.4 database software (again, get PSUs)
- build up a physcial standby (you won't need 10.2 sw)
- stop production when in synch
- activate the standby and upgrade it
Overall downtime will be (depending on installed options)
between 20 and 60 minutes usually. And you can test this
approach several times.
.
If you don't get new hardware ... hm ... then it will get tough. Minumal downtime usually requires a bit more effort ;-) Do you have a spare system which can take the load for a weekend or so? Then I'd build up a standby on the spare, switchover, reconstruct your current RAC with new Linux, new GI, PSUs, database 11.2.0.4 with PSUs, setup a phyiscal standby from SPARE prod back to the old/new cluster, activate and upgrade it. Downside here: you can't really test as you'll wipe out your current prod.

Hope this helps, cheers
Mike

Posted by Mike on September 11, 2014 at 10:33 AM CEST #

Thanks for replying.

We are going to stay on the same servers/hardware. No spare servers that we could use.

Here is our latest steps we are researching.

I am not including all detailed rac steps but this is a basic outline.

1. Shutdown oracle and rac on NODE1
2. Upgrade os on NODE1 --- since two different versions of os is not running then the 24 hour guideline does not apply.
3. Reinstall/relink oracle 10.2 on NODE1
4. Bring up rac on NODE1
At this time you need to meet Oracle’s 24 hour guideline since two different version of os is running until step 5 is done which should only take a few minutes
5. Shutdown oracle and rac on NODE2
Once step 5 is done then you are no longer running 2 different os versions so the 24 hour guideline does not apply.
6. Upgrade os on NODE2 --- 24 hour guideline does not apply
7. Reinstall/relink oracle 10.2 on NODE2
8. Bring up rac on NODE2
9. Upgrade oracle rac from 10.2 to 11.2

Posted by guest on September 11, 2014 at 05:06 PM CEST #

Ok, to upgrade the OS on both nodes only your solution sounds fine to me. But you may please double check with Oracle Support.

Posted by Mike on September 12, 2014 at 11:01 AM CEST #

Hi Mike,

We currently have 11R2 GI Stand Alone running and want to upgrade to 12R1 GI Stand Alone.
Is it possible to do a 'software only' installation of 12R1 GI Stand Alone, patch that software set to the latest PSU and, in a separate step (when having downtime), do the actual upgrade ot 11R2 GI to 12R1 GI.

Regards, Jaco

Posted by Jaco de Graaf on November 19, 2014 at 11:02 AM CET #

Hallo!

Kann ich mit GoldenGate auch den initialen Load der Daten von der Source- zur Target-DB machen oder ist GG nur für den Transport der Redo-Daten (oder wie auch immer das bei non-Oracle DB's heisst) zuständig?

Danke und Gruss

Posted by Christian on February 06, 2015 at 02:43 PM CET #

Hallo,

OGG kann theoretisch kleine Datenbanken selbst umziehen, das wuerde ich aber ab einer Groesse von 20GB vermeiden. Generell gesprochen ist OGG die Synchronisations-Lösung, um einen Umzug mit nahe-Null oder sogar zero downtime zu ermöglichen. Die Datenbank muss aber zuvor mit den verfübaren Technologien wie Transportable Tablespace oder Data Pump migriert oder upgegraded werden.

Mike

Posted by Mike on February 06, 2015 at 02:46 PM CET #

Danke für die Bestätigung!
Die Doku ist hier etwas interpretierbar.

Gruss
Christian

Posted by guest on February 06, 2015 at 04:22 PM CET #

after activate the standby and upgrade it
you will need to

• Attache databases to new CRS cluster

kal

Posted by guest on March 13, 2015 at 01:54 PM CET #

Post a Comment:
  • HTML Syntax: NOT allowed
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
« May 2015
SunMonTueWedThuFriSat
     
1
2
3
4
5
6
7
8
9
10
12
13
14
15
16
17
19
20
21
22
23
24
25
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