Oracle Database 19c Standard Edition (Oracle Linux 9) by metabloc

Welcome to your Oracle Database 19c Standard Edition deployment solution by metabloc. This stack was designed to be as streamlined as possible, with the least number of steps required to get you up and running quickly. Please follow the directions closely to ensure success. It is recommended to get the product you purchased running per this documentation first. Then you have the option to customize your solution to your requirements.

These instructions for our stack assume the following:

·        Basic understanding of the AWS console

·        Intermediate skill level and/or experience with Oracle Linux and Oracle database

·        Remote access SSH client, such as Putty, and how to create a ppk file from an AWS PEM file. These credentials will allow you to connect to your new EC2 instance in your AWS availability zone

Preinstalled Software

·        Oracle Linux 9.6

·        Oracle Database 19c Standard Edition 19.3

·        Oracle REST Data Services 23.1

·        Oracle SQLcl 24.4.1

·        Oracle APEX 24.2

·        JDK 21.0.5

License

Use of this software deployment solution requires an existing license for Oracle Database 19c Standard Edition for the number of CPUs in the EC2 instance.

Getting Started

Connect to your EC2 Instance using an SSH Client such as putty, as the ec2-user. More information about how to do this is here:

https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/connect-linux-inst-from-windows.html

Configuration Information

  Oracle Home                     : /opt/oracle/product/19c/dbhome_1
  ORDS/SQLDeveloper Web           : http://[EC2 Instance IP]:8080/ords/sql-developer
  APEX                            : http://[EC2 Instance IP]:8080/ords
  SQLcl                           : localhost:1521/orclpdb1

 

 

Database Information

    Oracle SID         : orcl
    Pluggable DB       : orclpdb1

Database Access

Operating System authentication with the oracle Linux user is enabled. Use this account to reset the SYS, SYSTEM, and any other database accounts.

Sample schemas have been preloaded in the orclpdb1 database (HR, HRREST, CO, SH).

The precreated PDB orclpdb1 database and CDB orclcdb1 can be accessed using the sqlcl client on the EC2 instance, the SQL Developer Web client, or using an Oracle client such as SQL Developer on your PC or another EC2 Instance. Ensure TCP Port 1521 is enabled in your AWS Security Group configuration to allow this connection.

To connect from the sqlcl client, on your SSH client, switch to the oracle user 

sudo su - oracle

Use SQLcl to connect to the precreated orclcdb1 container database as sysdba and switch to the orclpdb1 pluggable database:

sql / as sysdba
SQL> alter session set container = orclpdb1;

To reset any database user passwords, use the following:

SQL> alter user [username] identified by "[newpassword]" account unlock;

SQLcl access to the precreated PDB orclpdb1 from a terminal window

sql hr/[password]@localhost:1521/orclpdb1

SQLcl access to the CDB orcl 

sql system/[password]@localhost:1521/orcl

 

From a web browser:

 

Ensure TCP Port 8080 is enabled in your AWS Security Group configuration to allow connection from your web browser’s IP address.

 

APEX Application Information

To manage the APEX instance, visit http://[EC2 Instance IP]:8080/ords/apex, scroll to the bottom of the APEX Builder login page and click the Administration link to sign in to Administration Services with the ADMIN user.

Connect to the orclpdb1 pluggable database to reset the ADMIN Apex user password with the apxchange.sql script.

From your SSH client, switch to the oracle user 

sudo su - oracle

Connect to the orcl container database and switch to the orclpdb1 pluggable database, and run the APEX password change script apxchpwd.sql:

sql / as sysdba
SQL> alter session set container = orclpdb1;
SQL> @/home/oracle/apex/apxchpwd.sql

The APEX directory is /home/oracle/apex and APEX Images directory /home/oracle/apex_images.

The ORDS  directory is /home/oracle/ords and ORDS config directory /home/oracle/ords_config

 

AWS Elastic IP Address Allocation

 

It is strongly recommended that you create an AWS elastic IP address associated to this new EC2 build instance. This will allow you to start and stop without having to update the public IP address connection information.

 

 

A screenshot of a computer AI-generated content may be incorrect.

 

AWS Public IP Address Setting

 

A screenshot of a computer AI-generated content may be incorrect.

 

AWS Security Group Configuration

Enable SSH, HTTP, HTTPS and SQL*Net from your client IP to the EC2 Instance IP

  
  SSH          : 22:22
  HTTPS        : 443:443
  HTTP         : 80:80
  HTTP         : 8080:8080
  SQL*Net      : 1521:1521