Oracle - User Locked. URGENT
583343Mar 19 2010 — edited Mar 21 2010Hi
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