dongnan
总版主
总版主
  • 粉丝52
  • 发帖数2186
  • 铜币13612枚
  • 威望5957点
  • 银元150个
  • 社区居民
  • 最爱沙发
  • 忠实会员
  • 喜欢达人
  • 原创写手
阅读:1692回复:0

ORA-28001: the password has expired

楼主#
更多 发布于:2015-07-20 11:02
错误信息
ORA-28001: the password has expired,

由于Oracle 11G的新特性所致, Oracle 11G创建用户时缺省密码过期限制是180天, 如果超过180天用户密码未做修改则该用户无法登录。

提示密码过期
sqlplus dongnan/ywwd.net@//172.27.233.49:1521/hpns
SQL*Plus: Release 11.2.0.1.0 Production on Fri May 22 15:40:38 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.

ERROR:
ORA-28001: the password has expired

#按照提示更改密码.
Changing password for pngroup
New password:
Retype new password:
Password changed

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> quit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options


#使用新密码登录
sqlplus dongnan/ywwd.net@//172.27.233.49:1521/hpns

SQL*Plus: Release 11.2.0.1.0 Production on Fri May 22 15:41:02 2015

Copyright (c) 1982, 2009, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>


扩展
将口令有效期默认值180天修改成“无限制”。出于数据库安全性考虑,不建议将PASSWORD_LIFE_TIME值设置成UNLIMITED,
sqlplus "/as sysdba"
   
alter profile default limit password_life_time unlimited;


内容来自

http://www.linuxidc.com/Linux/2011-09/43100.htm
游客

返回顶部