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

This blog entry is the third and last part of the series „Create APEX in AWS“. Here I describe the installation and configuration of Apache Tomcat and the deployment of the ORDS application in Tomcat. Later I will explain the installation of the Webserver Nginx and configure it to access APEX via Apache Tomcat and ORDS.

Information about the installation of the APEX application in AWS can be found here. The installation and configuration of Oracle Data rest service is described  here.

Installation Apache Tomcat on the EC2 Container

As root: Download and extract the software:

Weiterlesen „Part 4: Configure APEX with ORDS, Apache-Tomcat und Nginx“

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“

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“

Cloud Control: the Graph in the Performance Top Activity view shrinks to left

Some time I have the problem with the vies of the Top Activity Page in the Cloud Control:

The Graf shrink to left and you can see only the part of the picture:

Weiterlesen „Cloud Control: the Graph in the Performance Top Activity view shrinks to left“

KVM Virtualization on top of the vmware workstation 12 guest vm‘s

Kernel-based Virtual Machine (KVM) provides a possibility to use the Oracle (or Redhat/CentOS) Linux kernel as a hypervisor.

In my example, I will configure the KVM virtualization on top of the guest vm running OEL 7.4. The guest VM is running on top of the VMWare Workstation 12.

To enable the virtualization layer select VM settings and navigate to the Processor settings. Enable the setting „Virtualize Intel VT-x/EPT or AMD-V/RVI.“

The Guest VM is now enabled for the using of the nested virtualization (such kvm). Start the Guest VM.

Install and configure KVM virtualization on the OEL 7.4 Linux

Weiterlesen „KVM Virtualization on top of the vmware workstation 12 guest vm‘s“

Upgrade Grid Infrastructure 12.1 to 12.2 + Install the 2017 August Release Update (RU) on Exadata

Preface

This document describes the upgrade of the GI from 12.1 to 12.2 with installation of the RU August 2017.

The Exadata consists of:

  • Two db nodes: exadb1/exadb2
  • Three cell servers

The software release of Exadata components:

Infiniband Software version:    2.2.6-2 (Juli 2017)
Storage cells version:          12.2.1.1.2.170714
DB node versioin:               12.2.1.1.2.170714
GI Version:                     12.1.0.2.170418
RDBMS Version:                  12.1.0.2.170418

The order of the action:

  • Out of the place installation of the Grid Infrastructure 12.2 on all database servers
  • Installation RU Patch August 2017 on all database servers
  • Upgrade Gird Infrastructure to 12.2

Weiterlesen „Upgrade Grid Infrastructure 12.1 to 12.2 + Install the 2017 August Release Update (RU) on Exadata“

How to configure the WebLogic AdminServer for High Availability

Introduction

The high availability of applications in the WebLogic environment is realized by clustering. Managed servers in the cluster work together. The information about transactions is distributed cluster-wide. If a cluster member fails, another server takes over the tasks of the failed server and executes them. In this way, the applications are kept running without interruption.

The AdminServer is a single point of failure: if the server fails, the Domain is no longer administrable:

– Configuration changes cannot be performed

– The administration console is not available

The managed servers are still running and can continue to work, even if the AdminServer is not available: this requires the activation of MSI (Managed Server Independence) Mode.

How can the AdminSevrer be protected from failure? In this blogpost I will describe all the steps that are necessary to keep your server running safely.

Weiterlesen „How to configure the WebLogic AdminServer for High Availability“

Oracle Forms & Reports 12.2.1.2.0: Create and Configure on the OEL 7.2 Server

Introduction

This post focuses on the creation, configuration and tuning of an initial Forms & Reports 12.2.1.2.0 Domain on the OEL 7.2 Server.

The WebLogic Server is a necessary requirement, and must already be installed. For instruction how to install the WebLogic Server 12.2.1.2 please refer to my previous post: WebLogic Server 12.2.1.2.0: Installation on the Linux OEL 7: step by step instruction

The following tasks will be implemented:

  • Preparing the Operating System for the installation of the WebLogic Server 12.2.1.2, Installation JDK 1.8 and the WebLogic Server 12.2.1.2:
  • Creating of database schemas
  • Installing and Configuring a Forms & Reports Domain
  • Post-Installation Tasks:
    • Configuring of components
    • Creating of Start & Stop scripts for the automatic start/stop of components
  • Tuning and Troubleshooting

The Domain will be created on the one OEL 7.2 server: host03.example.com (IP 192.168.75.35)

Installation Forms & Reports 12.2.1.2

Weiterlesen „Oracle Forms & Reports 12.2.1.2.0: Create and Configure on the OEL 7.2 Server“