Introduction Oracle Autonomous Database is a fully managed service. Simply specify the CPU count and the amount of storage needed and you are ready to go. Scaling up and down CPU and storage is an online operation without any service interruption. Additionally, you can enable CPU Auto Scaling. Traditional storage management operations like creating and…
Introduction Using Data Pump export and import is quite straightforward. Letting ZDM do it all for you (export, copy, import, and clean up) makes it possible to test your migration multiple times for no additional effort, and then when you are ready for the real migration, you are sure that exactly the same steps are…
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…
Database Heartbeat 