AccountingIntegrator 2.3.0 Installation Guide 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
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.