Always free autonomous database with OCI CLI

OGB Appreciation Day: Always free autonomous database with OCI CLI

To be part of the OGB Appreciation Day I have written a Blog Post to show you how easy it is to create an always free Autonomous Database with the OCI CLI.
Probably not everyone noticed it but the oci-cli does support always free databases in the Oracle Cloud.
According to my google search the version 2.6.7 of the oci-cli is required to create and manage always free databases via cli.
As soon as you have configured the oci-cli client (https://docs.cloud.oracle.com/iaas/Content/API/SDKDocs/cliconfigure.htm) you are able to play.
With the newest version of the oci-cli client you have the following option to create a always free ADW or ATP:
--is-free-tier
This leads into following command for the DB creation:
oci db autonomous-database create --compartment-id <YOUR_COMPARTMENT_ID> --is-free-tier TRUE --db-name test --admin-password <STRONG_PASSWORD>  --cpu-core-count 1 --data-storage-size-in-tbs 1
Please be aware that the parameters –cpu-core-count and –data-storage-size-in-tbs are required parameters and if you list your autonomous databases after the creation you will notice that the output will show 1TB storage and 1 CPU core count.
[julian@localhost .oci]$ oci db autonomous-database list --compartment-id ocid1.tenancy.oc1..qq7uvn6gmea 
{
  "data": [
    {
      "autonomous-container-database-id": null, 
      "compartment-id": "ocid1.tenancy.oc1..pqq7uvn6gmea", 
      "connection-strings": {
        "all-connection-strings": {
          "HIGH": "adb.eu-...", 
          "LOW": "adb.eu-...", 
          "MEDIUM": "adb.eu-", 
          "TP": "adb.eu-", 
          "TPURGENT": "adb.eu-"
        }, 
        "dedicated": null, 
        "high": "adb.eu-", 
        "low": "adb.eu-, 
        "medium": "adb.eu-"
      }, 
      "connection-urls": null, 
      "cpu-core-count": 1, 
      "data-storage-size-in-tbs": 1, 
      "db-name": "test", 
      "db-version": "18c", 
      "db-workload": "OLTP", 
      "defined-tags": {}, 
      "display-name": "autonomousdatabase20191010070625", 
      "freeform-tags": {}, 
      "id": "ocid1.autonomousdatabase.oc1.eu-frankfurt-1.", 
      "is-auto-scaling-enabled": false, 
      "is-dedicated": false, 
      "is-free-tier": true, 
      "is-preview": false, 
      "license-model": "LICENSE_INCLUDED", 
      "lifecycle-details": null, 
      "lifecycle-state": "AVAILABLE", 
      "service-console-url": "https://adb.eu-...service_type=ATP", 
      "system-tags": {
        "orcl-cloud": {
          "free-tier-retained": "true"
        }
      }, 
      "time-created": "2019-10-10T07:06:25.341000+00:00", 
      "time-deletion-of-free-autonomous-database": null, 
      "time-reclamation-of-free-autonomous-database": "2019-10-17T07:12:40.135000+00:00", 
      "used-data-storage-size-in-tbs": 1, 
      "whitelisted-ips": null
    },
But if you take a look at the service console (the url is in the list output) you will notice that there is only 20GB space available. Therefore don’t worry about the output of the list command. The important parameter of the list command is:
      "is-free-tier": true,

Comments

Post a Comment

Popular posts from this blog

Flutter for Single-Page Scrollable Websites with Navigator 2.0

Image
  Single page scrollable websites are everywhere. In this website design pattern, all the content is presented in one long-scrolling layout that contains multiple sections. Visitors can scroll or jump to a section by clicking buttons of a sticky menu. This pattern is a good fit for small content such as brochure websites, software library documentation, portfolios, and landing pages that are used to convert users [ 1 ]. Designers also love this pattern because it is simple, clean, and enables cool scroll animations. Jetbrains Mono single-page scrollable website Hive docs multi-page scrollable website In this series of articles, we will explore how to build a  single-page scrollable website  using Flutter. We will benefit from the Navigator 2.0 API to provide a good navigation experience to the users. You can find the source code of this series’ sample apps on my  Github page . The implementation details of the sample apps will be explained in the following articles: ...
Read more

A Data Science Portfolio is More Valuable than a Resume

Image
A Data Science Portfolio is More Valuable than a Resume Benjamin Obi Tayo Ph.D. Following Nov 20  · 5 min read D ata Science is a practical field. Hands-on skills are very important especially when you are interested in working outside academia as a practicing data scientist. In academia, you need more theoretical and research skills. While in-depth knowledge in the theoretical foundations of data science is important, as a practicing data scientist, hands-on experience is very crucial and one way to showcase you hands-on skills is via building a very great portfolio. Companies interested in hiring you would definitely be asking you for a portfolio, as it gives evidence of your strengths in fundamental data science concepts. While a data science resume is important, a data science portfolio is more valuable than a resume. This article will discuss 3 important platforms that can be used for portfolio buildi...
Read more

Better File Storage in Oracle Cloud

Image
Use Oracle Application Express with Oracle Cloud Infrastructure REST APIs to upload, download, and manage big files in Oracle Cloud. By Adrian Png November 27, 2019 Oracle Cloud Infrastructure  provides a comprehensive suite of REST APIs for accessing and managing cloud resources. For example, administrators can use REST APIs to create and manage autonomous databases and initiate backups. Oracle Application Express (Oracle APEX)  makes working with REST easy. The  APEX_WEB_SERVICE  package, available since Oracle APEX 4.0, provides developers with a function for consuming REST APIs. Oracle APEX 5.0 introduced the  APEX_JSON  package, allowing easy parsing of JSON responses. Oracle APEX 18.1 introduced the Web Source Module (WSM), which enables developers to access REST services and use the data in APEX components such as reports, interactive reports, and interactive grids. These features, when used together with Oracle Cloud Infrastructure REST ...
Read more