| ora 28000 account is locked [message #401700] |
Wed, 06 May 2009 03:41  |
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 #401730 is a reply to message #401700] |
Wed, 06 May 2009 04:52  |
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 |
 |
Michel Cadot
Messages: 68770
Registered: March 2007
Location: Saint-Maur, France, https...
|
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
