During the installation of Oracle 11g R2, this error occurred while creating a new DB instance, and if you select Ignore, a ora-28000 error occurs. Through the network query verification, this is the first configuration of the administrator password, the use of the beginning of the password, Oracle does not seem to support this, but did not prompt error, fainted! It is said that including other illegal special characters may also produce this problem. Record, Give Yourself a memo: ORA-00922: Option missing or invalid
Error reason: The syntax of the statement is generally problematic. For example, the name is wrong, the keyword is wrong and so on. For nonstandard naming, double quotation marks are generally used to create.
Workaround:
Identifier naming rules:
1, must start with the letter.
2. The length cannot exceed 30 single-byte characters.
3, can only include a-z,a-z,0-9,_,$ and #.
4. You cannot create two objects of the same name under the same user.
5. Cannot use reserved words and keywords
ORA-28000: Account Lockout
The first step: using PL/SQL, the login name is system, the database name is not changed, select the type of time to change the normal to SYSDBA;
The second step: select Myjob, view users;
Step three: Select System, right click on "edit";
Fourth step: Change the password, the "account is locked" tick off;
Fifth step: Click "Apply" and click "Close";
The sixth step: re-login can be verified by; from http://blog.chinaunix.net/uid-20416869-id-3062623.html
Oracle 11g installation error [ora-00922/ora-28000]