问题描述

重启后登录提示账号被锁定

[yashan@localhost ~]$ yasql 'sys/"Admin@2023"'
YashanDB SQL Personal Edition Release 23.1.1.100 x86_64

YAS-02193 the account is locked

操作过程

--sql方式关闭数据库
SQL> shutdown immediate
   2 ;

Succeed.

SQL> exit

--查看进程
[yashan@localhost instance]$ ps -ef | grep yash
root       1298   1279  0 19:23 pts/0    00:00:00 su - yashan
yashan     1299   1298  0 19:23 pts/0    00:00:00 -bash
yashan     1761      1  0 19:35 ?        00:00:00 /yashandb/install/bin/yasagent --init -c yashandb -l 192.168.40.152:1676 --host-id host0001 -k 7bafb2221442e2ef -d
yashan     1778      1  0 19:35 ?        00:00:02 /yashandb/install/bin/yasom --init -c yashandb -l 192.168.40.152:1675 -k 7bafb2221442e2ef -d
root       3439   2152  0 20:04 pts/1    00:00:00 su - yashan
yashan     3440   3439  0 20:04 pts/1    00:00:00 -bash
yashan     5363   3440  0 20:40 pts/1    00:00:00 ps -ef

--预想像oracle那样登录nomount mount open
[yashan@localhost instance]$ yasql 'sys/"Admin@2023"'
YashanDB SQL Personal Edition Release 23.1.1.100 x86_64

YAS-00402 failed to connect socket, errno 111, error message "Connection refused"



please input user name: 
YASQL-00007 invalid username/password; logon denied


please input user name: 
YASQL-00007 invalid username/password; logon denied


YASQL-00007 unable to CONNECT to Server after 3 attempts

--启动
[yashan@localhost instance]$ yasboot cluster start -c yashandb
 type | uuid             | name              | hostid | index    | status  | return_code | progress | cost 
-----------------------------------------------------------------------------------------------------------
 task | 89b8f2f3de1ae5cd | StartYasdbCluster | -      | yashandb | RUNNING | -           | 0        | -    

--查看状态和进程
[yashan@localhost instance]$ yasboot cluster status -c yashandb
 host_id  | node_type | nodeid | pid  
--------------------------------------
 host0001 | db        | 1-1:1  | 5544 
----------+-----------+--------+------
[yashan@localhost instance]$ ps -ef | grep yasql
yashan     6354   3440  0 20:50 pts/1    00:00:00 grep --color=auto yasql
[yashan@localhost instance]$ ps -ef | grep ya
root       1298   1279  0 19:23 pts/0    00:00:00 su - yashan
yashan     1299   1298  0 19:23 pts/0    00:00:00 -bash
yashan     1761      1  0 19:35 ?        00:00:01 /yashandb/install/bin/yasagent --init -c yashandb -l 192.168.40.152:1676 --host-id host0001 -k 7bafb2221442e2ef -d
yashan     1778      1  0 19:35 ?        00:00:02 /yashandb/install/bin/yasom --init -c yashandb -l 192.168.40.152:1675 -k 7bafb2221442e2ef -d
root       3439   2152  0 20:04 pts/1    00:00:00 su - yashan
yashan     3440   3439  0 20:04 pts/1    00:00:00 -bash
yashan     5544      1  4 20:44 ?        00:00:17 /yashandb/install/bin/yasdb open -D /yashandb/data/db-1-1
yashan     6361   3440  0 20:50 pts/1    00:00:00 ps -ef
yashan     6362   3440  0 20:50 pts/1    00:00:00 grep --color=auto ya

--再次登录
[yashan@localhost instance]$ yasql 'sys/"Admin@2023"'
YashanDB SQL Personal Edition Release 23.1.1.100 x86_64

YAS-02193 the account is locked