Setting up the Oracle database server

Prepare your Oracle database server and then run the supplied Oracle database scripts. You must complete the Oracle setup prior to installing AX Server.

Note

The Oracle database and AX Server cannot reside on the same machine.

The scripts to create the tablespace and the database user must be run manually on the Oracle database server before you run the AX Server setup wizard.

It is strongly recommended that you also manually run the set of scripts that create the database schema before running the setup wizard. The setup wizard can run the database schema scripts automatically, but creation of the schema is not always successful.

Prepare the database

Set up an Oracle database instance for AX Server and if required, configure the database server to allow encrypted connections between the database server and AX Server.

Note

After you install AX Server, you may need to import the database server certificate into the keystore of AX Server.

Run the tablespace and database user SQL scripts

The database administrator must run the following scripts on the Oracle database server prior to installing AX Server:

  • CREATE_AX_TABLESPACE.sql: defines the physical allocation of space for the AX Server database

    Note

    If you are hosting your database on Amazon RDS, do not run this script. Instead, see Hosting Oracle on Amazon RDS.

  • CREATE_DATABASE_USER.sql: creates the AX Server database user

The following variables must be set for CREATE_DATABASE_USER.sql:

  • V_USER
  • V_USERPWD

For more information, see Running the Oracle database scripts.

Hosting Oracle on Amazon RDS

If you are hosting an Oracle instance on Amazon RDS, instead of running CREATE_AX_TABLESPACES.sql, use the following commands:

create tablespace AX_DATA datafile size 1G autoextend on maxsize 10G;
create tablespace AX_INDEX datafile size 1G autoextend on maxsize 10G;
create temporary tablespace AX_TEMPORARY

Have your Database Administrator adjust the tablespace sizes as required for your installation.

Run the create database schema SQL scripts

Run the additional SQL scripts provided to create the AX Server database schema rather than relying on the AX Server setup wizard to create the schema:

  • Create Schema.sql
  • CreateQuartzTables.sql
  • Create Core Data.sql

For more information, see Running the Oracle database scripts.

Top

Analytics Exchange 14.1 Server Admin Guide