Failure phenomena: Sql> Connect Scott/scott ERROR: Ora-01017:invalid Username/password; Logon denied Sql> Connect Scott/scott ERROR: Ora-28000:the account is locked Indicates that the Scott user in Oracle was locked after 10 times because of the wrong password. Sql> Select Account_status,lock_date,profile from dba_users where username= ' SCOTT ';
Account_status to_char (lock_date, ' D profile -------------------------------- -------------------- ------------------------------ LOCKED (TIMED) 31-may-2004 19:33:53 DEFAULT This indicates that when the Oracle session is added again, the error is not connected. Fault resolution: (1) Unlock the current User: sql> alter user Scott account unlock; (2) View the current user's restrictions: Sql> 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 Indicates: After 10 times, the failed_login_attempts on the error, lock the user. Need to be modified to: unlimited sql> alter profile default limit Failed_login_attempts unlimited; or modified to: a greater number of times: 100000 Sql>alter profile default limit failed_login_attempts 100000; And then look at the resource situation: Sql> 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 UNLIMITED 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 Rows selected Sql> This will not be used: Client side due to input password error, causing users to be locked (timed) |