Oracle密码过期的处理方法

1、问题描述

如上图所示，使用账号密码登录 Oracle 数据库时，提示密码已失效。

1. 执行请求的操作时遇到错误:
3. ORA-28001: 口令已经失效
4. 28001. 00000 -  "the password has expired"
5. *Cause:    The user's account has expired and the password must be changed.
6.            This can happen if any of the followings is true:
7.            * The database administrator expired the user account using the
8.            ALTER USER PASSWORD EXPIRE statement.
9.            * The user account was associated with a password profile with
10.            a limited password life time and the user's password had not
11.            been changed in accordance with the PASSWORD_LIFE_TIME
12.            parameter.
13.            * The user account was created as part of either a database
14.            import inside a Pluggable Database (PDB) or clone of an
15.            existing PDB and the user's password did not meet the
16.            requirements of the mandatory profile enforced in the PDB.
17. *Action:   Change the password or contact the database administrator to
18.            understand the rules for choosing the new password which complies
19.            with the mandatory profile.
20. 供应商代码 28001

复制代码

2、处理方法

2.1、以SYSDBA身份登陆

1. sqlplus 账号/"密码"@数据库IP地址/数据库服务名 as sysdba;

复制代码

2.2、修改账号的密码

1. alter user 账号 identified by "密码";

复制代码

2.3、测试效果

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

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

来源：程序园用户自行投稿发布，如果侵权，请联系站长删除
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！