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;
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