Prerequisites and Architecture

DM8 deployement tested on x86_64 with RedHat 7. Database migrations from Oracle (GBK) and MySQL (UTF-8) to DM8 were validated locally before moving to ARM architecture.

1. Environment Setup

User and Directory Creation

groupadd dinstall
useradd -g dinstall dmdba
echo "123456" | passwd "dmdba" --stdin

mkdir /data/dm8
chown -R dmdba.dinstall /data/dm8

mkdir -p /opt/dmdbms
chown dmdba:dinstall /opt/dmdbms

mkdir -p /dmdata
chown dmdba:dinstall /dmdata

Mount the ISO Image

mount -o loop dm8_20240408_x86_rh7_64.iso /data/dm8

System Configuration

setenforce 0
sed -i 's/SELINUX=enforcing/SELINUX=disabled/' /etc/selinux/config

Append the following limits to /etc/security/limits.conf:

dmdba hard nofile 131072
dmdba soft nofile 131072
dmdba soft nice 0
dmdba hard nice 0
dmdba soft as unlimited
dmdba hard as unlimited
dmdba soft fsize unlimited
dmdba hard fsize unlimited
dmdba soft nproc 131072
dmdba hard nproc 131072
dmdba soft data unlimited
dmdba hard data unlimited
dmdba soft core unlimited
dmdba hard core unlimited
dmdba soft memlock unlimited
dmdba hard memlock unlimited

2. Software Installation

Switch to the installation user and run:

su - dmdba
cd /data/dm8
chmod 777 *
./DMInstall.bin -i

During interactive installation:

• Skip the license key step in trial mode
• Set timezone (e.g., 21 for China Standard Time)
• Specify the target path /opt/dmdbms

3. Database Instance Initialization

Navigate to the binary directory and use dminit with required parameters:

cd /opt/dmdbms/bin
./dminit help

Key parameters:

• PATH specifies datafile storage location
• UNICODE_FLAG=1 enables UTF-8
• LENGTH_IN_CHAR=1 makes VARCHAR length character‑based
• Combined setting: CHARSET=1,LENGTH_IN_CHAR=1 supports up to 4× size expansion

4. Basic Operations

• DM Tools: Access graphical and command-line utilities under /opt/dmdbms/bin
• Character Set Compatibility
  • GBK: declared during instance init with appropriate flags
  • UTF-8: set UNICODE_FLAG=1 and LENGTH_IN_CHAR=1
• User and Tablespace Setup: Create custom schemas via CREATE USER and CREATE TABLESPACE
• Configuration Tuning: Adjust memory, buffer, and log settings
• Startup Scripts: Enable automatic service start with systemctl wrappers

5. Database Migration

1. Create a new migration project.
2. Initiate a new migration task.
3. Select "Oracle to DM" as the source‑target pair.
4. Enter connection details for the source database.
5. Provide the destination DM database credentials.
6. Choose migration scope (schemas, tables, views, procedures).
7. Map source users to DM target users.
8. Select the specific tables to transfer.
9. Execute the migration and verify data consistency.