Deploying EMCC 13cR2 and 13cR3 on DBcs 12.2 and 18.2 Extreme Performance

This note is about deploying EMCC 13cR2 or 13cR3 on either OCI or OCI Classic with the database running on DBcs 12.2 or 18.2 Extreme Edition

Due to some improper validation being executed, the solution for this topology is first to install the software, apply a quickfix to support EE, then configure the OMS.

Database setup

#1 Provision the DBcs or dbsystem

Provision an emccdb DBcs with an emcc PDB running 12.2 or 18.2 with 2 OCPU/15GB, 100GB data.

#2 Setup the access rules to allow the compute hosting the OMS to connect to the database.

On OCI-c, create an IP security list for example emccdb_listener_client 10.29.0.0/16 (when 10.29.0.0 would be the private subnet)

On OCI-c, create a security rules to allow dblister access between the IP security list emccdb_listener_client and the security_list emccdb/db01/ora_db

On OCI, create an ingress rules to allow all traffic from 10.0.0.0/23

#3 Setup the PDB

Setup the PDB with the following parameters

ALTER SESSION SET CONTAINER=emcc;
ALTER SYSTEM SET "_allow_insert_with_update_check"=TRUE SCOPE=BOTH;
ALTER SYSTEM SET session_cached_cursors=500 SCOPE=SPFILE; 
ALTER PROFILE DEFAULT LIMIT password_verify_function null;
SHUTDOWN IMMEDIATE;
STARTUP;

OMS setup

#1 OMS provisioning

Provision a compute with 2 OCPUs, 15GB memory, and 100GB disk space

#2 Setup the oracle UNIX user

Create the oracle user. Use this note as a guideline.

Copy the private key to the oracle user to allow ssh directly to ssh.

#3 Increase system parameters

Set the following parameter

On Classic and OL6.9, in /etc/security/limits.conf
oracle soft nofile 1024
oracle hard nofile 65536

On OCI and OL75 in /etc/security/limits.d/30-nofile.conf
oracle soft nofile 1024
oracle hard nofile 65536

#4 Prepare the product home directories

mkdir -p /u01/app/oracle/product/gc133
mkdir -p /u01/app/oracle/product/emagent
mkdir -p /u01/app/oracle/product/library 
mkdir -p /u01/app/oracle/product/gc_bip/config 
mkdir -p /u01/app/oracle/product/gc_bip/cluster
mkdir -p /u01/app/oraInventory 
chown -R oracle:oinstall /u01/app/oracle
chown -R oracle:oinstall /u01/app/oraInventory

Note that if the purpose is to deploy EMCC in HA mode, at this point, a shared directory may have to be setup for the library and BI Publisher

#5 Create the file /etc/oraInst.loc

Create the file /etc/oraInst.loc with the following content, owned by oracle:oinstall

inventory_loc=/u01/app/oraInventory
inst_group=oinstall

#6 Download em13cR3

Download the emcc 13cR3 software. Use this note as a guideline.

#7 Install the system prereq

Classic OL6.9:
yum install make binutils gcc libaio glibc-common libstdc++ libXtst sysstat glibc-devel.i686 glibc-devel glibc

Classic OL7.4:
sudo yum install make binutils gcc libaio glibc-common libstdc++ sysstat glibc-devel.i686 glibc-devel libXtst xdpyinfo wget xorg-x11-xauth

OCI OL7.5: sudo yum install gcc glibc-devel glibc-devel.i686

#8 Generate the response file to prepare for a silent install

ssh -X oracle@<opchost>
chmod +x em13300_linux64.bin
./em13300_linux64.bin -getResponseFileTemplates -outputLoc /home/oracle

#9 Configure the installation file

Edit the file software_only.rsp

#10 Run the installer in silent mode

./em13300_linux64.bin -silent -responseFile /home/oracle/software_only.rsp

#11 Change the prereq checking files

Edit the file /u01/app/oracle/product/gcXXX/install/requisites/properties/stopPrereqOnDemand.properties and make sure that the following property is set to TRUE

id_check_db_is_enterprise_edition=TRUE

If install in interactive, the same would be achieved by downloading the following file for EMCC 13.2: p25679612_132000_Generic.zip

#12 Run the configuration assistant

/u01/app/oracle/product/gc132/sysman/install/ConfigureGC.sh

At this point, if getting any issue with the DISPLAY settings, check out this note.