How can I customize Exadata Syslog events?
We have enabled the syslog on our Exadata DB servers to send to a remote Syslog.
This is working great.
Problem:
Events like DB creation, User Add/Delete, Table creation are not logged to the Syslog facility.
How can we change the types/filtering of events that are sent to the Syslog facility.
Our line to forward alerts in /etc/rsyslog.conf is:
@syslog.domain.com:514
Where syslog.domain.com is our Enterprise Log collector.
Here are some example tasks that we performed that we would like to see in the logs.
2016/06/01 9:52am login as user01 to database
2016/06/01 9:53am select * from EXISTING_TABLE