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.
供应商代码 280012、处理方法
2.1、以SYSDBA身份登陆
sqlplus 账号/"密码"@数据库IP地址/数据库服务名 as sysdba;2.2、修改账号的密码
alter user 账号 identified by "密码";2.3、测试效果
如上图所示，密码修改成功，连接正常。
本文参考
【1】【佚名】【怎么修改oracle用户密码，特殊字符】【爱码网】【2023-11-08】
来源：程序园用户自行投稿发布，如果侵权，请联系站长删除
免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！
页:
[1]