Oracle installation Error ora-00922 (missing or invalid option)(2012-03-19 10:49:27)
reprinted
During the installation of Oracle 11g R2, this error occurred while creating a new DB instance, and if you select Ignore, a ora-28000 error occurs. Through the network query verification, this is the first configuration of the administrator password, the use of the beginning of the password, Oracle does not seem to support this, but did not prompt error, fainted! It is said that including other illegal special characters may also produce this problem. Record, Give Yourself a memo: ORA-00922: Missing or invalid error reason: There is usually a problem with the syntax of the statement. For example, the name is wrong, the keyword is wrong and so on. For nonstandard naming, double quotation marks are generally used to create. Workaround: Identifier naming rules: 1, 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. You cannot create two objects of the same name under the same user. 5. Cannot use reserved words and keywords
ORA-28000: Account Lockout
The first step: using PL/SQL, the login name is system, the database name is not changed, select the type of time to change the normal to SYSDBA; The second step: select Myjob, view users; The third step: select System, right click on "edit", Fourth step: Change the password, the "account is locked" tick off, Fifth step: Click "Apply" and then click "Close", Sixth step: Re-login can be verified;
Oracle installation Error ora-00922 (Zhuan)
