Oracle密码过期the password has expired解决办法
来源:互联网 发布:手机淘宝联盟鹊桥入口 编辑:程序博客网 时间:2024/05/16 18:02
oracle 出现the password has expired这个问题,今天突然发现项目访问不了,一查发现用不了,也登不进去,
这个问题由是Oracle11g密码过期的原因导致的
调试Web项目的时候出现异常:
[java] view plaincopyprint?
- java.sql.SQLException: ORA-28001: the password has expired
网上查了一下,连接Oracle,以Oracle用户登陆,输入以下命令
[sql] view plaincopyprint?
- select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
结果显示:
[html] view plaincopyprint?
- PROFILE
- ------------------------------------------------------------
- RESOURCE_NAME
- ------------------------------------------------------------
- RESOURCE_TYPE
- ----------------
- LIMIT
- ------------------------------------------------------------
- DEFAULT
- PASSWORD_LIFE_TIME
- PASSWORD
- 180
- ------------------------------------------------------------
结果显示密码有效期是180天
输入命令:
[sql] view plaincopyprint?
- alter profile default limit password_life_time unlimited;
- commit;
再次执行:
[sql] view plaincopyprint?
- select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
结果显示为:
[sql] view plaincopyprint?
- PROFILE
- ------------------------------------------------------------
- RESOURCE_NAME
- ------------------------------------------------------------
- RESOURCE_TYPE
- ----------------
- LIMIT
- ------------------------------------------------------------
- DEFAULT
- PASSWORD_LIFE_TIME
- PASSWORD
- UNLIMITED
- ------------------------------------------------------------
进行以上步骤之后需要改变密码,否则还会出现password has expired异常
改变密码的命令
[sql] view plaincopyprint?
- alter user XXXUSER identified by Welcome1;
如果账号被锁住,则需要解锁命令
[sql] view plaincopyprint?
- alter user XXXUSER identified by oracle account unlock;
再次调试,问题解决
0 0
- Oracle密码过期ORA-28001: the password has expired解决办法
- Oracle密码过期the password has expired解决办法
- Oracle密码过期the password has expired
- Oracle the password has expired -密码过期
- Oracle密码过期the password has expired
- Oracle密码过期the password has expired
- Oracle密码过期the password has expired
- Oracle密码过期the password has expired
- Oracle密码过期the password has expired
- Oracle密码过期the password has expired
- ORA-28001: the password has expired Oracle 密码过期
- ora-28001 the password has expired......oracle11g数据库密码过期
- Oracle 11g 密码过期问题 (password has expired)
- oracle 账号过期的解决办法 ORA-28001 ,28002 the password has expired
- oracle-the password has expired
- ORA-28001: the password has expired解决办法
- ORA-28001: the password has expired解决办法
- oracle 12c the password has expired
- RDS MySQL空间优化最佳实践
- android本地音乐播放器
- Watching the Kangaroo
- SQL解析过程详解
- va_start()
- Oracle密码过期the password has expired解决办法
- 在Debian 8(jessie)上安装Docker
- Node.JS 学习路线图
- HDU 4893 Wow! Such Sequence! (线段树单点更新+区间更新+区间查询+二分)
- 用java连接mongodb并执行$sum和$avg结合的聚合函数的实例。
- centos yum升级php5.3.3到最5.6.3
- python学习——第一个Python程序
- va_start和va_end使用详解
- 343. Integer Break