Patch your $OH before you upgrade

Always patch your new $ORACLE_HOME before you start the upgrade process for three reasons:

style="text-align: left; background-color: transparent; width: 621px;"
border="0" cellpadding="1" cellspacing="1">



(1) Omit pitfalls

You'll omit possibly existing (but already) fixed bug-related pitfalls



(2) Save time

It'll save you time because you'll have just one upgrade instead of two



pflaster.jpg


(3) Possible Downgrade

You'll keep the possibility of a later downgrade. You can
just downgrade to the version you've upgraded from, i.e. going from
10.2.0.3 to 11.1.0.6 and then to 11.1.0.7 means that you'll be able to
downgrade just to 11.1.0.6. But if you'd upgraded from 10.2.0.3 to
11.1.0.7 directly then you'll be able to downgrade back to 10.2.0.3 -
if you haven't changed the COMPATIBLE parameter.



You'll find the right patch information by looking up these Metalink Notes:

Recommended Database Patches
Available Patch Sets for Oracle Database 11g
Know Issues and Alerts for 11.1.0.7
Introduction to PSUs (Patch Set Updates)
July 2009 PSU
Known Issues with PSUs

Comments:

Post a Comment:
  • HTML Syntax: NOT allowed
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