Oracle Installation Error ora-00922 (missing or invalid option) This error occurs when you create a database instance while installing Oracle 11g R2, if you select ignore, A ora-28000 error is reported. After network query and verification, this is a password starting with a number when the administrator password is configured. Oracle does not seem to support this, but no error is prompted and fainted! It is said that other illegal special characters may also cause this problem. Www.2cto.com record, give yourself memo: ORA-00922: Option Missing or invalid error cause: generally is a statement Syntax problems. For example, the name is incorrect or the keyword is incorrect. For non-standard names, they are generally created using double quotation marks. Www.2cto.com solution: naming rules for identifiers: 1. The name must start with a letter. 2. The length cannot exceed 30 single-byte characters. 3, can only include A-Z, a-z, 0-9, _, $ and #. 4. Two objects with the same name cannot be created under the same user. 5. Do not use reserved words and keywords ORA-28000: account lock step 1: Use PL/SQL, login name is system, database name remains unchanged, when the type is selected change Normal to Sysdba; Step 2: select myjob to view users. Step 3: Select system and right-click Edit. Step 4: change the password and remove the account locked check box. Step 5: click "application" and then click "close". Step 6: log on again and you will be able to pass the verification;