Oracle Database 21c XE on OEL 7
Overview
Oracle Database 21c Express Edition (XE) is a free, preconfigured Oracle database for development and small workloads. This guide covers deploying and configuring it on OEL 7 from the SecureAnyCloud AMI on AWS Marketplace.
What you get:
- Oracle Database 21c XE (version 21.3), preconfigured with a sample database instance
- The Oracle XE database service, configured to start on boot
- The sqlplus command-line tool for database administration
- AWS CLI v2
- Systems Manager Agent (SSM) for remote management
- CloudWatch Agent for monitoring
- Latest security patches applied at build time
- 24/7 SecureAnyCloud support with guaranteed 24 hour response SLA
Prerequisites
Before you launch, make sure you have:
- An active AWS account
- An active subscription to the Oracle Database 21c XE on OEL 7 listing on AWS Marketplace
- An EC2 key pair in your target region
Recommended instance type: t3.medium (2 vCPU, 4 GB RAM)
Minimum requirements: 1 vCPU, 1 GB RAM, 20 GB disk space
Security Group Configuration
Configure these inbound rules:
- 22 (TCP), source your IP: SSH access
- 1521 (TCP), source your IP: Oracle Database Listener
Launch the Instance
- Search for "Oracle Database 21c XE OEL SecureAnyCloud" on AWS Marketplace.
- Click Continue to Subscribe, accept the terms, then click Continue to Configuration.
- Select your Region and click Continue to Launch.
- Choose Launch through EC2, then select the instance type and storage.
- Configure the security group, select your key pair, and launch the instance.
Connect via SSH
When your instance passes 2/2 status checks, connect over SSH:
ssh -i your-key.pem ec2-user@<PUBLIC_IP>If you need root, switch to it:
sudo su -Note: Wait for 2/2 status checks before you connect.
Using Oracle Database XE
The Oracle XE database service is preconfigured to start on boot. Manage the database with these commands.
Check the database service status:
sudo su - systemctl status oracle-xe-21cStop and start the database service:
systemctl stop oracle-xe-21c
systemctl start oracle-xe-21cConnect to the database with sqlplus:
sudo su - oracle sqlplus / as sysdbaCredentials: The randomly generated SYSTEM user password is in /stage/scripts/oracle-database-xe-config.log.
External connections (SQL Developer and similar tools): Use the instance public IP, port 1521 and service name XE.
On Startup
An OS update script runs on first boot. To disable it, run:
sudo rm -f /stage/scripts/initial_boot_update.sh
sudo crontab -e
# Remove the @reboot lineFilesystem Configuration
The image uses these mount points:
- /: root filesystem
- /boot: operating system kernel files
- /opt/oracle: Oracle software installation directory
Server Components
The image installs one component:
- Oracle Database 21c XE 21.3: installed at /opt/oracle
Scripts and Log Files
Scripts and logs, with their locations:
- initial_boot_update.sh (/stage/scripts): updates the OS with the latest packages
- initial_boot_update.log (/stage/scripts): output log for the boot update script
- oracle-database-xe-config.log (/stage/scripts): Oracle Database user credentials
Troubleshooting
You cannot connect over SSH
- Wait for the 2/2 status checks to pass.
- Verify that the security group allows port 22 from your IP.
- Check that you are using the correct key pair and connecting as
ec2-user.
The database service is not running
- Check the status:
systemctl status oracle-xe-21c - Start the service:
systemctl start oracle-xe-21c - View the logs:
journalctl -u oracle-xe-21c -f
You cannot connect to the database remotely
- Make sure the security group allows port 1521 from your IP.
- Confirm that the Oracle Listener is running by checking the service status.
- Verify that the service name in your connection settings is
XE.
Support
- Email: sales@secureanycloud.com
- Response time: 24/7 with guaranteed 24 hour response SLA
- Website: https://secureanycloud.com
Deploy on AWS
Launch Oracle Database 21c XE on OEL 7 with 24/7 support from SecureAnyCloud.
View on Marketplace
Need Help?
Our support team is available 24/7.
sales@secureanycloud.com