mikedietrichde.com Open in urlscan Pro
35.214.168.156  Public Scan

URL: https://mikedietrichde.com/2017/10/23/can-you-select-a-pdbs-character-set/?msclkid=a869cf39cf6d11ecbef8dfe805e966f5
Submission: On May 13 via manual from BE — Scanned from NL

Form analysis 7 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>

POST https://mikedietrichde.com/wp-comments-post.php

<form action="https://mikedietrichde.com/wp-comments-post.php" method="post" id="commentform" class="comment-form">
  <p class="comment-notes"><span id="email-notes">Your email address will not be published.</span> <span class="required-field-message" aria-hidden="true">Required fields are marked <span class="required" aria-hidden="true">*</span></span></p>
  <p class="comment-form-comment"><label for="comment">Comment <span class="required" aria-hidden="true">*</span></label> <textarea id="comment" name="comment" cols="45" rows="8" maxlength="65525" required="required"></textarea></p>
  <p class="comment-form-author"><label for="author">Name <span class="required" aria-hidden="true">*</span></label> <input id="author" name="author" type="text" value="" size="30" maxlength="245" required="required"></p>
  <p class="comment-form-email"><label for="email">Email <span class="required" aria-hidden="true">*</span></label> <input id="email" name="email" type="text" value="" size="30" maxlength="100" aria-describedby="email-notes" required="required"></p>
  <p class="comment-form-url"><label for="url">Website</label> <input id="url" name="url" type="text" value="" size="30" maxlength="200"></p>
  <p class="comment-subscription-form"><input type="checkbox" name="subscribe_comments" id="subscribe_comments" value="subscribe" style="width: auto; -moz-appearance: checkbox; -webkit-appearance: checkbox;"> <label class="subscribe-label"
      id="subscribe-label" for="subscribe_comments">Notify me of follow-up comments by email.</label></p>
  <p class="comment-subscription-form"><input type="checkbox" name="subscribe_blog" id="subscribe_blog" value="subscribe" style="width: auto; -moz-appearance: checkbox; -webkit-appearance: checkbox;"> <label class="subscribe-label"
      id="subscribe-blog-label" for="subscribe_blog">Notify me of new posts by email.</label></p>
  <p class="form-submit"><input name="submit" type="submit" id="submit" class="submit" value="Post Comment"> <input type="hidden" name="comment_post_ID" value="2857" id="comment_post_ID">
    <input type="hidden" name="comment_parent" id="comment_parent" value="0">
  </p>
  <p style="display: none;"><input type="hidden" id="akismet_comment_nonce" name="akismet_comment_nonce" value="92baed2e57"></p>
  <p style="display: none !important;"><label>Δ<textarea name="ak_hp_textarea" cols="45" rows="8" maxlength="100"></textarea></label><input type="hidden" id="ak_js_1" name="ak_js" value="1652452155607">
    <script>
      document.getElementById("ak_js_1").setAttribute("value", (new Date()).getTime());
    </script>
  </p>
