Oracle Installation Error ora-00922 (missing or invalid option) resolved

Source: Internet
Author: User

Oracle Installation Error ora-00922 (missing or invalid option) This error occurs when you create a database instance while installing Oracle 11g R2, if you select ignore, A ora-28000 error is reported. After network query and verification, this is a password starting with a number when the administrator password is configured. Oracle does not seem to support this, but no error is prompted and fainted! It is said that other illegal special characters may also cause this problem. Www.2cto.com record, give yourself memo: ORA-00922: Option Missing or invalid error cause: generally is a statement Syntax problems. For example, the name is incorrect or the keyword is incorrect. For non-standard names, they are generally created using double quotation marks. Www.2cto.com solution: naming rules for identifiers: 1. The name 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. Do not use reserved words and keywords ORA-28000: account lock step 1: Use PL/SQL, login name is system, database name remains unchanged, when the type is selected 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 click "close". Step 6: log on again and you will be able to pass the verification;

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.