Solution to Oracle 11g the account is locked

Source: Internet
Author: User


Oracle 11g the account is locked. Www.2cto.com 1. Failed to log on multiple times (the password may be incorrect); 2. the user is locked manually by the Administrator; 3. The user password expires, the password is not modified on time, and so on. The following is my solution: Connecting C: \ Users \ myname> sqlplus/nolog SQL> connect sys/sys as sysdba; connected. SQL> alter user system account unlock; the user has changed. Www.2cto.com SQL> commit; the submission is complete. SQL> conn system/OK // enter the new password and confirm that OKPassword changedConnected. SQL> conn system/OK is connected. SQL> show user; the USER is "SYSTEM" locked. Method 1: SQL> alter user system account lock; User altered. change account password 1. SQL> ALTER USER system IDENTIFIED BY sysPasswd; learn Oracle Database experience: 1. enter sqlplus under the DOS command to open the SQL Plus that comes with Oracle and a logon prompt appears. If you enter sqlplus/nolog, the logon prompt is not displayed after enabling SQL Plus. 2. in SQL Plus, enter conn to connect to the database. One format is SQL> conn username/password, for example, conn scott/tiger 3. code for locking and unlocking users in Oracle: SQL> alter user Username account lock; (locking) SQL> alter user Username account unlock; (unlocking)

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.