oracle用户密码过期问题

最新推荐文章于 2024-07-18 11:10:50 发布

柳暗发明君

最新推荐文章于 2024-07-18 11:10:50 发布

阅读量465

点赞数

CC 4.0 BY-SA版权

本文链接：https://blog.youkuaiyun.com/techsupporter/article/details/78241147

本文介绍了在使用Oracle数据库时遇到的密码过期错误，并提供了两种解决方案：一是临时更新用户密码；二是通过更改默认配置文件中的密码有效期设置来永久解决该问题。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

[oracle@edbjr2p1 ~]$ rman target / catalog rc_admin/rc_admin@prod4

Recovery Manager: Release 11.2.0.3.0 - Production on Sat Oct 14 15:38:28 2017

Copyright (c) 1982, 2011, Oracle and/or its affiliates. All rights reserved.

connected to target database: PROD2 (not mounted)
RMAN-00571: ===========================================================
RMAN-00569: =============== ERROR MESSAGE STACK FOLLOWS ===============
RMAN-00571: ===========================================================
RMAN-00554: initialization of internal recovery manager package failed
RMAN-04004: error from recovery catalog database: ORA-28001: the password has expired
[oracle@edbjr2p1 ~]$

查看用户用的是哪个profile，查看dba_profile表，默认是DEFAULT，查看一下DEFAULT对应的PASSWORD_LIFE_TIME参数，默认为180天

SYS@PROD4>select profile from dba_users where username='RC_ADMIN';

PROFILE
------------------------------
DEFAULT

SYS@PROD4>

select * from dba_profiles where profile='DEFAULT'
PROFILE RESOURCE_NAME RESOURCE LIMIT
------------------------------ -------------------------------- -------- ----------------------------------------
DEFAULT COMPOSITE_LIMIT KERNEL UNLIMITED
DEFAULT SESSIONS_PER_USER KERNEL UNLIMITED
DEFAULT CPU_PER_SESSION KERNEL UNLIMITED
DEFAULT CPU_PER_CALL KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
DEFAULT LOGICAL_READS_PER_CALL KERNEL UNLIMITED
DEFAULT IDLE_TIME KERNEL UNLIMITED
DEFAULT CONNECT_TIME KERNEL UNLIMITED
DEFAULT PRIVATE_SGA KERNEL UNLIMITED
DEFAULT FAILED_LOGIN_ATTEMPTS PASSWORD 10
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
DEFAULT PASSWORD_REUSE_TIME PASSWORD UNLIMITED
DEFAULT PASSWORD_REUSE_MAX PASSWORD UNLIMITED
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD NULL
DEFAULT PASSWORD_LOCK_TIME PASSWORD 1
DEFAULT PASSWORD_GRACE_TIME PASSWORD 7

解决：

1.ALTER USER 用户名 IDENTIFIED BY 密码 ; 即可连接

2.可以永久修改为无限制
alter profile default limit password_life_time unlimited;