</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&nbsp;&nbsp;(9)</option>
    <option class="level-0" value="250">ASM / RAC / GI&nbsp;&nbsp;(18)</option>
    <option class="level-0" value="432">Auditing&nbsp;&nbsp;(9)</option>
    <option class="level-0" value="1592">AutoUpgrade&nbsp;&nbsp;(35)</option>
    <option class="level-0" value="935">AWR&nbsp;&nbsp;(3)</option>
    <option class="level-0" value="520">Behavior Change&nbsp;&nbsp;(30)</option>
    <option class="level-0" value="4">Best Practice&nbsp;&nbsp;(33)</option>
    <option class="level-0" value="294">catctl.pl&nbsp;&nbsp;(6)</option>
    <option class="level-0" value="5">Cloud&nbsp;&nbsp;(18)</option>
    <option class="level-0" value="1184">Conference&nbsp;&nbsp;(24)</option>
    <option class="level-0" value="11">Customer Success&nbsp;&nbsp;(10)</option>
    <option class="level-0" value="643">Data Guard&nbsp;&nbsp;(3)</option>
    <option class="level-0" value="17">Data Pump&nbsp;&nbsp;(16)</option>
    <option class="level-0" value="630">DBCA&nbsp;&nbsp;(8)</option>
    <option class="level-0" value="19">DBUA&nbsp;&nbsp;(7)</option>
    <option class="level-0" value="487">Deprecated / Desupported&nbsp;&nbsp;(6)</option>
    <option class="level-0" value="575">Differences&nbsp;&nbsp;(3)</option>
    <option class="level-0" value="561">DMU – Characterset Migration&nbsp;&nbsp;(4)</option>
    <option class="level-0" value="889">Documentation&nbsp;&nbsp;(2)</option>
    <option class="level-0" value="476">E-Business Suite&nbsp;&nbsp;(4)</option>
    <option class="level-0" value="531">Enterprise Manager&nbsp;&nbsp;(5)</option>
    <option class="level-0" value="1662">Exadata / ODA&nbsp;&nbsp;(2)</option>
    <option class="level-0" value="1022">Export – Import&nbsp;&nbsp;(2)</option>
    <option class="level-0" value="1382">Fail Safe&nbsp;&nbsp;(4)</option>
    <option class="level-0" value="87">Fallback&nbsp;&nbsp;(9)</option>
    <option class="level-0" value="7">Flaws and Pitfalls&nbsp;&nbsp;(93)</option>
    <option class="level-0" value="190">General&nbsp;&nbsp;(17)</option>
    <option class="level-0" value="661">GoldenGate&nbsp;&nbsp;(4)</option>
    <option class="level-0" value="583">Hands-On Lab&nbsp;&nbsp;(11)</option>
    <option class="level-0" value="513">in-Memory&nbsp;&nbsp;(5)</option>
    <option class="level-0" value="462">Incremental Stats&nbsp;&nbsp;(3)</option>
    <option class="level-0" value="1374">Installation&nbsp;&nbsp;(7)</option>
    <option class="level-0" value="2361">Job Offering&nbsp;&nbsp;(1)</option>
    <option class="level-0" value="283">JVM&nbsp;&nbsp;(19)</option>
    <option class="level-0" value="355">Lifetime Support Policy&nbsp;&nbsp;(8)</option>
    <option class="level-0" value="1400">MAA&nbsp;&nbsp;(1)</option>
    <option class="level-0" value="627">Microsoft Windows&nbsp;&nbsp;(4)</option>
    <option class="level-0" value="1349">Minimal Downtime&nbsp;&nbsp;(2)</option>
    <option class="level-0" value="49">Music &amp; HiFi&nbsp;&nbsp;(6)</option>
    <option class="level-0" value="25">MyOracle Support&nbsp;&nbsp;(17)</option>
    <option class="level-0" value="1287">ODA – Oracle Database Appliance&nbsp;&nbsp;(1)</option>
    <option class="level-0" value="15">Off Topic&nbsp;&nbsp;(22)</option>
    <option class="level-0" value="1264">Office Hours&nbsp;&nbsp;(5)</option>
    <option class="level-0" value="18">OOW&nbsp;&nbsp;(68)</option>
    <option class="level-0" value="184">Operating System&nbsp;&nbsp;(9)</option>
    <option class="level-0" value="9">Optimizer&nbsp;&nbsp;(32)</option>
    <option class="level-0" value="602">ORAchk&nbsp;&nbsp;(4)</option>
    <option class="level-0" value="22">Oracle Database 11g&nbsp;&nbsp;(28)</option>
    <option class="level-0" value="6">Oracle Database 12.2.0.1&nbsp;&nbsp;(40)</option>
    <option class="level-0" value="3">Oracle Database 12c&nbsp;&nbsp;(66)</option>
    <option class="level-0" value="1267">Oracle Database 18c&nbsp;&nbsp;(10)</option>
    <option class="level-0" value="1537">Oracle Database 19c&nbsp;&nbsp;(19)</option>
    <option class="level-0" value="1801">Oracle Database 20c&nbsp;&nbsp;(2)</option>
    <option class="level-0" value="2107">Oracle Database 21c&nbsp;&nbsp;(8)</option>
    <option class="level-0" value="68">Parameters&nbsp;&nbsp;(41)</option>
    <option class="level-0" value="14">Patch Recommendation&nbsp;&nbsp;(150)</option>
    <option class="level-0" value="212">Performance Tuning&nbsp;&nbsp;(6)</option>
    <option class="level-0" value="1213">Pictures&nbsp;&nbsp;(1)</option>
    <option class="level-0" value="650">Real Application Testing&nbsp;&nbsp;(2)</option>
    <option class="level-0" value="1111">Release Schedule&nbsp;&nbsp;(27)</option>
    <option class="level-0" value="23">Removal&nbsp;&nbsp;(26)</option>
    <option class="level-0" value="467">Restart – SIHA – HAS&nbsp;&nbsp;(6)</option>
    <option class="level-0" value="421">RMAN&nbsp;&nbsp;(9)</option>
    <option class="level-0" value="538">SAP&nbsp;&nbsp;(2)</option>
    <option class="level-0" value="645">SE2 – Standard Edition 2&nbsp;&nbsp;(8)</option>
    <option class="level-0" value="521">Security&nbsp;&nbsp;(7)</option>
    <option class="level-0" value="13">Single-/Multitenant&nbsp;&nbsp;(87)</option>
    <option class="level-0" value="16">Slides&nbsp;&nbsp;(26)</option>
    <option class="level-0" value="656">SPM – SQL Plan Management&nbsp;&nbsp;(3)</option>
    <option class="level-0" value="761">Statistics&nbsp;&nbsp;(4)</option>
    <option class="level-0" value="746">TDE – Transparent Database Encryption&nbsp;&nbsp;(4)</option>
    <option class="level-0" value="205">Time Zone – DST&nbsp;&nbsp;(10)</option>
    <option class="level-0" value="167">Transportable&nbsp;&nbsp;(18)</option>
    <option class="level-0" value="21">Travel&nbsp;&nbsp;(50)</option>
    <option class="level-0" value="1">Uncategorized&nbsp;&nbsp;(9)</option>
    <option class="level-0" value="118">Upgrade / Migration&nbsp;&nbsp;(48)</option>
    <option class="level-0" value="320">Video / Viewlet&nbsp;&nbsp;(9)</option>
    <option class="level-0" value="61">Virtualization&nbsp;&nbsp;(5)</option>
    <option class="level-0" value="12">Workshop&nbsp;&nbsp;(179)</option>
    <option class="level-0" value="2278">XE – Express Edition&nbsp;&nbsp;(2)</option>
  </select>
