Introduction As more and more customers are moving their databases to Oracle Cloud, they have a mix of on-premises, Oracle Database Cloud Service, and Oracle Autonomous databases in their environments. DBAs and developers usually use SQL scripts to automate several tasks in the database. In some cases, they want to execute some tasks only on…
Introduction As you probably already know, Oracle APEX enables you to build applications with minimal coding. APEX is already available in all Oracle Autonomous Database workload types: transaction processing, data warehouse, and JSON. You get a fully-managed database where you can even more focus on your application development. Additionally, Oracle provides an Autonomous Database specifically…
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…
Database Heartbeat 