PROCESSIT Database Installation

Introduction Typographic conventions Recommendations Install PROCESSIT Database Installation Package Download Installation Package Login Confirm Swap space Create Oracle user and folder Create user oracle Create the Oracle folder Oracle folder ownership Prepare install files Move install package to server Unzip install package Test the network Yum installer Yum install Xhost Display test Verify that the hostname in hosts file Installation Steps Change user Start the Database installation Configure Security Updates Email address not specified Download Software Updates Select Installation Option System Class Node Selection Select Install Type Select Product Language Select Database Edition Specify Installation Location Create Inventory Select Configuration Type Specify Database Identifiers Specify Configuration Options Specify Management Options Specify Database Storage Options Specify Recovery Options Specify Schema Passwords Privileged Operating System Groups Perform Prerequisite Checks Summary Database Configuration Assistant Execute Configuration Scripts Finish /etc/oratab Set Environment Variables Check the ORACLE_HOME Start up the database Verify the database started Optional - Enterprise Manager Starting Enterprise Manager dbconsole Verify Enterprise Manager Status Accessing Enterprise Manager

Introduction

This document covers the installation of Oracle Db11g for ReadSoft PROCESSIT. The installation procedure is chronological, so each step should be performed in the sequence appearing in this document.

For details regarding PROCESSIT workflow installation, please refer to the standard PROCESSIT installation guide.

PROCESSIT uses Oracle BPEL Process Manager (a component of Oracle SOA Suite) 11.1.1.7 patched to the latest level.

Typographic conventions

Please note that all commands that should be typed are presented like this.

Recommendations

If installing on VMware we recommend that you take snapshots at various points throughout the installations to avoid restarting if something goes wrong.

Install PROCESSIT Database

Installation Package

Download Installation Package

Download p13390677_11204_Linux-x86-64_1of7.zip and p13390677_11204_Linux-x86-64_2of7.zip from the ReadSoft FTP Server.

Login

Confirm Swap space

cat /proc/swaps 10 GB swap space is required (accumulated on all partitions).

Create Oracle user and folder

Create user oracle

useradd oracle

passwd [password]

groupadd oinstall

groupadd dba

usermod -a -G oinstall,dba oracle

Create the Oracle folder

mkdir -p /oracle/Stage

Oracle folder ownership

chown -R oracle:oracle /oracle

Prepare install files

Move install package to server

Move p13390677_11204_Linux-x86-64_1of7.zip and p13390677_11204_Linux-x86-64_2of7.zip to a directory on the DB server. It is recommended to place them in /oracle/Stage/db_install

Unzip install package

Unzip the two files:

gunzip p13390677_11204_Linux-x86-64_1of7.zip
gunzip p13390677_11204_Linux-x86-64_2of7.zip

Test the network

Ping www.oracle.com

Yum installer

Open a new terminal on the server as root

cd /etc/yum.repos.d

Yum install

yum install binutils.x86_64 -y -q

yum install compat-libcap1.x86_64 -y -q

yum install compat-libstdc++-33.x86_64 -y -q

yum install compat-libstdc++-33.i686 -y -q

yum install gcc.x86_64 -y -q

yum install gcc-c++.x86_64 -y -q

yum install glibc.x86_64 -y -q

yum install glibc.i686 -y -q

yum install glibc-devel.i686 -y -q

yum install libaio.x86_64 -y -q

yum install libaio-devel.x86_64 -y -q

yum install libgcc.x86_64 -y -q

yum install libstdc++.x86_64 -y -q

yum install libstdc++.i686 -y -q

yum install libstdc++-devel.x86_64 -y -q

yum install libXext.i686 -y -q

yum install libXtst.i686 -y -q

yum install openmotif.x86_64 -y -q

yum install openmotif22.x86_64 -y -q

yum install redhat-lsb.x86_64 -y -q

yum install sysstat.x86_64 -y -q

