达梦数据库 忘记 SYSDBA 密码 处理方法

[dmdba@dbserver01 DM]$ ps -ef | grep server
dmdba      67632       1  0 22:22 pts/2    00:00:00 /dm8/bin/dmserver path=/dm8/data/DM/dm.ini -noconsole
dmdba      67735   67134  0 22:23 pts/2    00:00:00 grep server
[dmdba@dbserver01 DM]$ 
[dmdba@dbserver01 DM]$ id dmdba
uid=12345(dmdba) gid=12349(dinstall) groups=12349(dinstall),12350(dmdba)

# 以上，实例通过dmdba用户启动，它归属于dmdba组。如果启动用户不归属于dmdba，或dmdba组不存在的话，可以root用户如下操作：

# useradd dmdba
# usermod -G dmdba xxx

[dmdba@dbserver01 DM]$ disql sysdba/xxxx as sysdba

Server[LOCALHOST:5236]:mode is normal, state is open
login used time : 4.807(ms)
disql V8
SQL> select * from v$version; 

LINEID     BANNER                           
———- ———————————
1          DM Database Server 64 V8
2          DB Version: 0x7000c
3          03134284094-20231108-207962-20067

used time: 1.076(ms). Execute id is 501.
SQL> 
SQL> alter user sys identified by dameng123;
executed successfully
used time: 9.643(ms). Execute id is 502.
SQL> 
SQL> connect sysdba/dameng123@localhost:5236

Server[localhost:5236]:mode is normal, state is open
login used time : 2.677(ms)
SQL> 
SQL> select sysdate();

LINEID     SYSDATE()          
———- ——————-
1          2024-01-17 22:29:28

used time: 1.324(ms). Execute id is 701.
SQL> 

[dmdba@dbserver01 ~]$ disql / as sysdba

Server[LOCALHOST:5236]:mode is normal, state is open
login used time : 3.344(ms)
disql V8
SQL> alter user sys identified by dameng123;
executed successfully
used time: 44.092(ms). Execute id is 601.
SQL> 
SQL> sp_set_para_value(2,’ENABLE_LOCAL_OSAUTH’,0);
DMSQL executed successfully
used time: 2.082(ms). Execute id is 602.
SQL> host DmServiceDM restart
Stopping DmServiceDM:                                      [ OK ]
Starting DmServiceDM:                                      [ OK ]

SQL> connect sysdba/xxx@dm         
[-2501]:Invalid username or password.
SQL> 
SQL> connect sysdba/dameng123@dm

Server[192.168.101.179:5236]:mode is normal, state is open
login used time : 3.311(ms)
SQL> 
SQL> select sysdate();

LINEID     SYSDATE()          
———- ——————-
1          2024-01-17 22:34:27

used time: 0.961(ms). Execute id is 501.
SQL> show parameter ENABLE_LOCAL_OSAUTH;

LINEID     PARA_NAME           PARA_VALUE
———- ——————- ———-
1          ENABLE_LOCAL_OSAUTH 0

# 此时，如果发现dm.ini文件末尾添加的配置(ENABLE_LOCAL_OSAUTH = 1)仍然存在，手工删除即可。