Oracle密码过期the password has expired
来源:互联网 发布:银河麒麟linux下载 编辑:程序博客网 时间:2024/05/18 00:42
调试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;
再次调试,问题解决
from: http://blog.csdn.net/android_robot/article/details/7598345
阅读全文
0 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
- 响应式网格布局
- 使用hammer.js实现移动端webAPP手势滑动切换页面
- 二叉树的所有路径
- 解读pixhawk加速度计校准代码
- [LINUX]批量替换字符串
- Oracle密码过期the password has expired
- poj 1120 A New Growth Industry 模拟
- C++各种常见排序算法
- 细说反射,Java 和 Android 开发者必须跨越的坎
- 【PAT】【Advanced Level】1010. Radix (25)
- CodeForces 575 A.Fibonotci(矩阵快速幂+线段树)
- VMware虚拟机备份和恢复
- 系统类,系统分类和自定义分类优先级
- C primer plus(编程练习)file-3.11-3