Oracle-Startup Process Analysis

1. with grant option indicates that the user with the permission can continue to assign the permission.

With admin option

2. Use profile to manage user passwords

Create profile file name limit failed_login_attempts number of attempts password_lock_time lock days;

Alter user Username profile file name;

3. unlock a user

Alter user Username account unlock;

4. Termination Password

Create profile file name limit password_life_time change cycle/day password_grace_time grace period/day;

Alter user Username profile file name;

5. Password History

Create profile file name password_history limit password_life_time use days password_grace_time Grace days password_reuse_time 1

Alter user Username profile file name;

6. Delete the profile

Drop profile file name

7. oracle Startup Process

1) windows

A) lsnrctl start (start listener)

B) oradim-startup-sid start the database instance

2) linux environment

A) lsnctl start (start listener)

B) sqlplus sys/change_on_install as sysdba (Log On as dba)

C) startup (start)