Databases
cancel
Showing results for 
Search instead for 
Did you mean: 

Oracle 9i audit logs to syslog

Kenan Erdey
Honored Contributor

Oracle 9i audit logs to syslog

Hi,

we have an oracle 9i database running on 11.11. now we'd like to forward audit logs to syslog server. i am able to continously tailing a log file and send it with logger. But 9i opens a file for each session and does not directly support unix like logging.

What is done or can be done for directing logs to a logserver.

thanks.
Computers have lots of memory but no imagination
7 REPLIES
Steven E. Protter
Exalted Contributor

Re: Oracle 9i audit logs to syslog

Shalom,

The user oracle does not have rights to syslog.

It would be a security violation and a mistake to give it write access to the syslog.

root however has rights to the oracle 9i logs and can cat the output anywhere it wants.

SEP
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
Kenan Erdey
Honored Contributor

Re: Oracle 9i audit logs to syslog

ok, root should do it. so oracle users can't kill log directing process.
Computers have lots of memory but no imagination
Eric Antunes
Honored Contributor

Re: Oracle 9i audit logs to syslog

Hi,

What is the purpose of this?

I think you should not mix root information with oracle information in syslog.

Best Regards,

Eric Antunes
Each and every day is a good day to learn.
Dennis Handly
Acclaimed Contributor

Re: Oracle 9i audit logs to syslog

>SEP: The user oracle does not have rights to syslog. It would be a security violation and a mistake to give it write access to the syslog.

Anybody can write to syslog with the appropriate APIs: syslog(3) openlog(3) closelog(3)
Kenan Erdey
Honored Contributor

Re: Oracle 9i audit logs to syslog

Hi Eric,

purpose is to monitor what oracle users have done. this is for PCI/DSS.
Computers have lots of memory but no imagination
Kenan Erdey
Honored Contributor

Re: Oracle 9i audit logs to syslog

any suggestions please ?
Computers have lots of memory but no imagination
Eric Antunes
Honored Contributor

Re: Oracle 9i audit logs to syslog

Hi Kenan,

Metalink Note 293973.1 should be a good help in doing this.

Best Regards,

Eric Antunes
Each and every day is a good day to learn.