1、Linux管理员登录oracle
su – oracle
export ORACLE_SID=orclnew
sqlplus / as sysdba
登录成功
2、解锁被锁的oracle用户
alter user 用户(bjsjtwoa) account unlock;
alter user bjsjtwoa account unlock;
3、修改oracle用户密码
alter user 用户(bjsjtwoa)identified by 密码(P@ssw0rdTaiji@2015);
alter user bjsjtwoa identified by jdQvn6YpoOWWrfFu;
4、测试登录
conn 用户名/密码
conn bjsjtwoa/P@ssw0rdTaiji@2015
至此oracle被锁账户解锁成功;