Oracle

Supported versions and editions

Axway products are supported with the following Oracle versions and editions:

Oracle 12c

  • Oracle 12.1.0.2 minimum supported version
  • Standard Edition One
  • Standard Edition
  • Enterprise Edition

Tablespace information

The following is a list with the default tablespaces supported by component and their minimum size. You should adapt the size according to your use case.

Designer

  • IP_DATA_WORK* - 512 MB minimum size
  • DES_INDEX_WORK - 256 MB minimum size
  • DES_LOB_WORK - 256 MB minimum size

Composer + AI Enabler

  • XD_DATA_WORK* - 512 MB minimum size
  • XD_INDEX_WORK - 200 MB minimum size
  • XD_LOB_WORK - 200 MB minimum size

Repository

  • AIS_DATA_WORK* - 512 MB minimum size
  • AIS_INDEX_WORK - 512 MB minimum size
  • AIS_LOB_WORK - 512 MB minimum size

Report Server

  • RS_DATA_WORK* - 512 MB minimum size
  • RS_INDEX_WORK - 512 MB minimum size
  • RS_LOB_WORK - 512 MB minimum size

Database information

In order to use multibyte characters in AccountingIntegrator Rule Engine, the Oracle database for Composer must be created with the AL32UTF8 character set.

User information

Note   You can personalize your Oracle user name and tablespace name during the component installation.

The following table lists the AccountingIntegrator components that support one or two users in Oracle.

To install the product correctly, you must have previously created the user or users as specified below. Users MUST BE DIFFERENT as the tablespaces are the same.

Designer

Default Oracle user name

Set by the user during installation

Permissions needed

Create session, create procedure, create table, create view, create type, create sequence, create trigger, execute any procedure

Default Oracle tablespace

IP_DATA_WORK

Composer + AI Enabler one user

Default Oracle user name

Composer

Permissions needed

Create view, create sequence, create session, create table, create trigger, create procedure

Default Oracle tablespace

XD_DATA_WORK

Composer + AI Enabler one user

Default Oracle user name User must be granted these permissions Default Oracle tablespace
Administrator: Composer (User specifies the same name during installation) create session, create procedure, create table, create view, create sequence, create trigger XD_DATA_WORK
Functional: FComposer (User specifies the same name during installation) create session XD_DATA_WORK
Note   the DSEXTENSION user is optional, because it is only used if certain SQL extensions have to be put in place. They are not necessary at installation time, but required when SQL extensions are setting up.

Repository one user

Default Oracle user name

AISRepository

Permissions needed

Create session, create view, create sequence, create table, create trigger, create procedure

Default Oracle tablespace

AIS_DATA_WORK

Repository two users

Default Oracle user name User must be granted these permissions Default Oracle tablespace
Administrator: AISuiteRepository (The user can change the name during installation) create session, create procedure, create table, create view, create sequence, create trigger AIS_DATA_WORK
Functional: axway (The user can change the name during installation) create session, create synonym AIS_DATA_WORK

Report Server one user

Default Oracle user name

REPORT_DB

Permissions needed

Create session, create view, create sequence, create table, create trigger, create procedure

Default Oracle tablespace

RS_DATA_WORK

Report Server - two users

Default Oracle user name User must be granted these permissions Default Oracle tablespace
Administrator: AISuiteRepository (The user can change the name during installation) create session, create procedure, create table, create view, create sequence, create trigger RS_DATA_WORK
Functional: axway (The user can change the name during installation) create session, create synonym, select any table, insert any table, update any table, delete any table RS_DATA_WORK
Note   During the product installation you will be asked to provide details about the user or users you previously created.

Oracle RAC support

The following components support Oracle RAC (Real Application Cluster) for 12c (12.1.0.1):

  • Composer and AI Enabler
  • Report Server
  • Administration
  • Rule Engine Server
  • Repository
  • Designer

Oracle Options

No Oracle options (Oracle JVM, Oracle XML DB, etc.) are necessary for installing Axway products except for Datastore that requires Oracle JVM.

Related Links