Oracle patch set 184.108.40.206 - Free Download
My Belgium friend Phillipe Fierens raised a great question on Twitter last week and dropped me an email again after having a discussion with his client:. There is no minor upgrade anymore since every patch set release is a full release and since new parameters, parameter values, features and whatever appears even in patch sets. But the following discussion on Twitter with comments from all sides made me think about why people would honestly declare going for instance from Let me summarize why I completely disagree - and actually Dom Giles nailed it:.
You don't believe me? Then please check MOS Note: There is no "minor" patch set upgrade anymore. Even though I would love to tell you that going from But going to Oracle Database The first two digits identify the major database release number.
So, going from 9 to 10 to 11 to 12 is a major upgrade. I blogged about something very similar about a year and a half ago. Disagree - the doc does explain the release number and this part is carried over I believe since the 8i days. But it has nothing to do with the database upgrade.
Every release is a FULL release. You will see a ton of changes in the next release of the database as you saw with Compared to changes between 9i to 10g to 11g to 12c, changes between The method of delivery is just to make it easy to rollback in case of failed upgrade.
It has nothing to do with the fact that it is a major or minor upgrade. Major upgrade implies major feature changes, not how the upgrade is delivered. The new features guide is a good measure of whether or not an upgrade is major or minor. Things may be different when you look back to Oracle 9i and Oracle 10g.
Look at the features being introduced in And unfortunately not all changes make it into the new features guide, especially when we talk about changes with the optimizer or parallel or SPM I've had an interesting discussion today. Somebody removed OLAP with chopt - and got issues afterwards. This blog post is an addition to: Upgrade your Database - NOW! Archived Database Upgrade Blog. Best Practice June 20, Mike Dietrich Master Product Manager.
My Belgium friend Phillipe Fierens raised a great question on Twitter last week and dropped me an email again after having a discussion with his client: For Phillipe and myself the answer is pretty clear and straight forward: Let me summarize why I completely disagree - and actually Dom Giles nailed it: Since Oracle Database I hope this clarifies it all. Commenting is closed on this post. Arun, sorry to insist but I speak explicitly about upgrade since we deliver all patch sets as a full release - i.
Best Practice Upgrade to Oracle Database Best Practice Remove components from the Oracle kernel with chopt I've had an interesting discussion today.
Oracle Database 11gR2 (220.127.116.11) installation on Oracle Linux 6.4
Timezone file DSTv25 - patch for The File Download screen appears. Patches released through the Critical Patch Update program are provided only for product versions that are covered under the Premier Support or Extended Support phases of the Lifetime Support Policy. Time for another upgrade! For more information on Oracle Secure Backup, refer to. I've had an interesting discussion today. Oracle recommends that tablespaces be created with the following default properties: This bug will not affect the correct management or recommended actions associated with this type of performance class. For example, the latest time zone files that are supplied with Oracle Database 11 g Release 2
Archived Database Upgrade Blog
If the Oracle home is an Oracle Database home directory, then repeat steps for other binaries such as extjob , jssu , nmb , nmhs and nmo. There is no "minor" patch set upgrade anymore. Some ASAP implementations may require a tablespace layout that differs from the layout recommended here. Re-register the schema with xdb:
Database Engine: 18.104.22.168
For late-breaking updates and best practices about preupgrade, post-upgrade, compatibility, and interoperability discussions, see Note Executive Summary and Analysis. After upgrading to Oracle Database 11 g Release 2 A download progress screen appears. Oracle Fusion Middleware MapViewer, version s Table lists suggested Oracle Database initialization parameter values. In some non-English language environments, the use of the operating system date command may return unexpected characters which are then used to name the directory and files. The Metalink Note