Oracle Cloud: Configuring the Load Balancer and attaching it to the instance pool

In the previous blog post I explained the creation and configuration of the instance pool and autoscaling configuration.

If you run farm from the web server and the application server, you should route the client accesses to these servers via a load balancer. The load balancer receives the client requests and distributes them within the server pool.

In this blog post I am going to describe how to create and configure a load balancer and associate it with the instance pool. For the creation of the instance pool and autoscaling configuration please refer to my post How to configure and check the autoscaling of compute nodes in the Oracle Cloud Infrastructure (OCI)

Now we will provision the load balancer in the OCI.

Weiterlesen „Oracle Cloud: Configuring the Load Balancer and attaching it to the instance pool“

How to configure and check the autoscaling of compute nodes in the Oracle Cloud Infrastructure (OCI)

In this blog post I am going to explain the provisioning of the compute pool node with autoscaling configuration. I have already created the VM instance-bne and installed the Nginx web server in the VM.

During the provisioning of the Linux VM I added the Cloud-Init script as the advanced option that executes the installation and configuration of the Nginx webserver in my vm:

#cloud-config

package_update: false
packages:
  - nginx
runcmd:
 - systemctl enable nginx
 - systemctl start nginx
 - firewall-offline-cmd --add-service=http
 - systemctl restart firewalld
Weiterlesen „How to configure and check the autoscaling of compute nodes in the Oracle Cloud Infrastructure (OCI)“

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“

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“

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“

Extend Filesystem /u01 on an Exadata ComputeNode

Do you know the problem: an Exadata does not have enough space in filesystem /u01? The Exadata has the locale storage and you can increase /u01.

Steps:

1. Check filesystem and associated volume:

[root@myexadb01]# df -h

Filesystem                      Size    Used    Avail    Use%    Mounted on
/dev/mapper/VGExaDb-LVDbSys1     30G    23G    5.7G    80%    /
tmpfs                           757G    4.0K    757G    1%    /dev/shm
/dev/sda1                       488M    48M    405M    11%    /boot
/dev/mapper/VGExaDb-LVDbOra1    158G    107G    43G    72%    /u01

Check the free space in the volume group:

[root@myexadb01]# pvs
PV         VG        Fmt    Attr    PSize    PFree
/dev/sda2    VGExaDb   lvm2   a—u     1.63t    1.38t

Weiterlesen „Extend Filesystem /u01 on an Exadata ComputeNode“