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

Datastore Runtime

  • DSMAIN_DATA - 1 GB minimum size
    To avoid storage problems in Datastore, make sure that you use the following tablespace definitions:
    32K block size
    1 GB to 10 GB as extent value (10% of regular injected file size)
  • DSMAIN_INDEX - 1GB minimum size
    To avoid storage problems in Datastore, make sure that you use the following tablespace definitions:
    1 GB to 10 GB as extent value (10% of regular injected file size)
  • DSMAIN_LOB - 1 GB minimum size
  • DSCACHE_DATA - 1 GB minimum size
  • DSCACHE_INDEX - 1 GB minimum size
  • DSCACHE_LOB - 1 GB minimum size
  • DSMETA - 1 GB minimum size

Datastore Client

  • AIS_DATA_WORK* - 512 MB minimum size
  • AIS_INDEX_WORK - 512 MB minimum size
  • AIS_LOB_WORK - 512 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

The Oracle database for Datastore Runtime must be created with a single byte character set such as WE8ISO8859P15 or WE8MSWIN1252.

Caution   UTF-8 and UTF-16 encoding are not supported since they are not single byte character sets.

User information

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

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

Datastore Client one user

Default Oracle user name

DatastoreClient (The user can change the name during installation)

Permissions needed

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

Default Oracle tablespace

AIS_DATA_WORK

Datastore Client two users

Default Oracle user name User must be granted these permissions Default Oracle tablespace
Administrator: AISClient (The user can change the name during installation) create session, create procedure, create table, create view, create type, create sequence, create trigger AIS_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 AIS_DATA_WORK

Datastore Runtime

Default Oracle user name User must be granted these permissions Default Oracle tablespace
DSMAIN (User specifies the same name during installation)
  • create session, create table, create view, create procedure, create sequence
  • permission and quota on DSMETA, DSMAIN_DATA, DSMAIN_INDEX, DSMAIN_LOB tablespaces

The following java permissions must be granted using the DBMS_JAVA package:

  • Runtime permission:
    • Permission type: SYS:java.lang.RuntimePermission
    • Permission name: accessDeclaredMembers
  • Read write access on a set of database server folders to fully use the lifecycle management feature. See Enable the partition lifecycle functionality for more details.
DSMETA
DSCACHE (User specifies the same name during installation)
  • create session, create table, create view, create procedure, create sequence
  • permission and quota on DSMETA, DSCACHE_DATA, DSCACHE_INDEX, DSCACHE_LOB tablespaces
DSMETA
DSVIEW (User specifies the same name during installation)
  • create session, create table, create view, create procedure, create sequence
  • permission and quota on DSMETA tablespace
DSMETA
DSEXTENSION (User specifies the same name during installation)
  • create session, create table, create view, create procedure, create sequence
  • permission and quota on DSMETA tablespace

DSMETA

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):

  • Datastore Runtime
  • Datastore Client
  • 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