Oracle rac改参数,Oracle 11g RAC修改静态参数

--只需重启实例，不要重启数据库

09:58:09 sys@PTFDB> ALTER SYSTEM SET AUDIT_TRAIL=DB,EXTENDED SCOPE=SPFILE;

System altered.

Elapsed: 00:00:00.14

09:58:18 sys@PTFDB> show parameter audit

NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

audit_file_dest     string /u01/app/oracle/admin/ptfdb/ad

ump

audit_sys_operations     boolean TRUE

audit_syslog_level     string

audit_trail     string DB

09:58:57 sys@PTFDB> alter system set AUDIT_SYS_OPERATIONS=TRUE SCOPE=SPFILE;

System altered.

Elapsed: 00:00:00.02

09:59:03 sys@PTFDB> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

09:59:30 sys@PTFDB> startup

ORACLE instance started.

Total System Global Area 9420095488 bytes

Fixed Size    2236248 bytes

Variable Size 3925868712 bytes

Database Buffers 5469372416 bytes

Redo Buffers   22618112 bytes

Database mounted.

Database opened.

10:00:04 sys@PTFDB> show parameter audit

NAME     TYPE VALUE

------------------------------------ ----------- ------------------------------

audit_file_dest     string /u01/app/oracle/admin/ptfdb/ad

ump

audit_sys_operations     boolean TRUE

audit_syslog_level     string

audit_trail     string DB, EXTENDED

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