ORA-28001: the password has expired
来源:互联网 发布:手机淘宝如何找星店 编辑:程序博客网 时间:2024/06/17 04:30
ORA-28001: the password has expired
通过ORACLE_NET_SERVICE 连接数据库的时候,报错ORA-28001: the password has expired 密码无效
方法/步骤
查看联机文档相关报错
ORA-28001: the password has expired
Cause: The user's account has expired and the password needs to be changed
Action: change the password or contact the DBA
需要通过sqlplus / as sysdba 方式进去数据库更改
查看用户密码默认管理方式
SQL> select profile from dba_users where username='ZXX';
PROFILE
------------------------------
DEFAULT
查看数据库默认的密码管理方式有效期
SQL> SELECT * FROM dba_profiles WHERE profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE
------------------------------ -------------------------------- --------
LIMIT
----------------------------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD
180
修改用户密码并设置数据库默认密码为永久有效
SQL> alter user zxx identified by zxx;
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED ;
验证修改是否成功
sqlplus zxx/zxx@orcl 登录正常
DEFAULT 密码管理方式为永久有效
- 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
- 最大连续子序列之和
- jQuery表单input文本框默认说明文字获得焦点后消失效果
- php中的short_open_tag的作用
- Android Studio 解决方法数超过65536,导致dex无法生成的问题
- Java网络爬虫抓取新浪微博个人微博记录
- ORA-28001: the password has expired
- HDU 3904 A tree game题解
- PHP 5.0 的 新特性
- Code 阅读神器
- C++中使用TinyXML2
- 备忘录模式
- 网站发布后在IIS上定时执行任务
- Log4j.properties配置
- Blob、FileReader全面解析