1.审计目录
SYS@orcl> show parameter audit_file_dest;
进入审计目录:
cd /home/u01/app/oracle/admin/orcl/adump
[oracle@apollo adump]$ du -sh
806M .
[oracle@apollo adump]$ pwd
/home/u01/app/oracle/admin/orcl/adump
查询文件夹内文件数量:
[oracle@apollo adump]$ ls |wc -l
4549
2.审计内容
1)超级用户的连接会被审计
[oracle@apollo adump]$ cat orcl_m003_22182_20231214200853255988048418.aud
2)停库也会被审计
(连测试)
SQL> show parameter audit_file_dest;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest string /data1/u01/app/oracle/admin/prod/adump
-bash-4.2$ cd /data1/u01/app/oracle/admin/prod/adump
-bash-4.2$ ls |wc -l
208127
-bash-4.2$ du -sh
26G .
-bash-4.2$
清理文件夹:cd /data1/u01/app/oracle/admin/prod/adump/
rm -f *
3.修改审计目录位置
1)参数是否动态 能改是动态,不能改是静态参数
静态参数只能在文件里改
SQL> alter system set audit_file_dest='/home/oracle/adump';
alter system set audit_file_dest='/home/oracle/adump'
*
ERROR at line 1:
ORA-02096: specified initialization parameter is not modifiable with this
option
2)是spfile 还是pfile
SQL> alter system set audit_file_dest='/home/oracle/adump' scope=spfile;
System altered.
3) 静态文件需要重启库
SQL> shut immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORA-09925: Unable to create audit trail file
Linux-x86_64 Error: 2: No such file or directory
Additional information: 9925
SQL>
启动库时校验是否存在文件
mkdir /home/oracle/adump
startup后 审计日志到新位置:
SQL> show parameter audit