Forgot Oracle username and password how to retrieve

Question

I have forgotten my Oracle username and password and hence not able to use it  My Oracle version is 11 2 0 1 0 11g   I consulted Internet  They asked me to execute commands like    SYSDBA    but I was unable to do it as once I give    SYSDBA    on Command Prompt screen  it takes the command as the username and next asks for password  I cannot execute any commands suggested by them as whatever I enter is taken as the username  subsequently password is asked and error occurs

User · Answer

Open Command Prompt Terminal and type      sqlplus   as SYSDBA  SQL prompt will turn up  Now type      ALTER USER existing account name IDENTIFIED BY new password ACCOUNT UNLOCK   Voila  You ve unlocked your account

User · Answer

Open your SQL command line and type the following   SQL gt  connect   as sysdba  Once connected you can enter the following query to get details of username and password   SQL gt  select username password from dba users   This will list down the usernames but passwords would not be visible But you can identify the particular username and then change the password for that user  For changing the password use the below query   SQL gt  alter user username identified by password   Here username is the name of user whose password you want to change and password is the new password

User · Answer

The usernames are shown in the dba users s username column  there is a script you can run called   alter user username identified by password   You can get more information here - https   community oracle com thread 632617 tstart 0

User · Answer

Go to SQL command line - type    sql gt connect   as sysdba    then type   sql gt desc dba users    then type   sql gt select username password from dba users    If sysdba doesn t work then try connecting with username scott and password  Tiger  You will be able to see all users with passwords  Probably you might find your s  Hope this helps

User · Answer

if you are on Windows   Start the Oracle service if it is not started  most probably it starts automatically when Windows starts  Start CMD exe in the cmd  black window  type  sqlplus   as sysdba   Now you are logged with SYS user and you can do anything you want  query DBA USERS to find out your username  or change any user password   You can not see the old password  you can only change it

[oracle11g] Forgot Oracle username and password, how to retrieve?

Examples related to oracle11g