How Oracle Unlocks SOCTT users

Source: Internet
Author: User

Completed Oracle 10g database and forgot to unlock the Scott account. This can be in the SQL Plus tool (start | All Programs |<oracle-home>| Application Development | SQL Plus), or you can unlock the Scott account from the console via the command line.

In the first case, log in to SQL Pluswith the SYSTEM account + password you set when you installed it,

Then use the command "alter user Scott account unlock;" To unlock it.

After the solution is finished, use the following command to view: "select Username,account_status from Dba_users;",

You can see that the Scott account has been unlocked, but the status is still "expired" (password expired) meaning.

Never mind, enter the command "alter user Scott identified by Tiger;" and give it a new password.

Exit and log in as Scott/tiger .

In the second case, use Windows's Console (program | run, enter CMD to open). Under command line, enter Sqlplus/nolog, carriage return, the sql> command prompt appears, and then enter the command in the following order:

Sql>conn/as SYSDBA
Sql>alter user Scott account unlock;
Sql>disconnect
Sql>conn scott/[email protected];
The password is now expired, please enter a new password. Then enter two new defined passwords to enter the password separately to confirm that the Scott account is given a new password. Open SQL Plus and log in with your Scott account.

How Oracle Unlocks SOCTT users

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.