My oracle learning records

Source: Internet
Author: User

1. scott unlock
After installing the Oracle 10 Gb database, I forgot to unlock the scott account. In this case, you can go to the SQL plus tool (START | all programs | <Oracle-Home> | Application Development | SQL Plus), or unlock the scott account through command lines on the console.
In the first case, use the system account to log on to SQL Plus, and then use the command "alter user scott account unlock;" to unlock. After the solution is complete, run the following command to check: "select username, account_status from dba_users;". You can see that the scott account has been unlocked, but the status is still "expired" (the password has expired). It doesn't matter. input the command "alter user scott identified by tiger;" and then assign it a new password. Log out and log on to scott/tiger.
In the second case, use the Windows Console (Program | run, Enter cmd to open ). Enter sqlplus/nolog in the command line, press enter, and an SQL> command prompt appears. Then, enter the command in the following order:
SQL> conn/as sysdba
SQL> alter user scott account unlock;
SQL> disconnect
SQL> conn scott/tiger @ oral;
The system prompts that the password has expired. enter a new password. Then, enter the new password and press enter to confirm the new password for the scott account. Open SQL Plus and log on to the scott account.
2. Forgot the orace SYS password: sqlplus/nolog ------- conn/as sysdba

Author: "ant financial's blog"

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.