oracle-the password has expired
来源:互联网 发布:手机淘宝店铺怎么登录 编辑:程序博客网 时间:2024/04/30 21:15
调试Web项目的时候出现异常:
- java.sql.SQLException: ORA-28001: the password has expired
首先需要登录用户如:
密令:sqlplus
用户名:x5sys 密码:123456
登录后,才能进行以下语句
连接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 12c the password has expired
- Oracle密码过期the password has expired
- Oracle密码过期the password has expired
- Oracle ORA-28001: the password has expired
- Oracle密码过期the password has expired
- Oracle密码过期the password has expired
- Oracle密码过期the password has expired
- the password has expired
- the password has expired
- the password has expired
- the password has expired
- Oracle user password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- 基础练习 特殊回文数
- Eclipse中运行Maven打包编译时出现:Perhaps you are running on a JRE rather than a JDK?
- BloomFilter算法概述
- 综合素质评价系统-北上广深必须上的教育项目
- c语言fopen函数
- oracle-the password has expired
- excel2007保存时候比较卡的解决方法
- kafka入门:简介、使用场景、设计原理、主要配置及集群搭建(转)
- JSON.NET VS BinaryFormatter 性能
- 冒泡排序和插入排序区别
- 判断网络状态
- 插入排序法-C描述
- 【Inno Setup】添加许可协议,并默认选中我同意按钮
- python 安装 numpy,scipy模块