Part 2: Create the Oracle APEX Database in Amazon Relation Data Service (RDS)

This is the second part of my blog series about the installation and configuration an APEX database in the Amazon Cloud. Refer to following posts for the explanation of the whole solution:

Create the Virtual Private Cloud (Network) in AWS

At first, I will create my customer network in AWS.

In the AWS Console navigate to VPC and click on „Create VPC“. Specify the IPv4 IP Range (CIDR Block) and try „Create“:

Weiterlesen „Part 2: Create the Oracle APEX Database in Amazon Relation Data Service (RDS)“

Create Oracle APEX Environment in the Amazon Cloud with RDS: Part 1 – Overview

In this article I will describe the installation of APEX Environment in Amazon Web Service (AWS).

The whole environment includes following components:

  • AWS RDS: Oracle Database with activated APEX
  • VM (EC2 Container) with:
    • Oracle Rest Data Service (ORDS)
    • Apache Tomcat for the Hosting of the ORDS
    • Nginx: http Server

The major challenge is to install APEX without SYSDBA privilege, because the Oracle Database in the RDS is Vendor-Managed. Users cannot access the OS and do not have the database DBA role.

Blue Print of the APEX environment in the AWS:

In my next Posts I will cover the following topics:

Part 2: Create the APEX Database in Amazon Relation Data Service (RDS)

Part 3: Configure APEX with Oracle Rest Data Service (ORDS) in the new EC2 Container

Part 4: Configuration APEX with ORDS, Apache-Tomcat und Nginx

Part 3: Configure APEX with Oracle Rest Data Service (ORDS) in the new EC2 Container

In my previous blog posts, I have described how to create the customer Oracle Database in the RDS with APEX Component:

In this post, I will explain the configuration of Middleware components needed to present apex content in web. We will build the separate VM (EC2 Container) in AWS and configure following components: ORDS, Apache Tomcat und Nginx Server.

Installing and Configuring the VM for the APEX Listener

Create EC2 Container for the APEX:

Weiterlesen „Part 3: Configure APEX with Oracle Rest Data Service (ORDS) in the new EC2 Container“

Exadata: OS performance analyzing via ExaWatcher

The operating system statistics are collected in the Exadata environment using the tool ExaWatcher automatically. You can generate statistics reports over a certain time as user root:

The following example generates the report for the period from 09/24/2018 till 09/26/2018:

cd /opt/oracle.ExaWatcher

./GetExaWatcherResults.sh –from 09/24/2018_00:00:00 –to 09/26/2018_23:59:59

Results will be generated as the BZIP2 Archive in the directory /opt/oracle.ExaWatcher/archive/ExtractedResults.

The results can be analyzed very simple via Browser. You can unpack the archive, go to the directory and see separate directories for the different statistics:

Weiterlesen „Exadata: OS performance analyzing via ExaWatcher“

Change the security settings on Exadata with the script host_access_control

About three months ago I found a script named host_access_control.

The script provides the API to managing several host access and security settings. The script is available on Compute Nodes and Storage Cells since the Exadata Software Version 11.2.3.3.0. The utility is located in /opt/oracle.cellos/host_access_control. The script is not documented in the Exadata Documentation, but in the Super Cluster documentation.

The script called with the Option „-h“ displays the help:

Weiterlesen „Change the security settings on Exadata with the script host_access_control“