As anyone in IT knows, Oracle Database is the best database and most used by companies. If you use Oracle Database in your own datacenter, you need to know that you can migrate and run those databases in the Oracle Cloud, even if you use Oracle Database Options, Exadata, and RAC.
Some of the benefits that the cloud offers are the ease and speed of creating database instances with different versions, computing power and storage by choosing a few settings.
In this article we will create an Oracle Database Virtual Machine instance.
To create a new Oracle Database Virtual Machine instance, on the main menu click Bare Metal, VM, and Exadata.
Click Launch DB System.
In the Launch DB System page use the information below and click Launch DB System:
- Display Name: mydb
- Availability domain: AD1, AD2 or AD3
- Shape Type: Virtual Machine
- Instance type: Virtual Machine
- Shape: VM.Standard2.1
- Oracle Database Software Edition: Enterprise Edition High Performance
- Available Storage Size: 256
- License Type: License Included
- SSH Public Key: Add the generated id_rsa.pub key (See how to generate here)
- Virtual Cloud Network: The VCN you created (See how to create here)
- Client Subnet: The subnet you created (e.g. Public Subnet MQoB:US-ASHBURN-AD-1)
- Hostname Prefix: mycdb
- Database Name: mycdb
- Database Version: 18.104.22.168
- PDB Name: mypdb
- Database Admin Password: Any password (e.g. WElcome_#12)
- Confirm Database Admin Password: Repeat your password
- Database Workload: On-Line Transaction Processing (OLTP)
You will need to wait about 45 minutes while your service is provisioned.
Once the service is provisioned, you’ll see all the details about it.
To access your instance, open your terminal emulator and configure a new SSH session to access it.
- Remote host: Your Public IP address
- Username = opc
- Port = 22
- Private key = Your private key (e.g. id_rsa file)
Start a new SSH session, switch to the oracle user, and connect to the database.
$ sudo su - oracle
$ . oraenv
$ sqlplus / as sysdba
In this article, you learned how to create a new Oracle Database Virtual Machine instance.
Have a good time!