DOYENSYS Knowledge Portal




We Welcome you to visit our DOYENSYS KNOWLEDGE PORTAL : Doyensys Knowledge Portal




Sunday, March 20, 2016

ORA-28003: password verification for the specified password failed

SQL> alter user oracle identified by oracle123;
alter user oracle identified by oracle123
*
ERROR at line 1:
ORA-28003: password verification for the specified password failed
ORA-20009: Error: You cannot change password.

SQL> select profile from dba_users where username='oracle';

PROFILE
——————————
DEFAULT

SQL> select RESOURCE_NAME,RESOURCE_TYPE,LIMIT FROM DBA_PROFILES WHERE PROFILE='DEFAULT' AND RESOURCE_NAME='PASSWORD_VERIFY_FUNCTION';

RESOURCE_NAME                    RESOURCE
——————————– ——–
LIMIT
—————————————-
PASSWORD_VERIFY_FUNCTION         PASSWORD
PWD_CHANGE


SQL> ALTER PROFILE DEFAULT LIMIT PASSWORD_VERIFY_FUNCTION NULL;

Profile altered.

SQL> alter user oracle identified by oracle123;

User altered.

SQL> conn oracle/oracle123;
Connected.

No comments: