ORA-28002 Oracle 11g存在密码过期问题解决方案
网络编程 2021-07-05 16:08www.168986.cn编程入门
oracle数据库使用中会遇到ORA-28002 Oracle 11g存在密码过期问题,本文将提供详细的解决方案,需要的朋友可以参考下
故障现象
Oracle Database 11g 数据库普通用户登录时提示 ORA-28002: the password will expire within 7 days
[11:01:00oracle@dvd db_1]$sqlplus wang/oracle
SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the OLAP and Data Mining options
wang@SUN>
故障原因
Oracle 11G 普通用户有个180天的缺省密码周期,当快过期的时候即会出现此提示;
解决办法
查看当前用户对应profile、对应密码周期
select * from dba_profiles where profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
alter profile default limit password_life_time unlimited;
SELECT username,PROFILE FROM dba_users where username like upper('&USER');
sys@SUN> SELECT username,PROFILE FROM dba_users where username like upper('&USER');
Enter value for user: wang
old 1: SELECT username,PROFILE FROM dba_users where username like upper('&USER')
new 1: SELECT username,PROFILE FROM dba_users where username like upper('wang')
USERNAME PROFILE
------------------------------ ------------------------------
WANG DEFAULT
--查询到该用户对应的Profile文件为 DEFAULT
sys@SUN> set lines 222
sys@SUN> col PROFILE for a20
sys@SUN> col RESOURCE_NAME for a20
sys@SUN> col RESOURCE_TYPE for a20
sys@SUN> col LIMIT for a20
sys@SUN> select * from dba_profiles where profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
-------------------- -------------------- -------------------- --------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
--查询到该profile对应的密码生命周期配置为180天
修改当前用户对应profile对应对应密码周期
sys@SUN> alter profile default limit password_life_time 365;
Profile altered.
--修改该profile对应的密码生命周期配置为365天
sys@SUN> alter profile default limit password_life_time unlimited;
Profile altered.
--修改该profile对应的密码生命周期配置为 无限制
Oracle Database 11g 数据库普通用户登录时提示 ORA-28002: the password will expire within 7 days
[11:01:00oracle@dvd db_1]$sqlplus wang/oracle
SQL*Plus: Release 11.2.0.1.0 Production on Fri Nov 16 11:01:23 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
ERROR:
ORA-28002: the password will expire within 7 days
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - Production
With the OLAP and Data Mining options
wang@SUN>
故障原因
Oracle 11G 普通用户有个180天的缺省密码周期,当快过期的时候即会出现此提示;
解决办法
查看当前用户对应profile、对应密码周期
select * from dba_profiles where profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
alter profile default limit password_life_time unlimited;
SELECT username,PROFILE FROM dba_users where username like upper('&USER');
sys@SUN> SELECT username,PROFILE FROM dba_users where username like upper('&USER');
Enter value for user: wang
old 1: SELECT username,PROFILE FROM dba_users where username like upper('&USER')
new 1: SELECT username,PROFILE FROM dba_users where username like upper('wang')
USERNAME PROFILE
------------------------------ ------------------------------
WANG DEFAULT
--查询到该用户对应的Profile文件为 DEFAULT
sys@SUN> set lines 222
sys@SUN> col PROFILE for a20
sys@SUN> col RESOURCE_NAME for a20
sys@SUN> col RESOURCE_TYPE for a20
sys@SUN> col LIMIT for a20
sys@SUN> select * from dba_profiles where profile='DEFAULT' AND resource_name='PASSWORD_LIFE_TIME';
PROFILE RESOURCE_NAME RESOURCE_TYPE LIMIT
-------------------- -------------------- -------------------- --------------------
DEFAULT PASSWORD_LIFE_TIME PASSWORD 180
--查询到该profile对应的密码生命周期配置为180天
修改当前用户对应profile对应对应密码周期
sys@SUN> alter profile default limit password_life_time 365;
Profile altered.
--修改该profile对应的密码生命周期配置为365天
sys@SUN> alter profile default limit password_life_time unlimited;
Profile altered.
--修改该profile对应的密码生命周期配置为 无限制
编程语言
- 机械手焊接机器人编程 机械手焊接设备编程
- vb数据库编程实例,vb做数据库
- tiobe世界编程语言排行榜,全球编程语言排行
- 成都java编程培训 成都it编程培训中心
- 编程基础培训,编程基础知识培训
- flash游戏编程基础教程,flash游戏开发教程
- 不会英语能学编程吗 不会英语可以学程序员吗
- 爱心代码编程C语言 爱心代码编程c语言公式
- c语言编程学习入门 c语言编程快速入门
- 西门子plc编程培训 西门子plc编程培训班
- 哪里可以学编程 台州哪里可以学编程
- 少儿编程哪个好 少儿编程哪个品牌好
- 编程是什么意思,图形编程是什么意思
- c语言编程软件下载,c语言编程软件在哪下载
- java编程软件下载,java编程下载手机版
- ug编程培训学校,ug编程培训教程