RE: Those Pesky Little Audit Files (ora_99999.aud)
Depending on the OS, we had created a batch job to simply delete these aud files after a specific amount of time. You may want to implement a similar process. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL 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 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 from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Those Pesky Little Audit Files (ora_99999.aud)
I think it's the rather small manual (if you have it on paper) called either Migration something or New Features something. In there, in one of the appendices (as I recall it) there's a mentioning of a security standard that Oracle now (7.1) supports. ANSI or FIPS or such. Thanks for your effort. Mogens Jamadagni, Rajendra wrote: I have 71620 for DG/UX ... tell me what to look for ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Mogens Nrgaard[mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 11:49AM To: Multiple recipients 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 find the details. I failed to find 7.1doc on Google searches. Probably too muchbeer. Mogens Jamadagni, Rajendra wrote: O Oracle Guru's Please tell us, why _trace_files_public is *STILL* an underscore parameter?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Mogens Nrgaard [mailto:[EMAIL PROTECTED]] Sent:Friday, December 27, 2002 2:09 AM To: Multiple recipients oflist ORACLE-L Subject: Re: Those Pesky Little Audit Files(ora_9.aud) They were put there in 7.1 in order tocomply with some security standard. And their purpose is exactly toprevent a dba from logging in without being monitored. It's in the 7.1 newfeatures manual, as far as I remember. That's also the version whereit was suddenly not possible for the poor deveopers to see their owntracefiles, except if they set _trace_files_public=true. Mogens *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Those Pesky Little Audit Files (ora_99999.aud)
Also see MetaLink Note 210317.1 on why trace files should not be viewable by public. Hemant At 09:33 PM 27-12-02 -0800, you wrote: Metalink Note #1022776.6 explains why.. :) - Kirti -Original Message- From: Mogens Nørgaard [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 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) and I'll find the details. I failed to find 7.1 doc on Google searches. Probably too much beer. Mogens Jamadagni, Rajendra wrote: O Oracle Guru's Please tell us, why _trace_files_public is *STILL* an underscore parameter?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect 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 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 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 deveopers to see their own tracefiles, except if they set _trace_files_public=true. Mogens *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Those Pesky Little Audit Files (ora_99999.aud)
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 startup/shutdown and DBA functions, and we created an account within the database for the oracle Unix account... the aud trace files never told us much of anything. I don't want to know only that someone tried to get in, I want to now how he/she tried --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: 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 deveopers to see their own tracefiles, except if they set _trace_files_public=true. Mogens Rachel Carmichael wrote: 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 from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Those Pesky Little Audit Files (ora_99999.aud)
O Oracle Guru's Please tell us, why _trace_files_public is *STILL* an underscore parameter?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect 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.aud)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 deveopers to see their own tracefiles, except if they set _trace_files_public=true.Mogens *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Those Pesky Little Audit Files (ora_99999.aud)
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 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 from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Those Pesky Little Audit Files (ora_99999.aud)
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 be deleted by a later run. works for me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 27, 2002 10:39 AM To: Multiple recipients of list ORACLE-L 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 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 from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Those Pesky Little Audit Files (ora_99999.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) and I'll find the details. I failed to find 7.1 doc on Google searches. Probably too much beer. Mogens Jamadagni, Rajendra wrote: O Oracle Guru's Please tell us, why _trace_files_public is *STILL* an underscore parameter?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Mogens Nrgaard[mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 2:09AM 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 in the 7.1 new features manual, as far as I remember. That's alsothe version where it was suddenly not possible for the poor deveopers to seetheir own tracefiles, except if they set_trace_files_public=true. Mogens *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Those Pesky Little Audit Files (ora_99999.aud)
I have 71620 for DG/UX ... tell me what to look for ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect 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 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 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) and I'll find the details. I failed to find 7.1 doc on Google searches. Probably too much beer.MogensJamadagni, Rajendra wrote: O Oracle Guru's Please tell us, why _trace_files_public is *STILL* an underscore parameter?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect 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.aud)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 deveopers to see their own tracefiles, except if they set _trace_files_public=true.Mogens *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2
RE: Those Pesky Little Audit Files (ora_99999.aud)
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 to the beginning of time but I just tell 'em to get real. I just up'd the listerner log renaming routine to run on a daily basis because it was too big too view. Now the average size of the listener.julianday file is 20-50MB. The process of cleaning up oracle log and trace files is like a pooper-scooper at the end of the rodeo parade. Steve Orr Bozeman, Montana -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 9:05 AM To: Multiple recipients of list ORACLE-L Subject: RE: Those Pesky Little Audit Files (ora_9.aud) 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 be deleted by a later run. works for me. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, December 27, 2002 10:39 AM To: Multiple recipients of list ORACLE-L 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 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 from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Those Pesky Little Audit Files (ora_99999.aud)
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: Cost Based Optimisation (see http://www.jlcomp.demon.co.uk/tutorial.html ) Next Seminar dates: (see http://www.jlcomp.demon.co.uk/seminar.html ) England__January 21/23 The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -Original Message- To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: 27 December 2002 13:50 O Oracle Guru's Please tell us, why _trace_files_public is *STILL* an underscore parameter?? Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Those Pesky Little Audit Files (ora_99999.aud)
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 __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Friday, December 27, 2002 2:09 AM To: Multiple recipients of list ORACLE-L 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 deveopers to see their own tracefiles, except if they set _trace_files_public=true. Mogens Content-Type: text/html; charset=iso-8859-1; name=Attachment: 1 Content-Transfer-Encoding: quoted-printable Content-Description: Content-Type: text/plain; charset=iso-8859-1; name=ESPN_Disclaimer.txt Content-Transfer-Encoding: 7bit Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Those Pesky Little Audit Files (ora_99999.aud)
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 crashed, among 540 trace and trw files, one tracefile was 1.3GB (no it is not a type) in size. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Subject: 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 to the beginning of time but I just tell 'em to get real. I just up'd the listerner log renaming routine to run on a daily basis because it was too big too view. Now the average size of the listener.julianday file is 20-50MB. The process of cleaning up oracle log and trace files is like a pooper-scooper at the end of the rodeo parade. Steve Orr Bozeman, Montana *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Those Pesky Little Audit Files (ora_99999.aud)
I've got hard-copy of the 7 docs if you can give me a clue where to start searching for it... --- Mogens_Nørgaard [EMAIL PROTECTED] wrote: 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) and I'll find the details. I failed to find 7.1 doc on Google searches. Probably too much beer. Mogens Jamadagni, Rajendra wrote: O Oracle Guru's Please tell us, why _trace_files_public is *STILL* an underscore parameter?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect 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 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 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 deveopers to see their own tracefiles, except if they set _trace_files_public=true. Mogens *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Those Pesky Little Audit Files (ora_99999.aud)
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 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 crashed, among 540 trace and trw files, one tracefile was 1.3GB (no it is not a type) in size. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- From: Orr, Steve [mailto:[EMAIL PROTECTED]] Sent: Friday, December 27, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Subject: 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 to the beginning of time but I just tell 'em to get real. I just up'd the listerner log renaming routine to run on a daily basis because it was too big too view. Now the average size of the listener.julianday file is 20-50MB. The process of cleaning up oracle log and trace files is like a "pooper-scooper" at the end of the rodeo parade. Steve Orr Bozeman, Montana
RE: Those Pesky Little Audit Files (ora_99999.aud)
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 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) and I'll find the details. I failed to find 7.1 doc on Google searches. Probably too much beer.MogensJamadagni, Rajendra wrote: O Oracle Guru's Please tell us, why _trace_files_public is *STILL* an underscore parameter?? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect 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.aud)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 deveopers to see their own tracefiles, except if they set _trace_files_public=true.Mogens *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Those Pesky Little Audit Files (ora_99999.aud)
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, AUDIT_TRAIL=[FALSE|OFF] only stops AUDIT commands from producing a trail, either to AUDIT_TRAIL=[TRUE|DB] (i.e. SYS.AUD$ table) or to AUDIT_TRAIL=OS (i.e. AUDIT_FILE_DEST)... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, December 26, 2002 3:59 PM 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 from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Those Pesky Little Audit Files (ora_99999.aud)
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 from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Those Pesky Little Audit Files (ora_99999.aud)
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 deveopers to see their own tracefiles, except if they set _trace_files_public=true. Mogens Rachel Carmichael wrote: 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 from appearing in the audit_file_dest ??? I thought if I set the audit_trail to false then these would stop as well ... Apparently not. Anyone have an idea how to turn them off ?? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com