Oracle Audit function startup shutdown __oracle

Parameter control of an audit function
The value of the Audit_trail parameter can be set to the following

1. None: Not open
2. DB: Open Audit function
3. OS: Audit records are written to an operating system file.
4. TRUE: Same as parameter db
5. FALSE: Do not open audit function.
This parameter is written in SPFile, which requires a restart of the database.

Second check whether the audit function is started
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

Three Open audit


Sql> Conn/as SYSDBA
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

Sql> alter system set AUDIT_SYS_OPERATIONS=TRUE Scope=spfile; --Audit management user (login with sysdba/sysoper role)
Sql> alter system set audit_trail=db,extended Scope=spfile;

Restart Instance
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, EXTENDED
Complete

Four close audit
Sql> Conn/as SYSDBA
Sql> Show Parameter Audit
Sql> alter system set Audit_trail=none;
Restart Instance

Five checks whether the audit_trail of each node is None