| Connection Problem [message #63366] |
Wed, 29 September 2004 13:36  |
gulshan
Messages: 19
Registered: January 2004
|
Junior Member |
|
|
I have installed oracle 10g beta version and when i connect it as sys then it connected successfully but when i connect it through user like scott then it gave the error--->
ERROR:
ORA-28000: the account is locked
why the account scott is locked and is there any view to check that how many user are locked.
I have checked v$lock, v$locked_object, but i did not find the required result.
Could u plz help me regarding this.
Thanks in advance
|
|
|
|
| Re: Connection Problem [message #63373 is a reply to message #63366] |
Thu, 30 September 2004 03:03  |
 |
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
|
Senior Member
Account Moderator |
|
|
You need to unlock the user.
--
-- Logged in as DBA
--
mag@mutation_mutation > alter user test account lock;
User altered.
--
--check
--
mag@mutation_mutation > connect test/test
ERROR:
ORA-28000: the account is locked
Warning: You are no longer connected to ORACLE.
--
-- Login as DBA and unlock the account
--
mag@mutation_mutation > connect mag/mag
Connected.
mag@mutation_mutation > alter user test account unlock;
User altered.
mag@mutation_mutation > connect test/test
Connected.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
