Datastore 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 Datastore Runtime DSMAIN_DATA - 1 GB minimum sizeTo 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.RuntimePermissionPermission 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
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 Datastore Runtime DSMAIN_DATA - 1 GB minimum sizeTo 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.RuntimePermissionPermission 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.