To create our first standalone database we need to have an Oracle cloud account, if you don't have one yet, you can see this article where I show you how to create one.
Now that we have our account created, we enter the dashboard of our OCI. Then click on the hamburger in the upper left corner. Then we click on Oracle Database –> Autonomous Transaction Processing.
The screen where all the stand-alone databases are listed appears. To create our first standalone database we click on the button Create Autonomous Database.
Next we need to provide basic information:
Display name: here we enter a user-friendly description or other information that will help us to easily identify the resource. The display name does not have to be unique, and can be changed at any time. Avoid entering sensitive information.
Compartment: here we select the compartment of the stand-alone database. The compartments allow us to give an order to our databases. For example, we can have our databases organized by environments: Development, Test, Production, or we can organize it in any other criteria defined by the organization.
Database name: The database name must consist of letters and numbers only, starting with a letter. The maximum length is 14 characters. Avoid entering sensitive information here as well.
Below we need to select the workload type, deployment type and other settings.
The stand-alone database offers two types of workload:
- "Oracle Autonomous - Transaction Processing". provides us with a self-contained, secure, self-healing database service that can instantly scale to meet the demands of mission-critical transaction processing and mixed workload applications.
- "Oracle Autonomous - Data Warehouse". provides us with a fully self-contained, easy-to-use database that scales elastically, offers fast query performance and requires no database administration.
Next, we need to select the type of deployment:
- No Serveris a simple and elastic deployment option. Oracle autonomously operates all aspects of the database lifecycle, from database placement to backup and upgrades.
- Dedicatedis a private cloud on public cloud deployment option. A fully dedicated compute, storage, network and database service for a single tenant. The dedicated deployment provides the highest levels of security isolation and governance. The customer has customizable operational policies to guide autonomic operations for workload placement, workload optimization, upgrade scheduling, availability level, over-provisioning and peak utilization.
If we activate the option Always free of chargeThe main CPU count and Storage are disabled to show the free options (1 core and 0.02 TB).
Checking the "Auto Scaling" checkbox allows the system to use up to three times as many cores as provisioned as the workload increases.
On the other hand, if we deactivate the "Always Free" option, we can allocate the resources according to our requirements, with an associated cost at the end of the trial period.
In the next screen, we must enter the password of the ADMIN user and select the type of network and the type of license we require.
In case we have a database license we choose "Bring Your Own License (BYOL)" otherwise we choose License Included. For this demo we choose License Included.
In the case of the license we choose by default Acceso seguro desde cualquier lugar.
At the bottom of this same screen we can see a section to enter emails for contacts with which they will receive notifications and announcements.
In addition we can also see the link "Show/Hide Advanced Options".
By clicking on the link we can define tags to organize the resources in our lease and track them.
Click on the button Create Autonomous Database.
Immediately after that we are shown the page with the details of the standalone database, in provisioning status.
After a few minutes the stand-alone database is available.
Logging into Oracle APEX from the Standalone Database
Select the newly created standalone database. Then select the Tools tab.
A new window opens and asks us to enter the password of the ADMIN user.
Once the password for the standalone database has been entered, the Create APEX Workspace page is displayed.
Then the screen appears to configure whether we want a new schematic or an existing schematic. For this demonstration we choose new schematic.
Ingresamos el workspace, username y password.
Click on the button Create Workspace.
Next, the Instance administration page is displayed.
We exit the instance administration and enter the new Workspace we have just created.
The Login page is displayed in Oracle APEX. Click on the Connect button.
And this way we enter the APEX home page ready to create new applications in Oracle APEX 22.2.1.
Let's take advantage of these free resources provided by Oracle to learn APEX with an Autonomous database!