[Oracle learning start-1] user unlock and Password Input Problems

Source: Internet
Author: User

After Oracle 10 Gb is installed by default, oracle10g the account is locked when you log on with scott (password tiger) username. It turns out that scott cannot log on to Oracle. To solve this problem, you can log on as a DBA, log on, unlock user scott, and modify the scott password.

Procedure:

// Enter the command line: Enter sqlplus sys/sine as sysdba.

Enter sqlplus in the command line prompt, and enter the User name: system. The password is the one you entered when installing Oracle.

SQL> conn sys/sys as sysdba; (the semicolon must be written. However, if I log on to the system, it is not recommended that I write conn sys/sys as sysdba And conn system/orcl as sysdba ;)
Connected.
SQL> alter user scott account unlock;
User altered.
SQL> commit;
Commit complete.
SQL> conn scott/tiger

Password changed
Connected.

Command Line Logon: when you enter a user password, the command line does not display the input progress as if you did not enter a character, but if you have already entered a password

Then it still accepts the password. You can press Enter. Then the database operation interface is successfully entered.

Enter password:. It seems that the password is empty.

At the beginning, I thought that this place does not accept character input? It was accepted and not displayed.

Oracle's power ~~~

 


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.