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

Read Time:2 Minute, 35 Second

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

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

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

Scroll down yet a little further.

Define the password for the ADMIN user.

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:

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

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:

Check out the development section:

The Tools tab gives access to several browser based tools:

Let’s try SQL Developer Web

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

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.

Resources

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

About Post Author

Lucas Jellema

Lucas Jellema, active in IT (and with Oracle) since 1994. Oracle ACE Director and Oracle Developer Champion. Solution architect and developer on diverse areas including SQL, JavaScript, Kubernetes & Docker, Machine Learning, Java, SOA and microservices, events in various shapes and forms and many other things. Author of the Oracle Press book Oracle SOA Suite 12c Handbook. Frequent presenter on user groups and community events and conferences such as JavaOne, Oracle Code, CodeOne, NLJUG JFall and Oracle OpenWorld.

lucas.jellema@amis.nl

https://www.amis.nl/