PROTECTED]
Web:www.compuware.com
-Original Message-
Sent: Thursday, December 26, 2002 8:59 PM
To: Multiple recipients of list ORACLE-L
Subject:Re: Those Pesky Little Audit Files (ora_9.aud)
IIRC, these files are generated whenever someone logs in as sysdba or
internal. I
of list ORACLE-L
Subject: Re:Those Pesky Little Audit Files (ora_9.aud)
Yeah, it'sa nuisance in most installations, but the idea is to be compliant
with someabbreviation_that_I'm_sure_Tim_can_remember security
standard. Give mea 7.1 doc site (if it exists) and I'll
, 2002 10:49 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Those Pesky Little Audit Files
(ora_9.aud)
Yeah, it's a nuisance in most installations, but the idea is to be
compliant with some abbreviation_that_I'm_sure_Tim_can_remember
security standard. Give me a 7.1 doc site (if it exists
They don't do a great job of monitoring as all they record is the fact
that someone logged in. But then the other auditing Oracle does (or did
in earlier versions, I haven't investigated it in 9i) didn't capture
much information either.
Since we used to automate, via cron, some of the
that of ESPN Inc.
QOTD: Any clod can have facts, but
having an opinion is an art!
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 27, 2002 2:09
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Those Pesky Little Audit Files (ora_9
Thanks. Guess its clean-up job time.
-Original Message-
Sent: Thursday, December 26, 2002 7:59 PM
To: Multiple recipients of list ORACLE-L
IIRC, these files are generated whenever someone logs in as sysdba or
internal. I don't know of any way to stop them.
--- Kevin Lange [EMAIL
that's what I do Kevin. I have a cron job that cleans up all of the Oracle
log files. These audit files, Listener logs, Alert Logs, Trace files etc.
I run it twice a month, deleting anything that is 30 days or older. rename
alert logs and listener logs, rman's sbtio.log file so that they will
To: Multiple recipients of list ORACLE-L
Subject: Re:Those Pesky Little Audit Files (ora_9.aud)
They wereput there in 7.1 in order to comply with some security standard.
And theirpurpose is exactly to prevent a dba from logging in without
being monitored.It's
have facts, but
having an opinion is an art!
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 27, 2002 11:49
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Those Pesky Little Audit Files (ora_9.aud)Yeah, it's
a nuisance in most
Title: RE: Those Pesky Little Audit Files (ora_9.aud)
Yupp, I do the same thing. I figure if there's a problem documented somewhere in those files and I haven't responded to them in 30-60 days then its too old to worry about anyway. Sometimes OWS wants an alert log which goes back
Probably because changing it from it's default
value of FALSE introduces a potential security
hole - trace files may be dumped at any time,
and may contain information that is deemed to
be confidential.
.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
Coming soon a new one-day tutorial:
My guess would be that since it is a security risk, it's probably
not a good a idea to make it a supported parameter.
Jared
On Friday 27 December 2002 05:18, Jamadagni, Rajendra wrote:
O Oracle Guru's
Please tell us, why _trace_files_public is *STILL* an underscore
parameter??
Raj
Title: RE: Those Pesky Little Audit Files (ora_9.aud)
Or you might have to do the cleanup sooner if you have 9202 on AIX 5.1 and you have external tables and you run into that (yet unknown) pmon memory leak (where it supposedly corrupts first 80 bytes of memory). When the instance finally
!
-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]]
Sent: Friday, December 27, 2002 2:09 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: Those Pesky Little Audit Files (ora_9.aud)
They were put there in 7.1 in order to comply
Title: RE: Those Pesky Little Audit Files (ora_9.aud)
that
calls for a super-duper-pooper-scooper. :-)
-Original Message-From: Jamadagni, Rajendra
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 27, 2002
1:09 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Those
Metalink Note #1022776.6 explains why.. :)
-
Kirti
-Original Message-From: Mogens Nørgaard
[mailto:[EMAIL PROTECTED]]Sent: Friday, December 27, 2002 10:49
AMTo: Multiple recipients of list ORACLE-LSubject: Re:
Those Pesky Little Audit Files (ora_9.aud)Yeah, it's
They are generated when you connect internal, connect as sysdba, or connect
as sysoper. You can't turn them off.
In 9i, AUDIT_SYS_OPERATIONS=TRUE (default FALSE) will also create .aud
files in the AUDIT_FILE_DEST, but obviously that can be turned off. In all
versions of Oracle,
IIRC, these files are generated whenever someone logs in as sysdba or
internal. I don't know of any way to stop them.
--- Kevin Lange [EMAIL PROTECTED] wrote:
I thought I had these files stopped but apparently not.
Is there somone out there who can tell me how to stop the Audit files
They were put there in 7.1 in order to comply with some security standard.
And their purpose is exactly to prevent a dba from logging in without being
monitored. It's in the 7.1 new features manual, as far as I remember. That's
also the version where it was suddenly not possible for the poor
19 matches
Mail list logo
