[Oracle] sys/system/Scott User Password restoration method [reprinted]

1. Forget the logon password of a user except sys and system.
Log on to the conn sys/pass_word as sysdba as a sys (or system) user;
Use the following statement to modify the 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 run the alter USER command to change the password:
Conn sys/pass_word as sysdba;
Alter user system identified by newpass;
If you forget the password of the Sys user, you can use the System user to log on. Then run the alter USER command to change the password.
Conn system/pass_word;
Alter user system identified by newpass;
 
3. If the passwords of SYS and system users are forgotten or lost.
You can use orapwd. EXE to change the password.
Start Menu-& gt; Run-& gt; enter 'cmd', open the Command Prompt window, and enter the following command:
Orapwd file = D: \ Oracle10g \ 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.
However, Oracle provides two verification methods: OS verification and password file verification. If the first method is used, change the password as follows:
Sqlplus/nolog;
Connect/As sysdba
Alter user SYS identified;
Alter user system identified;
If you use the second method to modify the password, you can also use the following method to change the password:
Orapwd file = pwdxxx. ora Password = your new password entries = 10
After setting, restart the service and log on again.
 
Oracle 11g
 
After installing oracle on the local machine, you can change the password of SYS as follows:
1. open cmd, enter sqlplus/nolog, press enter, enter "Conn/As sysdba", and enter "alter user SYS identified by new password". Note: it is best to start the new password with a letter, otherwise the error Ora-00988 may occur. With this method, you can change the password as long as you have administrator permissions on the Oracle server and do not remember the password.
 
2. Execute the following command on the command line: sqlplus & #8220;/@ service name as sysdba & #8221;, and then alter user SYS identified by new password in sqlplus;
Alter user system identified by new password;
 
3. Run the command to the C root directory.
1) input: Set oracle_sid = your SID Name
2) input: sqlplus/nolog
3) input: connect/As sysdba
4) input: Alert user SYS identified by sys
5) input: Alert user system identified by System
6) The password is the initial password of the Oracle database.
 
4. first, enter sqlplus/nolog in cmd, and then enter Conn/As sysdba in the displayed interface. In this way, the user logged on to the local system will trust the user to access the database. there are two ways to solve this problem: Alter user (username) identified by "password", which can change the Username Password. of course, this username must already exist
Another is: create user (username) identified by & #8220; password & #8221; the command to Change User Permissions is grant roles to (username ); the above two methods are for the Oracle 9i version.
 
5.use the orapwd.exe command to modify the command.
Orapwd file = & #8217;/Oracle/pwdsid. ora & #8217; Password = 123456 this command is used to change the password of the Sys user. You overwrite the original password file. The password of other users except sys and system will not change.
 
6. Su & #8211; Oracle
Sqlplus/nolog
Conn/As sysdba
Startup (start if the database is not in the startup status)
Alter user SYS identification by 123456
Then you can use the Sys user password to log on.