Overview
SQL*Plus Version (Patched DBRU)
SQL*Plus -V client version output confirming the Oracle Database installation patched to current Database Release Update.
SQL*Plus Version (Patched DBRU)
Oracle Listener Status Port 1521
Sample SQL Query
This is a repackaged open source software product wherein additional charges apply for cloudimg support services.
Oracle Database is the world's most widely deployed relational database, powering mission-critical enterprise applications across industries. This listing delivers Oracle Database fully installed and configured, so a production-grade database is running within minutes of launch.
Choose Your Variant This listing is a family of Oracle Database AMIs on Oracle Linux 8; launch the AMI that matches your requirement. Oracle Database 19c is the Long Term Support release, recommended for long-term production; Oracle Database 21c is the Innovation Release, for applications certified against 21c. Standard Edition 2 suits departmental workloads and the SE2 licence model, while Enterprise Edition unlocks Partitioning, Advanced Compression, Advanced Replication and the full EE option set for demanding production workloads. Storage comes in two forms: a filesystem layout on a dedicated EBS data volume that is simple to operate and resize, or Automatic Storage Management (ASM) on Enterprise Edition, where single-instance Grid Infrastructure (Oracle Restart) manages +DATA and +RECO disk groups across raw EBS volumes for operational parity with on-premises ASM estates (asmcmd, srvctl, multi-volume IOPS striping, online storage management). The 21c ASM variant ships as a multitenant container database (ORCL) with a pluggable database (ORCLPDB).
What Is Included Oracle Database installed from upstream Oracle media, with a starter database and the SQL*Plus command-line client, and the Oracle listener on port 1521 preconfigured. The database storage tier lives on dedicated EBS volumes so it is independently resizable without touching the OS disk. Long Term Support variants are patched to the current Database Release Update for their release series.
Secure First Boot The image ships with no shared credentials. On the first boot of every instance, a one-shot service generates strong random passwords for SYSTEM and SYS (and ASMSNMP on ASM variants), sets them on the running database, and writes them to a file readable only by the root user. Authentication is enforced from the moment the listener is reachable.
Ready To Use Connect via SSH, retrieve the generated credentials from /root/oracle-db-credentials.txt, and open SQL*Plus or point your JDBC driver at port 1521. The database is open and the listener is serving immediately after first boot completes. SQL Developer and other JDBC clients can connect remotely on port 1521.
cloudimg Support 24/7 technical support by email. Help with Oracle Database deployment, tuning, backup and recovery, and migration.
Highlights
- Multiple AMI variants on one listing: Oracle Database 19c (Long Term Support) or 21c (Innovation Release), Standard Edition 2 or Enterprise Edition, on filesystem storage or Automatic Storage Management with Grid Infrastructure; launch the AMI that matches your requirement
- Per-instance first boot generates strong random passwords for SYSTEM, SYS (and ASMSNMP on ASM variants) and writes them to a root-only credentials file, so the database is never left with default or shared credentials
- 24/7 technical support from cloudimg, with expert assistance for Oracle Database deployment, performance tuning, backup and recovery, and cloud migration
Introducing multi-product solutions
You can now purchase comprehensive solutions tailored to use cases and industries.
Features and programs
Financing for AWS Marketplace purchases
Pricing
Free trial
- ...
Dimension | Description | Cost/hour |
|---|---|---|
m5.xlarge Recommended | m5.xlarge | $0.08 |
t3.micro | t3.micro instance type | $0.04 |
t2.micro | t2.micro instance type | $0.04 |
c6in.metal | c6in.metal instance type | $0.24 |
i7i.metal-48xl | i7i.metal-48xl instance type | $0.24 |
m6idn.2xlarge | m6idn.2xlarge instance type | $0.24 |
m8i-flex.4xlarge | m8i-flex.4xlarge instance type | $0.24 |
x2iedn.xlarge | x2iedn.xlarge instance type | $0.12 |
r7i.8xlarge | r7i.8xlarge instance type | $0.24 |
i3.2xlarge | i3.2xlarge instance type | $0.24 |
Vendor refund policy
Refunds available on request.
How can we make this page better?
Legal
Vendor terms and conditions
Content disclaimer
Delivery details
64-bit (x86) Amazon Machine Image (AMI)
Amazon Machine Image (AMI)
An AMI is a virtual image that provides the information required to launch an instance. Amazon EC2 (Elastic Compute Cloud) instances are virtual servers on which you can run your applications and workloads, offering varying combinations of CPU, memory, storage, and networking resources. You can launch as many instances from as many different AMIs as you need.
Version release notes
Initial release of Oracle Database 21c Enterprise Edition (Innovation Release) with Automatic Storage Management (ASM) on Oracle Linux 8. Datafiles on +DATA, fast recovery area on +RECO, managed by single-instance Grid Infrastructure (Oracle Restart).
Additional details
Usage instructions
Connect via SSH on port 22 as ec2-user. Retrieve the database credentials with: sudo cat /root/oracle-db-credentials.txt. Switch to the oracle user: sudo su - oracle. Source the environment: . ~/setEnv.sh. Connect with SQL*Plus to the CDB root: sqlplus system/<password>@localhost:1521/ORCL, or to the pluggable database where application schemas live: sqlplus system/<password>@localhost:1521/ORCLPDB. Connect as SYSDBA: sqlplus / as sysdba. Inspect ASM as the grid user: sudo su - grid, then asmcmd lsdg to list the +DATA and +RECO disk groups. The Oracle listener runs on port 1521 and accepts remote SQL Developer / JDBC connections. The user guide explains how to connect remotely, manage the listener, inspect and manage ASM disk groups, configure backup to +RECO, use Enterprise Edition options (Partitioning, Data Guard), and tune memory.
Resources
Vendor resources
Support
Vendor support
cloudimg provides 24/7 technical support for this product by email and live chat. Our engineers help with deployment, configuration, updates, performance tuning and troubleshooting; critical issues receive a one hour average response. Contact support@cloudimg.co.uk .
AWS infrastructure support
AWS Support is a one-on-one, fast-response support channel that is staffed 24x7x365 with experienced and technical support engineers. The service helps customers of all sizes and technical abilities to successfully utilize the products and features provided by Amazon Web Services.