—查询被锁用户
select * from dba_users WHERE account_status LIKE ‘%LOCKED%’;
—登录服务器解锁
sqlplus /nolog
conn /as sysdba
alter user ** account unlock;
G200
—登录服务器解锁
su - omm
source ${BIGDATA_HOME}/mppdb/.mppdbgs_profile
gsql -d dbname -p 25308 -r
alter user username account unlock;