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】

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。