Oracle 11g Audit File Audit

Audit files: Record suspicious operations in the database; SYS's connection and database start-up, stop is bound to be audited!
Location of audit Files:
Show Parameter Audit_file_dest

If the audit directory does not exist, the database will not start properly!
Sql> Startup
Ora-09925:unable to create audit trail file
linux-x86_64 error:2: No such file or directory
Additional information:9925

Oracle Audit is a chicken, audit logs increase the speed, and increase the system load, reduce system performance.

According to our practice in the production system is to disable auditing, disable and then clear the audit log.

1、查看审计功能是否开启 sqlplus  "/as sysdba" SQL> show  parameter  audit; NAME TYPE    VALUE --------------------     -------    -------------------------------- audit_file_dest         string   /u01/app/oracle/admin/ORCL/adump audit_sys_operations   boolean    TRUE audit_syslog_level    string audit_trail       string   DB 说明：表明审计功能为开启的状态   2、关闭oracle的审计功能 SQL>  alter system   set audit_sys_operations= FALSE scope=spfile; System altered. SQL>  alter system  set audit_trail=NONE  scope=spfile; System altered.   3、重启数据库 SQL> shutdown immediate; SQL> startup;   4、验证审计是否已经被关闭 SQL> show parameter audit; NAME TYPE    VALUE --------------------     -------    -------------------------------- audit_file_dest         string   /u01/app/oracle/admin/ORCL/adump audit_sys_operations   boolean    FALSE audit_syslog_level    string audit_trail       string   NONE 说明：表明审计功能为关闭的状态   5、清空审计表数据 SQL>   truncate table SYS.AUD$;

This article is from the "Liang blog" blog, make sure to keep this source http://7038006.blog.51cto.com/7028006/1841993

Oracle 11g Audit File Audit