First code and cli free steps with Oracle Database 21c in Oracle Cloud

Lucas Jellema

Oracle Database 21c has been released – for now only in the cloud. Starting to explore – that is what we call playing with it – it easy and free of any charge in the OCI Always Free Tier that includes two Oracle Database instances that now can be 21c instances.

In this article I will show the steps you should go through in order to get access to your own 21c database instance. It takes less than one minute of your time – and a few minutes waiting for provisioning of the instance. You need to install nothing. However, you do need to have an Oracle Cloud account – a free trial or a paid account. In both cases, the 21c database will not cost you any money.

Overview of the steps:

  • Open the OCI Console
  • Use the shortcut for creating an ATP database (Autonomous Transaction Processing)
  • Define the name for the database, choose release 21c, set the ADMIN password and submit the request for creating the instance
  • <wait for a few minutes>
  • access the instance – through the web based tools (such SQL Developer Web or APEX) or through client tools and libraries (in Cloud Shell or on your laptop) – and start exploring the new 21c features

Now with some picture to make it more tangible.

Creating an always free Oracle Database 21c instance

Open the OCI Console. Click on the shortcut for creating an ATP Database

image

Select the compartment into which the instance should be created. Set the name and display name for the instance.

image

Scroll down. Set the switch to Always Free – to be sure you do not accidentally create an instance that eats away your credits. Then select 21c as the Database version

image

Scroll down yet a little further.

Define the password for the ADMIN user.

image

Then press the button Create Autonomous Database. You can now sit back and relax – for 3-5 minutes – while your shiny new database is provisioned:

image

After a few minutes, the orange turns to green and the 21c instance is ready for action:

image

Accessing the new Database

You see several tabs and buttons at the top of the page. You can get hold of the wallet file with all necessary details for client tools – such as SQL*Developer or SQLcl – to access the database.

There is the Service Console that you can visit to learn about your instance and perform operational actions:

image

Check out the development section:

image

The Tools tab gives access to several browser based tools:

image

Let’s try SQL Developer Web

Login as ADMIN, using the freshly defined password:

image

The following browser based IDE – with a look that is very similar to the desktop tool – is presented:

image

You can start doing “your thing” with whatever 21c has to offer.

I started to try out dbms_mle to see how I can integrate JavaScript in PL/SQL code. I was not yet successful at that, unfortunately. Now I wonder whether that feature is available in this ATP always free instance. More likely, I am doing something wrong. Based on these instructions on DBMS_MLE.

image

Resources

Oracle Database 21c documentation: https://docs.oracle.com/en/database/oracle/oracle-database/21/


Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Next Post

What if companies say: “help me move away from Oracle”?

Facebook0TwitterLinkedin I hear this aspiration from a growing number of organizations. Sometimes as a quite literal question. This however is merely half of a wish. Apparently, organizations want to quite with one thing — but have not yet stipulated what they desire instead. What is the objective that is pursued […]