Oracle 10g关闭审计

1、修改前做好参数文件的备份
[oracle@pttestdbby1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 11 08:54:45 2014

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, oracle Label Security, OLAP, Data Mining Scoring Engine 
and Real Application Testing options

SQL> show parameter pfile

NAME                                TYPE        VALUE
------------------------------------ ----------- ------------------------------
spfile                              string      /u01/app/oracle/product/10.2.0
                                                /dbs/spfileZYJY75.ora

SQL> create pfile from spfile;

File created.

2、执行下面的命令
alter system set audit_trail=NONE scope=spfile;
由于audit_trail是动态参数，必须在后面加scope=spfile，重启库生效

3、关闭数据库
SQL> shutdown immediate

4、启动实例
SQL> startup

5、查看审计功能是否关闭
[oracle@pttestdbby1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 - Production on Tue Nov 11 09:12:45 2014

Copyright (c) 1982, 2010, Oracle. All rights reserved.


Connected to:
Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bit Production
With the Partitioning, oracle Label Security, OLAP, Data Mining Scoring Engine 
and Real Application Testing options

SQL> show parameter audit

NAME                                TYPE        VALUE
------------------------------------ ----------- ------------------------------
audit_file_dest                     string      /u01/app/oracle/admin/ZYJY75/a
                                                dump
audit_sys_operations                boolean     FALSE
audit_syslog_level                  string
audit_trail                         string      NONE

ok已经为NONE了，此时审计功能已经关闭了。

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/29949829/viewspace-1327974/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/29949829/viewspace-1327974/