Home » SQL & PL/SQL » SQL & PL/SQL » ora 28000 account is locked (oracle 10g)
ora 28000 account is locked [message #401700] Wed, 06 May 2009 03:41 Go to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
hi,
iam facing with this exception how to resolve with this
sql>conn system/manager@orcl1
connected;
sql>conn system/manager@orcl
ERROR:
ORA-28000: the account is locked
why orcl1 is fine but with orcl i am facing this.can anyone help me?
Re: ora 28000 account is locked [message #401701 is a reply to message #401700] Wed, 06 May 2009 03:43 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Because your account is open on one database and locked on the other one.
Ask your DBA.

Regards
Michel

[Updated on: Wed, 06 May 2009 03:43]

Report message to a moderator

Re: ora 28000 account is locked [message #401702 is a reply to message #401701] Wed, 06 May 2009 03:47 Go to previous messageGo to next message
rajasekhar857
Messages: 500
Registered: December 2008
Senior Member
what should i do as i am having dba privileges as there is no dba's here for it.
Re: ora 28000 account is locked [message #401704 is a reply to message #401702] Wed, 06 May 2009 03:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
First you should read:
SQL Reference
Database Administrator's Guide
Database 2 Day DBA

Then you can use ALTER USER statement.

Regards
Michel
Re: ora 28000 account is locked [message #401705 is a reply to message #401702] Wed, 06 May 2009 03:51 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Connect to another account with DBA privileges (or SYS if you can't find a DBA acount) and ALTER USER system UNLOCK;
Re: ora 28000 account is locked [message #401721 is a reply to message #401700] Wed, 06 May 2009 04:33 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Alter user system account unlock;


Thanks,
Re: ora 28000 account is locked [message #401725 is a reply to message #401721] Wed, 06 May 2009 04:37 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
ora_2007 wrote on Wed, 06 May 2009 11:33
[code]...

Once again, do you add anything to the previous post?
Please carefully read the question and answers before posting yourself.

Regards
Michel

[Updated on: Wed, 06 May 2009 04:43]

Report message to a moderator

Re: ora 28000 account is locked [message #401730 is a reply to message #401700] Wed, 06 May 2009 04:52 Go to previous messageGo to next message
ora_2007
Messages: 430
Registered: July 2007
Location: Mumbai
Senior Member
Quote:
Once again, do you add anything to the previous post?


SQL>Alter user system account unlock;

User alterd.


Quote:
@JRowbottom
ALTER USER system UNLOCK;



SQL>Alter user system unlock;
Alter user system unlock
                  *
ERROR at line 1
ORA-00922:Missing or invalid option.

Re: ora 28000 account is locked [message #401733 is a reply to message #401730] Wed, 06 May 2009 04:58 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is NOT what you post wanted to tell (as you other posts show it).
If you just wanted to say JRowbottom's post contains a typo, tell it, do not just post a statement.
In addition, I already posted a link to the statement and I think OP should be able to fix the typo by himself.

Regards
Michel
Previous Topic: How to make the column heading to bold
Next Topic: Locking on updation or Deletion (merged)
Goto Forum:
  


Current Time: Sun Dec 04 00:39:56 CST 2016

Total time taken to generate the page: 0.25185 seconds