Oracle password loss

Source: Internet
Author: User

What about oracle password loss? Three authentication mechanisms for oracle password: 1. operating system verification 2. password File verification 3. if the password of a Common Account is lost during database verification, you can use the database verification mechanism to log on to the system account and change the password of the user. For example, scott account: connect to the database: sqlplus/as sysdba modify the user Password: alert user scott indentifity by tiger; if the password of the sys account is forgotten: First, let's talk about how to start the oracle database: in linux, you must first start the listener and log on to the sys account before starting the oracle instance. Lsnrctl start sqlplus/as system (sqlplus/nolog conn/as sysdba in oracle 8, oracle 9i) startup (shutdown to close the Database Service) scott/tiger does not need to log on to sys in the window to start the oracle instance. Lsnrctl start oradim-startup-sid orcl logs on to the sys account only with/, or enters anything such as aaa/bbb as system. Because operating system verification is used. Computer Management-local users and groups-group-ORA_DBA-properties to delete the current system user. (Operating system verification) in this way, the login will fail again and the permission is insufficient. Enter sys/password as sysdba to log on. D: \ oracle \ product \ 10.1.0 \ Db_1 \ database PWD *** in the directory ***. ora is deleted, and a new one is created. Remember the created password (password file verification) to create PWD ***. ora: cmd pwdora indicates the command to be created. Orapwd file = d: \ oracle \ product \ 10.1.0 \ Db_1 | database \ PWD ***. ora \ password = 123456 entries = 10 log on.

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.