What should I do if I forget my username and password in Oracle?

Solution: 1. Enter sqlplus through the cmd command console to enter sqlplus; 2. Search for "Oracle 11g default username, password", and a lot of related default username and password information will be displayed; 3. Use the default Verify the username and password one by one to see if you can log in.

#What should I do if I forget the username and password set during installation? After checking the information on the Internet, I finally found the solution! Let’s see how it’s solved?

Solution:

Method 1:

First enter sqlplus: There are two ways to enter, one is through the cmd command Enter sqlplus on the computer, or directly enter Start-》Program-》Oracle-》Application Development-》sqlplus.

Search for "Oracle 11g default username, password", you can find a lot of related default username and password information, I won't post it here.

Then use the default username and password to verify one by one to see if anyone can log in.

If it displays: "invalid username/password;logon denied", continue to try other users. Until you find the user who appears: "error; the account is locked", write down the user name. For example, I found that the user ordsys is locked.

Re-log in to sqlplus, enter: "/as sysdba" at the "Please enter user name:" prompt, the screen displays "Connect to:..." and other information. Then the "SQL>" prompt appears. At this prompt, enter: "alert user ordsys account unlock;" Note that there is a semicolon, otherwise a "2" will automatically appear after input, waiting for you to continue input.

At this time, the screen displays: "The user has changed."

Re-log in to sqlplus, and at the "Please enter user name:" prompt enter: "ordsys ", enter "ordsys" after "Enter password:", the console will display: "error; the password has expired", and then ask to enter a new password and confirm the new password. At this point, you can finally connect to the database through your username and password.

Method 2:

You can also change the password for System sys and other users set when installing Oracle:

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;

Method 3:

Use OEM to set user information. Enter the OEM interface, select the "Server" tab, find "User" and click on it.

Select the user whose password needs to be changed, taking sys as an example:

Click Edit to enter the user management page.

Modify the corresponding information as needed. It should be noted that if you want to access OEM through a browser, you must ensure that the corresponding Oracle service is turned on.

Oracle Tutorial"

The above is the detailed content of What should I do if I forget my username and password in Oracle?. For more information, please follow other related articles on the PHP Chinese website!