SecureAnyCloud
Deployment guide

Oracle Database Client 19c on Windows

Overview

Oracle Database Client 19c provides the tools and libraries you need to connect to and manage remote Oracle Database instances from Windows. It includes SQL*Plus, Oracle Net and other client utilities, without requiring a full database installation.

This guide covers deploying and configuring Oracle Database Client 19c on Windows Server with the SecureAnyCloud AMI from AWS Marketplace.

What you get:

  • Oracle Database Client 19c installed on Windows Server.
  • SQL*Plus for connecting to remote Oracle databases.
  • Oracle Net Configuration utilities.
  • 24/7 SecureAnyCloud support with a guaranteed 24-hour response SLA.

Prerequisites

Before you launch this AMI, make sure you have:

  • An active AWS account.
  • An active subscription to the Oracle Database Client 19c on Windows listing on AWS Marketplace.
  • An EC2 key pair for decrypting the Windows Administrator password.
  • A Remote Desktop (RDP) client application.
  • The hostname, port and service name of the Oracle Database you want to connect to.

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

1

Launch the AMI

  • Go to AWS Marketplace and search for "Oracle Database Client 19c Windows SecureAnyCloud".
  • Choose Continue to Subscribe, accept the terms, then choose Continue to Configuration.
  • Select your preferred Region and Software Version.
  • Choose Continue to Launch.
  • Choose Launch through EC2 for full control over instance configuration.
  • Select your instance type (t3.small is recommended).
  • Configure storage: 30 GB gp3 minimum.
  • Configure your Security Group with the following inbound rules:

Port Protocol Source Purpose

3389 TCP Your IP Remote Desktop (RDP) access

Important: Restrict RDP access to your IP or trusted networks only. Do not open port 3389 to the public internet.

Select your EC2 key pair and launch the instance.

2

Retrieve the Administrator password

  • Wait for the instance to reach 2/2 status checks and the Running state.
  • In the EC2 Console, select your instance.
  • Choose Actions > Security > Get Windows password.
  • Choose Browse and upload the key pair (.pem file) you selected during launch.
  • Choose Decrypt password.
  • Copy the decrypted Administrator password.

Important: The Windows password can take up to 15 minutes after launch to become available. If a message says the password is not yet available, wait and try again.

3

Connect with Remote Desktop (RDP)

  • Open your Remote Desktop client application.
  • Enter the public IP address of your EC2 instance as the PC name.
  • Choose Add or Connect.
  • When prompted for credentials, enter:
  • Username: Administrator
  • Password: the decrypted password from the previous step.
  • If a certificate warning appears, accept it and choose Continue.

The Windows Server desktop opens with the Oracle Client utilities available.

4

Connect to a remote database with SQL*Plus

Open a Command Prompt and connect to your remote Oracle Database:

sqlplus system/password@(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=your-db-host)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=your-service-name)))

Replace system, password, your-db-host and your-service-name with your actual database connection details.

Server Components

Component Version

Oracle Database Client 19c 19.3.0.0.0

Windows Server See AMI description

Filesystem Layout

Drive Description

C: System drive with Windows Server and Oracle Client installation

Managing the Oracle Client

The Oracle Client is a set of tools and libraries, not a running service, so there are no services to start or stop. Open a Command Prompt or use the desktop shortcuts to access the Oracle Client utilities.

Troubleshooting

Cannot connect over RDP

  • Verify the instance has reached 2/2 status checks in the EC2 console.
  • Confirm your security group allows inbound TCP port 3389 from your IP.
  • Make sure you are using the correct Administrator password. Decrypt it again if needed.
  • Wait at least 15 minutes after launch for the password to become available.

SQL*Plus cannot connect to the remote database

  • Verify the target database is running and accepting connections.
  • Check that the hostname, port and service name are correct.
  • Make sure the security group of the target database allows inbound port 1521 from this client instance.
  • Test network connectivity from Command Prompt: telnet your-db-host 1521

ORA-12541: TNS:no listener

  • The target database listener is not running. Contact the database administrator.
  • Verify that the hostname and port are correct in your connection string.

ORA-12514: TNS:listener does not currently know of service

  • The service name in your connection string does not match the target database. Verify the correct service name with the database administrator.

Security Recommendations

  • Restrict RDP access. Allow port 3389 only from trusted IP addresses.
  • Change the Administrator password. Update the default Windows password after first login.
  • Secure credentials. Never store database passwords in plain-text files.
  • Encrypt connections. Configure Oracle Net Services to use SSL/TLS encryption.
  • Keep the system updated. Apply Windows Updates regularly.

Support

If you run into any issues with this product, 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 Oracle Database Client 19c on Windows with 24/7 support from SecureAnyCloud.

View this image

Need Help?

Our support team is available 24/7.

sales@secureanycloud.com