Introduction What comes into your mind first when you hear the term “licensing”? Boring? Complex? Well, I can’t promise you to make it fun, but what I definitely promise you is to make it easy to understand, at least in Oracle Cloud. In this blog post, we will explain what database options can be used…
Introduction Oracle Multitenant has been around since Oracle Database version 12c was released in 2013. With that, the previous architecture, since then called non-CDB was deprecated. Starting with version 21c, non-CDB architecture is not supported and available anymore. In the Oracle Cloud, all databases created via Cloud Tooling use the Multitenant Architecture. On VM DB…
Introduction Connecting to an Oracle Database is very straightforward. However, when you encounter an issue you might struggle with the root cause and how to solve it. For better troubleshooting, it is vital to understand the steps and checks being executed from the moment you hit the ENTER button. In this blog post, we will…
Introduction A serial console connection to bare metal or virtual machine DB system allows you to manage and troubleshoot your system in single-user mode using an SSH connection, e.g. if the boot volume becomes full causing a standard SSH connection to fail with permission denied errors. In this blog post, we will demonstrate step-by-step guidance to…
Introduction Oracle Cloud provides automated resource provisioning and management by the click of the button, literally. You just login into the OCI Console, which is a web-based interface, and click on the button to provision and manage your resources. However, managing large environments that way might become challenging. Additionally, you might want to execute some…
Introduction SYSDATE is a SQL function that returns the current date and time set for the operating system of the database server. CURRENT_DATE returns the current date in the session time zone. The same story applies to SYSTIMESTAMP and CURRENT_TIMESTAMP. When database and application servers are set to the same time zone, both functions will return the…
Introduction To directly export and import data to and from Object Storage, you need the DBMS_CLOUD PL/SQL package, which was initially introduced in Oracle Autonomous Database. DBMS_CLOUD was made available for non-Autonomous Oracle Databases with version 21c and later backported to 19.9. However, direct import and export from and to Object Storage using the Data…
Introduction Database Management is a cloud service that provides broad capabilities for managing and monitoring your Oracle Databases on-premises and in the cloud. The new release of Database Management service now supports Oracle Databases on Virtual Machine, Bare Metal, and Exadata Cloud Service in OCI without installing the Management Agent. For databases running on OCI…
Introduction From the very first version, Oracle Zero Downtime Migration (ZDM) supports physical online, and offline migrations using RMAN and Data Guard. However, every migration job was creating a new RMAN backup from the source database to be used to create the target database. Starting with ZDM version 21.2, you can skip the full backup…
Introduction Zero Downtime Migration (ZDM) provides great automation capabilities to migrate your Oracle Database to Oracle Cloud. After supporting Linux-based platforms, the new version 21.2 also supports cross-platform and even cross-cloud migrations. This blog post provides step-by-step instructions on how to migrate your AWS RDS for Oracle to Oracle Autonomous Database on Oracle Cloud using…
Database Heartbeat 