
A Simple Approach – Creating PDBs in a Data Guard environment with TDE enabled
Introduction In the Oracle Cloud every newly created database from 12c onward uses the Oracle Multitenant Architecture. Transparent Data Encryption is also enabled by default. So, as soon as you use Data Guard and create new PDBs, you have to take care of copying the wallets to the standby server. We already discussed two approaches…

Using STANDBYS=NONE to create PDBs in a Data Guard environment with TDE enabled
Introduction Creating and cloning PDBs in a multitenant environment is a simple and straight forward task, also when TDE is enabled. However, in a Data Guard environment where primary and standby use their own TDE wallets, it becomes challenging. In a previous blog we discussed how creating the master encryption key on the primary PDB…

Hello Upgrade! Do you run faster in the Cloud?
Introduction A customer is having long upgrade times on-premises. As they are moving to the Cloud, I got the question whether their upgrade in the Cloud would be faster. First of all, when it comes to patching, upgrade, and migration, I can only encourage you to read the blogs by Mike Dietrich and Daniel Overby…

Database Outage? Who cares???
Introduction Have you ever experienced this before? You click on “Book Now” for a trip or a hotel reservation, but get “an unknown error has occurred”, or even no feedback at all? You are ultimately torn between packing your bags and repeating the booking process.To avoid such situations, Application Continuity is there. By the way,…

Minimal Downtime Migration and Upgrade using Refreshable PDB Clones
Introduction Oracle Multitenant architecture makes it possible to effortlessly move PDBs from one CDB to another, even though the source and target CDBs were of different release versions, e.g. 18c and 19c, and even of different editions like moving from SE to EE. In the previous blog we discussed how patching can be done with…

Minimal Downtime Patching using Refreshable PDB Clones
Introduction Oracle Multitenant allows you to clone PDBs from one CDB to another easily, even though the source and target CDBs were of different patch levels, e.g. 19.9 and 19.10, and even different editions like moving from SE to EE. The only thing you’ll need is to run datapatch afterwards. Unplug and Plug the PDB…

Oracle Connection Manager (CMAN) – Install, Configure, and Connect to DBCS and Autonomous Databases
Introduction Oracle Connection Manager (CMAN) is a software that acts as a proxy server to forward connection requests from clients to databases.It operates on the session level and is usually installed on a separate server. CMAN is available for installations with Oracle Database Enterprise Edition 12c and higher. Use Cases CMAN could be useful in many use…

Using OCI CLI and Custom Database Software Images to Create, Patch, and Upgrade your Exadata Cloud Databases
Introduction After covering how to use the OCI CLI and Custom Database Software Images to patch and upgrade databases on VM DB Systems in the previous blogs, we are now going to see how to do this on Exadata systems. Exadata systems allow to provision multiple database homes of different software versions and having multiple…

Using Custom Database Software Images to Create, Patch, and Upgrade your Cloud Databases
Introduction When it comes to create, patch, or upgrade your Oracle database in the cloud, Oracle provides Database Software Images that include a specific Release Update (RU), e.g. 18.11, 19.7 or 19.9. However, if you need some additional one-off (interim) patches on top of that RU, you would have to apply them manually afterwards. This…

Automate Patching and Upgrade your Cloud Databases using OCI CLI
Introduction Patching and Upgrade your Oracle Databases in the Oracle Cloud is as easy as pushing the button in the web-based Cloud Console. However, if you want to schedule the task, and especially if you are planning to patch and upgrade tens or maybe hundreds of databases, then the OCI CLI is the tool of…
Loading…
Something went wrong. Please refresh the page and/or try again.
Follow My Blog
Get new content delivered directly to your inbox.