Multitenant Pills: Partial PDB cloning (and cleanup)
When consolidating to multitenant, there are several consolidation patterns. Big, complex databases usually have special requirements for which it might be a good choice to go to single-tenant (a single PDB in one CDB) Small, relatively easy databases are the best candidate for consolidation to…
Multitenant Pills – Change DBID for an existing PDB
When you plug the same PDB many times you have to specify “AS COPY” in the syntax: CREATE PLUGGABLE DATABASE ludo AS CLONE USING ‚/u01/app/oradata/ludo/ludo.xml‘; Otherwise, you will get an error similar to: ERROR at line 1: ORA-65122: Pluggable database GUID conflicts with the GUID…
Parallel Oracle Catalog/Catproc creation with catpcat.sql
With Oracle 19c, Oracle has released a new script, annotated for parallel execution, to create the CATALOG and CATPROC in parallel at instance creation. I have a customer who is in the process of migrating massively to Multitenant using many CDBs, so I decided to…
Oracle Home Management – part 7: Putting all together
Last part of the blog series… let’s see how to put everything together and have a single script that creates and provisions Oracle Home golden images: Review of the points The scripts will: let create a golden image based on the current Oracle Home save…
Oracle Home Management – part 6: Simple Golden Image Blueprint
As I explained in the previous blog posts, from a manageability perspective, you should not change the patch level of a deployed Oracle Home, but rather install and patch a new Oracle Home. With the same principle, Oracle Homes deployed on different hosts should have…
Oracle Home Management – part 5: Oracle Home Inventory and Naming Conventions
Having the capability of managing multiple Oracle Homes is fundamental for the following reasons: Out-of-place patching: cloning and patching a new Oracle Home usually takes less downtime than stopping the DBs and patching in-place Better control of downtime windows: if the databases are consolidated on…
Oracle Home Management – part 4: Challenges and Opportunities of the New Release Model
Starting with the upcoming next release (18c), the Oracle Database will be a yearly release. (18c, 19c, etc). New yearly releases will contain only new features ready to go, and eventually some new features for performance improvements (plus bug fixes and security fixes from the…
Oracle Home Management – part 3: Strengths and limitations of Rapid Home Provisioning
In the previous post I mentioned that having a central repository storing the Golden Images would be the best solution for the Oracle Home provisioning. In this context, Oracle provides Rapid Home Provisioning: a product included in Oracle Grid Infrastructure that automates home provisioning and…
Oracle Home Management – part 2: Common patching patterns
(*) Multiple times in this blog post I refer to a problem with new Oracle Home installs and rollback scripts. The problem has been fixed with PSU Jan 2017, I did not notice it before, sorry. Thanks to Martin Berger for the information Let’s see some…
Oracle Home Management – part 1: “Patch soon, patch often” vs. reality
With this post, I am starting a new blog series about Oracle Database home management, provisioning, patching… Best (and worst) practices, common practices and blueprints from my point of view as consultant and, sometimes, as operational DBA. I hope to find the time to continue…
Social Media @trivadis