Thursday, May 26, 2016

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...

Thursday, May 19, 2016

Wednesday, May 18, 2016

How to set an expiration date for user' password on Linux

Step 1: Open file /etc/login.defs, change option for PASS_MAX_DAYS, For example: # Password aging controls: # #       PASS_MAX_DAYS   Maximum number of days a password may be used. #       PASS_MIN_DAYS   Minimum number of days allowed between password changes. #       PASS_MIN_LEN    Minimum acceptable password...

Monday, May 9, 2016

Installation Mysql, php, apache

My environment: OS Red Hat Enterprise Linux Server release 6.5 (Santiago) MySQL Version 5.1.73-community MySQL Community Server (GPL) PHP PHP 5.6.10 (cli) Htdoc Directory /u01/qlts/public_html Apache Configuration ...