SecureAnyCloud
Deployment guide

SQL Developer

Overview

Oracle SQL Developer is a free integrated development environment (IDE) from Oracle for working with Oracle databases, MySQL and other SQL databases. It provides a graphical interface for database development, administration and data modeling.

This guide covers deploying and using Oracle SQL Developer on Windows Server with the SecureAnyCloud AMI from the AWS Marketplace.

What you get:

  • Oracle SQL Developer (latest version) preinstalled
  • Java Runtime Environment, which SQL Developer requires
  • A desktop shortcut for quick access
  • Windows Server with Remote Desktop access
  • 24/7 SecureAnyCloud support with a guaranteed 24-hour response SLA

Prerequisites

Before you launch the AMI, make sure you have:

  • An active AWS account
  • An active subscription to the SQL Developer listing on AWS Marketplace
  • An EC2 key pair for password decryption
  • A Remote Desktop client application
  • An Oracle database or other SQL database to connect to

Recommended instance type: t3.medium (2 vCPU, 4 GB RAM) or larger. The minimum requirements are 1 vCPU, 1 GB RAM and 30 GB of disk space.

1

Launch the AMI

  • Open the AWS Marketplace and search for "SQL Developer SecureAnyCloud".
  • Select Continue to Subscribe, accept the terms, then select Continue to Configuration.
  • Select your preferred Region and Software Version.
  • Select Continue to Launch.
  • Choose Launch through EC2 for full control over the instance configuration.
  • Select your instance type. t3.medium is recommended.
  • Configure storage with a minimum of 30 GB gp3.
  • Configure your Security Group with the following inbound rule:

Port Protocol Source Purpose

3389 TCP Your IP Remote Desktop (RDP) access

  • Select your EC2 key pair and launch the instance.
2

Retrieve the Windows Password

Wait for the EC2 instance to pass 2/2 status checks. Then:

  • Open the AWS Console and go to EC2 > Instances.
  • Select your instance.
  • Choose Actions > Security > Get Windows password.
  • Select Browse and upload your EC2 key pair .pem file.
  • Select Decrypt password.
  • Note the Username (Administrator) and the decrypted Password.

Important: The Windows password can take up to 15 minutes to become available after launch.

3

Connect via Remote Desktop

Open your Remote Desktop client.

On Windows: Press Win + R, type mstsc and press Enter. Enter the public IP address of your instance, then select Connect.

On macOS: Open Microsoft Remote Desktop. Select Add PC and enter the public IP address. Double-click the connection to connect.

When prompted, enter Username: Administrator and Password: the decrypted value from Step 2.

If a certificate warning appears, select Continue.

4

Launch SQL Developer

On the Windows desktop, double-click the SQL Developer shortcut to launch the application.

SQL Developer opens the main IDE window, with the Connections panel on the left and the worksheet area in the center.

5

Connect to an Oracle Database

In the Connections panel, select the green + icon (New Connection), then fill in the connection details:

  • Connection Name: a descriptive name (for example, "Production DB")
  • Username: your database username (for example, SYS or SYSTEM)
  • Password: your database password
  • Role: select SYSDBA if you connect as SYS
  • Hostname: the IP address or DNS name of your Oracle database server
  • Port: 1521 (the default Oracle listener port)
  • SID or Service Name: your database SID or service name

Select Test to verify the connection. If the test succeeds, select Connect.

Running SQL Queries

After you connect, use the SQL Worksheet to run queries.

Example: List all tables

SELECT table_name FROM user_tables ORDER BY table_name;

Select the Run Statement button (green play icon) or press Ctrl + Enter to execute a statement.

Example: Check database version

SELECT * FROM v$version;

Example: Show database users

SELECT username, account_status FROM dba_users ORDER BY username;

Additional Features

Export data: Right-click a table in the Connections tree and select Export. Choose your format (CSV, Excel, SQL Insert, and others).

Generate DDL scripts: Right-click a database object and select Quick DDL to view the CREATE statement.

Data modeling: Go to File > Data Modeler > Import > Data Dictionary, then select your connection and the objects to model.

Database administration: Go to View > DBA to open the DBA panel, then add a connection to access administration features.

Server Components

Component Version

SQL Developer Latest

Java Runtime Included

Filesystem Layout

Drive Description

C:\ System drive with Windows and SQL Developer installation

Key directories:

Directory Purpose

C:\Program Files\sqldeveloper SQL Developer installation

C:\Users\Administrator\AppData\Roaming\SQL Developer User preferences and connections

C:\Users\Administrator\Documents Default location for exported files

Troubleshooting

SQL Developer does not launch

  • Verify that Java is installed. Open Command Prompt and run java -version.
  • Check Windows Event Viewer for application errors.
  • Try running SQL Developer from the installation directory.

Cannot connect to Oracle database

  • Verify that the database hostname and port are correct.
  • Check that the database security group allows connections on port 1521 from this instance.
  • Verify that the SID or Service Name is correct.
  • Test network connectivity with telnet <db-host> 1521.
  • Ensure the Oracle Listener is running on the database server.

Connection times out

  • Check network connectivity between the SQL Developer instance and the database.
  • Verify that both instances are in the same VPC or have proper routing.
  • Check the security group rules on the database side.

Cannot connect via RDP

  • Verify that the instance has passed 2/2 status checks.
  • Check that your security group allows port 3389 from your IP address.
  • Wait up to 15 minutes for the Windows password to become available.

Security Recommendations

  • Change the Administrator password after your first login.
  • Restrict RDP access. Allow port 3389 only from your specific IP address.
  • Do not store database passwords in saved connections unless they are encrypted.
  • Use SSH tunnels to connect to databases across networks.
  • Launch in the same VPC as your database instances for secure, private connectivity.
  • Enable Windows Update. Keep the OS patched with the latest security updates.
  • Consider a VPN. For regular access, connect through a VPN rather than exposing RDP directly.

Support

For help with this image, contact SecureAnyCloud support:

  • Email: sales@secureanycloud.com
  • Website: secureanycloud.com
  • Support hours: 24/7 with a guaranteed 24-hour response SLA

Deploy on AWS

Launch SQL Developer with 24/7 support from SecureAnyCloud.

View this image

Need Help?

Our support team is available 24/7.

sales@secureanycloud.com