Oracle

Supported versions and editions

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

Oracle 12c

  • Oracle 12.1
  • Oracle 12.2
  • 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

  • DES_DATA_WORK* - 512 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

DSCLIENT_DATA - 512 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

InterPlay

  • IP_DATA_WORK* - 512 MB minimum size
  • IP_INDEX_WORK - 256 MB minimum size

Repository

AIS_DATA_WORK* - 512 MB minimum size

Report Server

RS_DATA_WORK* - 512 MB minimum size

Tablespaces and users by product/component

The following are examples of scripts to create tablespaces and users by product/component. Your DBA should adapt them to your case before execution.

Composer

CREATE BIGFILE TABLESPACE XD_DATA_WORK

DATAFILE '<ora_path>/XD_DATA_WORK.dbf'

SIZE 512M AUTOEXTEND ON MAXSIZE 1G

NOLOGGING

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

 

CREATE BIGFILE TABLESPACE XD_LOB_WORK

DATAFILE '<ora_path>/XD_LOB_WORK.dbf'

SIZE 512M AUTOEXTEND ON MAXSIZE 1G

NOLOGGING

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

 

CREATE USER COMPOSERAIS IDENTIFIED BY COMPOSERAIS

DEFAULT TABLESPACE XD_DATA_WORK

TEMPORARY TABLESPACE TEMP

QUOTA UNLIMITED ON XD_DATA_WORK

QUOTA UNLIMITED ON XD_INDEX_WORK

QUOTA UNLIMITED ON XD_LOB_WORK

PROFILE DEFAULT

ACCOUNT UNLOCK;

 

GRANT CREATE SESSION TO COMPOSERAIS;

GRANT CREATE CLUSTER, CREATE INDEXTYPE, CREATE OPERATOR, CREATE PROCEDURE, CREATE SEQUENCE, CREATE TABLE, CREATE TRIGGER, CREATE TYPE TO COMPOSERAIS;

GRANT CREATE JOB, CREATE LIBRARY, CREATE SYNONYM, CREATE VIEW TO COMPOSERAIS;

Sentinel

CREATE TABLESPACE SNTL_DATA_WORK DATAFILE '<ora_path>/SNTL_DATA_WORK.DBF' SIZE 400M EXTENT MANAGEMENT LOCAL ONLINE SEGMENT SPACE MANAGEMENT AUTO

CREATE TABLESPACE SNTL_DICO_WORK DATAFILE '<ora_path>/SNTL_DICO_WORK.DBF' SIZE 200M EXTENT MANAGEMENT LOCAL ONLINE SEGMENT SPACE MANAGEMENT AUTO

CREATE TABLESPACE SNTL_INDEX_WORK DATAFILE '<ora_path>/SNTL_INDEX_WORK.DBF' SIZE 300M EXTENT MANAGEMENT LOCAL ONLINE SEGMENT SPACE MANAGEMENT AUTO

CREATE USER SENTINEL IDENTIFIED BY SENTINEL DEFAULT TABLESPACE SNTL_DATA_WORK;

GRANT connect TO SENTINEL;

GRANT resource TO SENTINEL;

GRANT alter session TO SENTINEL;

GRANT create database link TO SENTINEL;

GRANT create synonym TO SENTINEL;

GRANT create session TO SENTINEL;

GRANT create procedure TO SENTINEL;

GRANT create table TO SENTINEL;

GRANT create view TO SENTINEL;

GRANT create type TO SENTINEL;

GRANT create sequence TO SENTINEL;

GRANT create trigger TO SENTINEL;

GRANT execute any procedure TO SENTINEL;

GRANT unlimited tablespace TO SENTINEL;

 

CREATE USER WEBDASHBOARD IDENTIFIED BY WEBDASHBOARD DEFAULT TABLESPACE SNTL_DATA_WORK;

GRANT create session TO WEBDASHBOARD;

GRANT create procedure TO WEBDASHBOARD;

GRANT create table TO WEBDASHBOARD;

GRANT create view TO WEBDASHBOARD;

GRANT create type TO WEBDASHBOARD;

GRANT create sequence TO WEBDASHBOARD;

GRANT create trigger TO WEBDASHBOARD;

GRANT execute any procedure TO WEBDASHBOARD;

GRANT unlimited tablespace TO WEBDASHBOARD;

Datastore

CREATE TABLESPACE DSMAIN_DATA

LOGGING

DATAFILE '<ora_path>/DSMAIN_DATA.dbf'

SIZE 1024M REUSE AUTOEXTEND ON

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE DSMAIN_INDEX

LOGGING

DATAFILE '<ora_path>/DSMAIN_INDEX.dbf'

SIZE 1024M REUSE AUTOEXTEND ON

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE DSMAIN_LOB

LOGGING

DATAFILE '<ora_path>/DSMAIN_LOB.dbf'

SIZE 1024M REUSE AUTOEXTEND ON

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

 

CREATE TABLESPACE DSCACHE_DATA

LOGGING

DATAFILE '<ora_path>/DSCACHE_DATA.dbf'

SIZE 1024M REUSE AUTOEXTEND ON

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE DSCACHE_INDEX

LOGGING

DATAFILE '<ora_path>/DSCACHE_INDEX.dbf'

SIZE 1024M REUSE AUTOEXTEND ON

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

CREATE TABLESPACE DSCACHE_LOB

LOGGING

DATAFILE '<ora_path>/DSCACHE_LOB.dbf'

