Databases

Oracle Database Client 19c on Windows User Guide

| Product: Oracle Database Client 19c on Windows

Overview

This guide covers the deployment and configuration of Oracle Database Client 19c on Windows Server using cloudimg AMIs from the AWS Marketplace. Oracle Database Client 19c provides the tools and libraries needed to connect to and manage remote Oracle Database instances from a Windows environment. It includes SQL*Plus, Oracle Net, and other client utilities without requiring a full database installation.

What's included in this AMI:

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

Prerequisites

Before launching this AMI, ensure you have:

  1. An active AWS account
  2. An active subscription to the Oracle Database Client 19c on Windows listing on AWS Marketplace
  3. An EC2 key pair for decrypting the Windows Administrator password
  4. A Remote Desktop (RDP) client application
  5. The hostname, port, and service name of the Oracle Database you wish 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 disk space.

Step 1: Launch the AMI

  1. Navigate to the AWS Marketplace and search for "Oracle Database Client 19c Windows cloudimg"
  2. Click Continue to Subscribe, accept the terms, then Continue to Configuration
  3. Select your preferred Region and Software Version
  4. Click Continue to Launch
  5. Choose Launch through EC2 for full control over instance configuration
  6. Select your instance type (t3.small recommended)
  7. Configure storage: 30 GB gp3 minimum
  8. 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.

  1. Select your EC2 key pair and launch the instance

Step 2: Retrieve the Administrator Password

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

Important: It may take up to 15 minutes after launch for the Windows password to become available. If you see a message indicating the password is not yet available, wait and try again.

Step 3: Connect via Remote Desktop (RDP)

  1. Open your Remote Desktop client application
  2. Enter the public IP address of your EC2 instance as the PC name
  3. Click Add or Connect
  4. When prompted for credentials, enter:
  5. Username: Administrator
  6. Password: The decrypted password from the previous step
  7. Accept the certificate warning if prompted and click Continue

You should now see the Windows Server desktop with Oracle Client utilities available.

Step 4: Connect to a Remote Database via 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. There are no services to start or stop. Simply open a Command Prompt or use the desktop shortcuts to access Oracle Client utilities.

Troubleshooting

Cannot connect via RDP

  1. Verify the instance has reached 2/2 status checks in the EC2 console
  2. Confirm your security group allows inbound TCP port 3389 from your IP
  3. Ensure you are using the correct Administrator password (re-decrypt if needed)
  4. Wait at least 15 minutes after launch for the password to become available

SQL*Plus cannot connect to remote database

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

ORA-12541: TNS:no listener

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

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

  1. 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: Only allow port 3389 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 encounter any issues with this product, contact cloudimg support:

  • Email: support@cloudimg.co.uk
  • Website: www.cloudimg.co.uk
  • Support hours: 24/7 with guaranteed 24 hour response SLA