Steps performed by an Oracle DBA

The following steps must be performed by an Oracle DBA.

1. Set up Oracle Database 10g with the following characteristics:

Option Value

Database name Any valid Oracle database name

Tablespace Create tablespaces for Microsoft

Dynamics AX to use, for example:

 AXTAB, for tables

 AXIDX, for indexes

 AXTMP, for temporary tables

The Microsoft Dynamics AX administrator can configure the tablespaces after Microsoft Dynamics AX has been fully installed. For more information, see Configure Oracle tablespaces.

Note If you are upgrading, you must use the same tablespace names in the Microsoft Axapta 3.0 system and the Microsoft Dynamics AX new system.

Note Microsoft Dynamics AX supports Unicode collations. If you are setting up a new Microsoft Dynamics AX installation, we recommend that you choose a Windows collation for your location. For more information about choosing a collation for an Oracle database, see your Oracle documentation.

2. Setup uses the Windows account of the installing user to allow the AOS account (the domain account or Network Service account that is associated with an AOS

instance) to connect to the Oracle database, and to write stored procedures to the Oracle database. To enable this, set the following rights:

 Add the network account of the person who will install the AOS to the database administrators group in Oracle.

 Set Oracle to use Windows authentication.

3. Optional. Add the AOS account of each computer that runs an AOS instance in your system as a user in the database. Grant the user accounts the following rights in the database:

GRANT CREATE USER TO "<AOSaccount_name>";

GRANT SELECT ANY CATALOG TO "<AOSaccount_name>";

GRANT CREATE PROCEDURE TO "<AOSaccount_name>";

If you do not perform this step, Setup grants the following rights to the current AOS instance:

 ALL PRIVILEGES

 SELECT ANY DICTIONARY

4. Optional. Create a schema (user account) for each database instance and grant the following rights:

CREATE USERS <schema name> IDENTIFIED BY "<schema password>";

GRANT ALTER ANY CLUSTER TO "<schema name>";

GRANT ALTER ANY DIMENSION TO "<schema name>";

GRANT ALTER ANY INDEX TO "<schema name>";

GRANT ALTER ANY INDEXTYPE TO "<schema name>";

GRANT ALTER ANY MATERIALIZED VIEW TO "<schema name>";

GRANT ALTER ANY PROCEDURE TO "<schema name>";

GRANT ALTER ANY TABLE TO "<schema name>";

GRANT ALTER TABLESPACE TO "<schema name>";

GRANT ALTER USER TO "<schema name>";

GRANT ANALYZE ANY DICTIONARY TO "<schema name>";

GRANT CREATE ANY CLUSTER TO "<schema name>";

GRANT CREATE ANY DIMENSION TO "<schema name>";

GRANT CREATE ANY INDEX TO "<schema name>";

GRANT CREATE ANY INDEXTYPE TO "<schema name>";

GRANT CREATE ANY MATERIALIZED VIEW TO "<schema name>";

GRANT CREATE ANY PROCEDURE TO "<schema name>";

GRANT CREATE ANY TABLE TO "<schema name>";

GRANT CREATE ANY VIEW TO "<schema name>";

GRANT CREATE CLUSTER TO "<schema name>";

GRANT CREATE DATABASE LINK TO "<schema name>";

GRANT CREATE DIMENSION TO "<schema name>";

GRANT CREATE INDEXTYPE TO "<schema name>";

GRANT CREATE MATERIALIZED VIEW TO "<schema name>";

GRANT CREATE PROCEDURE TO "<schema name>";

GRANT CREATE PUBLIC DATABASE LINK TO "<schema name>";

GRANT CREATE TABLE TO "<schema name>";

GRANT CREATE TABLESPACE TO "<schema name>";

GRANT CREATE USER TO "<schema name>";

GRANT CREATE VIEW TO "<schema name>";

GRANT DELETE ANY TABLE TO "<schema name>";

GRANT DROP ANY CLUSTER TO "<schema name>";

GRANT DROP ANY DIMENSION TO "<schema name>";

GRANT DROP ANY INDEX TO "<schema name>";

GRANT DROP ANY INDEXTYPE TO "<schema name>";

GRANT DROP ANY MATERIALIZED VIEW TO "<schema name>";

GRANT DROP ANY PROCEDURE TO "<schema name>";

GRANT DROP ANY TABLE TO "<schema name>";

GRANT DROP ANY VIEW TO "<schema name>";

GRANT DROP PUBLIC DATABASE LINK TO "<schema name>";

GRANT DROP TABLESPACE TO "<schema name>";

GRANT DROP USER TO "<schema name>";

GRANT EXECUTE ANY INDEXTYPE TO "<schema name>";

GRANT EXECUTE ANY PROCEDURE TO "<schema name>";

GRANT EXPORT FULL DATABASE TO "<schema name>";

GRANT GLOBAL QUERY REWRITE TO "<schema name>";

GRANT GRANT ANY OBJECT PRIVILEGE TO "<schema name>";

GRANT GRANT ANY PRIVILEGE TO "<schema name>";

GRANT IMPORT FULL DATABASE TO "<schema name>";

GRANT INSERT ANY TABLE TO "<schema name>";

GRANT LOCK ANY TABLE TO "<schema name>";

GRANT MANAGE SCHEDULER TO "<schema name>";

GRANT MANAGE TABLESPACE TO "<schema name>";

GRANT QUERY REWRITE TO "<schema name>";

GRANT SELECT ANY DICTIONARY TO "<schema name>";

GRANT SELECT ANY TABLE TO "<schema name>";

GRANT SELECT ANY TRANSACTION TO "<schema name>";

GRANT SYSDBA TO "<schema name>";

GRANT UPDATE ANY TABLE TO "<schema name>";

If you do not perform this step, Setup grants to the following rights to the schema.

 ALL PRIVILEGES

 SELECT ANY DICTIONARY

 SELECT_CATALOG_ROLE

5. Optional. (If you do not perform this step, it will be performed by Microsoft

Dynamics AX Setup.) Import the Setup stored procedures. You can find the Setup stored procedures on the Microsoft Dynamics AX DVD, in the Support folder, OracleCreateServerSessions and OracleCreateUserSessions. The stored procedures have been wrapped.