ORA-28001: the password has expired
来源:互联网 发布:sqlserver数据库安装 编辑:程序博客网 时间:2024/06/06 03:03
Oracle提示错误消息ORA-28001: the password has expired
问题产生原因:是由于Oracle 11G的新特性所致, Oracle 11G创建用户时缺省密码过期限制是180天, 如果超过180天用户密码未做修改则该用户无法登录。
解决方法:
首先,以SYS DBA身份进入sqlpuls
打开sqlpuls
SQL->请输入用户名:sys as sysdba
SQL->密码:
SQL->select username,account_status from dba_users;
查看其中常用的用户状态是否是EXPIRED 还是LOCKED
有的是LOCKED<TIME>
如果sysman状态是过期,修改密码方法:
语句查询密码的有效期设置,
LIMIT字段是密码有效天数。在密码将要过期或已经过期时可通过
ALTER USER 用户名 IDENTIFIED BY 密码 ;
语句进行修改密码,密码修改后该用户可正常连接数据库。
长久对应可通过
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
语句将口令有效期默认值180天修改成“无限制”。出于数据库安全性考虑,不建议将PASSWORD_LIFE_TIME值设置成UNLIMITED,
建议客户定期修改数据库用户口令。
0 0
- ORA-28001: the password has expired
- 解决"ORA-28001: the password has expired”
- ORA-28001: the password has expired
- ORA-28001: the password has expired
- 解决"ORA-28001: the password has expired”
- ORA-28001: the password has expired .
- ORA-28001: the password has expired
- ORA-28001: the password has expired
- ORA-28001: the password has expired
- ORA-28001: the password has expired解决方法
- ORA-28001: the password has expired
- ORA-28001: the password has expired解决方法
- ORA-28001: the password has expired解决方法
- 解决ORA-28001 the password has expired
- ORA-28001: the password has expired
- ORA-28001: the password has expired
- ORA-28001: the password has expired解决方法
- ORA-28001: the password has expired
- Android回调函数理解
- Anroid之WakeLock
- 有序数组,输出和为m的所有数对(pair)
- Maven运行JUnit测试之mvn test的默认行为
- 文章标题
- ORA-28001: the password has expired
- iOS Visual format language(VFL)
- WM_QUERYENDSESSION
- android 实现侧滑菜单
- 架构整洁之道
- 余弦距离、欧氏距离和杰卡德相似性度量的对比分析
- android 的onResume方法
- 自己喜欢的句子
- ITPub 上的一道题,学习下思路