Dynamics Ax 4.0 Database upgrade for Oracle
Before starting the upgrade process do the following activities: Create an empty Oracle 10g database. Microsoft dynamics will support Oracle 10g database only. While creating the database log in as an Windows Administrator Use the following SQL statement for creating new user in Oracle 10g CREATE USER "OPS$ \ " IDENTIFIED EXTERNALLY; Grant rights to the user "OPS$ \ " as given below : GRANT ALL PRIVILEGES, SELECT ANY DICTIONARY TO “OPS$ \ "; For upgrading the existing database, create the tablespace in Oracle 10g with the same name as in oracle 9. For New Installation create 3 tablespaces (AXTAB,AXIDX,AXTMP) as given below: CREATE TABLESPACE AXTAB DATAFILE'D:\ORACLE\ORADATA\AXDB\AXTAB01.DBF' SIZE 3000M BLOCKSIZE 8192;CREATE TABLESPACE AXIDX DATAFILE'D:\ORACLE\ORADATA\AXDB\AXIDX01.DBF' SIZE 2000M BLOCKSIZE 8192;CREATE TEMPORARY TABLESPACE AXTMP TEMPFILE'D:\ORACLE\ORADATA\AXDB\AXTMP01.DBF' SIZE 1000M;COMMIT; 4.1. Create a schema ...