Highlights about Oracle for the first time

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:

1. 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:

1. 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:

1. Drop TableSys. PLSQLDEV_AUTHORIZATION;

Solve the problem.