</form>

POST #

<form action="#" method="post" accept-charset="utf-8" id="subscribe-blog-blog_subscription-5">
  <div class="jetpack-subscribe-count">
    <p> Join 5,979 other subscribers </p>
  </div>
  <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/2017/10/23/can-you-select-a-pdbs-character-set/?msclkid=a869cf39cf6d11ecbef8dfe805e966f5">
    <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>

POST

<form method="post">
  <input type="submit" value="Close and accept" class="accept">
</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 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

 * 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
 * Events
 * Videos
 * Scripts
 * Links
 * Oracle Documentation
 * PrivacyToggle Child Menu
   * Cookie Policy (EU)
   * GDPR – Request personal data
 * About


CAN YOU SELECT A PDB’S CHARACTER SET?

Posted on October 23, 2017 by Mike.Dietrich DMU - Characterset Migration
Single-/Multitenant 2


Since Oracle Database 12.2.0.1 a Multitenant container database can host PDBs
with different character sets. This was a huge restriction in Oracle Database
12.1., at least outside the US and Canada. Here in Germany alone you may find
plenty of different database character sets, for instance WE8ISO8859P1,
WE8ISO8859P9, WE8ISO8859P15, WE8MSWIN1252, maybe still some old WE8DEC – and of
course the unicode ones UTF8 and AL32UTF8. But the question is: Can you select a
PDB’s character set when you provision a new PDB?

MIXING PDB CHARACTER SETS IN ORACLE DATABASE 12.2.

One of the limiting restrictions in Oracle 12.1 Multitenant got lifted with
Oracle 12.2: You can have PDBs with different character sets in one container
database deployment. The requirement: You must create the container database
with  character set AL32UTF8. This means the database character set in CDB$ROOT
and therefore as well in PDB$SEED will be AL32UTF8. Once this is the case you
can plugin PDBs with all sorts of character sets.

But when you provision a new PDB it will be provisioned as a clone of PDB$SEED –
and of course will have the character set AL32UTF8 as well. There may be very
rare situations where you want a fresh PDB with a different character set.

CHANGING THE PDB’S CHARACTER SET

The tool to change a PDB’s character set is the Data Migration Assistant for
Unicode (DMU). DMU is installed in all Oracle releases since Oracle 11.2.0.4 by
default. Just check the $ORACLE_HOME/dmu subdirectory and start the DMU with sh
dmu.sh. And find more information about the DMU here: DMU – Tips and Tricks.

