oracle 基础维护

oracle 基础维护

1.关闭180天密码自动过期

 select * from dba_prfiles where pfile="DEFAULT" and resource_name = 'PASSWORD_LIFE_TIME';

 alter profile default limit password_lift_time;

2.关闭审计

 show parameter audit;

 alter system set audit_trail = none scope=spfile;

3.启动和关停

  sqlplus / as sysdba

  startup  --启动

  startup mount;

  shotdown immediate --停止