ORA-28001: the password has expired
来源:互联网 发布:excel编程容易找工作吗 编辑:程序博客网 时间:2024/05/16 05:27
Oracle提示错误消息ORA-28001: the password has expired
发表于:2011年09月19日 15:38 0
首先,以SYS DBA身份进入sqlpuls
打开sqlpuls
SQL->请输入用户名:sys as sysdba
SQL->密码:
登录成功以后查询DBA用户状态
SQL->select username,account_status from dba_users;
查看其中常用的用户状态是否是EXPIRED 还是LOCKED
有的是LOCKED<TIME>
如果sysman状态是过期,修改密码方法:
语句查询密码的有效期设置,
LIMIT字段是密码有效天数。在密码将要过期或已经过期时可通过
ALTER USER 用户名 IDENTIFIED BY 密码 ;
语句进行修改密码,密码修改后该用户可正常连接数据库。
长久对应可通过
ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED
语句将口令有效期默认值180天修改成“无限制”。出于数据库安全性考虑,不建议将PASSWORD_LIFE_TIME值设置成UNLIMITED,
建议客户定期修改数据库用户口令。
- 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解决方法
- ORA-28001: the password has expired
- ORA-19815: WARNING: db_recovery_file_dest_size of 2147483648 bytes is 87.41% used
- C语言:循环名句运用 累加器输入一个数值进行累加,输入13
- ORA-24324: service handle not initialized
- JavaSE使用log4j个性化控制日志
- 对象结构型——组合模式(Composite)
- ORA-28001: the password has expired
- 2011年贝佐斯给股东的一封信:发明的力量
- 操作系统GUI历史与争论
- 近期工作中的错误总结
- 什么是ROM、RAM、DRAM、SRAM和FLASH的区别
- iPhone网络开发之如何使用NSURLConnection
- c++程序实验报告(15-3)
- 小问题积累
- Tomcat6.0虚拟目录配置