# 前提条件

## DM端

- 主库开启逻辑日志文件

RLOG_APPEND_LOGIC    1

- 主库开启归档

ARCH_INI 1

## oracle端

### 开启归档
```
--检查归档是否开启
[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Fri Jul 2 22:30:14 2021

SQL> connect /as sysdba
Connected.

SQL> archive log list;
Database log mode              No Archive Mode
Automatic archival             Disabled            ----------代表没有开启
Archive destination            /oracle/product/11.2.0/dbs/arch
Oldest online log sequence     10
Current log sequence           12

--关闭数据库
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.

--启动数据库(当数据库处于此模式时，可以执行一些管理的任务)
SQL> startup mount
ORACLE instance started.

Total System Global Area 1185853440 bytes
Fixed Size                  2212776 bytes
Variable Size             838863960 bytes
Database Buffers          335544320 bytes
Redo Buffers                9232384 bytes
Database mounted.

--开启数据库归档
SQL> alter database archivelog;

Database altered.

SQL> alter system set log_archive_dest='/oracle/arch';

System altered.

--打开数据库正常模式
SQL> alter database open;

Database altered.

--检查是否开启
SQL> archive log list ;
Database log mode              Archive Mode
Automatic archival             Enabled            ---------代表开启
Archive destination            /oracle/arch       ---------归档日志目录
Oldest online log sequence     10
Next log sequence to archive   12
Current log sequence           12
```

### 检查数据库最小附加日志及全列日志
```
SQL> select SUPPLEMENTAL_LOG_DATA_MIN, SUPPLEMENTAL_LOG_DATA_ALL from v$database;
如果是为no，就执行以下语句
SQL>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA;
SQL>ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
```

### 将Oracle的回收机制关闭
```
SQL>alter system set recyclebin=off deferred;
```

### 检查字符集是否一致 
```
先查询oracle数据库的字符集：
SQL> select userenv('language') from dual;
再查询系统字符集
echo $NLS_LANG
如果该变量值为空或者与查询结果不一致，请将该变量设置为查询结果的值
修改~/.bash_profile文件，增加export NLS_LANG=“sql查询结果值”

[oracle@localhost ~]$ sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Sun Jul 4 22:44:48 2021

SQL>
SQL> conn sys/orcl as sysdba
Connected.
SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL>
SQL>
SQL> startup mount
ORACLE instance started.

Total System Global Area 1185853440 bytes
Fixed Size                  2212776 bytes
Variable Size             838863960 bytes
Database Buffers          335544320 bytes
Redo Buffers                9232384 bytes
Database mounted.
SQL>
SQL>
SQL> alter system enable restricted session;

System altered.

SQL>
SQL> alter system set job_queue_processes=0;

System altered.

SQL>
SQL> alter database open;

Database altered.

SQL> alter database character set INTERNAL_USE utf8;

Database altered.

SQL> shutdown immediate;

Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area 1185853440 bytes
Fixed Size                  2212776 bytes
Variable Size             838863960 bytes
Database Buffers          335544320 bytes
Redo Buffers                9232384 bytes
Database mounted.
Database opened.
SQL>

```

### 创建用户dmhs（oracle和dm都创建用户）
```
Create user dmhs identified by "admin123";
Grant dba to dmhs;
```

### Root用户安装odbc ，搭建DMHS最好要2.3.0以上的版本
```
---wget ftp://ftp.unixodbc.org/pub/unixODBC/unixODBC-2.3.0.tar.gz
查看是否安装rpm -qa|grep unixODBC
tar -xvf unixODBC-2.3.0.tar.gz
cd unixODBC-2.3.0/ --如配置错误，看是否安装gcc
./configure --prefix=/usr/local/unixODBC-2.3.0 --includedir=/usr/include --libdir=/usr/lib --bindir=/usr/bin --sysconfdir=/etc
make && make install
odbcinst -j

--配置UNIXODBC 
vim /usr/local/etc/odbc.ini
[ORACLE]
Description = ORACLE ODBC DSN
Driver = Oracle in OraDb11g_home1
SERVER = 127.0.0.1
UID = DMHS
PWD = dm123
Servername = ORCL
PORT = 1521

vim /usr/local/etc/odbcinst.ini
[Oracle in OraDb11g_home1]
Description = ODBC DRIVER FOR ORACLE
Driver = /ora/oracle/product/11.2.0/db_1/lib/libsqora.so.11.1
Threading = 0

--配置完
isql -v ORACLE DMHS dm123
```

