In the first part of this blog series, we created an Oracle Linux virtual machine (VM) on Oracle Cloud VMware Solution. In this second part, we create two types of Oracle autonomous databases.

We access the first database type through a private virtual cloud network (VCN) endpoint and access the second database type through the service gateway. Creating two types of databases demonstrates the network configuration required for each database type to a VMware Solution VM.

Create an Oracle autonomous database accessed by VCN

In the Oracle Cloud Infrastructure (OCI) Console, go to the menu and select Oracle Database and then Autonomous Database.

A screenshot of the OCI Console with the menu expanded and the Oracle Database and Autonomous Database options outlined in red.

Choose your compartment and click Create Autonomous Database. In this example, I use Oracle Cloud VMware Solution.

A screenshot of the Autonomous Databases page with the Compartment (OCVS) and Create Autonomous Database button outlined in red.

Pick a display name for your database. I chose a name advising that the autonomous database is created in the VMware Solution VCN. Then choose the workload type.

A screenshot of the basic information page for the autonomous database with the display name and workload type outlined in red.

Enter the password and password confirmation fields, choose Private endpoint access only, and then pick the VCN of the VMware Solution cluster and subnet. I picked the subnet from the Oracle Cloud VMware Solution software-defined data center (SDDC) page, in the resources of SDDC Networks and Subnet tabs.

A screenshot of the Create administrator credentials page with the password, access type, VCN, and subnet fields outlined in red.

Pick the network service gateway (NSG) for the NSX Edge Uplink 1, and click the VLAN name.

A screenshot of the SDDC Networks page with the VLAN of choice and VLAN name outlined in red.

After entering the NSGs in the VMware Solution, choose the license type and click Create Autonomous Database.

A screenshot of the Create Autonomous Database page with the NSG and license type outlined with red.

On the following page, click Network Security Groups.

A screenshot of the Autonomous Database Details page with the network security groups outlined in red.

Update the NSG and add an egress rule with the SDDC NSX external access IP address. You can find this IP address in the SDDC. Under Resources, go to the SDDC Networks and click the “NSX Edge Uplink 1” VLAN.

A screenshot of the SDDC Networks page with the VLAN outlined in red.

This VLAN has an external access address for the cluster, which we use as the source IP address for accessing the database through an ingress rule.

A screenshot of the VLAN Details page with the external access link and private IP address outlined in red.

Check the source CIDR block of the NSX.

A screenshot of the CIDR details wtih the direction, source, source port, and destination port range outlined in red.

Create an Oracle autonomous database accessed through the service gateway

Enter the database display name, workload type, and deployment type.

A screenshot of the Create Autonomous Database page with the display name, workload type, and deployment type outlined in red.

I used the default configuration of database version, OCPU and storage, and entered the admin. password.

A screenshot of the Create Autonomous Database page wtih the password and confirmation outlined in red.

For this database, I used “Secure access from everywhere” for the access type with Bring Your Own License (BYOL). Then click Create Autonomous Database.

A screenshot of the Create Autonomous Database page with the access type, license type, and Create Autonomous Database button outlined in red.

See the summary database creation page using secure access from everywhere through the service gateway.

A screenshot of the Autonomous Database Details page.

Copy the database wallet and install SQL Developer RPM on your Oracle Linux VM

Download the wallet for both databases from the jump host using the OCI Console. In each database in the Console, under Database Connection, choose Instance Wallet for the wallet type and click Download Wallet. Then enter your password.

A screenshot of the Download Wallet window with the password filled in.

Then go to the JumpBox and download the Autonomous Database Wallet zip files to the VM. To run file transfer protocol (FTP), you need the IP address of the VM. To locate the VM IP address, go to vCenter, and get the IP address assigned to the server.

A screenshot of the vSphere Client dashboard with the IP address outlined in red.

Run FTP to the server with the IP address and copy the wallet.

sftp johnsmith@172.0.0.66
sftp> mput <ADB Wallet file name>.zip
sftp> exit

A screenshot of the command prompt window after running the code with the download location outlined in red.

Download the SQL Developer Linux RPM and Java Development Kit (JDK). Transfer SQL Developer to the Oracle Linux VM with the following command:

% sftp johnsmith@172.0.0.66
sftp> mput <SQL Developer Linux >.rpm
sftp> exit

A screenshot of the code with the download command outlined in red.

Transfer the JDK RPMs to the Oracle Linux VM with the following command:

% sftp johnsmith@172.0.0.66
sftp> mput <JDK Linux >.rpm
sftp> exit

A screenshot of the code block with the download location outlined in red.

Connect to the VM either through putty or vCenter and install SQL Developer.

A screenshot of the code block with the sudo command to install SQL Developer outlined in red.

Then install the JDK file, which is required to start SQL Developer.

A screenshot of the code block with the sudo command to install the JDK file outlined in red.

You have now created two autonomous databases, copies the wallet to the Oracle Cloud VMware Solution virtual machine, and installed the SQL developer tool to connect to the database.

To be concluded

In part 3 of this blog, we configure the DNS and network to enable Oracle SQL developer running on an Oracle Cloud VMware Solution virtual machine to connect to the databases that we created.

Want to learn more about Oracle Cloud VMware Solution and Autonomous Database? See the following resources: