ORA-28001: the password has expired scott/tiger
来源:互联网 发布:智慧足迹数据科技 编辑:程序博客网 时间:2024/06/05 15:47
今天在使用oracle 11时,使用sqlplus中默认的账号scott登录,发现报错,无法登录
解决此类问题:
1,账号scott已经是unlocked状态了。--当然,他不会报这个错
2,
Oracle11g的密码过期。
原因:是由于oracle11g中默认在default概要文件中设置了“PASSWORD_LIFE_TIME=180天”所导致。
,3,
C:\>sqlplus / as sysdba
查看指定概要文件(如default)的密码有效期设置:
SQL> select * from dba_profiles where profile='DEFAULT' and resource_name='PASSWORD_LIFE_TIME';
4,如果时间限制为180天,则执行如下操作,修改成无限期的:
SQL> alter profile default limit password_life_time unlimited;
SQL> commit;
5,如果还不行,这里有个简单的方法。将密码改成一个新密码,然后再用password命令,再修过回原来的密码即可
- ORA-28001: the password has expired scott/tiger
- 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解决方法
- filter_interceptor
- Android学习之路——9.Creating an IME(译)
- priority_queue使用方法
- dedecms在本人博客的由来
- 1414_Number Steps
- ORA-28001: the password has expired scott/tiger
- 在sqlserver中创建表
- haproxy配置文件详解
- 图片垂直居中
- java框架Hibernate连接SQL Server
- google map的简单二次开发
- PHP实现无限分类
- 在html中添加背景音乐和图片
- 模拟static_assert