The failure of oracle user connection makes us a headache. The following describes how to solve the failure of oracle user connection and hopes to help you learn about oracle user connection.
The failure of oracle user connection makes us a headache. The following describes how to solve the failure of oracle user connection and hopes to help you learn about oracle user connection.
After installing Oracle11g, I want to enable the built-in SQL Plus for learning, and then follow the prompts to use the sys user to connect to the database. If I lose the SQL Plus, an error is prompted several times:
Error: the account is locked
This may be due to the following reasons.
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 is not modified on time, and so on.
It seems that scott cannot log on, and I try to log on with the user "system". I remember that I was prompted to enter the password when installing Oracle 11g, then I lost one by myself. As a result, I tried the connection with my original password. It can be seen that in oracle 11g system, the user's password is not the default, but set by yourself 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 tiger;
The user has changed.
Now you can log on with scott and tiger!
SQL> conn scott/tiger
Connected.
