Checando parâmetro audit
|
1 2 3 4 5 6 7 8 |
SYS@ORCL> show parameter audit; NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ audit_file_dest string /opt/oracle/admin/ORCL/adump audit_sys_operations boolean FALSE audit_syslog_level string audit_trail string DB |
Execute o seguinte sql para desativar auditoria.
|
1 2 3 |
SYS@ORCL > ALTER SYSTEM SET AUDIT_TRAIL=NONE SCOPE=SPFILE; System altered. |
Baixar a instância
|
1 |
SYS@ORCL > shutdown immediate; |
|
1 |
SYS@ORCL > startup |
Checando parâmetro audit
|
1 2 3 4 5 6 |
NAME TYPE VALUE ------------------------------------ -------------------------------- ------------------------------ audit_file_dest string /opt/oracle/admin/nbs/adump audit_sys_operations boolean FALSE audit_syslog_level string audit_trail string NONE |