Oracle密码过期the password has expired
来源:互联网 发布:移动4g是什么网络 编辑:程序博客网 时间:2024/05/18 02:33
调试Web项目的时候出现异常:
- java.sql.SQLException: ORA-28001: the password has expired
连接Oracle,以Oracle用户登陆,输入以下命令
- select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
- PROFILE
- ------------------------------------------------------------
- RESOURCE_NAME
- ------------------------------------------------------------
- RESOURCE_TYPE
- ----------------
- LIMIT
- ------------------------------------------------------------
- DEFAULT
- PASSWORD_LIFE_TIME
- PASSWORD
- 180
- ------------------------------------------------------------
输入命令:
- alter profile default limit password_life_time unlimited;
- commit;
- select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
- PROFILE
- ------------------------------------------------------------
- RESOURCE_NAME
- ------------------------------------------------------------
- RESOURCE_TYPE
- ----------------
- LIMIT
- ------------------------------------------------------------
- DEFAULT
- PASSWORD_LIFE_TIME
- PASSWORD
- UNLIMITED
- ------------------------------------------------------------
改变密码的命令
- alter user XXXUSER identified by Welcome1;
- alter user XXXUSER identified by oracle account unlock;
1 0
- 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 密码过期
- Oracle密码过期ORA-28001: the password has expired解决办法
- Oracle密码过期the password has expired解决办法
- ora-28001 the password has expired......oracle11g数据库密码过期
- Oracle 11g 密码过期问题 (password has expired)
- oracle-the password has expired
- oracle 账号过期的解决办法 ORA-28001 ,28002 the password has expired
- oracle 12c the password has expired
- Oracle ORA-28001: the password has expired
- the password has expired
- ISBN
- NYOJ116 士兵杀敌(二)【树状数组】
- HDOJ题目2952Counting Sheep (DFS)
- highcharts之多折线图
- kafka+storm集成并运行demo-单机
- Oracle密码过期the password has expired
- git merge与rebase 区别
- 不用插件实现WordPress代码高亮显示
- ZooKeeper的简单操作
- IO流
- Android -- 查询手机上所有的能分享图片或者文字的App packageName
- 要像管理咨询一样去做软件需求调研
- LinearLayout 属性详解
- OC:字符串类(Foundation)