Oracle密码过期的处理方法
1、问题描述
如上图所示，使用账号密码登录 Oracle 数据库时，提示密码已失效。
执行请求的操作时遇到错误:
ORA-28001: 口令已经失效
28001. 00000 - "the password has expired"
*Cause: The user's account has expired and the password must be changed.
This can happen if any of the followings is true:
* The database administrator expired the user account using the
ALTER USER PASSWORD EXPIRE statement.
* The user account was associated with a password profile with
a limited password life time and the user's password had not
been changed in accordance with the PASSWORD_LIFE_TIME
parameter.
* The user account was created as part of either a database
import inside a Pluggable Database (PDB) or clone of an
existing PDB and the user's password did not meet the
requirements of the mandatory profile enforced in the PDB.
*Action: Change the password or contact the database administrator to
understand the rules for choosing the new password which complies
with the mandatory profile.
供应商代码 28001
2、处理方法
2.1、以SYSDBA身份登陆
sqlplus 账号/"密码"@数据库IP地址/数据库服务名 as sysdba;
2.2、修改账号的密码
alter user 账号 identified by "密码";
2.3、测试效果
如上图所示，密码修改成功，连接正常。