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
Posted by GANESH on July 13, 2007 at 04:18 PM PDT #
Posted by Murtaza on July 27, 2007 at 08:43 AM PDT #
The Solution is a Bullseye.
Thank u.
Posted by Satish Kumar Nara on August 21, 2007 at 01:47 AM PDT #
straight forward answer which WORKS... Thnx
Posted by Sumit on August 28, 2007 at 02:10 AM PDT #
thanks a Ton :)
Posted by Neeta on October 02, 2007 at 01:28 AM 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 31, 2007 at 04:58 AM 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 31, 2007 at 05:19 AM PDT #
xc,gk.m g
lkg';xl bf' v'
df k.h j
gf
Posted by 192.8.220.9 on December 09, 2007 at 11: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 06:06 PM PST #
thanks a lot.....rajesh
great solution u have given....
it helps me more.....
thanks
sasidevi murugan
Posted by sasidevi on January 04, 2008 at 01:54 AM PST #
Thanks alot ,user solution solved our problem......
Posted by Rajiv,Ali on January 16, 2008 at 01:48 AM 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 24, 2008 at 12:02 AM 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 24, 2008 at 12:04 AM PST #
Thanks a lot pal.. its really useful :)
Posted by Harsha Kiron on January 27, 2008 at 08:52 PM PST #
this is the great way of my problem
Posted by Chaka on March 07, 2008 at 08:40 PM PST #
Hey buddy.. thanks a lot..
i had stuck with this plm..
Posted by Ganesh on March 09, 2008 at 02:05 PM PDT #
Thanks a lot..
The provided solution works.
Posted by Anil on April 06, 2008 at 08:39 PM PDT #
Thanks a lot Rajesh.
Posted by Arijit on April 06, 2008 at 09: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 03:40 PM PDT #
just just just the perfect solution to all my trouble.
thanx a lot.
Posted by himanshu pratap on April 12, 2008 at 01:18 AM PDT #
thankssssssssssssssssssssssssssssss:*
Posted by Mani on April 18, 2008 at 10:25 AM PDT #
Thank to rajesh
Ur solution is very helpful 4 me,thanks alot
Posted by Nitin Goyal on April 25, 2008 at 03:42 AM 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 11: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 11: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 02, 2008 at 04:21 AM PDT #
thanks buddy
u r genius
d perfect solution
Posted by 117.197.242.80 on July 02, 2008 at 07:39 AM PDT #
thanks buddy
u r genius
d perfect solution
Posted by swostik on July 02, 2008 at 07:40 AM PDT #
Thanx alot .... its really very helpfull..
Posted by Zulfikar Ali on December 24, 2008 at 11:39 PM PST #
thanks a lot u help me solve ma probs..............
Posted by 195.229.236.213 on December 26, 2008 at 12:05 AM PST #
Thanks buddy. !!
Posted by Kiran on January 07, 2009 at 09:15 PM PST #
Thanks.............Thekkadath
Posted by Ishu on February 13, 2009 at 06:01 AM 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 03:10 PM PDT #
thanx .. i love brilliant ppl
Posted by dodz on March 22, 2009 at 02:15 AM 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 01:16 PM PDT #