After installing Oracle10g, 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.