SQL> show parameter audit_trail
NAME TYPE VALUE
audit_trail string DB
--修改audit_trail参数值
SQL> alter system set audit_trail='FALSE';
alter system set audit_trail='FALSE'
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modifie
SQL> alter system set audit_trail='FALSE' scope = both;
alter system set audit_trail='FALSE' scope = both
ERROR at line 1:
ORA-02095: specified initialization parameter cannot be modifie
--只能修改到spfile
SQL> alter system set audit_trail='FALSE' scope=spfile;
System altered.
--显示audit_trail参数值，说明当前实例未更改
SQL> show parameter audit_trail
NAME TYPE VALUE
audit_trail string DB
SQL> shutdown normal
ORA-01031: insufficient privileges
SQL> conn / as sysdba;
Connected.
SQL> shutdown normal;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 171966464 bytes
Fixed Size 787988 bytes
Variable Size 144964076 bytes
Database Buffers 25165824 bytes
Redo Buffers 1048576 bytes
Database mounted.
Database opened.
--重新启动后，audit_trail参数值已经更改……
SQL> show parameter audit_trail;
NAME TYPE VALUE
audit_trail string FALSE
这里仅仅对一个审计参数的初始化和修改进行了说明，路过的如果有oracle的高手们，是如何操作的，使之能够实现动态修改呢，或者有没有别的方案实现审计，而不是每次都需要重新启动数据库……。