ORA-600: [4406] - ORA-28003 - ORA-20002 when executing SQLPLUS PASSWORD command (Doc ID 744651.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.3
This problem can occur on any platform.

Symptoms

-- Changing password
SQL> password
Changing password for TEST
Old password:        <-- specify current password
New password:        <-- type in a conflicting password
Retype new password: <-- retype conflicting password

ERROR:
ORA-600: internal error code, arguments: [4406], [0x32E1E574], [0x0],
ORA-28003: password verification for the specified password failed
ORA-20002: Password length less than 8

            
            
            
STACK TRACE: (ORA-600)
------------
ktcrab kpoauth opiodr ttcpip opitsk opiino opiodr opidrv ...
 

Changes

Issue occurs when:

SQL> password 
SELECT * FROM sys.dba_profiles 
where resource_name='PASSWORD_VERIFY_FUNCTION'
and limit != 'NULL';
PROFILE                 RESOURCE_NAME RESOURCE LIMIT 
--------- --------------------------- -------- ---------------
DEFAULT PASSWORD_VERIFY_FUNCTION PASSWORD VERIFY_PWD
Example - Password Verification Function 
----------------------------------------
...
IF LENGTH (PASSWORD) < 8
THEN
INSERT INTO log_password(dt_chgt_pwd,status,v_schema,v_txt)
VALUES (SYSDATE, 'ERROR',username,
SYS_CONTEXT ('USERENV', 'OS_USER')
|| ', terminal '
|| SYS_CONTEXT ('USERENV', 'TERMINAL')
|| ', logged on as user: '
|| SYS_CONTEXT ('USERENV', 'CURRENT_SCHEMA')
....
COMMIT; <== Commit is triggering the issue!
...

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms