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.

Designer

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

InterPlay

  • IP_DATA_WORK* - 512 MB minimum size
  • IP_INDEX_WORK - 256 MB minimum size
  • IP_LOB_WORK - 256 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

User information

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

The following table lists the InterPlay 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

InterPlay one user

Default Oracle user name

InterPlay (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

InterPlay two users

Default Oracle user name Role User must be granted these permissions Default Oracle tablespace
Administrator: InterPlay (Name set by the user during installation) N/A create session, create procedure, create table, create view, create type, create sequence, create trigger, execute any procedure IP_DATA_WORK
Business: axway (Name can be changed by the user during installation) INTERPLAY_RW_ROLE (role and user must be created before installation - The administrator assigns the corresponding role to the user) create session, create synonym IP_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):

  • InterPlay
  • Report Server
  • Administration
  • 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