My Oracle Support Banner

Password Change Will Truncate The Password To 30 Characters (Doc ID 342872.1)

Last updated on FEBRUARY 22, 2019

Applies to:

SQL*Plus - Version 9.2.0.1 and later
z*OBSOLETE: Microsoft Windows 2000
z*OBSOLETE: Microsoft Windows XP
z*OBSOLETE: Microsoft Windows Server 2003
"Checked for relevance on 09-Nov-2007"

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.

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.