Use the Autonomous Database Free Container Image
- About the Free Container Image
You can access the Autonomous Database Free Container Image from a repository and run it in your local environment. - Container Registry Locations for Autonomous Database Free Container Image
There are multiple locations where you can obtain Autonomous Database Free Container Image, including: Oracle Cloud Infrastructure Registry (Container Registry) and GitHub. - Start Free Container Image
After you download Autonomous Database Free Container Image, you can start the image in a container. - Perform Database Operations using adb-cli
Theadb-cli
command-line utility can be used to perform database operations after the container is up and running. - Connect to an Free Container Image
When the Free Container Image is running in a container, you can connect to an Autonomous Database instance. - Migrate Data Between Autonomous Database Free Containers
When a new version of the Free Container Image is available, you can migrate data from a container to another container.
Parent topic: Tasks
About the Free Container Image
You can access the Autonomous Database Free Container Image from a repository and run it in your local environment.
Autonomous Database provides a fully managed Oracle Database that is available on Oracle Cloud Infrastructure. On Oracle Cloud Infrastructure, you perform lifecycle management operations and run Autonomous Database using the Oracle Cloud Infrastructure Console and you connect to your database through the public internet or through a private network that you set up (depending on your network configuration and security needs).
Note:
Autonomous Database supports both the Oracle Autonomous Database Free Container Image 19c and Oracle Autonomous Database Free Container Image 23ai versions.
The Autonomous Database Free Container Image provides an alternative to run Autonomous Database in a container in your own environment, without requiring access to Oracle Cloud Infrastructure Console or to the internet. When you run Autonomous Database in a container, the container provides a local, isolated environment with additional options for development, testing, and exploration of Oracle Autonomous Database features.
- Autonomous Database Free Container Image License
Describes licensing for Autonomous Database Free Container Image. - Autonomous Database Free Container Image Features
The Autonomous Database Free Container Image provides many of the features available with Autonomous Database Serverless. - Autonomous Database Free Container Image Recommendations and Restrictions
Describes requirements and restrictions for Free Container Image.
Parent topic: Use the Autonomous Database Free Container Image
Autonomous Database Free Container Image License
Describes licensing for Autonomous Database Free Container Image.
Autonomous Database Free Container Image is subject to licensing.
The container image you have selected and all of the software that it contains is licensed under Oracle Free Use Terms and Conditions that are provided in the container image. Your use of the container is subject to the terms of those licenses.
Parent topic: About the Free Container Image
Autonomous Database Free Container Image Features
The Autonomous Database Free Container Image provides many of the features available with Autonomous Database Serverless.
-
Each Free Container Image provides two Autonomous Database instances, one instance with Data Warehouse workload type and one instance with Transaction Processing workload type.
-
The database will be started with either the Transaction Processing workload type or the Data Warehouse workload type based on the workload type you specify during startup.
-
You can perform database operations using the
adb-cli
command-line utility. -
The Free Container Image resource allocation is 4 ECPUs and 20 GB of storage, and allows a maximum of 30 simultaneous database sessions.
-
Each Free Container Image supports the Autonomous Database consumer groups:
-
Data Warehouse workload: You connect through HIGH, MEDIUM, or LOW services
-
Transaction Processing workload: You connect through HIGH, MEDIUM, LOW, TP, or TPURGENT services
See About Autonomous Database Workload Types for more information.
-
-
The Free Container Image provides support for the following built-in database tools:
-
Database Actions
-
Oracle REST Data Services (ORDS)
-
Oracle APEX
-
Oracle Database API for MongoDB
-
Parent topic: About the Free Container Image
Autonomous Database Free Container Image Recommendations and Restrictions
Describes requirements and restrictions for Free Container Image.
Recommendations for Resource Allocation for the Free Container Image
The following is the recommended resource allocation for the Free Container Image:
-
4 CPUs
-
8 GB memory
Restrictions for Free Container Image
-
There is no automatic patching or maintenance windows for the Free Container Image. The repository provides the latest version of the Free Container Image. Check the repository to find newer versions of Free Container Image.
-
The following Autonomous Database built-in tools are not supported:
- Graph
- Oracle Machine Learning
- Data Transforms
-
When Autonomous Database runs in a container, the container provides a local Autonomous Database instance. The container image does not include the features that are only available through the Oracle Cloud Infrastructure Console or the APIs. Some features that are available in-database and also available through the Oracle Cloud Infrastructure Console can still be used through in-database commands, such as resetting the
ADMIN
password. The following lists some of the features that are not available:Feature Available or Not Available Backup an Instance Not available Choose a Character Set Not available Clone an Instance Not available Create an Elastic Pool Not available Customer-managed keys Not available Database rename Not available Data Safe Not available Disable compute auto scaling Not available Disable Built-in Database Tools Not available Disable storage auto scaling Not available Disaster recovery options, including Autonomous Data Guard and Backup-Based Disaster Recovery. Not available Download wallet Not available Enable Built-in Database Tools Not available Enable compute auto scaling Not available Enable storage auto scaling Not available Join an Elastic Pool Not available Network ACLs Not available Oracle Cloud Infrastructure events Not available Performance hub Not available Private endpoints Not available Real Application Testing Not available Resource Principal based authentication Not available Restart Instance Not available Restore an Instance Not available Rotate wallet Not available Sample Schema Not available Scale down CPU and storage Not available Scale up CPU and storage Not available Selecting the Instance Patch Level Not available Start Instance Not available Stop Instance Not available Note:
When you run Free Container Image in a container, you can start an instance, stop an instance, or restart an instance by starting, stopping or restarting the container.
Parent topic: About the Free Container Image
Container Registry Locations for Autonomous Database Free Container Image
There are multiple locations where you can obtain Autonomous Database Free Container Image, including: Oracle Cloud Infrastructure Registry (Container Registry) and GitHub.
You can obtain the Autonomous Database Free Container
Image in multiple locations. The examples shown use
podman
commands (see Podman for more information).
Parent topic: Use the Autonomous Database Free Container Image
Start Free Container Image
After you download Autonomous Database Free Container Image, you can start the image in a container.
The database will be started with either the Transaction Processing workload type or the Data Warehouse workload type based on the workload type you specify.
Parent topic: Use the Autonomous Database Free Container Image
Perform Database Operations
using adb-cli
The adb-cli
command-line utility can be used to perform
database operations after the container is up and running.
To use adb-cli
, you can define the
following alias for
convenience:
alias adb-cli="podman exec <container_name> adb-cli"
Available Commands
You can view the list of available commands using the following command:
adb-cli --help
Usage: adb-cli [OPTIONS] COMMAND [ARGS]...
ADB-S Command Line Interface (CLI) to perform container-runtime database operations
Options:
-v, --version Show the version and exit.
--help Show this message and exit.
Commands:
add-database
change-password
Add Database
You can add a database using the following command:
adb-cli add-database --workload-type "ATP" --admin-password "Welcome_MY_ATP_1234"
Change Password
You can change the admin password using the following command:
adb-cli change-password --database-name "MYATP"
--old-password "Welcome_MY_ATP_1234" --new-password "Welcome_12345"
Parent topic: Use the Autonomous Database Free Container Image
Connect to an Free Container Image
When the Free Container Image is running in a container, you can connect to an Autonomous Database instance.
To connect to an Autonomous Database instance running in a container, you can either setup the wallet and connect or use a TLS walletless connection.
- Connect to ORDS, APEX, or Database Actions from an Autonomous Database Container Image
The containerhostname
is used to generate self-signed SSL certificates to serve HTTPS traffic on port 8443. Oracle APEX and Database Actions can be accessed using the container host (or simplylocalhost
). - Available TNS Aliases for Connecting to an Autonomous Database Container Image
You can use any one of the following aliases to connect to an Autonomous Database Container Image. - Connect to an Autonomous Database Container Image with a Wallet
Describes the steps to connect to an Autonomous Database container image with a Wallet. - Connect to an Autonomous Database Container Image without a Wallet (TLS)
Describes the steps to connect to an Autonomous Database container image without a Wallet (TLS).
Parent topic: Use the Autonomous Database Free Container Image
Connect to ORDS, APEX, or Database Actions from an Autonomous Database Container Image
The container hostname
is used to generate self-signed
SSL certificates to serve HTTPS traffic on port 8443. Oracle APEX and Database Actions can
be accessed using the container host (or simply localhost
).
Application | URL |
---|---|
Oracle APEX | https://localhost:8443/ords/apex |
Database Actions | https://localhost:8443/ords/sql-developer |
Note:
For additional databases plugged in usingadb-cli
add-database
command, use the URL formats
https://localhost:8443/ords/{database_name}/apex
and
https://localhost:8443/ords/{database_name}/sql-developer
to
access APEX and Database Actions respectively.
Parent topic: Connect to an Free Container Image
Available TNS Aliases for Connecting to an Autonomous Database Container Image
You can use any one of the following aliases to connect to an Autonomous Database Container Image.
Table 3-7 Available TNS Aliases
Protocol | Transaction Processing Workload | Data Warehouse Workload |
---|---|---|
mTLS |
|
|
TLS |
|
|
The TNS alias mappings for these connect strings are in
$TNS_ADMIN/tnsnames.ora
. See Manage Concurrency and Priorities on Autonomous Database for information on the service names in
tnsnames.ora
.
Parent topic: Connect to an Free Container Image
Connect to an Autonomous Database Container Image with a Wallet
Describes the steps to connect to an Autonomous Database container image with a Wallet.
Perform the following steps to setup a wallet and connect:
Parent topic: Connect to an Free Container Image
Connect to an Autonomous Database Container Image without a Wallet (TLS)
Describes the steps to connect to an Autonomous Database container image without a Wallet (TLS).
To connect without a wallet, you need to update your client's truststore with the self-signed certificate generated at container start.
Perform the following steps to setup a TLS connection and connect.
Parent topic: Connect to an Free Container Image
Migrate Data Between Autonomous Database Free Containers
For example, use existing data that you created in a container by migrating that data to the latest version of Free Container Image when a new update is available.
Parent topic: Use the Autonomous Database Free Container Image