yum install xorg-x11-utils.x86_64 -y -q

Xhost

xhost +

Display test

Test the xclock application to see if the graphical interface is working. Press ctrl+c to stop the clock.

Verify that the hostname in hosts file

Verify the chosen hostname is available in the /etc/hosts as the first entry for the ip . Edit file if necessary.

cat /etc/hosts

Installation Steps

Change user

su - oracle

Start the Database installation

cd /oracle/Stage/db_install/database

./runInstaller

The database installer is shown.

Configure Security Updates

Remove the I wish checkmark.

Click Next

Email address not specified

Click Yes

Download Software Updates

Select Skip software updates

Click Next

Select Installation Option

Select Create and configure a database

Click Next

System Class

Select Server Class

Click Next

Node Selection

Select Single Instance Database Installation

Click Next

Select Install Type

Select Advanced install

Click Next

Select Product Language

Click Next

Select Database Edition

Select Enterprise Edition

Click Next

Specify Installation Location

Change the oracle base path: Oracle base = /oracle/db/

Click Next

Create Inventory

Change the Inventory Directory: Inventory Directory = /oracle/oraInventory

Select oinstall for the oraInventory Group Name

Click Next

Select Configuration Type

Select General Purpose/Transaction Processing

Click Next

Specify Database Identifiers

Enter the global database name, for instance PROCESSIT.

Ensure that the Oracle Service Identifier is equivalent.

Click Next

Specify Configuration Options

On the memory tab, check Enable Automatic Memory Management.

Change the Allocate Memory value to 4096

On the character sets tab, select Use Unicode

Click Next

Specify Management Options

Select Use Database Control for database management

Click Next

Specify Database Storage Options

Select File System

Change Specify database file location: /oracle/db/oradata

Click Next

Specify Recovery Options

Select Do not enable automatic backups

Click Next

Specify Schema Passwords

Select Use the same password for all accounts

Specify the password. This password is referenced as [password] in this document.

Confirm the password.

Privileged Operating System Groups

Confirm that the Database Administrator (OSDBA) Group is set to dba and the Database Operator (OSOPER) Group is set to oracle.

Click Next

Perform Prerequisite Checks

If any of the checks fail, click the Fix & Check Again button and follow directions

Click Check Again to repeat the check

Missing package pdksh-5.2.14 can be safely ignored

Once all the checks have passed, Click Next

If Ignore All was checked, Click Yes

Summary

Click Install. The installation begins.

Database Configuration Assistant

Click Ok.

Execute Configuration Scripts

Open a new terminal window and log in as root.
Run these scripts:
- sh /oracle/oraInventory/orainstRoot.sh
- sh /oracle/db//product/11.2.0/dbhome_1/root.sh
Press Enter to the full path for local bin dir. Or type /usr/local/bin
Return to the execute conf. ass. window.
Click Ok to continue.

Finish

Click Close to finish database installation.

/etc/oratab

Edit /etc/oratab such that the last item on the line for PROCESSIT is Y.

For example: PROCESSIT:/oracle/db/product/11.2.0/dbhome_1:Y

Set Environment Variables

. oraenv

Enter PROCESSIT .

Check the ORACLE_HOME

echo $ORACLE_HOME

Start up the database

dbstart $ORACLE_HOME

If any permission issues occur, go to SELinux Administration, select Status and set System Default Enforcing Mode and Current Enforcing Mode to permissive.

Verify the database started

sqlplus / as sysdba

SQL*Plus should connect to the running database

Optional - Enterprise Manager

Starting Enterprise Manager dbconsole

emctl start dbconsole

Verify Enterprise Manager Status

emctl status dbconsole

Accessing Enterprise Manager

Open a web browser and enter the following URL:

https://<hostname or ip>:1158/em

The Database Control Login page is displayed. Enter a username and password for a user that is authorized to access the Oracle Enterprise Manager Database Control. Click Login.