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