mikedietrichde.com
Open in
urlscan Pro
35.214.168.156
Public Scan
Submitted URL: http://mikedietrichde.com/
Effective URL: https://mikedietrichde.com/
Submission: On October 20 via manual from IN — Scanned from NL
Effective URL: https://mikedietrichde.com/
Submission: On October 20 via manual from IN — Scanned from NL
Form analysis 5 forms found in the DOM
GET https://mikedietrichde.com/
<form method="get" class="searchform themeform" action="https://mikedietrichde.com/">
<div>
<input type="text" class="search" name="s" onblur="if(this.value=='')this.value='To search type and hit enter';" onfocus="if(this.value=='To search type and hit enter')this.value='';" value="To search type and hit enter">
</div>
</form>GET https://mikedietrichde.com/
<form method="get" class="searchform themeform" action="https://mikedietrichde.com/">
<div>
<input type="text" class="search" name="s" onblur="if(this.value=='')this.value='To search type and hit enter';" onfocus="if(this.value=='To search type and hit enter')this.value='';" value="To search type and hit enter">
</div>
</form>GET https://mikedietrichde.com
<form action="https://mikedietrichde.com" method="get"><label class="screen-reader-text" for="cat">Categories</label><select name="cat" id="cat" class="postform">
<option value="-1">Select Category</option>
<option class="level-0" value="8">APEX (9)</option>
<option class="level-0" value="250">ASM / RAC / GI (18)</option>
<option class="level-0" value="432">Auditing (10)</option>
<option class="level-0" value="1592">AutoUpgrade (41)</option>
<option class="level-0" value="935">AWR (3)</option>
<option class="level-0" value="520">Behavior Change (31)</option>
<option class="level-0" value="4">Best Practice (38)</option>
<option class="level-0" value="294">catctl.pl (6)</option>
<option class="level-0" value="5">Cloud (18)</option>
<option class="level-0" value="1184">Conference (29)</option>
<option class="level-0" value="11">Customer Success (11)</option>
<option class="level-0" value="643">Data Guard (3)</option>
<option class="level-0" value="17">Data Pump (19)</option>
<option class="level-0" value="630">DBCA (8)</option>
<option class="level-0" value="19">DBUA (8)</option>
<option class="level-0" value="487">Deprecated / Desupported (7)</option>
<option class="level-0" value="575">Differences (3)</option>
<option class="level-0" value="561">DMU – Characterset Migration (4)</option>
<option class="level-0" value="889">Documentation (2)</option>
<option class="level-0" value="476">E-Business Suite (4)</option>
<option class="level-0" value="531">Enterprise Manager (5)</option>
<option class="level-0" value="1662">Exadata / ODA (2)</option>
<option class="level-0" value="1022">Export – Import (2)</option>
<option class="level-0" value="1382">Fail Safe (4)</option>
<option class="level-0" value="87">Fallback (9)</option>
<option class="level-0" value="7">Flaws and Pitfalls (102)</option>
<option class="level-0" value="190">General (17)</option>
<option class="level-0" value="661">GoldenGate (4)</option>
<option class="level-0" value="583">Hands-On Lab (11)</option>
<option class="level-0" value="513">in-Memory (5)</option>
<option class="level-0" value="462">Incremental Stats (3)</option>
<option class="level-0" value="1374">Installation (8)</option>
<option class="level-0" value="2361">Job Offering (1)</option>
<option class="level-0" value="283">JVM (19)</option>
<option class="level-0" value="355">Lifetime Support Policy (8)</option>
<option class="level-0" value="2552">Linux (1)</option>
<option class="level-0" value="1400">MAA (1)</option>
<option class="level-0" value="627">Microsoft Windows (5)</option>
<option class="level-0" value="1349">Minimal Downtime (2)</option>
<option class="level-0" value="49">Music & HiFi (6)</option>
<option class="level-0" value="25">MyOracle Support (17)</option>
<option class="level-0" value="1287">ODA – Oracle Database Appliance (1)</option>
<option class="level-0" value="15">Off Topic (23)</option>
<option class="level-0" value="1264">Office Hours (5)</option>
<option class="level-0" value="18">OOW (73)</option>
<option class="level-0" value="184">Operating System (10)</option>
<option class="level-0" value="9">Optimizer (33)</option>
<option class="level-0" value="602">ORAchk (4)</option>
<option class="level-0" value="22">Oracle Database 11g (28)</option>
<option class="level-0" value="6">Oracle Database 12.2.0.1 (40)</option>
<option class="level-0" value="3">Oracle Database 12c (66)</option>
<option class="level-0" value="1267">Oracle Database 18c (10)</option>
<option class="level-0" value="1537">Oracle Database 19c (21)</option>
<option class="level-0" value="1801">Oracle Database 20c (2)</option>
<option class="level-0" value="2107">Oracle Database 21c (9)</option>
<option class="level-0" value="2503">Oracle Database 23c (2)</option>
<option class="level-0" value="2567">ORAdiff (2)</option>
<option class="level-0" value="68">Parameters (41)</option>
<option class="level-0" value="14">Patch Recommendation (180)</option>
<option class="level-0" value="212">Performance Tuning (6)</option>
<option class="level-0" value="1213">Pictures (1)</option>
<option class="level-0" value="650">Real Application Testing (2)</option>
<option class="level-0" value="1111">Release Schedule (36)</option>
<option class="level-0" value="23">Removal (26)</option>
<option class="level-0" value="467">Restart – SIHA – HAS (6)</option>
<option class="level-0" value="421">RMAN (9)</option>
<option class="level-0" value="538">SAP (2)</option>
<option class="level-0" value="645">SE2 – Standard Edition 2 (8)</option>
<option class="level-0" value="521">Security (7)</option>
<option class="level-0" value="13">Single-/Multitenant (88)</option>
<option class="level-0" value="16">Slides (26)</option>
<option class="level-0" value="656">SPM – SQL Plan Management (3)</option>
<option class="level-0" value="761">Statistics (4)</option>
<option class="level-0" value="746">TDE – Transparent Database Encryption (4)</option>
<option class="level-0" value="205">Time Zone – DST (13)</option>
<option class="level-0" value="167">Transportable (19)</option>
<option class="level-0" value="21">Travel (50)</option>
<option class="level-0" value="1">Uncategorized (9)</option>
<option class="level-0" value="118">Upgrade / Migration (49)</option>
<option class="level-0" value="320">Video / Viewlet (9)</option>
<option class="level-0" value="61">Virtualization (5)</option>
<option class="level-0" value="12">Workshop (186)</option>
<option class="level-0" value="2278">XE – Express Edition (2)</option>
</select>
</form>POST #
<form action="#" method="post" accept-charset="utf-8" id="subscribe-blog-blog_subscription-5" data-blog="126042384" data-post_access_level="everybody">
<p id="subscribe-email">
<label id="jetpack-subscribe-label" class="screen-reader-text" for="subscribe-field-blog_subscription-5"> Email Address - @oracle.com doesn't work </label>
<input type="email" name="email" required="required" value="" id="subscribe-field-blog_subscription-5" placeholder="Email Address - @oracle.com doesn't work">
</p>
<p id="subscribe-submit">
<input type="hidden" name="action" value="subscribe">
<input type="hidden" name="source" value="https://mikedietrichde.com/">
<input type="hidden" name="sub-type" value="widget">
<input type="hidden" name="redirect_fragment" value="subscribe-blog-blog_subscription-5">
<button type="submit" class="wp-block-button__link" name="jetpack_subscriptions_widget"> Subscribe </button>
</p>
</form><form id="jp-carousel-comment-form">
<label for="jp-carousel-comment-form-comment-field" class="screen-reader-text">Write a Comment...</label>
<textarea name="comment" class="jp-carousel-comment-form-field jp-carousel-comment-form-textarea" id="jp-carousel-comment-form-comment-field" placeholder="Write a Comment..."></textarea>
<div id="jp-carousel-comment-form-submit-and-info-wrapper">
<div id="jp-carousel-comment-form-commenting-as">
<fieldset>
<label for="jp-carousel-comment-form-email-field">Email (Required)</label>
<input type="text" name="email" class="jp-carousel-comment-form-field jp-carousel-comment-form-text-field" id="jp-carousel-comment-form-email-field">
</fieldset>
<fieldset>
<label for="jp-carousel-comment-form-author-field">Name (Required)</label>
<input type="text" name="author" class="jp-carousel-comment-form-field jp-carousel-comment-form-text-field" id="jp-carousel-comment-form-author-field">
</fieldset>
<fieldset>
<label for="jp-carousel-comment-form-url-field">Website</label>
<input type="text" name="url" class="jp-carousel-comment-form-field jp-carousel-comment-form-text-field" id="jp-carousel-comment-form-url-field">
</fieldset>
</div>
<input type="submit" name="submit" class="jp-carousel-comment-form-button" id="jp-carousel-comment-form-button-submit" value="Post Comment">
</div>
</form>Text Content
Manage Cookie Consent
We use cookies to optimize our website and our service.
Functional Functional Always active
The technical storage or access is strictly necessary for the legitimate purpose
of enabling the use of a specific service explicitly requested by the subscriber
or user, or for the sole purpose of carrying out the transmission of a
communication over an electronic communications network.
Preferences Preferences
The technical storage or access is necessary for the legitimate purpose of
storing preferences that are not requested by the subscriber or user.
Statistics Statistics
The technical storage or access that is used exclusively for statistical
purposes. The technical storage or access that is used exclusively for anonymous
statistical purposes. Without a subpoena, voluntary compliance on the part of
your Internet Service Provider, or additional records from a third party,
information stored or retrieved for this purpose alone cannot usually be used to
identify you.
Marketing Marketing
The technical storage or access is required to create user profiles to send
advertising, or to track the user on a website or across several websites for
similar marketing purposes.
Manage options Manage services Manage {vendor_count} vendors Read more about
these purposes
Accept cookies Deny View preferences Save preferences View preferences
Cookie Policy Privacy Statement About
Skip to content
UPGRADE YOUR DATABASE - NOW!
*
*
*
Mike Dietrich's Blog About Oracle Database Upgrades… Mostly
Expand Menu
* Current Page: Blog
* Slides
* Hands-On LabToggle Child Menu
* 1. Setup
* 2. Load
* 3. Capture and Preserve
* 4. AutoUpgrade
* 5. AWR Diff
* 6. SQL Perf Analyzer
* 7. SQL Plan Mgmt
* 8. SQL Tuning Advisor
* 10. Plugin UPGR => CDB2
* 11. Migrate FTEX
* 12. Un-/ Plug / Upgrade
* 13. Fallback StrategiesToggle Child Menu
* 14a. Issues During Upgrade
* 14b. Issues After Upgrade
* 15. AutoUpgrade – Special
* AutoUpgrade – HOL 19c – Japanese
* Videos
* Scripts
* Links
* Oracle Documentation
* PrivacyToggle Child Menu
* Cookie Policy (EU)
* GDPR – Request personal data
* About
RESTRICTED UPGRADE SUPPORT ADDED FOR SEVERAL RELEASES OF ORACLE DATABASE
5
IMPORTANT CLARIFICATIONS TO THE ORACLE DATABASE ERROR CORRECTION POLICY
2
ORADIFF IS LIVE – COMPARE TWO ORACLE DATABASE AND PATCH RELEASES
17
IN-PERSON UPGRADE WORKSHOPS IN BRUSSELS AND UTRECHT
11
2 YEARS OF EXTENDED SUPPORT GET WAIVED FOR ORACLE DATABASE 19C
6
YOUR UPGRADE AND MIGRATION PROGRAM AT OCW23
4
YOUR UPGRADE / MIGRATION / PATCHING GUIDE FOR OCW23
8
SEPTEMBER 2023 VERSION OF AUTOUPGRADE IS AVAILABLE
4
YOU MAY NEED TO RUN ROOT.SH AGAIN AFTER RU PATCHING
10
HOW MANY FIXES ARE YOU MISSING?
2
RESTRICTED UPGRADE SUPPORT ADDED FOR SEVERAL RELEASES OF ORACLE DATABASE
5
IMPORTANT CLARIFICATIONS TO THE ORACLE DATABASE ERROR CORRECTION POLICY
2
ORADIFF IS LIVE – COMPARE TWO ORACLE DATABASE AND PATCH RELEASES
17
IN-PERSON UPGRADE WORKSHOPS IN BRUSSELS AND UTRECHT
11
2 YEARS OF EXTENDED SUPPORT GET WAIVED FOR ORACLE DATABASE 19C
6
YOUR UPGRADE AND MIGRATION PROGRAM AT OCW23
4
YOUR UPGRADE / MIGRATION / PATCHING GUIDE FOR OCW23
8
SEPTEMBER 2023 VERSION OF AUTOUPGRADE IS AVAILABLE
4
YOU MAY NEED TO RUN ROOT.SH AGAIN AFTER RU PATCHING
10
HOW MANY FIXES ARE YOU MISSING?
2
RESTRICTED UPGRADE SUPPORT ADDED FOR SEVERAL RELEASES OF ORACLE DATABASE
5
IMPORTANT CLARIFICATIONS TO THE ORACLE DATABASE ERROR CORRECTION POLICY
2
ORADIFF IS LIVE – COMPARE TWO ORACLE DATABASE AND PATCH RELEASES
17
IN-PERSON UPGRADE WORKSHOPS IN BRUSSELS AND UTRECHT
11
PreviousNext
IMPORTANT CLARIFICATIONS TO THE ORACLE DATABASE ERROR CORRECTION POLICY
Posted on October 19, 2023 by Mike.Dietrich Best Practice Patch Recommendation
Release Schedule 2
When I came back from vacation a few weeks ago (or was it almost 2 months ago??)
I learned that we have added some Important clarifications to the Oracle
Database Error Correction Policy. The clarifications are mainly about how long
you will be able to request a single fix for a given Release Update (RU). Take
this not as a constraint but a motivation to argue internally to not stay on too
old Release Updates.
Photo by Saul Macias on Unsplash
HOW TO FIND THE IMPORTANT NOTES?
It is not easy to find this important note in MOS, …
Continue reading...
HOW MANY FIXES ARE YOU MISSING?
Posted on October 4, 2023 by Mike.Dietrich ORAdiff Patch Recommendation 2
Since we’ve had a public holiday in Germany yesterday, this feels almost like my
Monday-morning-rant blog post. But seriously, this question came up so many
times the past weeks. And I think it is worth a blog post to answer the
question: How many fixes are you missing?
Photo by Paul Hutton on Unsplash
WHY WOULD YOU WANT TO KNOW?
To be frank, customers I discussed the patch bundle topic with recently are
often not interested in knowing how many fixes they are missing. Discussions
quickly emerge into “quality” or “ease” or “cost” for how to apply patches. But
rarely …
Continue reading...
SEPTEMBER 2023 VERSION OF AUTOUPGRADE IS AVAILABLE
Posted on September 29, 2023 by Mike.Dietrich AutoUpgrade 4
It’s time again – and the new September 2023 version of AutoUpgrade is available
for download to you.
Photo by Spenser Sembrat on Unsplash
WHERE TO DOWNLOAD IT?
As usual, the MOS Note: 2485457.1 offers you access to the new release, and to
the previous versions of the tool as well. This new version will show the
following version information:
Plain text
Copy to clipboard
Open code in new window
EnlighterJS 3 Syntax Highlighter
java -jar autoupgrade.jar -version
build.version 23.4.230921
build.date 2023/09/21 14:43:05 -0400
build.hash 165be072
build.hash_date 2023/09/21 13:05:52 -0400
build.supported_target_versions 12.2,18,19,21
build.type production
build.label (HEAD, tag: v23.4, origin/stable_devel, stable_devel)
java -jar autoupgrade.jar -version build.version 23.4.230921 build.date
2023/09/21 14:43:05 -0400 build.hash 165be072 build.hash_date 2023/09/21
13:05:52 -0400 build.supported_target_versions 12.2,18,19,21 build.type
production build.label (HEAD, tag: v23.4, origin/stable_devel, stable_devel)
java -jar autoupgrade.jar -version
build.version 23.4.230921
build.date 2023/09/21 14:43:05 -0400
build.hash 165be072
build.hash_date 2023/09/21 13:05:52 -0400
build.supported_target_versions 12.2,18,19,21
build.type production
build.label (HEAD, tag: v23.4, origin/stable_devel, stable_devel)
This version will be also included in the Jan 2024 RU, 19.22.0, but not …
Continue reading...
IN-PERSON UPGRADE WORKSHOPS IN BRUSSELS AND UTRECHT
Posted on September 27, 2023 by Mike.Dietrich Workshop 11
For a long time we haven’t met in person I guess. But I know very well that the
audiences in Brussels, Belgium, and Utrecht, Netherlands, are very active. And
it’s actually the best to meet for In-person Upgrade Workshops in Brussels and
Utrecht in October – not via zoom And this is your change to sign up if you
haven’t already.
Photo by Chris Lawton on Unsplash
WHEN WILL IT HAPPEN?
Very simple – and you are just one click away:
* Brussels, Belgium – Tuesday, Oct 10, 2023
.
* Utrecht, Netherlands – Wednesday, Oct 11, 2023
.
Both events …
Continue reading...
YOUR UPGRADE / MIGRATION / PATCHING GUIDE FOR OCW23
Posted on September 18, 2023 by Mike.Dietrich OOW 8
Thanks for using this blog post. It will be your Upgrade / Migration / Patching
Guide for OCW23. You will find the slide decks to download, the coming talks,
the HOL as well as the survey links and other important sources. We wil update
it every day throughout the conference. If you have questions, please use the
“Comment” option below the blog post. And we won’t post content BEFORE the
session but instead AFTER the sessions.
ALL YOU NEED, DAY BY DAY
Please find – grouped day by day – each of our talks with the survey links and …
Continue reading...
YOUR UPGRADE AND MIGRATION PROGRAM AT OCW23
Posted on September 4, 2023 by Mike.Dietrich OOW 4
Are you coming to Oracle Cloud World 2023 and to Oracle DatabaseWorld at
CloudWorld? Then you should read on since this may be your upgrade and migration
program at OCW23. We are desperately looking forward to see and meet you in 2
weeks in Las Vegas. Don’t forget to add the talks you’d like to visit to your
schedule as some of the rooms have limited capacity. And at least one of our
labs is already sold out.
https://www.oracle.com/database/upgrades/#rc30p2
WHO’S SPEAKING AND HOL’ING?
Speakers and your lab hosts will be:
* Roy Swonger
* Mike Dietrich
* Daniel Overby Hansen
* Rodrigo Jorge
… Continue reading...
RESTRICTED UPGRADE SUPPORT ADDED FOR SEVERAL RELEASES OF ORACLE DATABASE
Posted on August 23, 2023 by Mike.Dietrich Release Schedule 5
You may have read my blog post from yesterday about the additional second year
of Waived Extended Support for Oracle Database 19c. But there are more news such
as Restricted Upgrade Support added for several releases of Oracle Database.
Photo by Georgi Kalaydzhiev on Unsplash
WHAT HAS BEEN ANNOUNCED?
When you consult our single-source-of-truth MOS Note: 742060.1 – Release
Schedule of Current Database Releases you may see also this message:
> Restricted Upgrade Support has been added for 2024 through Customer Success
> Services (aka ACS)
But you have to look a bit closer and either go through the long …
Continue reading...
2 YEARS OF EXTENDED SUPPORT GET WAIVED FOR ORACLE DATABASE 19C
Posted on August 22, 2023 by Mike.Dietrich Release Schedule 6
I learned the other week that 2 years of Extended Support get waived for Oracle
Database 19c. So, just in case you haven’t seen it, please take note since this
is important to know.
Photo by Bob Brewer on Unsplash
WHERE CAN YOU FIND THE UPDATED INFORMATION?
You can find the updated information in our single-source-of-truth MOS Note:
742060.1 – Release Schedule of Current Database Releases explaining:
> Premier Support (PS) ends April 30, 2024, two years of waived Extended Support
> (ES) fees will be in effect from May 1, 2024 until April 30, 2026. Fees will
> be required
… Continue reading...
ORADIFF IS LIVE – COMPARE TWO ORACLE DATABASE AND PATCH RELEASES
Posted on August 8, 2023 by Mike.Dietrich ORAdiff 17
Did you ever wanted to find out the differences between two Oracle database
releases? Today, I am super-super excited. Especially, since this was a long
journey. And I have to thank our entire team, Rodrigo especially but also Bill
and all the others working and helping here. THIS is the tool many of you have
looking for since years. It is time now, ORAdiff is live – compare two Oracle
Database and Patch releases.
WHAT IS ORADIFF?
This tool is made for you. It allows you to compare two Oracle releases to each
other. And not only core …
Continue reading...
YOU MAY NEED TO RUN ROOT.SH AGAIN AFTER RU PATCHING
Posted on August 7, 2023 by Mike.Dietrich Patch Recommendation 10
With the Oracle Critical Patch Update Advisory – July 2023 – you may have
spotted a change in the Database Release Update READMEs: You may need to run
root.sh again after RU patching. Why is that?
Photo by Mario Häfliger on Unsplash
LET US HAVE A QUICK LOOK
I verified this with the 19.20.0 README on Linux. But I guess this applies to
the other READMEs as well. Please bare in mind that this applies to the Database
RUs only, not to Grid Infrastructure. You can find this new paragraph in it:
> 3.3.5 UPDATE PERMISSIONS FOR EXTJOB
… Continue reading...
GOING TO INDIA: ORACLE COMMUNITY YATRA (OCYATRA) 2023
Posted on July 17, 2023 by Mike.Dietrich Workshop 0
One year ago I’ve had the pleasure to visit India for the YATRA 2022 tour. I
couldn’t do all 6 tour stops and had to skip Delhi and Hyderabad. But this year
I will be there for all 6 cities. So I am going to India: Oracle Community Yatra
(OCYatra) 2023. And I hope to see YOU there, will I?
WHY YOU NEED TO GET YOUR TICKET NOW?
I guess, most of you in the area have tickets already. Just in case if you
didn’t purchase one yet, it’s time to do so. It is not expensive but be …
Continue reading...
ORACLE LINUX (OL), RED HAT ENTERPRISE LINUX (RHEL) AND CENTOS
Posted on July 11, 2023 by Mike.Dietrich Linux Operating System 9
Oracle isn’t always evil. And I personally never understood why not everyb0dy is
on Oracle Linux (OL) already. It’s free, it gets extremely well maintained. And
some issues my customers saw with Red Hat Enterprise Linux (RHEL) were fixed
with OL literally more than a year before RHEL did. No blame to anybody – but
that is my experience when customers tell me about issues over the past two
years. But what is the future of Oracle Linux (OL), Red Hat Enterprise Linux
(RHEL) and CentOS? And why am I writing this blog post?
Photo by Brigitta Schneiter on
… Continue reading...
ORACLE DATABASE 19C ON ARM PLATFORM IS AVAILABLE
Posted on July 5, 2023 by Mike.Dietrich Oracle Database 19c Release Schedule 16
I knew it would come – but we couldn’t tell you. And there were some rumors for
a longer time. Anyhow, last week at the end of June 2023 Oracle Database 19c on
Arm platform is available for download and in the Oracle Cloud. In case you
wonder why I write “Arm” – I learned last week that the writing has been changed
a while ago from ARM to Arm.
WHERE CAN YOU DOWNLOAD IT?
It is available for download already.
* Oracle Database 19c(19.19) for Linux Arm (aarch64)
* https://www.oracle.com/database/technologies/oracle-database-software-downloads.html#19c
* 19c Client(19.19) and Instant Client 19c(19.19) for Linux on Arm (aarch64)
… Continue reading...
JUNE 2023 VERSION OF AUTOUPGRADE IS AVAILABLE
Posted on July 3, 2023 by Mike.Dietrich AutoUpgrade 2
It’s time to exchange your AutoUpgrade tools with the most recent one when you
plan to do upgrades or use it for patching already. The June 2023 version of
AutoUpgrade is available for download from MOS Note:2485457.1. And in case you
are still using DBUA for unknown reasons, please read this blog post, too.
Photo by Jason Hudson on Unsplash
WHERE TO DOWNLOAD?
As usual, please download the newest version of AutoUpgrade via MOS
Note:2485457.1 – Download AutoUpgrade.
WHAT DOES THIS VERSION IMPROVE?
NEW FEATURES
* BUG-34010941 – Incorparated the Health check package to identify database
dictionary inconsistencies
… Continue reading...
DBUA DEPRECATION AND FUTURE DESUPPORT IN ORACLE DATABASE 23C
Posted on June 21, 2023 by Mike.Dietrich AutoUpgrade DBUA Deprecated /
Desupported 14
Daniel pointed me to Tim Hall’s blog post about deprecated and desupported
features in Oracle Database 23c. And his first bullet point mentioned is the
DBUA Deprecation and future Desupport in Oracle Database 23c. Since Daniel and I
agree that this needs a bit more explanation, we would like to share more
background information with you.
Photo by Ajeet Mestry on Unsplash
DEPRECATED VS DESUPPORT?
At first, let me refresh an old topic. What does deprecated mean, and what is
the difference to desupport? A long while ago I wrote this blog post about it,
and nothing …
Continue reading...
VIRTUAL CLASSROOM SEMINAR 17: FROM SR TO PATCH
Posted on June 20, 2023 by Mike.Dietrich Workshop 4
This is your chance to sign up to our Virtual Classroom Seminar 17: From SR to
Patch – Insights into the Oracle Database Development process. It will happen
Thursday, June 22 at 16:00h CET. As usual, this is free of charge. It is your
unique chance to get insights into our database development process. We lift the
curtain for a bit, and tell you what’s happening behind the scenes. Don’t miss
this chance.
Photo by Steven Van Elk on Unsplash
WHY AND HOW REGISTER?
This is the seminar telling you what happens behind the scenes. We will tell …
Continue reading...
PATCH DOWNLOAD ASSISTANT HAS NOW MRPS AS WELL
Posted on June 16, 2023 by Mike.Dietrich Patch Recommendation 12
You gave feedback – we discussed it, and Muthu implemented it right away. This
will be a shorter blog post about one of our most favorite MOS notes, MOS Note:
2118136.2 since the Patch Download Assistant has now MRPs as well.
Photo by Ben Pattinson on Unsplash
WHAT IS THE DOWNLOAD ASSISTANT ALL ABOUT?
We call MOS Note: 2118136.2 – Assistant: Download Reference for Oracle
Database/GI Update, Revision, PSU, SPU(CPU), Bundle Patches, Patchsets and Base
Releases one of our top 5 MOS notes because it is so handy. You need to download
an RU? 3 clicks later you download it. …
Continue reading...
ZERO DOWNTIME UPGRADE OF TIMEZONE DATA IN ORACLE 21C AND 23C?
Posted on June 6, 2023 by Mike.Dietrich Best Practice Oracle Database 21c Oracle
Database 23c Time Zone - DST 2
There is a feature in Oracle Database 21c I planned to write about for a very
long time: Zero Downtime Upgrade of Timezone Data in Oracle 21c and 23c. This
sounds very promising – but let us take a closer look together in this blog
post.
Photo by Bruno Figueiredo on Unsplash
TIME ZONE UPGRADE?
There is of course an ongoing discussion whether and when you should upgrade the
DST version of your database to a current value. Since we all live in a more and
more globalized world, this topic becomes more and more important. Even more
important …
Continue reading...
CHOOSE YOUR DESIRED TIME ZONE VERSION (DST) UPGRADE
Posted on May 24, 2023 by Mike.Dietrich Time Zone - DST Transportable 6
This morning I received a very reasonable question from a customer who has a
time zone mismatch between source and target database. And he wants to transport
into a PDB on Exadata. Even though, this sounds trivial at first sight,
unfortunately it isn’t. But a bug fix done recently for a German automotive
customer is very handy here. So let me show you how you can Choose your desired
time zone version (DST) upgrade.
Photo by Vince Veras on Unsplash
WHERE DOES THE PROBLEM START?
In this particular – and not unusual case – the customer wants to migrate …
Continue reading...
PATCHING TO ORACLE 19.19.0 OUT-OF-PLACE WITH ADDITIONAL PATCHES
Posted on May 23, 2023 by Mike.Dietrich AutoUpgrade Patch Recommendation 55
From all my quarterly blog posts you know that I patch usually in-place for
space and other reasons. And you may have similar reasons when you patch. But it
is not ideal – and just speaking about risk and downtime, you should always
patch out-of-place. So let me show you how Patching to Oracle 19.19.0
out-of-place with additional patches works.
Photo by Stefano Ferretti on Unsplash
WHAT DO I NEED?
Actually, this is not complicated at all. And if you never done it this way,
give it a try now please.
* Base release Oracle Database 19.3.0 image
* opatch 37 from
… Continue reading...
PATCHING PROCESS CHANGES WITH MRPS
Posted on May 22, 2023 by Mike.Dietrich Patch Recommendation 10
I blogged about the Monthly Recommended Patches (MRP) several times before. And
due to the feedback you and we had given, a few things got changed. The main
change is from having the MRP bundled as a system patch making opatchauto a
requirement. See below what Patching process changes with MRPs were implemented
recently.
Photo by Karthik Sreenivas on Unsplash
BEFORE …
As you could read already in:
* Applying the first MRP to 19.17.0 and
* Applying the MRP from December 2022 to 19.17.0
the introduction of the MRPs added one major flaw: They’ve been built as system
patches which made …
Continue reading...
CLEANING UP OLDER PATCH ARTIFACTS – IMPROVING OPATCH PERFORMANCE
Posted on May 16, 2023 by Mike.Dietrich Patch Recommendation 26
This blog post is about a feature not only I but you did ask for actually for a
long time. Cleaning up older patch artifacts – improving opatch performance.
Both in one opatch release. And opatch 12.2.0.1.37 from April 2023 has it.
Photo by Toon Lambrechts on Unsplash
A LITTLE BIT OF HISTORY
One of the longest journey I had ever done in my long time in Oracle was helping
customers to find a voice for patch cleanup. Oracle 19c is a long term support
release. Many customers upgraded to it already. And you apply patches on a
regular …
Continue reading...
VIRTUAL CLASSROOM SEMINAR 16: RELEASE AND PATCHING STRATEGY FOR ORACLE 19C AND
23C
Posted on May 8, 2023 by Mike.Dietrich Patch Recommendation Release Schedule
Workshop 9
There are just two days left to sign up for our Virtual Classroom Seminar 16:
Release and Patching Strategy for Oracle 19c and 23c. We’ll talk to you on
Wednesday, May 10 at 16:00h CET.
Photo by JESHOOTS.COM on Unsplash
WHAT’S THE TOPIC?
We’ll try to cover everything for your best release and patching strategy with
Oracle Database 19c of course, but also moving forward to Oracle Database 23c.
Our big focus will be several aspects of patching. You’ll hear us talking not
only about standard database patching but especially about patching in RAC
environments.
We’ll put together a …
Continue reading...
DATAPATCH MAY BE SLOWER WHEN TRADITIONAL AND UNIFIED AUDITING ARE ON
Posted on April 11, 2023 by Mike.Dietrich Auditing Flaws and Pitfalls 7
I wrote several times especially about Unified Auditing in the past. It is a
very efficient and useful way to audit operations in the database. But you need
to be a bit careful about what’s on, and what isn’t. Now we recently had a
customer case where it was clearly proven that Datapatch may be slower when
Traditional and Unified Auditing are on. But how can this happen?
Photo by marcos mayer on Unsplash
RECAPPING TRADITIONAL AUDITING
At first, I am neither a security not an auditing expert. But I played quite a
bit with Unified Auditing over the …
Continue reading...
ORACLE DATABASE WORLD IN LONDON – THE EVENT IN APRIL 2023
Posted on April 5, 2023 by Mike.Dietrich Conference Workshop 7
You may have heard or seen – or even registered already – for the regional
Oracle Cloud World in London on April 19, 2023 already. But were you aware that
the “event to be at” happens just the next day on April 20? It will be Oracle
Database World in London – THE event in April 2023.
WHEN AND WHERE WILL IT HAPPEN?
April 20, 2023, a Thursday will be the day to mark in your calendar. We’ll meet
you at Oracle Database World, the regional database event to be at in London
this year at the …
Continue reading...
*
* Next Page »
Mike Dietrich
Oracle Senior Director of Product Manager for Database Upgrade, Migrations and
Patching writing just another blog.
Opinions certainly are my own as is this page.
ARCHIVES
Archives Select Month October 2023 (2) September 2023 (4) August 2023 (4)
July 2023 (4) June 2023 (4) May 2023 (5) April 2023 (3) March 2023 (3)
February 2023 (3) January 2023 (6) December 2022 (3) November 2022 (3)
October 2022 (4) September 2022 (5) August 2022 (5) July 2022 (3) May 2022
(6) April 2022 (5) March 2022 (4) February 2022 (2) January 2022 (4)
December 2021 (5) November 2021 (2) October 2021 (2) September 2021 (2)
August 2021 (10) July 2021 (5) June 2021 (6) May 2021 (5) April 2021 (5)
March 2021 (3) February 2021 (7) January 2021 (7) December 2020 (4) November
2020 (5) October 2020 (12) September 2020 (4) August 2020 (7) July 2020
(14) June 2020 (10) May 2020 (11) April 2020 (12) March 2020 (6) February
2020 (10) January 2020 (13) December 2019 (6) November 2019 (6) October 2019
(8) September 2019 (8) August 2019 (7) July 2019 (17) June 2019 (7) May
2019 (7) April 2019 (9) March 2019 (1) February 2019 (7) January 2019 (5)
December 2018 (7) November 2018 (10) October 2018 (7) September 2018 (10)
August 2018 (11) July 2018 (16) June 2018 (10) May 2018 (11) April 2018
(13) March 2018 (14) February 2018 (7) January 2018 (11) December 2017 (5)
November 2017 (6) October 2017 (10) September 2017 (11) August 2017 (17)
July 2017 (20) June 2017 (6) May 2017 (19) April 2017 (7) March 2017 (12)
February 2017 (11) January 2017 (10) December 2016 (6) November 2016 (16)
October 2016 (9) September 2016 (6) August 2016 (4) July 2016 (6) June 2016
(4) May 2016 (9) April 2016 (11) March 2016 (9) February 2016 (6) January
2016 (9) December 2015 (12) November 2015 (9) October 2015 (12) September
2015 (16) August 2015 (10) July 2015 (13) June 2015 (8) May 2015 (5) April
2015 (8) March 2015 (5) February 2015 (14) January 2015 (7) December 2014
(4) November 2014 (7) October 2014 (7) September 2014 (11) August 2014 (9)
July 2014 (6) June 2014 (3) May 2014 (6) April 2014 (7) March 2014 (5)
February 2014 (6) January 2014 (7) December 2013 (3) November 2013 (5)
October 2013 (3) September 2013 (3) August 2013 (5) July 2013 (9) June 2013
(2) May 2013 (2) April 2013 (4) January 2013 (3) December 2012 (1) November
2012 (1) October 2012 (8) September 2012 (6) August 2012 (3) July 2012 (4)
June 2012 (3) May 2012 (5) April 2012 (6) March 2012 (6) February 2012 (8)
January 2012 (3) December 2011 (3) November 2011 (5) October 2011 (7)
September 2011 (3) August 2011 (5) July 2011 (5) June 2011 (4) May 2011 (8)
April 2011 (1) March 2011 (3) February 2011 (2) January 2011 (4) December
2010 (4) November 2010 (12) October 2010 (6) September 2010 (8) August 2010
(5) July 2010 (5) June 2010 (6) May 2010 (4) April 2010 (9) March 2010
(17) February 2010 (12) January 2010 (3) December 2009 (4) November 2009
(5) October 2009 (4) September 2009 (5) August 2009 (11) July 2009 (3)
CATEGORIES
Categories Select Category APEX (9) ASM / RAC / GI (18) Auditing (10)
AutoUpgrade (41) AWR (3) Behavior Change (31) Best Practice (38)
catctl.pl (6) Cloud (18) Conference (29) Customer Success (11) Data
Guard (3) Data Pump (19) DBCA (8) DBUA (8) Deprecated / Desupported (7)
Differences (3) DMU – Characterset Migration (4) Documentation (2) E-Business
Suite (4) Enterprise Manager (5) Exadata / ODA (2) Export – Import (2) Fail
Safe (4) Fallback (9) Flaws and Pitfalls (102) General (17) GoldenGate (4)
Hands-On Lab (11) in-Memory (5) Incremental Stats (3) Installation (8) Job
Offering (1) JVM (19) Lifetime Support Policy (8) Linux (1) MAA (1)
Microsoft Windows (5) Minimal Downtime (2) Music & HiFi (6) MyOracle
Support (17) ODA – Oracle Database Appliance (1) Off Topic (23) Office
Hours (5) OOW (73) Operating System (10) Optimizer (33) ORAchk (4) Oracle
Database 11g (28) Oracle Database 12.2.0.1 (40) Oracle Database 12c (66)
Oracle Database 18c (10) Oracle Database 19c (21) Oracle Database 20c (2)
Oracle Database 21c (9) Oracle Database 23c (2) ORAdiff (2) Parameters (41)
Patch Recommendation (180) Performance Tuning (6) Pictures (1) Real
Application Testing (2) Release Schedule (36) Removal (26) Restart – SIHA –
HAS (6) RMAN (9) SAP (2) SE2 – Standard Edition 2 (8) Security (7)
Single-/Multitenant (88) Slides (26) SPM – SQL Plan Management (3)
Statistics (4) TDE – Transparent Database Encryption (4) Time Zone – DST (13)
Transportable (19) Travel (50) Uncategorized (9) Upgrade / Migration (49)
Video / Viewlet (9) Virtualization (5) Workshop (186) XE – Express
Edition (2)
UPGRADE @YOUTUBE
RSS FEED FOR UPGRADE YOUR DATABASE – NOW!
* Important clarifications to the Oracle Database Error Correction Policy
* How many fixes are you missing?
* September 2023 version of AutoUpgrade is available
* In-person Upgrade Workshops in Brussels and Utrecht
* Your Upgrade / Migration / Patching Guide for OCW23
SUBSCRIBE VIA EMAIL
Email Address - @oracle.com doesn't work
Subscribe
Join 7,936 other subscribers
RECENT POSTS
* Important clarifications to the Oracle Database Error Correction Policy
* How many fixes are you missing?
* September 2023 version of AutoUpgrade is available
* In-person Upgrade Workshops in Brussels and Utrecht
* Your Upgrade / Migration / Patching Guide for OCW23
FOLLOW ME ON TWITTER
Upgrade your Database – NOW! © 2023. All Rights Reserved.
*
*
*
Manage consent
Loading Comments...
Write a Comment...
Email (Required) Name (Required) Website