Oracle requisites

<< Click to Display Table of Contents >>

Navigation:  Automation Server > Automation Server configuration and administration guide > System prerequisites > Database server prerequisites >

Oracle requisites

Overview

Automation Server requires a database server for your processes repository.

Oracle database is supported for the database server configuration.

You need to install and set up an Oracle instance, ensuring you comply with the information below.

 

Supported versions and editions

The following are supported:

 

VERSION

Oracle 12c

Oracle 11g R2

 

Supported for Standard and Enterprise editions.

Express (XE) edition is not supported.

 

note_pin

Supported character sets for Oracle databases are both Unicode and non-Unicode. However,

Migrating Oracle databases to Unicode (from non-unicode character sets) is not supported.

For Unicode Oracle databases,

String attributes will hold a maximum of 1000 characters.

If you need more than 1000 characters, extended text attributes should be used.

 

Prerequisites and recommendations

When configuring your Oracle database:

 

1. If you are using archiving (enabling the Archive mode), we recommend you use two destinations for your archivelog.

 

2. We recommend using Automatic Shared Memory Management (ASMM configuration).

You need to assign a minimum of:

4 Giga bytes for SGA memory.

3 Giga bytes for PGA memory.

 

PGA_SGA

 

3. We recommend assigning a block size of at least 8000 bytes, and specifying a maximum of 300 processes.

 

Block_and_Processes

 

4. We recommend using 4 redo logs groups, each one of them assigned to use 3 Giga bytes.

 

note_pin

Note that the above recommendations are strictly the minimum prerequisites for your Oracle 11g instance.

Further sizing considerations will depend on your project's characteristics, and a detailed analysis to determine scalability and additional demands, is recommended.

 

When using an Oracle cluster (i.e, RAC), consider the usual recommendations as issued by Oracle, such as using a high speed network connection for Heartbeat purposes.

 

Verifying Oracle requisites

Carry out the next steps, to make sure that your Oracle instance is set to work with Bizagi.

 

Which version do I have?

To determine your version of an installed Oracle instance, connect to your database instance and run:

select * from v$version;

 

This query should display a supported Oracle version.

 

Required Bizagi user configuration

Once you are certain you have installed your Oracle instance while meeting the prerequisites, create a specific admin user for Bizagi (to initially create the database, to upgrade Bizagi's version and perform other tasks).

This user is called BizagiAdmon.

You need to create this user for Bizagi, in your Oracle instance by running a script.

 

Procedure

To create the user by running a SQL script, follow these instructions:

 

1. Connect to your Oracle instance as the sys user (sysdba)

 

ConnectSysdba

 

2. Edit the ConfigureInstanceForBizAgi-[Oracle_Version].sql. script

Locate the Bizagi installation path and browse into the Project model's database folder (by default at C:\Program Files\BizAgi\BizAgi Enterprise\ProjectModel\Database\).

For Oracle 11g R2, edit the script called ConfigureInstanceForBizAgi-11g.sql.

 

note_pin

The script has a .basql file extension.

In other to retrieve the actual script, rename this file extension to .zip and then extract its contents.

 

To edit the script, remove the comment lines that mark the following variables, and edit their values:

BA_TABLES_DATAFILES_DIR: Replace with the path to where you want to create the tablespaces datafiles.

BA_LOBS_DATAFILES_DIR: Replace with the path to where you want to create the datafiles holding Bizagi LOBS.

BA_INDEXES_DATAFILES_DIR: Replace with the path where you want to create the indexes datafiles.

BA_BACKUP_PATH: Replace with the path to where you want to store automatic backups.

BA_BIZAGIADMON_PASSWORD: Replace with the password for the BizagiAdmon user.

 

BizAgiAdmonScript

 

3. Run the script.

Run the edited script and make sure the operation completes successfully.

 

ExecuteBizAgiAdmon

 

note_pin

This script is subject to change in each Bizagi version.

Use the script that corresponds exactly to your installed version of Bizagi.

 

4. Configure the optimizer.

The following is applicable to Oracle version 12 and is a recommended guideline due to Oracle's report on BUG 21615091 (https://support.oracle.com/rs?type=bug&id=21615091).

Connect with a user with DBA rights (e.g, DBA, SYSTEM) and run the following script to configure the optimizer:

ALTER SYSTEM SET "_optimizer_reduce_groupby_key" = FALSE;