An Oracle instance installation appears ORA-28000 and ORA-00922 errors ____oracle

tip ora-28000:the the account is locked

and

hint ORA-00922: Option missing or invalid

The domain itself has password requirements, Windows 7 also has password requirements, Oracle also has password requirements. And Oracle's requirements are the most specific. ORA-28000 and ORA-00922 errors when installing an instance are generally the result of a password not set according to Oracle's requirements.

The most exasperating is in the account to set the password he does not complain, do not prompt, only when the installation of the instance to tell you the error, so you ignore, but ignore the result is an instance of the installation part of the failure, for a novice Oracle is vomiting blood.

ORA-00922: Option missing or invalid

Error reason: The syntax of the sentence is usually problematic. For example, the name is not correct, the key is wrong to write and so on. For non-standard naming, typically double quotes are used to create.

Solution:

Identifier naming rules: (Password setting rules)

1, must start with the letter.

2, length can not exceed 30 single-byte characters.

3, can only include a-z,a-z,0-9,_,$ and #.

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

5, cannot use the reserved word and the key word

ora-28000:the account is locked

After network query verification, this is belong to the previous configuration administrator password, the use of the number at the beginning of the password, Oracle seemingly do not support this, but did not prompt error, faint. It is said that including other illegal special characters may also cause this problem.

That is, the password can not start with a number, can only use identifiers to name the rules of the characters, the minimum password to contain uppercase letters, lowercase letters and numbers.

Set the password according to the rules above, the Oracle instance installs without ORA-28000 and ORA-00922 errors

don't want to reload. ---

Solution:

Method 1:

The first step: the use of Pl/sql, login name System, the database name unchanged, select the type of time to modify the normal to SYSDBA;

The second step: select Myjob, view users;

The third step: select System, right-click click "Edit";

Fourth step: Modify the password, the "account is locked" check remove;

Fifth step: Click "Apply" and then click "Close";

The sixth step: re-login can be validated;

Method 2:

ALTER USER username account UNLOCK;

Method 3:

In Plsql developer, if you are prompted to log in Scott/tiger, ora-28000 is locked.

Solution:

After the new installed Oracle 11g, with the Scott/tiger test, you will receive the following error message:

oracle11g the account is locked

oracle11g the password has expired

Reason: The default oracle11g Scott cannot log in.

Solve:

(1) Conn Sys/sys as SYSDBA; Log on as DBA

(2) Alter user Scott account unlock;//and unlock

(3) Conn Scott/tiger//pop Up a Change Password dialog box, modify the password on it

In the operation of the input CMD in DOS mode input sqlplus, the system user name login, password is just installed Oracle when they fill out the password orcl, log in later.

Sql> Conn Sys/sys as SYSDBA;

(Semicolon is required but I am logged in with system this should not be written Conn Sys/sys as SYSDBA should write Conn SYSTEM/ORCL as SYSDBA;)

Connected.

sql> alter user Scott account unlock;

User altered.

Sql> commit;

Commit complete.