# 查看所有 DM 服务状态
systemctl list-units --all | grep -iE 'DmCSS|DmASMSvr|DmService|DmWatcher|DmMonitor|DmAP'
# 单个服务状态
systemctl status DmServiceDSC01
systemctl start DmCSSServiceCSS1 # CSS 服务(必须先起)
systemctl start DmASMSvrServiceASM1 # ASM 服务(依赖 CSS,已配置 After)
systemctl start DmServiceDSC01 # dmserver 实例(依赖 ASM)
systemctl start DmWatcherServiceDWT1 # 守护进程(最后起,AUTO 模式会自动打开数据库)
systemctl start DmCSSServiceCSS2 systemctl start DmASMSvrServiceASM2 systemctl start DmServiceDSC02 systemctl start DmWatcherServiceDWT2
systemctl start DmAPService # dmap(如未运行)
systemctl start DmServiceDW01 # 备库实例
systemctl start DmWatcherServiceDWT3 # 守护进程
systemctl start DmMonitorServiceMON1 # 监视器(常驻)
# DSC01 示例
systemctl stop DmWatcherServiceDWT1
systemctl stop DmServiceDSC01
systemctl stop DmASMSvrServiceASM1
systemctl stop DmCSSServiceCSS1
# DSC02 同理(DWT2/DSC02/ASM2/CSS2);DW01:DWT3 → DW01 → MON1
systemctl restart DmServiceDSC01
systemctl disable DmServiceDSC01 # 关闭开机自启
systemctl enable DmServiceDSC01 # 恢复开机自启
| 服务 | dsc01 | dsc02 | dw01 |
|---|---|---|---|
| CSS | DmCSSServiceCSS1 | DmCSSServiceCSS2 | - |
| ASM | DmASMSvrServiceASM1 | DmASMSvrServiceASM2 | - |
| 数据库实例 | DmServiceDSC01 | DmServiceDSC02 | DmServiceDW01 |
| 守护进程 | DmWatcherServiceDWT1 | DmWatcherServiceDWT2 | DmWatcherServiceDWT3 |
| 监视器 | - | - | DmMonitorServiceMON1 |
| dmap | DmAPService | DmAPService | DmAPService |
disql SYSDBA/Sysdba001@192.168.240.101:5236 # 任一节点 ip 均可
| 用途 | 账号 | 口令 |
|---|---|---|
| 数据库系统管理员 | SYSDBA | Sysdba001 |
| 数据库审计管理员 | SYSAUDITOR | Auditor001 |
| DCR 初始化口令(仅初始化阶段使用) | - | DmHust@4400 |
| 虚拟机 SSH(root) | root | 1 |
口令策略:8-48 位,须含大小写字母+数字(达梦默认复杂度)。
| 用途 | 端口 | 说明 |
|---|---|---|
| 数据库服务 | 5236 | 三节点一致,对外连接 |
| MAL 实例端口 | 11246 / 11247 / 11248 | DSC01 / DSC02 / DW01(心跳网 10.10.10.x) |
| ASM MAL | 11266 / 11267 | DSC01 / DSC02 |
| CSS 端口 | 11286 / 11287 | DSC01 / DSC02 |
| DCR 端口 | 11276 / 11277 | DSC01 / DSC02 |
| CHECK 端口 | 11256 / 11257 | DSC01 / DSC02 |
| 守护/MAL_DW | 52141 | 监视器连接(MON_DW_IP=10.10.10.101/102/103:52141) |
| MAL 实例 DW | 5276 | 守护进程内部通信 |
| dmap 辅助端口 | 4236 | DMAP 服务(备份还原用) |
| SSH | 22 | 运维 |
-- 实例状态/模式
select name, status$, mode$ from v$instance;
-- 归档状态
select arch_type, arch_dest, arch_status from v$arch_status;
-- OGUID
select oguid from v$instance;
# 监视器(dw01)
/dm8/bin/dmmonitor /dmdata/DAMENG/dmmonitor.ini
monitor> show # 查看主备情况(DSC主库/DW备库、LSN、归档状态)
monitor> exit # 看完退出(避免长期挂着第二个监视器)
# 查看守护状态
select group_name, inst_name, watcher_status, dw_status, md_status from v$dmwatcher;
文章
阅读量
获赞
