dcsimg
December 18, 2017
Hot Topics:

Using Oracle JDeveloper 12c with Oracle Database 12c on Oracle Cloud Platform, Part 1

  • December 6, 2017
  • By Deepak Vohra
  • Send Email »
  • More Articles »

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

Download and install Oracle JDeveloper 12c on a local Windows machine.

Oracle JDeveloper 12c Console is shown in Figure 1.

Oracle JDeveloper 12c start page
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.

Oracle Cloud Service Dashboard
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.

Create Instance>Quick Start Services>Database
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.

Quick Starts for Oracle Database
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.

Standard Edition>Create
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).

Confirmation>Download
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.

Confirmation>Create
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.

Create Instance>All Services>Data Management>Database>Create
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.

Create Service
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.

Create Service Wizard
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.

Specifying a Service Name
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.

Selecting a Software Edition as Oracle Database 12c Release 2
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.

Completing Basic Database Instance Information
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.

Service Details
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.

SSH Public Key>Edit
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.

SSH Public Key for VM Access
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.

Download Keys>Download
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.

Download Keys>Done
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.

Advanced Settings>Include "Demos" PDB
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.

Service Details>Next
Figure 20: Service Details>Next

In Confirmation, click Create (see Figure 21).

Confirmation>Create
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.

Creating Instances for Oracle Database Cloud Service
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.

Service Instances created
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.






Comment and Contribute

 


(Maximum characters: 1200). You have characters left.

 

 


Enterprise Development Update

Don't miss an article. Subscribe to our newsletter below.

Sitemap | Contact Us

Thanks for your registration, follow us on our social networks to keep up-to-date