Resolving ORACLE ERROR:ORA-28000: the account is locked

After installation of Oracle10g, there was a problem ..couldnt login using SQL+. None of the accounts(scott/tiger) worked . At last a quick web search gave the solution . Here is what it is:

From your command prompt, type
sqlplus "/ as sysdba"

Once logged in as SYSDBA, you need to unlock the SCOTT account
SQL> alter user scott account unlock;
SQL> grant connect, resource to scott;

More can be found here http://www.experts-exchange.com/Databases/Oracle/Q_21455839.html

Comments:

VERY HELPFULL

Posted by GANESH on July 13, 2007 at 09:18 AM PDT #

Thanx a Million...!!

Posted by Murtaza on July 27, 2007 at 01:43 AM PDT #

The Solution is a Bullseye.

Thank u.

Posted by Satish Kumar Nara on August 20, 2007 at 06:47 PM PDT #

straight forward answer which WORKS... Thnx

Posted by Sumit on August 27, 2007 at 07:10 PM PDT #

thanks a Ton :)

Posted by Neeta on October 01, 2007 at 06:28 PM PDT #

Hi all,
I typed (sqlplus "/ as sysdba") in command prompt. But, it seems asking username and password. I gave many combinations of username and password. But not yet entered into SQL. What I need to give here. Can you anyone send me the solution to my question?(n.amaresh@gmail.com).

Thanks,
Amaresh

Posted by Amaresh on October 30, 2007 at 09:58 PM PDT #

Amaresh, I'm not sure why you should be getting that error if the oracle installation was successfull.

Did you try to accessing the "em" web application ?
http://hostname:1158/em

Login as,
username : sysdba
password : <password>
Connect : Sysdba

Posted by Thekkadath on October 30, 2007 at 10:19 PM PDT #

xc,gk.m g

lkg';xl bf' v'
df k.h j

gf

Posted by guest on December 09, 2007 at 03:13 PM PST #

Awesome Rajesh....i was looking for the solution since 1 hr....it's a gr8 help.Thank a lot buddy.

Posted by kavitha on December 22, 2007 at 10:06 AM PST #

thanks a lot.....rajesh
great solution u have given....
it helps me more.....

thanks
sasidevi murugan

Posted by sasidevi on January 03, 2008 at 05:54 PM PST #

Thanks alot ,user solution solved our problem......

Posted by Rajiv,Ali on January 15, 2008 at 05:48 PM PST #

Please help me... i've got an error with oracle where when i try to make the .mk file... it prompted `/oracle/product/9.2.0/lib/libclntsh.sl' is up to date. can anyone help me on this matter? please

Posted by zarul on January 23, 2008 at 04:02 PM PST #

Please help me... i've got an error with oracle where when i try to make the .mk file... it prompted `/oracle/product/9.2.0/lib/libclntsh.sl' is up to date. can anyone help me on this matter? please

Posted by zarul on January 23, 2008 at 04:04 PM PST #

Thanks a lot pal.. its really useful :)

Posted by Harsha Kiron on January 27, 2008 at 12:52 PM PST #

this is the great way of my problem

Posted by Chaka on March 07, 2008 at 12:40 PM PST #

Hey buddy.. thanks a lot..
i had stuck with this plm..

Posted by Ganesh on March 09, 2008 at 07:05 AM PDT #

Thanks a lot..
The provided solution works.

Posted by Anil on April 06, 2008 at 01:39 PM PDT #

Thanks a lot Rajesh.

Posted by Arijit on April 06, 2008 at 02:18 PM PDT #

Thanks Rajesh for this simple solution.I have been searching all over for this but everyone had a complicated solution that did not work.Indians are always the best.Keep up the good work.All the best.

Posted by Sushma on April 07, 2008 at 08:40 AM PDT #

just just just the perfect solution to all my trouble.
thanx a lot.

Posted by himanshu pratap on April 11, 2008 at 06:18 PM PDT #

thankssssssssssssssssssssssssssssss:\*

Posted by Mani on April 18, 2008 at 03:25 AM PDT #

Thank to rajesh
Ur solution is very helpful 4 me,thanks alot

Posted by Nitin Goyal on April 24, 2008 at 08:42 PM PDT #

hi, the command given by you to unlock the account is correct, but since i do not know the sysdba password , hence i am unable to login into SQL+. also i had only one account in the Database server which is also locked. Can anything be done by me without contacting my DBA??

Posted by Virendar on May 02, 2008 at 04:31 PM PDT #

sorry virendar, i'm not aware as of how to unlock it without contacting DBA... Can you see if you have em access (http://database-host:1158/em)

Posted by Thekkadath on May 03, 2008 at 04:22 PM PDT #

hi,can any one help me to find out the system(machine)which is locking the account(ORA-28000 error),is there any oracle views which i can query for the same.

Posted by amarnath on June 01, 2008 at 09:21 PM PDT #

thanks buddy
u r genius
d perfect solution

Posted by guest on July 02, 2008 at 12:39 AM PDT #

thanks buddy
u r genius
d perfect solution

Posted by swostik on July 02, 2008 at 12:40 AM PDT #

Thanx alot .... its really very helpfull..

Posted by Zulfikar Ali on December 24, 2008 at 03:39 PM PST #

thanks a lot u help me solve ma probs..............

Posted by guest on December 25, 2008 at 04:05 PM PST #

Thanks buddy. !!

Posted by Kiran on January 07, 2009 at 01:15 PM PST #

Thanks.............Thekkadath

Posted by Ishu on February 12, 2009 at 10:01 PM PST #

The only alternative I can think of without contacting the DBA is only if, the PASSWORD_TIME_LOCK is not set with UNLIMITED.

If not you can wait until the number of days mentioned in PASSWORD_TIME_LOCK to try again.

Posted by Kumar Karuppusamy on March 10, 2009 at 08:10 AM PDT #

thanx .. i love brilliant ppl

Posted by dodz on March 21, 2009 at 07:15 PM PDT #

Thanx this is a wonderful command, i've tried many website but not found anything before this site..

command work properly and I got access to oracle..

Thanx again

Posted by Rahul shukla on March 27, 2009 at 06:16 AM PDT #

Post a Comment:
Comments are closed for this entry.
About

I'm a Quality Engineer at Sun Microsystems. Here in this blog, you may find information about Software Testing, Portal Server, Virtualization, Web2.0 and Misc Technical topics. The views expressed here are personal and does not reflect that of my employer

Search


Archives
« April 2017
SunMonTueWedThuFriSat
      
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
      
Today