Oracle forgets user name and password solutions ____oracle

Http://blog.sina.com.cn/s/blog_4ab645500100r6vo.html

A long time ago installed Oracle, today finally decided to learn a lesson, the results of a morning to contribute to how to connect the database

What to do if you forget the username and password you set up when you installed it. Checked the information on the Internet, finally solved.

method One:

First enter the Sqlplus: Enter the way there are two kinds, one is through the cmd command table input Sqlplus, the other is directly in the beginning-"program-" oracle-"Application Development-" sqlplus. Search "oracle11g default username, password", can find a lot of relevant default username and password information, I will not post it. Then use the default username and password to verify one by one, to see if there is no login, if the display: "Invalidusername/password;logon denied" to continue to try other users. Until found appeared: "Error; The Accountis locked "user, write down the username, such as I found the Ordsys this user is locked. Re-login Sqlplus, in the "Please enter user name:" Prompt input: "/ASSYSDBA", screen display "connected to: ..." and other information. Then the "sql>" prompt appears and enters at this prompt: "Alertuser ordsys accountunlock;" Note that there is a semicolon, or it will automatically appear after the input "2" waiting for you to continue typing. The screen now displays: "The user has changed." ”

Re-login Sqlplus, in the "Please enter user name:" Prompt input: "Ordsys", after "Enter password:" After entering "Ordsys", the console will display: "Error;thepassword hasexpired", and then ask for a new password, confirm the new password. At this point, you can finally successfully connect to the database through user name and password.

Method Two:

In addition, you can change passwords for users such as system SYS that are set up when Oracle is installed: Login sqlplus/nolog Connection database: Connect/as sysdba Modify user password (for example: Modify SYS user password is 123): Alter user SYS identified by123;



Method Three:

Use OEMs to set up user information. Enter in Browser: https://localhost:1158/em

Will go to the OEM interface, select the "Server" tab and find "user" clicks.

Select the user who needs to modify the password, for example, SYS:

Click Edit to enter the user admin page.

Modify the appropriate information as needed. It is important to note that if you want to access OEMs through a browser, you must ensure that Oracle's corresponding service is turned on.

Locate the service by using the control Interface-> Administrative Tools-> Services, as shown in the following illustration, to start.