6

ORA-28002: the password will expire within 2 days

 2 years ago
source link: https://blog.51cto.com/u_15679792/5687430
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.
neoserver,ios ssh client

ORA-28002: the password will expire within 2 days

精选 原创

今天启动皕杰报表平台时候，发现tomcat报警告信息ORA-28002: the password will expire within 2 days，这实际上是oracle11g中默认在default概要文件中设置了"PASSWORD_LIFE_TIME=180”所导致,oracle用户的密码必须在180天内更改，或则启动数据库的时候会提示连接失败，oracle默认用户180天内得改一次密码。

1、查看用户的proifle是那个，一般是default：

SELECT username,PROFILE FROM dba_users;

2、查看指定概要文件（如default）的密码有效期设置：

SELECT * FROM dba_profiles s WHERE s.profile=’DEFAULT’ AND resource_name=’PASSWORD_LIFE_TIME’;

3、将密码有效期由默认的180天修改成“无限制”：

ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

4、修改后，还没有被提示ORA-28002警告的用户不会再碰到同样的提示；

但是已经提示的用户必须改次密码，可以改成原来一样的密码。

alter user root identified by 123；

  • 赞
  • 收藏
  • 评论
  • 分享
  • 举报

</div


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK