• Article Type: General
• Product: Aleph
• Product Version: 20

Description:
Running util Y/8 displays the error message:
ORA-00922: missing or invalid option

Enter Number [0] 1
Enter User Name:USM50
Enter New Password:p@ssword
Do you want to update this password in ALEPH Password file ([n]/y)? Y
The password for USM50 was saved in ALEPH password file
If you want to update this password in Oracle
Enter ALEPH_DBA user/passwd, or press [Enter] to exit :ALEPH_DBA/ALEPH_DBA_PASSWORD
Change passwd in Oracle

SQL*Plus: Release 11.1.0.7.0 - Production on Thu Jul 8 10:41:39 2010

Copyright (c) 1982, 2008, Oracle. All rights reserved.

SQL> Connected.
SQL> SQL> alter user USM50 identified by p@ssword
*
ERROR at line 1:
ORA-00922: missing or invalid option


SQL> Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Enter CR to continue...

Resolution:
Normal Oracle passwords can contain only alphanumeric characters, underscore “_”, dollar sign “$” and pound/hash sign “#”. The password is a maximum of 30 characters which means that the total permutations are 39 (26+10+3) to the power of 30, though it is slightly less due to these three facts:

* Oracle discourages using “$” and “#” character in the password to avoid scripting errors.
* The password cannot start with either “_”, “$”, “#” or any number.
* The password cannot contain Oracle/SQL keywords like SELECT.

If you want the password to have characters other than the 39 listed then use util Y/8 to update the ALEPH password file but do not use util Y/8 to update the password in Oracle. Instead you will have to connect to the database as ALEPH_DBA and then issue the same command as above with the password enclosed in double quotes

SQL> alter user USM50 identified by "p@ssword";

You know the change was successful if the response to the above command is:
User altered

• Article last edited: 10/8/2013