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“

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“

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“

WebLogic Server 12.2.1.2.0: Installation on the Linux OEL 7: step by step instruction

Kategorie    Step by Step

Introduction

This post describes the installation of the WebLogic Server Version 12.2.1.2.0

The following tasks are performed and described:

  • 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

The installation will be proceeding on the Oracle Enterprise Linux 7.2: host03.example.com

Pre-installation Tasks

Weiterlesen „WebLogic Server 12.2.1.2.0: Installation on the Linux OEL 7: step by step instruction“