ORA-28000 : the account is locked

[ 에러]

 

     ORA-28000 : the account is locked

 

[ 조치 방법 ] 

     sqlplus '/ as sysdba

     alter user system(lock걸린user) account unlock;


     pwd변경
         alter user system identified by 변경후pwd ; 

[ 해경 방안 ]

 

   lock안걸리게 하는 방법(제한을 풀면됨)

 

   alter profile default limit FAILED_LOGIN_ATTEMPTS UNLIMITED;