Handling of expired user passwords
1.windows environment
1.1 Turn on the database service
1.1.1 In windows environment, find DmServiceDMSERVER directly in the service and open it
1.1.2 Command line method: dmserver.exeh:dmdbmsdataDAMENGdm.ini
1.2 Use the SYSDBA system administrator user to log in to the database because the user password has expired
1.2.1 Recommend to use the management tool directly, double click on it
1.2.2 Command line method: dISQLSYSDBA/SYSDBA@localhost
1.3 Reset the password for users whose passwords have expired, as shown in the following example
--execute sql statements directly from within the Administration tool
alter user "DMDBA" identifiedby "DMDBA_12345";
1.4 Sometimes passwords contain special characters such as @ that prevent dISQL from connecting and running directly. It needs to be handled by a transfer character. The disql escape character is used as follows
--In windows, the password needs to be included using double quotes, while transferring the use of double quotes, as in the following example.
disqlSYSDBA/"abcd@efgh"@localhost
2.under linux environment
2.1 Turn on the database service
[dmdba@localhost Desktop]$ cd/home/dmdba/dmdbms/bin
[dmdba@localhost bin]$ ./dmserver/home/dmdba/dmdbms/data/DAMENG/dm.ini
file dm.key not found, use defaultlicense!
version info: develop
Use normal os_malloc instead of HugeTLB
Use normal os_malloc instead of HugeTLB
DM Database Server x64V7.1.5.158-Build(2017.02.13-77698)ENT startup...
License will expire on 2018-02-13
ckpt lsn: 57014
iid page's trxid = 1794
NEXT TRX ID = 1795
SYSTEM IS READY.
If SYSTEMIS READY is displayed, the database service is started successfully
2.2 Use the SYSDBA system administrator user to log in to the database because the user password has expired
[dmdba@localhost bin]$ ./disqlSYSDBA/SYSDBA@localhost
Server[localhost:5236]:mode is normal,state is open
login used time: 26.201(ms)
disqlV7.1.5.158-Build(2017.02.13-77698)ENT
Connected to: DM 7.1.5.158
2.3 Reset the password for users whose passwords have expired, as shown in the following example
SQL>alter user "DMDBA"identified by "DMDBA_12345"; //Fill in the new password
2.4 Sometimes passwords contain special characters such as @ causing disql to not connect and run directly. It needs to be handled by a transfer character. The disql escape character is used as follows
--linux, the password needs to be included using double quotes, while the outer layer is then transferred using single quotes, as in the following example.
[dmdba@localhost bin]$ ./disqlDBATEST/'"abcd@efgh"'@localhost
Recommended>>
1、TinyWeibo
2、Illustration of tree traversal with stack data structure
3、A mustsee 17 SQL query speedup tips that only experts know
4、JIRA Installation
5、How to download and install Metamask the ethereum wallet