MyArchiBook

How to Reset PASSWORD for a “LOCKED” Oracle SQL- Developer Account

with 15 comments

ORA- 28000: the account is locked.”

Our mind becomes almost very restless when we have an important project to be completed within the next few hours and our Oracle DB gets locked due to attempting maximum number of incorrect password hits.

Error Msg

Now to unlock the account and reset the password you have 3 choices,

CHOICE 1: Wait till the LOCK_TIME is complete and then try the next maximum attempts.
CHOICE 2: Send a mail to the DB Administrator and wait till the Administrator Unlocks the account.
CHOICE 3: Follow the steps in this BlogPost 

Before following the below steps, please confirm that, you have logged into your Windows OS as an Administrator.

Now follow these steps,

Step 1: Open COMMAND PROMPT

Step 2: Type sqlplus /nolog
This command helps you to log into the sqlPlus Editor.
*Note- there is a space between sqlplus and /nolog

Step 3: Enter command CONNECT SYS as SYSDBA

This command helps you to connect to the SQL Server as Database Administrator.

Here SYSDBA is the ROLEName.

Oh wait, you are not yet connected… , SYS is the userName, now you have to enter the password to get connected

Step 4: Next Enter SYS_password
You will see the command “SQL>Connected”
Now you are the ADMINISTRATOR. So, you can control your SQL Server, which means you can control your DB Account even.

Let’s see how …

Step 5: Next Enter the following command

select username,password,account_status from dba_users;

This command retrieves the UserName , Password and Account status of all the accounts in your SQL Server.
You will also find your Oracle DB name that is “LOCKED” and the LOCK that is TIMED.

Account Locked

Step 6: Now our next step is to Unlock the account,
Enter alter user USERNAME identified by password;

Here my userName is AISHU. So my command goes like this

alter user AISHU identified by password;

STEP 7: Enter alter user USERNAME account unlock;

This command helps you unlock your account

You can check if your account has been unlocked by typing the command as in “STEP 5″. The Result should be as below.

Account Open

Step 8: Now Open your SQL Developer.

  1. Right Click on your DB Name.
  2. Click on Properties.
  3. Set your DBName,UserName Password. Configure the rest of the settings.
  4. Click on Test. If the Test proves SUCCESS, Click on Save .
  5. Click on Connect to connect to your database.

Hope you are happy in unlocking your account.

Advertisements

Written by thangaveluaishwarya

May 10, 2013 at 9:01 AM

Posted in Oracle, Technical Posts

Tagged with ,

15 Responses

Subscribe to comments with RSS.

  1. nice blog… it was very useful aishwarya……

    Bharathi V

    May 10, 2013 at 10:23 AM

  2. Congrats………………

    Nee ellam nalla varuva.

    All The best……………

    Saleth Rajesh.v

    May 10, 2013 at 10:45 AM

  3. Good start! Keep up the interest and continuity!

    Murali

    May 10, 2013 at 10:50 AM

  4. NIce post. Keep up the good work!

    str4ng3r

    May 10, 2013 at 4:57 PM

  5. Well its a good start nice explanation on the steps. Go head

    Arul Prasad

    May 14, 2013 at 9:27 AM

  6. Great Job … Keep it going !!!

    rajakumartu

    May 15, 2013 at 1:43 AM

  7. Good! explained step by step….

    You’re doing great, continue the good work !

    RajanBabu.S

    May 16, 2013 at 6:25 AM

  8. Very Niceeeeeeeeeee !!!!!!!!!!

    hariharan

    May 18, 2013 at 12:27 AM

  9. nice………………carry on………………….

    a

    June 1, 2013 at 11:25 PM

    • nice it is important to us

      bhupesh

      November 29, 2013 at 5:56 PM

  10. all others steps worked successfully , but i am nit getting Sql developer ?

    rohan

    January 7, 2014 at 12:10 PM

  11. Really helped me alot..great work… thank you..

    srinivas

    September 30, 2014 at 3:32 AM

  12. Very helpful. Thankyou

    Anonymus

    November 5, 2016 at 12:41 PM

  13. Reblogged this on Welcome to Achyu's blog.

    Achyutananda Panigrahy

    February 17, 2017 at 12:35 PM


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: