Oracle JDeveloper is a Java integrated development environment (IDE) with support for most commonly used relational database. Oracle Cloud Platform provides Oracle Database and MySQL database as a managed Cloud service. By implementing an Oracle Cloud Platform Console, a user may provision an Oracle Database instance without having to download, install, and configure the database on a local machine. In three articles, we shall create an Oracle Database 12c instance on Oracle Cloud Platform and use JDeveloper 12c to connect to the database and create a database table. This first of the three articles has the following sections:
- Setting the Environment
- Creating a Quick Start Database Service
- Creating an Oracle Database Cloud Service Using Detailed Wizard
- Conclusion
Setting the Environment
Download and install Oracle JDeveloper 12c on a local Windows machine.
Oracle JDeveloper 12c Console is shown in Figure 1.
Figure 1: Oracle JDeveloper 12c start page
Create an Oracle Cloud Platform account and subscribe to Oracle Database Cloud service. A free trial of Oracle Cloud Platform is available. The Oracle Cloud Services Dashboard is shown in Figure 2.
Figure 2: Oracle Cloud Service Dashboard
An Oracle Database service instance on the Oracle Cloud may be provisioned using one of two options from the Dashboard:
- Quick Start Database Service Wizard
- Detailed Oracle Database Service Wizard
We shall discuss each of these options to provision an Oracle Database service on Oracle Cloud next.
Creating a Quick Start Database Service
Click Create Instance in the Dashboard in Figure 1. In the Create Instance wizard, select the Quick Start Services tab, as shown in Figure 3. Click Create for the Database service.
Figure 3: Create Instance>Quick Start Services>Database
A Quick Starts wizard for Oracle Database gets launched, as shown in Figure 4. Three different editions of Oracle Database are available: Standard Edition, Enterprise Edition, and Extreme Performance edition. From Standard to Extreme Performance edition, the supported features are improved. Each of these editions is based on Oracle Database 12.2. The storage for the Standard edition is 15 GB, for the Enterprise edition is 512 GB, and for the Extreme Performance edition is 1 TB. For this article, we shall use the Standard Edition.
Figure 4: Quick Starts for Oracle Database
The Instance Name is automatically generated, but it may be modified. Click Create for Standard Edition, as shown in Figure 5.
Figure 5: Standard Edition>Create
A Confirmation dialog gets displayed with a link to download the SSH public & private keys and credentials to access the database. Click Download (see Figure 6).
Figure 6: Confirmation>Download
A service_credentials.zip file, which has three files—privateKey, publicKey, and service_credentials.txt—gets downloaded. Extract the files to a directory. Click Create, as shown in Figure 7, to create a database service instance.
Figure 7: Confirmation>Create
Creating an Oracle Database Cloud Service Using Detailed Wizard
Click Create Instance in the Dashboard as before and select the All Services tab in the Create Instance wizard, as shown in Figure 8. Click Create for the Database service in the Data Management header.
Figure 8: Create Instance>All Services>Data Management>Database>Create
The Oracle Database Cloud Service wizard gets started. Click Create Service, as shown in Figure 9.
Figure 9: Create Service
The Oracle Database Cloud Service>Create Service wizard gets started, as shown in Figure 10. Some of the database instance information is pre-specified in the fields provided.
Figure 10: Create Service Wizard
Specify a Service Name (up to 50 characters), which must start with a letter and can contain only letters, numbers, and hyphens and cannot end with a hyphen, as shown in Figure 11.
Figure 11: Specifying a Service Name
The BYOL (Bring Your Own License) checkbox should be selected only if a user-supplied license is to be used. Select a Software Release (Oracle Database 12c Release 2) from the three versions available, as shown in Figure 12.
Figure 12: Selecting a Software Edition as Oracle Database 12c Release 2
Select a Software Edition (Enterprise Edition) and select a Database Type (Single Instance). Click Next, as shown in Figure 13.
Figure 13: Completing Basic Database Instance Information
The Service Details page gets displayed, as shown in Figure 14. DB Name is pre-specified as ORCL and PDB (Pluggable Database) Name is pre-specified as PDB1. The default settings may be modified, but we shall use the default. The Administration Password for SYS and SYSTEM users must be between 8 and 30 characters with at least one lower-case letter, one upper-case letter, one number, and one special character, as shown in the field callout in Figure 14.
Figure 14: Service Details
Default settings for Usable Database Storage (GB), Total Data File Storage (GB), and Compute Shape are pre-configured. Click Edit for the SSH Public Key field, as shown in Figure 15.
Figure 15: SSH Public Key>Edit
In the SSH Public Key for VM Access dialog, click Create a New Key to generate a key pair automatically, and click Enter, as shown in Figure 16.
Figure 16: SSH Public Key for VM Access
A SSH Key pair gets generated automatically. Click Download in the Download Keys dialog, as shown in Figure 17.
Figure 17: Download Keys>Download
Click Done, as shown in Figure 18, after an sshkeybundle.zip file has been downloaded. The SSH Keys pairs are used to access a database instance VM and we won’t be using the SSH Keys because we shall be connecting to the database using JDeveloper.
Figure 18: Download Keys>Done
A SSH Public Key gets added to the field. Optionally, select the checkbox for Include “Demos” PDB in Advanced Settings, as shown in Figure 19.
Figure 19: Advanced Settings>Include “Demos” PDB
After having selected or specified all the required service configuration settings, click Next, as shown in Figure 20.
Figure 20: Service Details>Next
In Confirmation, click Create (see Figure 21).
Figure 21: Confirmation>Create
The two instances of Oracle Database Cloud services, one created using the Quick Start wizard and the other created using the detailed wizard, start to get provisioned, as shown in Figure 22.
Figure 22: Creating Instances for Oracle Database Cloud Service
After the service instances have been created, the Submitted On timestamp gets replaced with the Created On timestamp, as shown in Figure 23.
Figure 23: Service Instances created
Conclusion
In this article, we discussed connecting to Oracle Database service instance on Oracle Cloud Platform with Oracle JDeveloper 12c. First, we created Oracle Database service instances using each of the Create Instance options: Quick Start wizard and detailed wizard. Later articles will explore this in more depth.
