X

Archived Database Upgrade Blog

Patch Recommendation

Patch Recommendation

The OJVM Patching Saga - and how to solve it - Part V

Related Posts on"The OJVM Patching Saga - and how to solve it": Part I - The OJVM Basics Part II - Important Notes and Information Part III - The Mitigation...

Related Posts on"The OJVM Patching Saga - and how to solve it": Part I - The OJVM Basics Part II - Important Notes and Information Part III - The Mitigation Patch Part IV - What you may have missed Part V - MOS Note explaining "Conditional Rolling Install"  . MOS Note released explaining patching without STARTUP UPGRADE mode An important note regarding OJVM rolling patching has been published on MyOracle Support: MOS Note: 2217053.1RAC Rolling Install Process for the "Oracle...

Patch Recommendation

The OJVM Patching Saga - and how to solve it - Part IV

Related Posts on"The OJVM Patching Saga - and how to solve it": Part I - The OJVM Basics Part II - Important Notes and Information Part III - The Mitigation...

Related Posts on"The OJVM Patching Saga - and how to solve it": Part I - The OJVM Basics Part II - Important Notes and Information Part III - The Mitigation Patch Part IV - What you may have missed Part V - MOS Note explaining "Conditional Rolling Install"  What is missing with the "Mitigation Patch? Michael, the team lead from a large Oracle customer mailed me the other day. He wanted to disable Java on all their +600 databases by using the Mitigation Patch for OJVM. But he...

Patch Recommendation

Where is the Jan 2017 PSU for Oracle Database 11.2.0.4?

Where is it? This question reached me a week ago:"Where is the January 2017 PSU for Oracle Database 11.2.0.4?" "What's the deal?" was my first thought - just go...

Where is it? This question reached me a week ago:"Where is the January 2017 PSU for Oracle Database 11.2.0.4?" "What's the deal?" was my first thought - just go and download it from MOS. Well, not really ... . Where to download Proactive Bundle Patches, Patch Set Updates and Patch Sets? My favorite note is:MOS Note:1454618.1 Quick Reference to Patch Numbers for PSU, SPU(CPU), BPs and Patchsets It gives me access to all the download links for the patch bundles I'm looking for....

Patch Recommendation

DBA_REGISTRY_HISTORY vs DBA_REGISTRY_SQLPATCH

At the DOAG Conference in November in Nürnberg in November 2016 a customer asked me right after my talk about "Upgrade to Oracle Database 12.2. - Live and...

At the DOAG Conference in November in Nürnberg in November 2016 a customer asked me right after my talk about "Upgrade to Oracle Database 12.2. - Live and Uncensored" why the DBA_REGISTRY_HISTORY does not get updated when he applies a Bundle Patch and follows all instructions including the "./datapatch -verbose" call. I was wondering as well and asked him to open an SR. Which he did. And he received the message from Support that it is not supposed to appear in Oracle 12c...

Patch Recommendation

October 2016 Proactive BP got replaced

Just received a message from Oracle Support this early morning as I did install the Proactive Bundle Patch from October 2016 into my Oracle Database 12.1.0.2...

Just received a message from Oracle Support this early morning as I did install the Proactive Bundle Patch from October 2016 into my Oracle Database 12.1.0.2 environment saying: Dear Oracle Customer,You are receiving this email because our recordsindicate you downloaded the following patch:Patch number: 24448103Release: DB Proactive Bundle 12.1.0.2.161018Platform: Linux x86-64This patch has been replaced and is now available for download. Please review section 1.1 of...

Patch Recommendation

New preupgrd.sql is available - MOS 884522.1

A new preupgrd.sql got released this week via MOS Note:884522.1. Plus use this one for upgrades to Oracle Database 12.1.0.2 instead of the deployed (or any...

A new preupgrd.sql got released this week via MOS Note:884522.1. Plus use this one for upgrades to Oracle Database 12.1.0.2 instead of the deployed (or any other earlier version). Changes since initial release of 12.1.0.2 Do not recommend pga_aggregate_limit for 12.1 databases fix miscalculation of upgrade parallel pdb count Updates to the memory sizing uploaded in build #12 Removed the 32-bit and 64-bit values in the manual display. Added a pga_aggregate_limit....

Patch Recommendation

October 2016 PSU and BP - Database Patching?

What will you get when you download the most recent Oracle Database PSU or BP from October 2016? MOS Note: 1683799.1 - 12.1.0.2 Patch Set - Availability and...

What will you get when you download the most recent Oracle Database PSU or BP from October 2016? MOS Note: 1683799.1 - 12.1.0.2 Patch Set - Availability and Known Issues is not entirely clear. Therefore lets shed some light ... The Matrix This matrix in MOS Note: 1683799.1 tells you about the availability of PSUs and BPs for a regular database installation (non-RAC, non-Exadata). But it doesn't clearly tell you what's included - and the names being used aren't very revealing...

Patch Recommendation

October 2016 PSU and Proactive BP are available

When the leafs are falling down ... ... then it's time for the October 2016 Patch Set Update (PSU) and Proactive Bundle Patches (BP).  Things you need to know:...

When the leafs are falling down ... ... then it's time for the October 2016 Patch Set Update (PSU) and Proactive Bundle Patches (BP).  Things you need to know: General information: Critical Patch Update - October 2016 Risk Matrix for: Oracle Database Server, version(s) 11.2.0.4, 12.1.0.2 Patch Availability: MOS Note: 2171485.1 Download the Database PSU or BP:MOS Note: 1683799.1 - 12.1.0.2 Patch Set - Availability and Known Issues Interesting information: Newly scheduled final...

Patch Recommendation

_rowsets_enabled - Apply patch and use the default

I while back I blogged about issues with "rowsets", a new Oracle 12c feature which unfortunately had two known wrong result (WQR) bugs: Switch off...

I while back I blogged about issues with "rowsets", a new Oracle 12c feature which unfortunately had two known wrong result (WQR) bugs: Switch off "_rowsets_enabled" in Oracle Database 12c  Nov 10, 2015 UPDATE: _rowsets_enabled in Oracle Database 12c Nov 16, 2015 extended with updates on Dec 2, 2015 and Sep 14, 2016 What does "rowsets" actually mean? I'd like to thank Sankar, our Development manager for providing this explanation which sheds some light on how important this...

Oracle

Integrated Cloud Applications & Platform Services