Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to set audit_syslog_level

BillWJul 30 2013 — edited Jul 30 2013

In my 11.2.0.3.0 rdbms I am attempting to send oracle audit to syslog. Apparently audit_syslog_level connot be set from a sql prompt -

SQL> alter system set audit_syslog_level=auth.info scope=spfile;

alter system set audit_syslog_level=auth.info scope=spfile

                 *

ERROR at line 1:

ORA-02095: specified initialization parameter cannot be modified

so next I tried first is

SQL> alter system set audit_trail=OS

I then created an init file from the spfile and added the entry

*.audit_syslog_level=auth.info

the stopped and restarted the database using the init file and startup failed with the error -

SQL> startup pfile=initoemrepos.ora

ORA-32028: Syslog facility or level not recognized

The oracle database reference, AUDIT_SYSLOG_LEVEL shows those as being correct parameters. I'm puzzled and would appreciate any feedback.

Thank you.

Bill Wagman

This post has been answered by sb92075 on Jul 30 2013
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 27 2013
Added on Jul 30 2013
4 comments
2,114 views