Oracle ORA-28001: the password has expired
来源:互联网 发布:什么是串口编程 编辑:程序博客网 时间:2024/05/21 12:14
今天重启服务器,发现连接的数据库有个账号密码过期了,然后在网上搜索了哈解决办法。顺便在自己的博客中备忘。以下是我解决的步骤:
1. 以sysdba连接数据库;
在命令行里面输入: sqlplus /as sysdba或者直接打开sqlplus,输入命令: conn /as sysdba
2. 然后查看密码过期的用户的密码管理方式:
SQL> select profile from dba_users where username='SYSTEM';
3. 在查看该管理方式的详细信息:
SQL> select * from dba_profiles where profile=[用户密码管理方式] and resource_name='PASSWORD_LIFE_TIME';
4. 修改账号密码并设置数据库的该账号的密码为永久有效:
SQL> alter user[username] identified by [password];
SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED ;
5. 重新登陆该账号即可。
0 0
- Oracle ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- Oracle报错,ORA-28001:the password has expired
- Oracle提示错误消息ORA-28001: the password has expired
- ORA-28001: the password has expired Oracle 密码过期
- Oracle密码过期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
- Tomcat配置(备忘)
- RelativeLayout 显示、隐藏、移除
- Matalb符号矩阵输入BUG
- 【Cocos2d-x】3.6 Android环境搭建
- 多线程代码
- Oracle ORA-28001: the password has expired
- android之3g调试1
- 欢迎使用CSDN-markdown编辑器
- [NOIP2009][spfa]最优贸易
- StormDRPC 概念以及简单例子测试
- C++中的static关键字的总结
- 华为OJ测试--在字符串中找出连续最长的数字串
- MVC异常过滤器 (错误页)
- python基础(1)