Modern Oracle DBA

STEP 1 :- Check SMTP status  [root@fintest ~]#  /etc/init.d/sendmail status sendmail (pid  1744) is running... sm-client (pid  1754) is running... STEP 2:- Start SMTP server [root@fintest ~]#  /etc/init.d/sendmail start Starting sendmail:                                         [  OK  ] Starting sm-client:                                        [  OK  ] STEP 3:- Stop SMTP server [root@fintest ~]#  /etc/init.d/sendmail stop Shutting down sm-client:                                  [  OK  ] Shutting down sendmail:                                   [  OK  ]

Step 1--> connect / as sysdba user Step 2--> Check the account status SELECT username, account_status FROM dba_users; SELECT username, account_status FROM dba_users where username='GSMUSER'; USERNAME ACCOUNT_STATUS PROFILE -------------------- -------------------- --------------- GSMUSER LOCKED(TIMED) DEFAULT STEP 3-->Avoid this type of locking issue I have to create a new profile with FAILED_LOGIN_ATTEMPTS values as UNLIMITED and assign this new profile to the user Step 4--> Create a new profile name for locked username for you are identification purpose only SQL> CREATE PROFILE GSMUSER_NOEXPIRY LIMIT   COMPOSITE_LIMIT 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   FAILED_LOGIN_ATTEMPTS UNLIMITED ; Step 5 - Assign New profile to the user as default profile SQL>Alter user GSMUSER