SIZE 1024M REUSE AUTOEXTEND ON

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

 

CREATE TABLESPACE DSMETA LOGGING DATAFILE '<ora_path>/DSMETA.dbf' SIZE 1024M REUSE AUTOEXTEND ON EXTENT MANAGEMENT LOCAL SEGMENT SPACE MANAGEMENT AUTO;

 

CREATE TABLESPACE DSCLIENT_DATA

LOGGING

DATAFILE '<ora_path>/DSCLIENT_DATA.dbf'

SIZE 1024M REUSE  AUTOEXTEND ON

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

 

CREATE USER DSMAIN IDENTIFIED BY DSMAIN DEFAULT TABLESPACE DSMETA;

GRANT create session TO DSMAIN;

GRANT create procedure TO DSMAIN;

GRANT create table TO DSMAIN;

GRANT create view TO DSMAIN;

GRANT create sequence TO DSMAIN;

GRANT unlimited tablespace TO DSMAIN;

 

CREATE USER DSVIEW IDENTIFIED BY DSVIEW DEFAULT TABLESPACE DSMETA;

GRANT create session TO DSVIEW;

GRANT create procedure TO DSVIEW;

GRANT create table TO DSVIEW;

GRANT create view TO DSVIEW;

GRANT create sequence TO DSVIEW;

GRANT unlimited tablespace TO DSVIEW;

 

CREATE USER DSCACHE IDENTIFIED BY DSCACHE DEFAULT TABLESPACE DSMETA;

GRANT create session TO DSCACHE;

GRANT create procedure TO DSCACHE;

GRANT create table TO DSCACHE;

GRANT create view TO DSCACHE;

GRANT create sequence TO DSCACHE;

GRANT unlimited tablespace TO DSCACHE;

CREATE USER DSCLIENT IDENTIFIED BY DSCLIENT DEFAULT TABLESPACE DSCLIENT_DATA;

GRANT create session TO DSCLIENT;

GRANT create procedure TO DSCLIENT;

GRANT create table TO DSCLIENT;

GRANT create view TO DSCLIENT;

GRANT create sequence TO DSCLIENT;

GRANT unlimited tablespace TO DSCLIENT;

Designer

create tablespace DES_DATA_WORK

datafile '<ora_path>/DES_DATA_WORK.dbf' SIZE 60M

autoextend on next 5M

extent management local

uniform size 128K;

 

create user IPDESIGNER identified by IPDESIGNER

default tablespace DES_DATA_WORK

temporary tablespace TEMP;

grant connect, create table, create sequence, create trigger, create view, create session, create type, create procedure, execute any procedure, unlimited tablespace to IPDESIGNER;

InterPlay

create tablespace IP_DATA_WORK

datafile '<ora_path>/IP_DATA_WORK.dbf' SIZE 60M

autoextend on next 5M

extent management local

uniform size 128K;

 

create tablespace IP_INDEX_WORK

datafile '<ora_path>/IP_INDEX_WORK.dbf' SIZE 60M

autoextend on next 5M

extent management local

uniform size 128K;

 

create user INTERPLAY_ADM identified by INTERPLAY_ADM

default tablespace IP_DATA_WORK

temporary tablespace TEMP;

grant connect, create table, create sequence, create trigger, create view, create session, create type, create procedure, execute any procedure, unlimited tablespace to INTERPLAY_ADM;

 

create user INTERPLAY_APP identified by INTERPLAY_APP

default tablespace IP_DATA_WORK

temporary tablespace TEMP;

grant connect, create table, create session, create synonym, unlimited tablespace to INTERPLAY_APP;

PassPort

create tablespace PASS_DATA_WORK

datafile '<ora_path>/PASS_DATA_WORK.dbf' SIZE 100M

autoextend on next 5M

extent management local

uniform size 256K ;

 

create user PASSPORT identified by PASSPORT

default tablespace PASS_DATA_WORK

temporary tablespace TEMP;

 

grant connect, create procedure, create session, create table, create view, unlimited tablespace to PASSPORT;

Report Server

CREATE TABLESPACE RS_DATA_WORK

LOGGING

DATAFILE '<ORACLE data path>/RS_DATA_WORK.dbf'

SIZE 512M REUSE AUTOEXTEND ON

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

 

create user AISReport identified by AISReport

default tablespace RS_DATA_WORK

temporary tablespace TEMP;

grant connect, create table, create sequence, create trigger, create view, create session, create type, create procedure, execute any procedure, unlimited tablespace to AISReport;

Repository

CREATE TABLESPACE AIS_DATA_WORK

LOGGING

DATAFILE '/home/oracle/app/oracle/oradata/<SID>/AIS_DATA_WORK.dbf'

SIZE 512M REUSE AUTOEXTEND ON

EXTENT MANAGEMENT LOCAL

SEGMENT SPACE MANAGEMENT AUTO;

 

CREATE USER AISRepository IDENTIFIED BY AISRepository

DEFAULT TABLESPACE AIS_DATA_WORK;

GRANT create session TO AISRepository;

GRANT create procedure TO AISRepository;

GRANT create table TO AISRepository;

GRANT create view TO AISRepository;

GRANT create type TO AISRepository;

GRANT create sequence TO AISRepository;

GRANT create trigger TO AISRepository;

GRANT execute any procedure TO AISRepository;

GRANT unlimited tablespace TO AISRepository;

Related Links