How does Oracle change after forgetting the Sys,system password?

A. Forget the login password for users other than SYS and system users.   Login 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: Passwords are not all numbers. and cannot be a number start. Otherwise it will appear: ORA-00988: Password missing or invalid two, forget sys user, or the password of the system user.   If you forget the password of the system user, you can log in with the SYS user. Then change the password with the alter USER command:  conn sys/pass_word as Sysdba; alter user SYSTEM identified by "Newpass";  If you are forgetting the password of the SYS user, you can log in with the system user. Then change the password with the alter USER command.  conn System/pass_word;  alter user SYSTEM identified by "Newpass"; third, if the password of the Sys,system users are forgotten or lost.   You can use the ORAPWD.EXE tool to change your password.   Start Menu-> run-> input ' CMD ', open a Command Prompt window, enter the following command:  orapwd File=d:\oracle10g\database\pwdctcsys.ora password=newpass  This command regenerates the password file for the database. The location of the password file is under the \database directory in the Oracle_home directory.   This password is to modify the SYS user's password. The password for other users except SYS does not change.　　However, Oracle provides two authentication methods, one is OS authentication, another method of password file authentication, if it is the first way to change the password in the following ways: Sqlplus/nolog;　　Connect/as sysdba alter user SYS identified by;　　Alter user system identified by; If the second method is modified in the above way, you can also modify the password under the method: Orapwd File=pwdxxx.ora password= YouSet the new password entries=10 after setting up, restart the service, log on again. Oracle 11g after the native installation of Oracle, do not remember the SYS user's password, the following method can be modified password: 1. Open cmd, enter Sqlplus/nolog, enter "Conn/as sysdba", enter "ALTER user SYS identified by new password", note: The new password is best to start with a letter, or there may be an error Ora-00988. With this method, as long as they have administrator rights to the Oracle server, do not remember the password when you can change the password at will. 2. Execute the following command at the command line: Sqlplus "/@ service name as SYSDBA", then alter user SYS identified by new password in Sqlplus; Alter user system identified by new password; 3. Shipping Row to C packing directory 1) input: SET oracle_sid = your SID name 2) input: SQLPLUS/NOLOG3) Input: Connect/as sysdba4) Input: Alert user sys identified by SYS5) Input: Alert user system identified by SYSTEM6) The change is complete, the password is the Oracle database initial password 4. First, the cmd input sqlplus/nolog and then in the interface to break into Conn/as SYSDBA, so that the local system login to trust users to enter the database operation. There are two ways to solve this problem: ALTER user (USERNAME) identified by "password"; This is the password that can be changed USERNAME. Of course this USERNAME must already exist another is: CREATE USER (USERNAME) identified by "password"; The commands to change user permissions are: GRANT ROLES to (USERNAME), and the above 2 methods are for Oracle 9I versions. 5. With the Orapwd.exe command, you can modify the command. Orapwd file= '/oracle/pwdsid.ora ' password=123456 This command is to modify the SYS user's password. You overwrite the generated file with the original password file. The password for other users except SYS does not change. 6.su-oraclesqlplus/nologconn/aS Sysdbastartup (starts if the database is not in the boot state) ALTER user SYS identified by 123456

You can then log on using the SYS user password

Operating system authentication Mode Conn/as SYSDBA

ALTER user SYS identified by xxx

This article original link: http://blog.itpub.net/26015009/viewspace-717505/

How does Oracle change after forgetting the Sys,system password?