Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Oracle - User Locked. URGENT

583343Mar 19 2010 — edited Mar 21 2010
Hi

I have just changed the password for one of the user on my Database.
In the meantime a lot many requests hit database with that user with the old password and the account is now locked.
I have UNLOCKED the user with below command: -

ALTER USER omuser identified by omusernew ACCOUNT UNLOCK;

but still I am unable to connect to this schema (omuser)

Can anyone please help me out in resolving this?

Below are the DEFAULT Profile details: -

select resource_name, resource_type, limit
from dba_profiles
where profile='DEFAULT';

RESOURCE_NAME RESOURCE_TYPE LIMIT

COMPOSITE_LIMIT KERNEL UNLIMITED
SESSIONS_PER_USER KERNEL UNLIMITED
CPU_PER_SESSION KERNEL UNLIMITED
CPU_PER_CALL KERNEL UNLIMITED
LOGICAL_READS_PER_SESSION KERNEL UNLIMITED
LOGICAL_READS_PER_CALL KERNEL UNLIMITED
IDLE_TIME KERNEL UNLIMITED
CONNECT_TIME KERNEL UNLIMITED
PRIVATE_SGA KERNEL UNLIMITED
FAILED_LOGIN_ATTEMPTS PASSWORD 10
PASSWORD_LIFE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_TIME PASSWORD UNLIMITED
PASSWORD_REUSE_MAX PASSWORD UNLIMITED
PASSWORD_VERIFY_FUNCTION PASSWORD NULL
PASSWORD_LOCK_TIME PASSWORD UNLIMITED
PASSWORD_GRACE_TIME PASSWORD UNLIMITED
This post has been answered by 725039 on Mar 19 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 18 2010
Added on Mar 19 2010
26 comments
16,707 views