28007oracle,ORA-28007密码无法重用?怎么回事?

今天修改用户的profile,测试密码修改和重用,结果发现

ORA-28007,密码无法重用

各位大侠们快帮忙诊断一下.补充:在windows下9.2.0.1测试没有问题

测试过程

[php]

操作系统：AIX 5200-05

[oracle@res2] /oracle> sqlplus "/as sysdba"

SQL*Plus: Release 9.2.0.6.0 - Production on Thu Apr 20 17:47:33 2006

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.

Connected to:

Oracle9i Enterprise Edition Release 9.2.0.6.0 - 64bit Production

With the Partitioning option

JServer Release 9.2.0.6.0 - Production

SQL> show parameter res

NAME                                 TYPE        VALUE

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

enqueue_resources                    integer     7500

hi_shared_memory_address             integer     0

mts_listener_address                 string

optimizer_features_enable            string      9.2.0

resource_limit                       boolean     FALSE

resource_manager_plan                string

shared_memory_address                integer     0

shared_pool_reserved_size            big integer 30198988

undo_suppress_errors                 boolean     FALSE

SQL> alter system set resource_limit=true;

System altered.

SQL> create profile p_passwd limit

2         failed_login_attempts 5

3          password_life_time 85

4         password_reuse_max 3

5          password_grace_time 5;

Profile created.

SQL> create user toms identified by toms;

User created.

SQL> alter user toms profile p_passwd;

User altered.

SQL> alter profile p_passwd limit password_reuse_time 3/1440;

Profile altered.

SQL> alter profile p_passwd limit password_reuse_max 3;

Profile altered.

SQL> alter user toms identified by toms1;

User altered.

SQL> alter user toms identified by toms2;

User altered.

SQL> alter user toms identified by toms3;

User altered.

SQL> alter user toms identified by toms;

User altered.

SQL> alter user toms identified by toms;

alter user toms identified by toms

*

ERROR at line 1:

ORA-28007: the password cannot be reused

SQL> set time on

17:49:31 SQL>

17:50:22 SQL>

17:51:00 SQL>

17:51:28 SQL>

17:52:13 SQL>

17:53:54 SQL> alter user toms identified by toms;

alter user toms identified by toms

*

ERROR at line 1:

ORA-28007: the password cannot be reused

17:56:50 SQL> select * from sys.user_history$;

USER# PASSWORD                       PASSWORD_DATE

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

72 72E8A3B73B937D6F               20060420174913

72 E262B02D5984C8CF               20060420174919

72 25EA60AC95CBC7D8               20060420174922

72 CAA416E25BD69736               20060420174924

17:56:54 SQL> alter user toms identified by toms;

alter user toms identified by toms

*

ERROR at line 1:

ORA-28007: the password cannot be reused

17:57:30 SQL> /

alter user toms identified by toms

*

ERROR at line 1:

ORA-28007: the password cannot be reused

18:00:09 SQL>

18:01:25 SQL>

18:01:25 SQL>

[/php]