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". nos ofrece un servicio de base de datos autónomo, seguro y de reparación automática que puede escalarse instantáneamente para satisfacer las demandas de procesamiento de transacciones de misión crítica y aplicaciones de carga de trabajo mixtas.
- "Oracle Autonomous - Data Warehouse". nos proporciona una base de datos totalmente autónoma y fácil de usar que se escala elásticamente, ofrece un rendimiento de consulta rápido y no requiere administración de la base de datos.
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.
En la siguiente pantalla, debemos ingresar la contraseña del usuario ADMIN y seleccionar el el tipo de network y el tipo de licencia que requerimos.
En el caso que tengamos una licencia de la base de datos elegimos “Traiga su Propia licencia (BYOL)” en caso contrario elegimos licencia incluida. Para esta demostración elegimos Licencia incluida.
In the case of the license we choose by default Acceso seguro desde cualquier lugar.
En la parte inferior de esta misma pantalla podemos observar una sección para ingresar emails para contactos con el cual recibiran notificaciones y anuncios.
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!