The steps required to deploy an Oracle database Oracle the cloud are as follows:
1. Generate SSH keys
It is necessary to generate the SSH keys that will be launched later to connect to a database in OCI. Another option is to create them during the creation of the Virtual Machine DB system, as we will do in this example.
2. Creation of a Virtual Cloud Network (VCN)
Before you can provision a database in OCI, you must first deploy a VCN (Virtual Cloud Network). A VCN is a virtual private network used to deploy your cloud environment.
Once logged into the OCI console, to create the VCN, you can follow the necessary steps at this link:
Creating a Virtual Cloud Network (VCN)
Important!
Creating a VCN in OCI is free. However, creating an Oracle Cloud Database Service is not free. There are other options for this, such as Oracle Database.
It is therefore assumed that you have sufficient credits in your OCI console or that you are in a training environment where you can deploy this environment at no additional cost.
3- Creation of a Virtual Machine DB system
Once we have created and configured a Virtual Cloud Network (VCN), we can deploy a database virtual machine through the OCI console.
To do so, once logged into the OCI console, use the following link: Cloud Sign In
We navigate through the menu that appears on the left side of the screen.
Next, click on the Oracle Database option and then on Oracle Database Service.
We select the compartment on which our database will be deployed and click on the Create DB system button .
We fill in the necessary information according to our needs.
As a test, we will fill in the following.
- a. DB system name: oracleconraulVM
- b. Compartment: oracleconraul
- c. Shape: Click on "Change Shape." Select AMD, VM.Standard.E4.Flex, click on the three dots, choose "Update OCPU," and set it to 1.
- d. Oracle Software Edition: Enterprise Edition
- e. Select Storage Management Software and choose Logical Volume Manager.
- f. Available Storage Size (GB): We choose 256 GB
- g. SSH Keys. Download both public keys by clicking on the "Save private Key" and "Save public Key" buttons. To connect, you will only need the private key.
It is very important to save these keys, as they will be necessary to connect to the database we are going to create. - h. License type: We choose License Included
- i. Virtual Cloud Network: Select the VCN you created in step 2 from the drop-down menu.
- j. Client subnet: In this case, we will choose the "public-subnet" option created in step 2.
- k. Hostname prefix: oracleconraulHOST
- l. Database name: TEST
- m. Database unique name suffix: PROD
We enable the "Unified Auditing" option in the database.
We change the database version to deploy version 26ai by clicking on the "Change Database Image" button . We choose to deploy version 26ai.
- n. PDB name: TESTPDB1
We will provide you with the password that will manage the SYS and SYSTEM user accounts.
The password must meet the following requirements:
Passwords must be between 9 and 30 characters long and contain at least 2 uppercase letters, 2 lowercase letters, 2 special characters, and 2 numeric characters. The special characters must be _, #, or -.
For this test, we remove the "Enable automatic Backup" option, leaving it disabled, and click on the CREATE button.
The provisioning status of our VM will appear in the OCI console. This process will take a few minutes.
If everything is correct, the status of our database will be Available.
If we click on the Databases tab, we can see that our database has been created correctly.
4- Connection to the newly created node
We go to the "Nodes" tab.
In our case, we have configured a public IP address for training purposes, so we can connect from outside.
In this case, we are going to connect with Mobaterm https://mobaxterm.mobatek.net/, taking advantage of the fact that it accepts OpenSSSH keys. If you try to connect with PuTTY, for example, you will have to create or convert the key to .ppk.
If you need to connect with Putty how to do it putty
We will run the MobaXterm application, and in the SSH tab - > Advanced SSH Settings, we will fill in the following.
a. Remote Host: Public IP from the OCI nodes tab, in our case 150.X.X.X
b.Specify username: opc (default oracle compute Instances OCI).
c. Use Private Key: Click on the "Use Private Key" option and link it to the private IP downloaded previously.
Although there are many more options, this would be sufficient.
In the Bookmark settings tab, we can give the session an identifying name. In Session Name, we enter TESTOCIDB to identify it and click OK.
If everything is correct, we will enter our virtual machine correctly.
We can now verify that the database has been created correctly according to the characteristics we selected earlier.
[opc@oracleconraulhost ~]$ sudo su – oracle
Last login: Thu Feb 12 11:42:27 UTC 2026 on pts/0
[oracle~]$ . oraenv
ORACLE= [TEST] ? TEST
The Oracle has been set tooracle
[oracle~]$ sqlplus / as sysdba
SQL*Plus: Release 23.26.0.0.0 – for Oracle and Engineered Systems on Thu Feb 12 11:44:21 2026
Version 23.26.0.0.0
Copyright (c) 1982, 2025, Oracle. All rights reserved.
Connected to:
Oracle Database 26ai Enterprise Edition Release 23.26.0.0.0 – for Oracle and Engineered Systems
Version 23.26.0.0.0
SQL*Plus: Release 23.26.0.0.0 – for Oracle and Engineered Systems on Thu Feb 12 16:39:27 2026
Version 23.26.0.0.0
SQL> show pdbs
CON_ID CON_NAME OPEN MODE RESTRICTED
———– —————- —————— ——————-
2 PDB$SEED READ ONLY NO
3 TESTPDB1 READ WRITE NO
