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…
Introduction Oracle offers the Cloud Console, which is an easy to use web-based interface to create and manage all Oracle cloud resources. However, in many use cases it is more efficient to do your tasks programmatically using command line tools instead of clicking on every button in the web browser manually: Provision and terminate the…
Introduction Oracle Cloud is not the future! It is the future and already the presence. Actually is it already there for many years now. Everyday more and more workloads are moving to the Oracle Cloud. No surprise when we look at all the benefits of automation, high availability, and security. I already talked about the…
Introduction Oracle GoldenGate is a software product that allows you to replicate, filter, and transform data from one database to another in real-time. It can be used to migrate databases with (near) zero downtime. As logical replication, source and target databases could be of different versions, platforms, and character sets. Even many non-Oracle databases are supported.…
Introduction See what happens and how to proceed after creating or cloning a PDB in a Data Guard environment while Transparent Data Encryption (TDE) is enabled. If you are new to TDE, have a look at this blog first. The Environment I’m using Oracle Database Cloud service Enterprise Edition Extreme Performance. The database version is 19.8. TDE…
Introduction In this blog post we are going to have a step by step instruction to Enable Transparent Data Encryption (TDE). Create an encrypted tablespace. Create an auto-login wallet/keystore. Create a Secure External Password Store (SEPS). Clone PDBs from local and remote CDBs and create their master encryption keys. I’ll try to keep it as…
You’ll get this message if Your source database uses a single-byte character set (e.g. WE8ISO8859P1), and Your column width is defined using BYTE length semantic, and You have some column values that do not fit when using a multi-byte character set (e.g. UTF8) as Autonomous Database does If you are not familiar with these terms,…
In the case of hybrid disaster recovery and having an unencrypted database on-premises, you can create the corresponding unencrypted standby database in the cloud using RMAN DUPLICATE or RESTORE from Object Storage. When you create a new unencrypted tablespace on the on-premises primary database, the standby database in the cloud creates the corresponding unencrypted tablespace via redo. So everything is fine and you…
No, not necessarily. All Oracle databases from version 12.1 in the Oracle Cloud are automatically deployed using the Multitenant architecture. This is probably the reason why this question is asked. Let’s have a deeper look. Database Cloud Service (DBCS) License Included For EE-HP and EE-EP, you can create up to 4096 PDBs. For SE and…
One of the most beneficial cloud features is scalability on-demand, paying only for what you use, and releasing the resources when not needed anymore. So the question is, could I configure the standby database to use fewer CPUs than the primary to save costs? Yes, BUT… you have to consider a few things! Oracle Cloud provides…
