Forget how the SYS user password for Oracle is modified

A. Forget the login password for users other than SYS and system users. Log in 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 cannot be 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 the password for the SYS user is forgotten, 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 Sys,system user's password is forgotten or lost. You can use the ORAPWD.EXE tool to modify the password. Start Menu-> run-> input ' CMD ', open a command Prompt window and 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 the password that modifies the SYS user. 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 below: orapwd File=pwdxxx.ora password= You set the new password entries=10 set, restart the service, re-login on it. Oracle 11g after the native installation of Oracle, do not remember the SYS user's password, using the following methodsYou can change the 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, Otherwise, error Ora-00988 may occur. 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, enter Sqlplus/nolog under CMD and then break into Conn/as SYSDBA in the interface. This allows the user who is logged on as the local system to trust the user to enter the database. There are two ways to solve this problem: ALTER User (USERNAME) identified by "password"; This is the password that can change the USERNAME. Of course this USERNAME must already exist another is: CREATE user (USERNAME) identified by "password"; the command to change user permissions is: GRANT ROLES to (USERNAME), the above 2 methods are for Oracle 9I version. 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 then you can log in using the SYS subscriber password.System authentication method Conn/as Sysdbaalter user sys identified by xxx

Forgot how to modify the SYS user password for Oracle