I remember that Oracle I installed more than a year ago has never been used. When I was preparing for use, I encountered various problems. I had to find a solution on the Internet to solve them one by one. I 'd like to note it in case I forget it:
I. OracleForget the password of a common user
As a super AdministratorSysLog on and modify the settings.
InWindowsCommand line:
1. EnterOracleCommand line:Sqlplus
2. log on to the database: User Name:Sys
Password:Sys as sysdba
3. Change the password:
- ALTER USERUsername IDENTIFIEDBYNewpass;
(UsernameTo modify a user's account,NewpassFor the new password after modification)
For more information about password modification, see:
II. the account is locked
For example, I willScottChange PasswordTigerIn this caseScottCommon User Login, appears"The account is locked"An error occurred. Log On again with the super administrator permission and run the following command:
- Alter UserUsername account unlock;
(UsernameTo unlock a user's account)
For more unlock questions, see:
Iii. Not AllowedPL/SQL DeveloperThis database
In this case, the user scottLogin, but I use myPL/SQL Developer"Not AllowedPL/SQL DeveloperThis database"Problem: log on to the command line as the super administrator again and execute the command:
- Drop TableSys. PLSQLDEV_AUTHORIZATION;
Solve the problem.