Oracle Database Licensing in Oracle Cloud Made Easy

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…

Convert your 19c non-CDB to PDB in Oracle Cloud

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…

The Journey of an Oracle Database Connection

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…

How to create a Serial Console Connection to your VM DB System

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…

Three Ways to Authenticate OCI CLI in Oracle Cloud

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…

SYSDATE vs. CURRENT_DATE in Oracle Database

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…

Import your Data directly from Object Storage in Oracle Database 21.3 and 19.12

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…

How to Enable Database Management for Oracle Cloud Databases

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…