Note:

Deploy Oracle Autonomous Database on Oracle Roving Edge Infrastructure

Introduction

Oracle Roving Edge Infrastructure enables customers to distribute their cloud workloads beyond their Oracle Cloud Infrastructure (OCI) tenancy to deliver cloud services and run application workloads at retail, satellite, and other edge locations. As a result, customers can process data faster and closer to their users and at the points of data ingestion to generate timely insights from their data.

Oracle Autonomous Database provides an easy-to-use, fully autonomous database that scales elastically and delivers fast query performance. As a service, Oracle Autonomous Database does not require database administration. With Oracle Autonomous Database you do not need to configure or manage any hardware or install any software. Oracle Autonomous Database handles provisioning the database, backing up the database, patching and upgrading the database, and growing or shrinking the database. Oracle Autonomous Database is a completely elastic service.

Oracle Autonomous Database also includes the following:

Audience

Oracle Roving Edge Infrastructure administrators, developers, and users.

Objectives

Prerequisites

Install Oracle Autonomous Database Free Container Image on Oracle Roving Edge Infrastructure

Task 1: Update the Oracle Linux instance

  1. Verify that the Oracle Linux instance is up to date. Access the instance using ssh and run the following command to update instances.

    sudo dnf -y update
    
  2. Reboot the instance.

    sudo reboot
    
  3. Reconnect using ssh.

    ssh oracle@<ip_address_of_ol_node>
    

Task 2: Install the container-tools Module

  1. Run the following command to install the container-tools module on the Oracle Linux instance.

    sudo dnf module install -y container-tools:ol8
    

Task 3: Install the Oracle Database Free Server using Podman

  1. Create a data volume. The data volume allows the database to persist during container recreation.

    podman volume create oradata
    
  2. Create a secret. The secret is a utility to pass secure text strings to the container, such as ssh-keys or passwords.

    echo "Welcome1" | podman secret create oracle_pwd -
    

    Note: The SYS, SYSTEM, and PDBADMIN administrative user accounts, all use the same password. Oracle recommends that your password should be at least 8 characters in length, containing at least 1 upper case character, 1 lower case character, and 1 digit from 0 to 9.

  3. Start the Oracle Autonomous Database Free Container Image for Autonomous Transaction Processing (ATP) workload.

    podman run -d \
    -p 1521:1521 \
    -p 1522:1522 \
    -p 8443:8443 \
    -p 27017:27017 \
    -e WORKLOAD_TYPE=ATP \
    -e WALLET_PASSWORD=********* \
    -e ADMIN_PASSWORD=********* \
    --cap-add SYS_ADMIN \
    --device /dev/fuse \
    -v oradata:/opt/oracle/oradata \
    --name adb-free \
    container-registry.oracle.com/database/adb-free:latest-23ai
    
    

    Oracle Autonomous Database Free Container Image supports 2 types of database workload types: Autonomous Data Warehouse (ADW) and ATP. These are similar to transaction processing and data warehouse workload type databases in Oracle Autonomous Database Serverless cloud service.

    On first startup of the container image:

    • User mandatorily has to change the admin passwords. Specify the password using the environment variable ADMIN_PASSWORD.

    • Wallet is generated using the wallet password WALLET_PASSWORD.

Task 4: Connect to the Oracle Database Free Server Container

  1. Get the mapped database port.

    podman port adb-free
    

    Example output:

    1521/tcp -> 0.0.0.0:1521
    1522/tcp -> 0.0.0.0:1522
    8443/tcp -> 0.0.0.0:8443
    27017/tcp -> 0.0.0.0:27017
    
  2. Install SQL*Plus.

    sudo dnf install -y oracle-instantclient-release-el8
    sudo dnf install -y oracle-instantclient-sqlplus
    
  3. Connect to the Oracle Database Free Server Container using SQL*Plus.

    sqlplus admin/<myatp_admin_password>@myatp_low
    

    Example output:

    SQL*Plus: Release 21.0.0.0.0 - Production on Mon Jun 10 20:21:34 2024
    Version 21.14.0.0.0
    
    Copyright (c) 1982, 2022, Oracle.  All rights reserved.
    
    Last Successful login time: Mon Jun 10 2024 20:16:49 +00:00
    
    Connected to:
    Oracle Database 23ai Enterprise Edition Release 23.0.0.0.0 - Production
    Version 23.4.0.24.05
    
    SQL>
    

Install Oracle Autonomous Database Free RPM on Oracle Roving Edge Infrastructure

Task 1: Update the Oracle Linux instance

  1. Verify that the Oracle Linux instance is up to date. Access the instance using ssh and run the following command to update instances.

    sudo dnf -y update
    
  2. Reboot the instance.

    sudo reboot
    
  3. Reconnect via ssh.

    ssh oracle@<ip_address_of_ol_node>
    

Task 2: Install the Oracle Database Free RPM

  1. Install the Pre-installation RPM.

    sudo dnf install -y oracle-database-preinstall-23ai-1.0-2.el8.x86_64
    

    The Oracle Database Pre-installation RPM automatically creates the Oracle installation owner and groups, and it also sets up other kernel configuration settings as required for Oracle Database installations. If you plan to use job-role separation, create an extended set of database users and groups depending on your requirements.

  2. Download the Oracle Database Free software.

    curl -JLO https://download.oracle.com/otn-pub/otn_software/db-free/oracle-database-free-23ai-1.0-1.el8.x86_64.rpm
    

    To access the Oracle Database Free software download details, see Access the Oracle Database Free software download details.

  3. Install the database software.

    sudo dnf localinstall -y  oracle-database-free-23ai-1.0-1.el8.x86_64.rpm
    

Task 3: Create and Configure the Oracle Database

  1. Review the configuration parameters.

    vi /etc/sysconfig/oracle-free–23ai.conf
    

    The configuration script creates a container database (FREE) with one pluggable database (FREEPDB1) and configures the listener at the default port (1521).

  2. Create the database with the default settings.

    sudo /etc/init.d/oracle-free-23ai configure
    

    Note: At the command prompt, specify a password for the SYS, SYSTEM, and PDBADMIN administrative user accounts. Oracle recommends that your password should be at least 8 characters in length, containing at least 1 upper case character, 1 lower case character, and 1 digit [0-9].

Task 4: Connect to the Oracle Database Free

  1. Set the environment for the database.

    export ORACLE_SID=FREE
    export ORAENV_ASK=NO
    . /opt/oracle/product/23ai/dbhomeFree/bin/oraenv
    
  2. Connect to the database.

    sqlplus / as sysdba
    

    Example output:

    SQL*Plus: Release 23.0.0.0.0 - Production on Thu Jun 6 11:19:10 2024
    Version 23.4.0.24.05
    
    Copyright (c) 1982, 2024, Oracle.  All rights reserved.
    
    
    Connected to:
    Oracle Database 23ai Free Release 23.0.0.0.0 - Develop, Learn, and Run for Free
    Version 23.4.0.24.05
    

Acknowledgments

More Learning Resources

Explore other labs on docs.oracle.com/learn or access more free learning content on the Oracle Learning YouTube channel. Additionally, visit education.oracle.com/learning-explorer to become an Oracle Learning Explorer.

For product documentation, visit Oracle Help Center.