But as the name indicates, the DMU is meant to change a database’s (or PDB’s)
character set to Unicode. There is a option to use DMU to change to another
character set with csrepair.plb. But this does not help here as one of the
requirements to use csrepair.plb says: “Only repairing from single-byte to
single-byte character sets or multi-byte to multi-byte character sets is allowed
as no conversion of CLOB data will be attempted.”

Furthermore the old (and now unsupported) ALTER DATABASE CHARACTER SET
INTERNAL_USE <new NLS_CHARACTERSET> seems to work fine at first sight, but
actually doesn’t change any CLOB data. And you’ll have plenty of CLOB data in
the PDB’s dictionary. Don’t use it. Your PDB won’t be in healthy state
afterwards anymore.

Basically this means you can’t change a PDB’s character set from a non-unicode
character set to a unicode character set which is the requirement for mixing
different character sets within a single Multitenant deployment.

POTENTIAL WORKAROUND?

Actually the only potential workaround I can think of is:

 * Create a non-CDB database with the desired character set you need and the
   options you’d like to have. See also: Use your own templates in DBCA to
   create databases.
 * Plug in this non-CDB into your CDB with a obvious name, such as
   PDB_MASTER_WE8ISO8859P15 (PDBs can have a maximum name length of 30 bytes).
   See also: Upgrade to Oracle Database 12.2 and Converting it into an 12.2 PDB
   (plugin).
 * Provision from this PDB in the future once you need a new PDB with this
   character set.

SUMMARY

You can’t select a PDB’s character set during creation. It will always
provisioned as a clone of PDB$SEED and therefore have a multi-byte character set
(AL32UTF8) when you have a CDB environment being able to host different
character sets in PDBs.

And as you can’t change a PDB’s character set from single-byte to multi-byte
afterwards either your only workaround is to provide your own “seed” PDBs with
the character set of your choice and provision new PDBs as a clone of it.

Thanks (as always) to Sergiusz Wolicki for helping me with my questions!

–Mike

Share this:
 *  
 *  
 * 
 * 


RELATED

CLONING A PDB FROM ORACLE 12.1 TO ORACLE 12.2

Is cloning a PDB from Oracle 12.1 to Oracle 12.2 possible? A colleague raised
this question recently. And a customer did ask me the same question a few days
before at a user group conference. There are several ways to move a PDB from
Oracle 12.1. to 12.2. But the…

November 29, 2017

UPGRADE PDBS – ONE AT A TIME VIA UNPLUG/PLUG/UPGRADE

Basically there are two techniques to upgrade an Oracle Multitenant
environment:Everything at Once and One (or many) at a Time. This blog post
describes the case how to Upgrade PDBs - One at a Time via unplug/plug/upgrade.
I will describe all necessary steps. During some presentations, discussions etc
people were…

August 5, 2014

DATABASE MIGRATION FROM NON-CDB TO PDB – CLONE VIA NON$CDB, UPGRADE, CONVERT

The third option for plugging in a non-CDB is called Database Migration from
non-CDB to PDB – Clone via NON$CDB, upgrade, convert. As I showed already in
this blog post a while ago, your source must be at least an Oracle 12.1
database. And this technique can be used also…

July 25, 2019


Tags: AL32UTF8Change Character SetCharactersetDMUMultitenantPDBSingle
TenantUnicode


 * Next Differences between PSU / BP and RU / RUR
 * Previous Are OJVM patches included in the Oracle 12.2 RU / RUR?

YOU MAY ALSO LIKE...

 * TRANSPORTABLE TABLESPACES – EXAMPLE AND STRANGE ERROR WITH A PDB

   

 * UNPLUG A 12.2.0.1 PDB AND PLUGIN INTO 18C IN THE CLOUD

   

 * UPGRADE TESTING – ONLINE CLONE A PDB TO 19C

   


