AI智能
改变未来

oracle账户被锁

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被锁账户解锁成功;

赞(0) 打赏
未经允许不得转载:爱站程序员基地 » oracle账户被锁