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、测试效果

如上图所示，密码修改成功，连接正常。

本文参考

【1】【佚名】【怎么修改oracle用户密码，特殊字符】【爱码网】【2023-11-08】