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"

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 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

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

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

Warning: You are no longer connected to ORACLE.

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