How to fix the Account Locked (Timed) Oracle

Step 1: Check status of Account:

select username, account_status,profile from dba_users where username='APPUSER';

Step 2: Create an profile

CREATE PROFILE APP_DEFAULT LIMIT
COMPOSITE_LIMIT UNLIMITED
SESSIONS_PER_USER UNLIMITED
CPU_PER_SESSION UNLIMITED
CPU_PER_CALL UNLIMITED
LOGICAL_READS_PER_SESSION UNLIMITED
LOGICAL_READS_PER_CALL UNLIMITED
IDLE_TIME UNLIMITED
CONNECT_TIME UNLIMITED
PRIVATE_SGA UNLIMITED
FAILED_LOGIN_ATTEMPTS UNLIMITED
PASSWORD_LIFE_TIME UNLIMITED
PASSWORD_REUSE_TIME UNLIMITED
PASSWORD_REUSE_MAX UNLIMITED
PASSWORD_VERIFY_FUNCTION NULL
PASSWORD_LOCK_TIME UNLIMITED
PASSWORD_GRACE_TIME UNLIMITED;

Step 3: Grant the profile to user 'APPUSER':

ALTER USER appusr PROFILE app_default;

ALTER USER appusr ACCOUNT UNLOCK;

Step 4: Check againt status

select username, account_status,profile from dba_users where username='APPUSER';


USERNAME       ACCOUNT_STATUS
------------------------------ --------------------------------
PROFILE
------------------------------
APPUSER        OPEN
APP_DEFAULT

Share this

Vtgdb