Highlights of Oracle usage 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. Forget the password of a common user in Oracle

Log on to the super administrator sys and modify the settings.

In the Windows command line:

1. Go to the Oracle command line: sqlplus

2. log on to the database: User name: SYS

Password: SYS as sysdba

3. Change the password:

Alter User Username identified by newpass;

(Username is the account to be modified, and newpass is the new password after modification)

For more Password Change questions, see: http://hi.baidu.com/quandang/item/14ed05dc40fed0dc251f40c6

 

II. The account is locked

For example, if I change Scott's password to Tiger and use Scott's normal user to log on, the error "the account is locked" appears. Log On again with the super administrator privilege and run the following command:

Alter User Username account unlock;

(Username is the account to be unlocked)

For more unlock questions, see http://quanjj.iteye.com/blog/1106846

 

Iii. PL/SQL developer is not allowed for this database

At this time, you can log on from the command line as Scott, but when I log on using PL/SQL developer, the question "PL/SQL developer is not allowed to use this database" appears, log on to the command line as a super administrator and run the following command:

Drop table SYS. plsqldev_authorization;