ORACLE (10 and XE): audit_trail on windows event
Date: Tue, 22 Sep 2009 14:47:30 +0200
Message-ID: <CH3um.39927$Tq6.26863_at_tornado.fastwebnet.it>
Hi all,
i'm an absolute beginners on oracle systems, so, excuse me for the "stupid qeustion" maybe.
I'm working to a project for to log and store the administrative login to the oracle DB, in both OS windows and unix (linux).
I've readed something but on my test server i cannot reproduce what i'm looking for.
I have an oracle XE on windows (2008) and oracle 10 on linux. I execute on linux the follow commands:
alter system set audit_sys_operations=true scope=spfile; alter system
set audit_syslog_level='local1.info' scope=spfile;
shutdown;
startup;
alter system set audit_trail=os scope=spfile;
audit session whenever not successful ;
Well, on linux it seems to work,but i'm not so sure because i cannot see any LOGOFF.
On windows DOESN'T completely:
alter system set audit_sys_operations=true scope=spfile; alter system
shutdown;
startup;
alter system set audit_trail=os scope=spfile;
audit session whenever not successful ;
Where i was wrong?
There is some documentation to read for to solve this issue?
Thanks Received on Tue Sep 22 2009 - 07:47:30 CDT