Introduction Oracle Exadata Database Machine is an optimized system specifically developed to run Oracle Databases providing high availability, high capacity, cost efficiency, and superior performance. It uses unique and intelligent Exadata software and ultra-fast internal network fabric supporting every kind of application workload. So it is little surprise that Oracle uses Exadata as their ONLY…
Introduction Databases and even application servers in the Cloud are usually provisioned in a private subnet that is not accessible from the internet. End users will access applications via a load balancer. To log in to the private machines for management purposes, customers will have to set up their private connection to Oracle Cloud via…
Introduction Lately, I got a question from a customer about why patching in the cloud takes too long. First of all, we need to clarify things first and understand the exact situation: what Database Service is being used? What is the database version? Multitenant? How many PDBs are present in the CDB? How many CPUs…
Introduction Gradual Database Password Rollover for Applications is a new feature that was introduced in Oracle Database 21c. Now, it is backported and also available in 19c with RU 19.12. It enables to update an application user’s password while keeping the old password valid for a specific period of time. During this period, the application…
Introduction Oracle Databases in Oracle Cloud use Transparent Data Encryption (TDE) by default to protect data at rest. The default configuration “Oracle-Managed Keys” stores the master encryption keys in a wallet file locally on the database servers. Now, Oracle also supports the integration with the OCI Vault Service, where you are able to create and…
Introduction We discussed why Oracle Cloud is the best place to run your Oracle databases in a previous blog post. However, it is also understandable that not all databases can be moved to the cloud (yet) and it might be not affordable for everyone to run all of these databases on Cloud@Customer. Keeping your Oracle…
Introduction Oracle Cloud databases provide fully automated backups that can be enabled by the click of a button. However, the backups are stored in an Oracle-managed bucket. Hence, the automatic backups can only be used to restore on the same database host or create a new database in the same availability domain. If you want…
Introduction As IT environments are growing and becoming more complex, the need for standardization, cost reduction, and greater agility is raising more than ever. Cloud solutions provide customers with features and capabilities to exactly achieve these goals and satisfy their business demands. When it comes to moving Oracle databases to the cloud, you might ask…
Introduction Cloning PDBs in Multitenant environments is an easy way to migrate a PDB from one CDB to another or to create multiple copies of that PDB for test and development purposes. The data files are being read from the source and transferred to the target CDB. Hence, cloning a PDB also means generating workload…
Introduction ZDM uses RMAN to perform an offline physical migration. It backs up the source database and instantiates a new database from this backup to the target environment. This is similar to cloning a database. The target database has no relationship to the source, so there is no data synchronization or fallback capability. No SQL*Net…
Database Heartbeat 