Re: ORACLE (10 and XE): audit_trail on windows event

From: ddf <oratune_at_msn.com>
Date: Tue, 22 Sep 2009 06:09:27 -0700 (PDT)
Message-ID: <76000a5f-52f2-4f4c-b82f-a97b08bb4650_at_o35g2000vbi.googlegroups.com>

On Sep 22, 7:47 am, "Michele \"L'emarginato\" " <m..._at_job.giob> wrote:
> 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

You are looking for these files in the directory listed in the audit_file_dest parameter?

David Fitzjarrell Received on Tue Sep 22 2009 - 08:09:27 CDT