My Oracle Support Banner

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

Last updated on OCTOBER 27, 2016

Applies to:

SQL*Plus - Version: 9.2
Microsoft Windows 2000
Microsoft Windows XP
Microsoft Windows Server 2003

"Checked for relevance on 09-Nov-2007"


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 scott identified by qwertyuiopasdfghjklzxcvbnm1234567890;
alter user scott identified by qwertyuiopasdfghjklzxcvbnm1234567890
ERROR at line 1:
ORA-00972: identifier is too long

Verified issue with SQL*Plus

Changing password for SCOTT
Old password: tiger
New password: qwertyuiopasdfghjklzxcvbnm1234567890
Retype new password: qwertyuiopasdfghjklzxcvbnm1234567890
Password changed

SQL> connect scott/qwertyuiopasdfghjklzxcvbnm1234567890@ora92
ORA-01017: invalid username/password; logon denied

Warning: You are no longer connected to ORACLE.


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

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