2 RESPONSES

 * Comments2
 * Pingbacks0

 1. Eric He says:
    October 23, 2017 at 13:47
    
    Mike:
    Thanks a lot. I just want to ask one question, if CDB$ROOT is AL32UTF8, can
    you plugged in a PDB with single character character set like US7ASCII?
    
    Thanks.
    
    Reply
    * Mike.Dietrich says:
      October 23, 2017 at 14:48
      
      Hi Eric,
      
      had to try it out 😉
      
      SQL> select * from pdb_plug_in_violations where cause=’PDB not Unicode’;
      
      TIME NAME CAUSE TYPE ERROR_NUMBER LINE MESSAGE STATUS ACTION CON_ID
      ————————————————————————— ——————– —————————————————————- ——— ———— ———-
      —————————————- ——— —————————————- ———-
      23-OCT-17 03.42.37.168422 PM US7 PDB not Unicode WARNING 0 1 Character set
      mismatch: PDB character se PENDING Oracle recommends using Unicode
      (AL32UTF 3
      t US7ASCII. CDB character set AL32UTF8. 8) character set for the database.
      Consi
      der migrating the database to Unicode.
      
      Yes, works – but you’ll receive a “WARNING” in PDB_PLUG_IN_VIOLATIONS.
      Warnings don’t prevent PDBs to be opened unrestricted.
      
      Cheers
      Mike
      
      Reply
      
    


LEAVE A REPLY CANCEL REPLY

Your email address will not be published. Required fields are marked *

Comment *

Name *

Email *

Website

Notify me of follow-up comments by email.

Notify me of new posts by email.





Δ

This site uses Akismet to reduce spam. Learn how your comment data is processed.


ARCHIVES

Archives Select Month May 2022  (3) 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  (9)
AutoUpgrade  (35) AWR  (3) Behavior Change  (30) Best Practice  (33)
catctl.pl  (6) Cloud  (18) Conference  (24) Customer Success  (10) Data
Guard  (3) Data Pump  (16) DBCA  (8) DBUA  (7) Deprecated / Desupported  (6)
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  (93) General  (17) GoldenGate  (4)
Hands-On Lab  (11) in-Memory  (5) Incremental Stats  (3) Installation  (7) Job
Offering  (1) JVM  (19) Lifetime Support Policy  (8) MAA  (1) Microsoft
Windows  (4) Minimal Downtime  (2) Music & HiFi  (6) MyOracle Support  (17) ODA
– Oracle Database Appliance  (1) Off Topic  (22) Office Hours  (5) OOW  (68)
Operating System  (9) Optimizer  (32) ORAchk  (4) Oracle Database 11g  (28)
Oracle Database 12.2.0.1  (40) Oracle Database 12c  (66) Oracle Database
18c  (10) Oracle Database 19c  (19) Oracle Database 20c  (2) Oracle Database
21c  (8) Parameters  (41) Patch Recommendation  (150) Performance Tuning  (6)
Pictures  (1) Real Application Testing  (2) Release Schedule  (27) Removal  (26)
Restart – SIHA – HAS  (6) RMAN  (9) SAP  (2) SE2 – Standard Edition 2  (8)
Security  (7) Single-/Multitenant  (87) Slides  (26) SPM – SQL Plan
Management  (3) Statistics  (4) TDE – Transparent Database Encryption  (4) Time
Zone – DST  (10) Transportable  (18) Travel  (50) Uncategorized  (9) Upgrade /
Migration  (48) Video / Viewlet  (9) Virtualization  (5) Workshop  (179) XE –
Express Edition  (2)


UPCOMING EVENTS

There are no upcoming events at this time.


UPGRADE @YOUTUBE




RSS FEED FOR UPGRADE YOUR DATABASE – NOW!

 * Binary patching is slow because of the inventory
 * How to speed up your database and GI patching
 * Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022
 * Oracle Database 12.2.0.1 – End of Support and Patch Bundles
 * Patching all my environments with the April 2022 Patch Bundles


SUBSCRIBE VIA EMAIL

Join 5,979 other subscribers

Email Address - @oracle.com doesn't work

Subscribe


FOLLOW ME ON TWITTER


RECENT POSTS

 * Binary patching is slow because of the inventory
 * How to speed up your database and GI patching
 * Virtual Classroom Seminar #14: AutoUpgrade 2.0 on May 5, 2022
 * Oracle Database 12.2.0.1 – End of Support and Patch Bundles
 * Patching all my environments with the April 2022 Patch Bundles

Upgrade your Database – NOW! © 2022. All Rights Reserved.

 * 
 * 
 * 
 * 

Manage consent
 

Loading Comments...

 

Write a Comment...
Email (Required) Name (Required) Website


Privacy & Cookies: This site uses cookies. By continuing to use this website,
you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy