长期未维护的数据库,登录后报错:ora-28000 the account is locked
用户被锁,解锁用户即可
# 切换oracle用户
# su - oracle
# 用sqlplus登录Oracle
# sqlplus /as sysdba
# 解锁,更换密码(可选)
# alter user {用户名} identified by {密码} account unlock;
提示:User altered.
长期未维护的数据库,登录后报错:ora-28000 the account is locked
用户被锁,解锁用户即可
# 切换oracle用户
# su - oracle
# 用sqlplus登录Oracle
# sqlplus /as sysdba
# 解锁,更换密码(可选)
# alter user {用户名} identified by {密码} account unlock;
提示:User altered.