What if oracle forgets the password of sys/system/scott?

Source: Internet
Author: User


What should I do if oracle forgets the password of sys/system/scott? I. Forget the login password of a user other than SYS and SYSTEM. Log On with SYS (or SYSTEM) USER: conn sys/PASS_WORD as sysdba; use the following statement to modify the USER's password: alter user user_name identified by newpass; Note: The password cannot be full of numbers. It cannot start with a number. Otherwise: ORA-00988: Password missing or invalid
2. Forget the password of the SYS user or the SYSTEM user. If you forget the password of the SYSTEM user, you can use the SYS user to log on. Then, use the alter user password command to change the password: conn sys/PASS_WORD as sysdba; www.2cto.com alter user system identified by newpass. If you forget the password of SYS, you can use the system user to log on. Then, use the alter user password command to change the password. Conn system/PASS_WORD; www.2cto.com alter user system identified by newpass; 3. If SYS and SYSTEM users' passwords are forgotten or lost. This is particularly important. You can use ORAPWD. EXE to change the password. Www.2cto.com Start Menu-> Run-> enter 'cmd', open the Command Prompt window, enter the following command: orapwd file = D: \ oracle \ product \ 10.2.0 \ db_1 \ database \ pwdctcsys. ora password = newpass this command re-generates the Database password File. The password file is located in the \ database directory under the ORACLE_HOME directory. This password is used to change the password of the sys user. The password of other users except sys and system will not change.

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.