查询被锁用户

—查询被锁用户
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;