How to retrieve the password of system and sys in Oracle

If you do not know the system in Oracle, you can use the following method to retrieve the password of the sys User: first, an ordinary user is added to the database: execute the following command in SQL * Plus: SQLconnectassysdba (you can also connect to SQLconnectinternal in the following way) SQLalterusersysidentifiedbysys; (after the carriage return, the user sys Password

If you do not know the system in Oracle, you can use the following method to retrieve the password of the sys User: first, an ordinary user is added to the database: execute the following command in SQL * Plus: SQLconnect/as sysdba (you can also connect to: SQLconnect internal) SQLalter user sys identified by sys; (after the carriage return, the user sys Password

If you do not know the system in Oracle, you can use the following methods to retrieve the password of sys:

First, an ordinary user is added to the database:
Run the following command in SQL * Plus:
SQL> connect/as sysdba (you can also connect in the following way: SQL> connect internal)
SQL> alter user sys identified by sys; (after you press enter, the password of user sys will be changed to sys)
Similarly, you can change the system password.
SQL> alter user system identified by system; (after you press enter, the password of the user system will be changed to system)

Operating system authentication

Conn/as sysdba

Change sys Password

Test OK in windows

Oracle? Database Express Edition Getting Started Guide
10g Release 2 (10.2)

What should I do if I forget my password in Oracle? 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 "/@ service name as sysdba", 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
The other is: create user (USERNAME) identified by "password"; 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 = '/oracle/pwdsid. ora' 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-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.