Backgroud
Today, I installed a Windows system on a virtual machine to set up an Oracle server. There were many issues from installation to usage, and resolving these problems took a lot of time and research.
During the installation process, I encountered ORA-00922 and ORA-28000 errors. These errors occurred because the password setup was too casual and did not comply with Oracle’s password requirements.
How to Troubleshoot ORA-00922: Missing or Invalid Option?
Cause of this Error
This error generally occurs due to syntax issues in the statement. For example, incorrect naming or incorrect keywords. For non-standard naming, double quotes are typically used for creation.
Solution
● Identifier Naming Rules: (Password Setting Rules)
● Must start with a letter.
● Length must not exceed 30 single-byte characters.
● Can only include A-Z, a-z, 0-9, _, $, and #.
● Cannot create two objects with the same name under the same user.
● Reserved words and keywords cannot be used.
How to Troubleshoot ORA-28000: the account is locked
This error occurs when an administrator password is set to start with a number, which Oracle apparently does not support. It is also said that including other illegal special characters can cause this issue.
Thus, the password should not start with a number and should only use characters allowed by the identifier naming rules. The password must include at least one uppercase letter, one lowercase letter, and one number.
Setting the password according to these rules will prevent ORA-28000 and ORA-00922 errors during Oracle instance installation.
At the time, I opted to reinstall directly. However, there are solutions that don’t require reinstallation, which I haven’t tried:
1. Use PL/SQL, with the login name as system, and keep the database name unchanged. Change the type from Normal to Sysdba.
2. Select myjob, and view users.
3. Select system, right-click and choose “Edit”.
4. Change the password and uncheck “Account is locked”.
5. Click “Apply” and then “Close”.
6. Log in again, and you should pass the verification.