Note:
- This tutorial requires access to Oracle Cloud. To sign up for a free account, see Get started with Oracle Cloud Infrastructure Free Tier.
- It uses example values for Oracle Cloud Infrastructure credentials, tenancy, and compartments. When completing your lab, substitute these values with ones specific to your cloud environment.
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:
-
Oracle Application Express (Oracle APEX): A low-code development platform that enables you to build scalable, secure enterprise apps with world-class features.
-
Oracle REST Data Services (ORDS): A Jakarta Enterprise Edition (formerly known as Java Enterprise Edition) based data service that makes it easy to develop modern REST interfaces for relational data and JSON Document Store.
-
Oracle Database Actions: It is a web-based interface that uses Oracle REST Data Services to provide development, data tools, administration, and monitoring features for Oracle Autonomous Database.
-
Oracle Machine Learning Notebooks early adopter is an enhanced web-based notebook platform for data engineers, data analysts, R and Python users, and data scientists. You can write code, text, create visualizations, and perform data analytics including machine learning. In Oracle Machine Learning Notebook, notebooks are available in a project within a workspace, where you can create, edit, delete, copy, move, and even save notebooks as templates.
Audience
Oracle Roving Edge Infrastructure administrators, developers, and users.
Objectives
-
Install Oracle Autonomous Database Free Container Image on Oracle Roving Edge Infrastructure.
-
Install Oracle Autonomous Database Free Red Hat Package Manager (RPM) on Oracle Roving Edge Infrastructure.
Prerequisites
-
Access to Oracle Linux instance running on an Oracle Roving Edge Infrastructure node.
-
A macOS, Linux, or Windows computer with
ssh
support installed. -
SSH access to the Oracle Linux instances with
ssh
key authentication set up from your macOS, Linux, or Windows computer. -
Access to
sudo
on the Oracle Linux instances. -
Basic knowledge of using and working on Linux hosts including installing software, creating and editing files, and working with services.
Install Oracle Autonomous Database Free Container Image on Oracle Roving Edge Infrastructure
Task 1: Update the Oracle Linux instance
-
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
-
Reboot the instance.
sudo reboot
-
Reconnect using
ssh
.ssh oracle@<ip_address_of_ol_node>
Task 2: Install the container-tools
Module
-
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
-
Create a data volume. The data volume allows the database to persist during container recreation.
podman volume create oradata
-
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
, andPDBADMIN
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. -
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
-
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
-
Install SQL*Plus.
sudo dnf install -y oracle-instantclient-release-el8 sudo dnf install -y oracle-instantclient-sqlplus
-
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
-
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
-
Reboot the instance.
sudo reboot
-
Reconnect via
ssh
.ssh oracle@<ip_address_of_ol_node>
Task 2: Install the Oracle Database Free RPM
-
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.
-
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.
-
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
-
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
). -
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
, andPDBADMIN
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
-
Set the environment for the database.
export ORACLE_SID=FREE export ORAENV_ASK=NO . /opt/oracle/product/23ai/dbhomeFree/bin/oraenv
-
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
Related Links
Acknowledgments
- Author - Jeevan Sreenivas (Principal Technical Product Manager)
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.
Deploy Oracle Autonomous Database on Oracle Roving Edge Infrastructure
G10387-01
June 2024