What to do if you forget your username in oracle11g

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.

What should I do if oracle11g forgets my username?

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!