Method: 1. Start SQLPLUS, enter "sqlplus/as sysdba" to connect; 2. Execute the "alter user sys identified by password" command to change the password; 3. Log in as sys from "Enterprise manager" That’s it.
The operating environment of this tutorial: Windows 10 system, Oracle 11g version, Dell G3 computer.
Situation description: I chose automatic installation during installation. Due to a long time, I forgot my username and password, so now I have tried several default usernames and passwords. , all prompt invalid username and password.
Solution:
1. Start SQLPLUS, prompt for user name, and then enter
sqlplus/as sysdba
The password is empty. Prompt to connect to the information, the connection is successful!
2. Execute alter user sys identified by password;
Set successfully!
3. Now you can log in as sys from Enterprise manager
Expand knowledge:
You can also install Oracle for the system Change the password of the set System sys and other users:
Log in to sqlplus/nolog
Connect to the database: connect /as sysdba
Change the user password (for example: change the sys user password to 123): alter user sys identified by 123;
The example is as follows:
Recommended tutorial: "Oracle Video Tutorial 》
The above is the detailed content of What to do if you forget your username in oracle11g. For more information, please follow other related articles on the PHP Chinese website!