Drop Down MenusCSS Drop Down MenuPure CSS Dropdown Menu

Monday, April 29, 2019

ORA-28007: the password cannot be reused

SQL>  alter user system identified by xxxx;
 alter user system identified by xxxx
*
ERROR at line 1:
ORA-28007: the password cannot be reused

User status:
select USERNAME, PROFILE, ACCOUNT_STATUS from dba_users where username = 'SYSTEM';

Check user profile:

select * from dba_profiles where profile='USER_PROFILE';
select * from dba_profiles where profile='DBUSER' and  RESOURCE_NAME in ('PASSWORD_REUSE_TIME') ;

col PROFILE format a50;
select * from dba_profiles where profile like '%C##EMGC_PROFIL%';

alter profile USER_PROFILE limit password_verify_function NULL;
alter profile USER_PROFILE limit PASSWORD_REUSE_MAX unlimited;
alter profile C##EMGC_PROFILE limit PASSWORD_REUSE_MAX unlimited;
alter profile USER_PROFILE limit PASSWORD_REUSE_TIME unlimited;

Once the password is changed make it to default...


Disable Password Policy in Oracle Database 12c and solution to ORA-28003: password verification for the specified password failed
Check if PASSWORD_VERIFY_FUNCTION is used:
SQL> select limit from dba_profiles where profile = 'DEFAULT' and resource_name = 'PASSWORD_VERIFY_FUNCTION';
--Turn off verification:
alter profile default limit password_verify_function null;

======
set pages 200;
set lines 200;
col LIMIT format a30;
col PROFILE format a40;
select profile, resource_name, limit from dba_profiles where resource_type='PASSWORD' order by 1,2;

alter profile DEFAULT limit PASSWORD_REUSE_TIME UNLIMITED;

alter profile DEFAULT limit PASSWORD_REUSE_MAX UNLIMITED;

alter profile default limit password_verify_function ORA12C_STRONG_VERIFY_FUNCTION;

No comments:

Post a Comment