Running Oracle database scripts

Before you run the AX Server setup wizard to install the application files, you need to run the supplied SQL script to create the AX Server database user. You can also, optionally, run the set of SQL scripts that create the database schema manually if you do not want to complete this step using the setup wizard.

To run the Oracle database scripts:

Download the AX Server installer from ACL Launchpad, and extract the setup wizard files.
Open Windows Explorer and navigate to the DBScripts\Oracle subfolder where you extracted the setup wizard files.
Copy the SQL script files to the Oracle server, or a location you can run the scripts from.
Run the CREATE_AX_TABLESPACES.sql script to define the physical allocation of space for the database.
Open Create Database User.sql and update the V_USER and V_USERPWD variables defined at the top of the script, with the username and password you want to use for the AX Server database user. Save and close the file when you have made the necessary changes.
Run the Create Database User.sql script using a database administrator account running under the SYSDBA role.
If you want to create the database schema manually run the following SQL scripts using the AX Server database user account:
- Create Schema.sql
- CreateQuartzTables.sql
- Create Core Data.sql
If you run the AX Server schema scripts manually, and someone else will run the AX Server setup wizard, you must instruct them to choose the Use an existing ACL Analytics Exchange database option in the AX Server database connection settings page.
If you are installing AX Exception as part of your ACL Analytics Exchange configuration, you also need to run an additional SQL script to add the required AX Exception roles to the database. You must select the file that corresponds to the language you are installing. For example, if you are completing the English installation, run the SQL script file named EMRole_EN.sql.