Password Change Will Truncate The Password To 30 Characters
(Doc ID 342872.1)
Last updated on JANUARY 31, 2022
Applies to:
SQL*Plus - Version 9.2.0.1 and laterz*OBSOLETE: Microsoft Windows 2000
z*OBSOLETE: Microsoft Windows XP
z*OBSOLETE: Microsoft Windows Server 2003
Symptoms
In Oracle9i SQL*Plus on Windows a PASSWORD Command or a forced password change through a expired
password will truncate a specified password with over 30 characters to the maximum allowed 30 characters.
Oracle9i SQL*Plus will show error "SP2-0650: New passwords do not match" on Linux.
Oracle10g SQL*Plus will report the correct behavior of showing error:
ORA-00988: missing or invalid password(s)
ALTER USER will report:
SQL> alter user <USERNAME> identified by <LONGLONGPASWORD>;
alter user <USERNAME> identified by <LONGLONGPASSWORD>
ERROR at line 1:
ORA-00972: identifier is too long
Verified issue with SQL*Plus
SQL>password
Changing password for <USER>
Old password: <ShortPassword>
New password: <LONGLONGPASSWORD>
Retype new password: <LONGLONGPASSWORD>
Password changed
SQL>
SQL> connect <USER>/<LONGLONGPASSWORD>@DBNAME
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
SQL> alter user <USERNAME> identified by <LONGLONGPASWORD>;
alter user <USERNAME> identified by <LONGLONGPASSWORD>
ERROR at line 1:
ORA-00972: identifier is too long
Verified issue with SQL*Plus
SQL>password
Changing password for <USER>
Old password: <ShortPassword>
New password: <LONGLONGPASSWORD>
Retype new password: <LONGLONGPASSWORD>
Password changed
SQL>
SQL> connect <USER>/<LONGLONGPASSWORD>@DBNAME
ERROR:
ORA-01017: invalid username/password; logon denied
Warning: You are no longer connected to ORACLE.
Cause
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Symptoms |
Cause |
Solution |
References |