SOLVED

ORA-28002: the password will expire within 7 days

Asked by OracleDba••12 views•oracle
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
ORA-28002: the password will expire within 7 days

ORA-28002:

the password will expire within 7 days

Cause:

The user's account is about to about to expire and the password needs 

to be changed.

Action:

Change the password or contact the database administrator.
#oracle#error

Solutions(1)

Accepted Solution
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
s:

1) Simply change the password to avoid it temporary

[oracle@lnxsvr ~]$ sqlplus scott/tiger

  SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012

  Copyright (c) 1982, 2009, Oracle.  All rights reserved.

  ERROR:

  ORA-28002: the password will expire within 7 days

  Connected to:

  Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

  SQL> PASSWORD

  Changing password for SCOTT

  Old password:

  New password:

  Retype new password:

  Password changed

2) Set PASSWORD_LIFE_TIME of the profile assigned user to UNLIMITED 

   then change the password to avoid it permanently

[oracle@lnxsvr ~]$ sqlplus scott/tiger

SQL*Plus: Release 11.2.0.1.0 Production on Wed Jun 20 14:08:01 2012

Copyright (c) 1982, 2009, Oracle. All rights reserved.

ERROR:

ORA-28002: the password will expire within 7 days

Connected to:

Oracle Database 11g Release 11.2.0.1.0 - 64bit Production

SQL> connect / as sysdba

Connected.

SQL> SELECT PROFILE FROM dba_users WHERE username = 'SCOTT';

PROFILE

------------------------------

DEFAULT

SQL> SELECT LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT'

AND RESOURCE_NAME='PASSWORD_LIFE_TIME';

LIMIT

----------------------------------------

60

SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_LIFE_TIME UNLIMITED;

Profile altered.

SQL> SELECT ACCOUNT_STATUS FROM DBA_USERS WHERE USERNAME='SCOTT';

ACCOUNT_STATUS

--------------------------------

EXPIRED(GRACE)

SQL> connect scott/tiger

Connected.

SQL> PASSWORD

Changing password for SCOTT

Old password:

New password:

Retype new password:

Password changed
OracleDba•

Post Your Solution