Introduction This is a step by step instruction of the minimum steps needed to import your Data Pump dump files into Oracle Autonomous Database. Without installing anything! Before you export your data, have a look at best practices and what to consider when you migrate to Autonomous Database. Step 0: Upload you Dump Files into…
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…
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…
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…
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,…
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…
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…
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…
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…
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…
