errorORA-28001 the password has expired .或者Caused by: java.sql.SQLException: ORA-28001: 口令已经失效
来源:互联网 发布:java个人简历 编辑:程序博客网 时间:2024/06/06 08:34
解决:
1、先在sqlpuls使用sql
在 SQL> 下运行:SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
查看出现的结果
ROW1 FIELDS
PROFILE DEFAULT
RESOURCE_NAME PASSWORD_LIFE_TIME
RESOURCE_TYPE PASSWORD
LIMIT UNLIMITED
2、如果字段 LIMIT的值是“UNLIMITED”,则是正常的。如果是“LIMITED”或是“180”,
则需运行下面的语句
在 SQL>下运行:ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;
2、commit;
4、commit;后,在修改PASSWORD_LIFE_TIME值之前已经失效的用户,还是需要重新修改一次密码才能使用。
ALTER USER test INDENTIFIED BY password
5、可打开users目录,找到相应的user,之后进行编辑,查看口令的勾是否还打上(正常情况下是没有勾上)
- errorORA-28001 the password has expired .或者Caused by: java.sql.SQLException: ORA-28001: 口令已经失效
- java.sql.SQLException: 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
- ubuntu11.10上安装Squid配置代理服务器
- 嵌入式linux的mdev机制
- Android Make flow
- 设计模式之外观
- js 模拟qq对话框的拖动效果
- errorORA-28001 the password has expired .或者Caused by: java.sql.SQLException: ORA-28001: 口令已经失效
- Zigbee基础实验之ADC
- 苹果的傲慢
- 电信项目三月结
- C++ 希尔排序
- 线程与内核对象的同步
- 简易任务调度实现--可用于windows服务/asp.net网站执行后台计算
- php调用C++扩展库出现段错误 (core dumped)
- [QTP] Retrieves the value of the cell in the specified row of the parameter in the run-time Data Tab