What if the Oracle database forgets SYS and the system password and system is locked?

Source: Internet
Author: User
Tags sqlplus

I doctor became too big to forget the Oracle SYS user and system user password, and after several attempts to log on to system, the system is locked.

After some attempt, finally solved. The process is as follows:

First, rebuild the sys password file. The Reconstruction method is:

1. Open cmd Command window;

2, execute orapwd command, its usage is:

C:\windows\system32>orapwd

Usage:orapwd file=<fname> entries=<users> force=<y/n> ignorecase=<y/n> nosysdba=<y/n>

where

File-name of password file (required),

Password-password for SYS would is prompted if not specified at command line,

Entries-maximum number of distinct DBA (optional),

Force-whether to overwrite existing file (optional),

Ignorecase-passwords is case-insensitive (optional),

Nosysdba-whether to shut out of the SYSDBA logon (optional Database Vault only).

The file option is the full path of the files, and the file name is pwd+ DB instance name + ". Ora". Password The password for the new setting.

The command format I executed is as follows:

C:\windows\system32>orapwd File=d:\oracle\product\11.2.0\dbhome_1\database\pwd****.ora password=****** Entries =5 Force=y

(Note that it is a good idea to back up the original file before executing the Rebuild password file command)

After the command is executed, the new password file overwrites the original password file.

After restarting the Oracle database service, you can log in to sys with a new password.

The next step is to troubleshoot system user lockout issues.

In the CMD command window, connect to the database with Sqlplus.

C:\Documents and Settings\administrator>sqlplus sys/***** as Sysdba

where * * Part is the login password.

Then execute the command to unlock the system.

Sql>alter user System account unlock;

Finally, modify the password for the system user.

Sql>alter user system identified by **********;

where the * * * section is the new password.

The system is unlocked and can be logged in with a new password.

Original link: http://www.lhtry.net/Blog/Detail?id=19

What if the Oracle database forgets SYS and the system password and system is locked?

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.