Shulou(Shulou.com)06/01 Report--

This error occurred during the installation of Oracle 11g R2 while creating a new database instance, and an ora-28000 error will occur if you select ignore.

Verified by the network query, this belongs to the previous configuration of the administrator password, using the password at the beginning of the number, Oracle does not seem to support this, but at that time did not prompt error, faint! It is said that the inclusion of other illegal special characters may also cause this problem.

Make a note and give yourself a memo:

ORA-00922: options are missing or invalid

The reason for the error: there is usually a problem with the syntax of the statement. Such as incorrect naming, misspelled keywords and so on. For non-standard naming, it is generally created in double quotation marks.

Solution:

Naming rules for identifiers:

1. You must start with a letter.

2. The length cannot exceed 30 single-byte characters.

3. It can only include Amurz, Z, and #, 0-9, and #.

4. You cannot create two objects with the same name under the same user.

5. Reserved words and keywords cannot be used

ORA-28000: account locked

Step 1: use PL/SQL, login name is system, database name remains unchanged, and change Normal to Sysdba when selecting type.

Step 2: select myjob to view users

Step 3: select system, right-click and click "Edit"

Step 4: change the password and uncheck the "account is locked"

Step 5: click "apply" and then click "close"

Step 6: log in again and you can pass the verification.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.