Query authentication via the network, it is belong to in the previous configuration when the administrator password, used the Numbers at the beginning of the password, Oracle apparently does not support this, but didn't prompt error, faint! Is said to contain other illegal special characters can also cause this problem,
The record, give oneself cheat:
ORA - 00922: option is missing or invalid
Error reason: the general's statement syntax has a problem, such as the name is wrong, write wrong keywords, etc., for the naming of non-standard, generally adopts the double quotes to create,
Solution:
Identifier naming rules:
1, must begin with a letter,
2, the length can't more than 30 single-byte characters,
3, only including a-z, a-z, and 0-9, _, and # $and,
4, can't, are two of the same name in the same user object,
5, can't use reserved words and keywords
ORA - 28000: account
Step 1: using PL/SQL, login system, database name, choose type of Normal modification as Sysdba when;
Step 2: choose myjob, view the users;
Step 3: select system, right click, click on the "edit";
Step 4: modify the password, the "account was locked box;
Step 5: click on "application" and click "close";
Step 6: log back in via validation;
CodePudding user response:
Thanks for sharing, it is recommended that the blog