# 部署

## 部署DMHS(图形化  oracle主机安装完全版  dm主机安装精简版)
```
--dm端
./dmhs_V4.1.1_dm8_rev99696_rh6_64_veri_20210527.bin 
--oracle端
./dmhs_V3.1.3_oracle_rev99507_rh6_64_veri_20210511.bin 
```

## dm端

### exec配置

dmhs的bin目录下dmhs.hs
```
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<dmhs>
    <base>
        <lang>ch</lang>
        <mgr_port>5345</mgr_port>
        <name>exec</name>
        <ckpt_interval>60</ckpt_interval>
        <siteid>5</siteid>
        <version>2.0</version>
    </base>
    <exec>
        <recv>
            <mgr_port>5345</mgr_port>
            <data_port>5346</data_port>
        </recv>
        <enable>1</enable>
        <name>exec</name>
        <db_type>DM8</db_type>
        <db_server>192.168.19.100</db_server>
        <db_user>SYSDBA</db_user>
        <db_pwd>SYSDBA</db_pwd>
        <db_port>5236</db_port>
        <char_code>PG_UTF8</char_code>
        <exec_thr>1</exec_thr>
    </exec>
</dmhs>
```

### 启动
```
[dmdba@localhost bin]$ ./dmhs_server start --console

[dmdba@localhost bin]$ ./dmhs_console
DMHS> connect 127.0.0.1:5345
DMHS> start exec
```

### CPT配置

dmhs的bin目录下dmhs.hs
```
<?xml version="1.0" encoding="GB2312" standalone="no"?>
<dmhs>
    <base>
        <lang>ch</lang>
        <mgr_port>5345</mgr_port>
        <name>cpt</name>
        <ckpt_interval>60</ckpt_interval>
        <siteid>3</siteid>
        <version>2.0</version>
    </base>
    <cpt>
        <enable>1</enable>
        <name>cpt</name>
        <db_type>ORACLE11G</db_type>
        <db_server>localhost:1521/orcl</db_server>
        <db_user>dmhs</db_user>
        <db_pwd>admin123</db_pwd>
        <db_port>1521</db_port>
        <cpt_mask/>
        <send>
            <ip>192.168.19.100</ip>
            <mgr_port>5345</mgr_port>
            <data_port>5346</data_port>
            <filter>
                <enable>
                    <item>DMHS.*</item>
                </enable>
            </filter>
            <map/>
        </send>
    </cpt>
</dmhs>
```

### 启动
```
[oracle@localhost bin]$ ./dmhs_server dmhs.hs --console

[oracle@localhost bin]$ ./dmhs_console
DMHS> connect 127.0.0.1:5345
DMHS> clear exec lsn
DMHS> COPY 0 "SCH.NAME='DMHS'"CREATE|INSERT|DICT
DMHS> start cpt
```

# FAQ

### 执行start cpt的时候报加载执行模块失败

现象： 提示执行模块失败，日志连接oracle ORA-12154: TNS:could not resolve the connect identifier specified

解决：   
1.sqlplus dmhs/密码@ORCL 查看是否正常  
2.lsnrctl status  监听是否正常  
3.查看tnsnames.ora配置  $ORACLE_HOME/network/admin/目录下  
4.echo $ORACLE_SID  
5.echo $ORACLE_HOME  
6.查看/etc/hosts   如果没有配置ip，则tnsnames.ora的ip改为localhost，tnsping ORCL看是否正常  
7.listener.ora   
8.测试sqlplus dmhs/admin123@localhost:1521/orcl   ，如果可以连接成功你就把localhost:1521/orcl这串配置在db_sever里面

DM 武汉达梦数据库股份有限公司  
24小时免费服务热线：400 991 6599  
达梦技术社区：https://eco.dameng.com

ITPub博客

达梦DMHS搭建oracle到DM

最新文章