ORA-00922: Option Missing or invalid and ORA-28000: Oracle account locked Solution

ORA-00922: Option Missing or invalid

Error cause: the statement syntax is incorrect. For example, the name is incorrect or the keyword is incorrect. For non-standard names, they are generally created using double quotation marks.

Solution:

Identifier naming rules:

1. It 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. Reserved Words and keywords cannot be used.
ORA-28000: account locked
Step 1: Use PL/SQL. the login name is system, and the database name remains unchanged. When selecting a type, 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 "close ";

Step 6: log on again and you will be able to pass the verification;
Second

Alter User Username account unlock;
Third

In PLSQL developer, the ora-28000 the account is locked is prompted when you log on with Scott/tiger.

Solution:

After 10 Gb of Oracle is installed, the following error message is displayed when Scott/tiger is used for testing:

Oracle10g the account is locked

Oracle10g the password has expired

Cause: Scott of Oracle10g cannot log on by default.

Solution:

(1) Conn sys/sys as sysdba; // Log On As A DBA

(2) alter user Scott account unlock; // then unlock

(3) Conn Scott/tiger // a dialog box is displayed, which allows you to change the password.
Enter cmd in running mode, enter sqlplus in DOS mode, and log on with the System user name. The password is the Oracle password you entered when you installed oracle. After logging on.
SQL> conn sys/sys as sysdba ;)

Connected.

SQL> alter user Scott account unlock;

User altered.

SQL> commit;

Commit complete.

SQL> conn Scott/tiger // enter the new password and confirm the password. OK

Password Changed

Connected.
Then you can log on to PLSQL developer with Scott/tiger .....