Two implementation methods for Oracle user unlocking commands

After installing Oracle 10 Gb, I want to enable SQL * plus for learning, and then follow the steps in the book to connect to the database with scott user. After the installation, an error is prompted several times.

Error: the account is locked

Then I checked the Internet and found that the user was locked. The reason why the user was locked may be the following.

1. Failed to log on multiple times. (The password may be incorrect)

2. the user is manually locked by the Administrator.

3. the user password expires. The password has not been modified on time...

This user is definitely unable to log on, and then I log on with the user "system", but I haven't logged on for half a day and went online to check again, most of the users and passwords on the Internet are about oracle 9i. Later I remember that I was prompted to enter the password during installation. I tried it and connected it, therefore, in oracle 10 Gb system, the user's password is not the default one, but is set during installation.

After logging in with system, run the following command:

 
 

  
  
SQL> alter user scott account unlock; 
 
 

The user has changed.

This completes the unlock operation. Next, you can set a new password for scott.

Modify scott's logon Password

 
 

  
  
SQL> alter user scott identified by pan; 
 
 

The user has changed.

OK. You can log on to scott and pan again!

 
 

  
  
SQL> conn scott/pan 
 
 

Connected.

After the new Oracle 10 Gb is installed, the system/password can be used to log on normally, but the scott/tiger user cannot log on:

 
 

  
  
conn scott/tiger   
  
  
error：Oracle 10g the account is locked   
  
  
Oracle 10g the password has expired 
 
 

Cause: Oracle 10 Gb scott cannot log on by default. Disabled.

Solution:

First, confirm that the oracle database and client have been installed.

. Execute the following statement in the DOS client:

Note the symbol

 
 

  
  
C: \ sqlplus/nolog
  
  
Sqlp \ conn sys/system @ oracle10AsSysdba // sys is the current oracle user system. The password oracle10 is SID.
  
  
#Alter UserSoctt account lock; // lock scott user
  
  
#Alter UserScott account unlock; // unlock the scott user
  
  
#Alter UserScott identifiedByScott // change scott's user password to scott, and scott's user's default password to tiger
 
 

1 input C: \ sqlplus/nolog in Dos

2. Log On As A DBA

 
 

  
  
conn sys/password as sysdba;  
 
 

3 unlock

 
 

  
  
alter user scott account unlock; 
 
 

4. A dialog box is displayed to change the password.

 
 

  
  
Conn scott/tiger
  
  
SQL> conn sys/sysAsSysdba;
  
  
Connected.
  
  
SQL>Alter UserScott account unlock;
  
  
UserAltered.
  
  
SQL>Commit;
  
  
CommitComplete.
  
  
SQL> conn scott/tiger // enter the new password and confirm the password. OK
  
  
PasswordChanged
  
  
Connected.
 
 

1. Oracle username re-indexing method
2. Explain how to query user tablespaces in Oracle
3. An analysis of the management method of the Oracle user permission table
4. Introduction to Oracle database backup and recovery features
5. Five restrictions on using Oracle External tables