Edit D:\app\Administrator\product\11.2.0\dbhome_1\oc4j\j2ee\oc4j_applications\applications\em\em\online_help\tdpsg\tdpsg_auditing006.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd"> <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <title>Enabling or Disabling the Standard Audit Trail</title> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = ohj/ohw) - Version 5.1" /> <meta name="date" content="2009-06-02T18:13:3Z" /> <meta name="robots" content="noarchive" /> <meta name="doctitle" content="Enabling or Disabling the Standard Audit Trail" /> <meta name="relnum" content="11g Release 2 (11.2)" /> <meta name="partnum" content="E10575-01" /> <link rel="copyright" href="./dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="stylesheet" href="./dcommon/css/blafdoc.css" title="Oracle BLAFDoc" type="text/css" /> <link rel="contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="prev" href="tdpsg_auditing005.htm" title="Previous" type="text/html" /> <link rel="next" href="tdpsg_auditing007.htm" title="Next" type="text/html" /> <script src="./callback.js" type="text/javascript"></script> <noscript>Your browser does not support JavaScript. This help page requires JavaScript to render correctly.</noscript> </head> <body> <div class="zz-skip-header"><a href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr valign="bottom"> <td align="left"></td> <td align="center"><a href="tdpsg_auditing005.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpsg_auditing007.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> <p><a id="CEGIDHAG" name="CEGIDHAG"></a><a id="TDPSG50521" name="TDPSG50521"></a></p> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h1>Enabling or Disabling the Standard Audit Trail</h1> <a name="BEGIN" id="BEGIN"></a> <p><a id="sthref458" name="sthref458"></a>Before you perform the standard auditing procedures described in this section, you must enable standard auditing. When you enable standard auditing, you can create the audit trail in the database audit trail or write the audit activities to an operating system file. If you write to an operating system file, you can create the audit record in text or XML format.</p> <p class="orderedlisttitle">To enable or disable the standard audit trail: </p> <ol> <li> <p>Start Database Control.</p> </li> <li> <p>Log in as <code>SYS</code> and connect with the <code>SYSDBA</code> privilege.</p> <ul> <li> <p><span class="bold">User Name</span>: <code>SYS</code></p> </li> <li> <p><span class="bold">Password</span>: Enter your password.</p> </li> <li> <p><span class="bold">Connect As</span>: <code>SYSDBA</code></p> </li> </ul> </li> <li> <p>Click <span class="bold">Server</span> to display the Server subpage.</p> </li> <li> <p>In the Database Configuration section, click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('INITPARAM_MAIN');"><span class="bold">Initialization Parameters</span></a>.</p> <p>The Initialization Parameters page appears.</p> </li> <li> <p>Click <span class="bold">SPFile</span> to display the SPFile subpage.</p> <p>If the <span class="bold">SPFile</span> tab does not display in your installation, then you did not install Oracle Database using a server parameters file. Go to the next step.</p> </li> <li><a id="BCGIAGAH" name="BCGIAGAH"></a> <p>In the <span class="bold">Name</span> field, enter <code>audit_trail</code> to find the <code>AUDIT_TRAIL</code> parameter, and then click <span class="bold">Go</span>.</p> <p>You can enter the first few characters of the parameter, for example, <code>AUDIT_</code>. Alternatively, you can scroll down the list of parameters to find the <code>AUDIT_TRAIL</code> parameter.</p> </li> <li> <p>In the <span class="bold">Value</span> field, select one of the following values:</p> <ul> <li> <p><code>DB</code>: Enables database auditing and directs all audit records to the database audit trail (<a id="sthref460" name="sthref460"></a><code>SYS.AUD$</code>), except for records that are always written to the operating system audit trail. (This value is the default if you created the database using Database Configuration Assistant. Otherwise, the default is <code>NONE</code>.)</p> </li> <li> <p><code>OS</code>: Enables database auditing and directs all audit records to an operating system <a id="sthref461" name="sthref461"></a><a id="sthref462" name="sthref462"></a>file. Writing the audit trail to operating system files is better for performance instead of sending the audit records to the <code>SYS.AUD$</code> table. If the auditor is distinct from the database administrator, you must use the <code>operating system</code> setting. Any auditing information stored in the database is viewable and modifiable by the database administrator.</p> <p>To specify the location of the operating system audit record file, set the <code>AUDIT_FILE_DEST</code> initialization parameter. The default directory is <code>$ORACLE_HOME/rdbms/audit</code>.</p> </li> <li> <p><code>NONE</code>: Disables standard auditing.</p> </li> <li> <p><code>DB, EXTENDED</code>: Performs all actions of the <a id="sthref463" name="sthref463"></a><code>AUDIT_TRAIL=DB</code> setting and also populates the SQL bind and SQL text CLOB-type columns of the <a id="sthref464" name="sthref464"></a><code>SYS.AUD$</code> table, when available. (These two columns are populated only when this parameter is specified.)</p> </li> <li> <p><code>XML</code>: Writes to the operating system audit record file in XML format. Prints all elements of the <code>AuditRecord</code> node except <code>Sql_Text</code> and <code>Sql_Bind</code> to the operating system XML audit file.</p> </li> <li> <p><code>EXTENDED</code>: Specifies <code>XML, EXTENDED</code>, which performs all actions of <a id="sthref465" name="sthref465"></a><code>XML</code> and also populates the SQL bind and SQL text CLOB-type columns of the <a id="sthref466" name="sthref466"></a><code>SYS.AUD$</code> table, wherever possible. (These columns are populated only when this parameter is specified.)</p> </li> </ul> </li> <li> <p>Click <span class="bold">Apply</span>.</p> </li> <li> <p>Restart the Oracle Database instance:</p> <ol> <li> <p>Click the <span class="bold">Database Instance</span> link.</p> </li> <li> <p>Click <img src="shortcut.png" alt="callback" border="0" /><a href="javascript:void(0);" onclick="redirectEMpage('DBHOMEPAGE');"><span class="bold">Home</span></a> to display the Database Control home page.</p> </li> <li> <p>Under General, click <span class="bold">Shutdown</span>.</p> </li> <li> <p>In the Startup/Shutdown Credentials page, enter your credentials.</p> <p>See <a href="topicid:ADMQS12037">Shutting Down and Starting Up Using Oracle Enterprise Manager Database Control</a> for more information.</p> </li> <li> <p>After the shutdown completes, click <span class="bold">Startup</span>.</p> </li> </ol> </li> </ol> <p>Note the following:</p> <ul> <li> <p>You do not need to restart the database if you change the auditing of objects. You only need to restart the database if you made a universal change, such as turning on or off <span class="italic">all</span> auditing or changing the destination of the audit trail operating system files.</p> </li> <li> <p>You do not need to set <code>AUDIT_TRAIL</code> to enable either fine-grained auditing or <code>SYS</code> auditing. (<code>SYS</code> auditing enables you to monitor the activities of a system administrator. See <a href="javascript:open('http://www.oracle.com/pls/db112/lookup?id=DBSEG0611','newWindow').focus()"><span class="italic">Oracle Database Security Guide</span></a> for more information.) For fine-grained auditing, you add and remove fine-grained auditing policies as necessary, applying them to the specific operations or objects you want to monitor. You can use the <code>AUDIT_SYS_OPERATIONS</code> parameter to enable and disable <code>SYS</code> auditing.</p> </li> </ul> <div class="helpinfonotealso"> <h2>Related Topics</h2> <p><a href="tdpsg_auditing001.htm#BCGJGGFJ">About Auditing</a></p> <p><a href="tdpsg_auditing005.htm#BCGDDGEC">About Standard Auditing</a></p> <p><a href="tdpsg_auditing015.htm#BCGHGJBG">Tutorial: Creating a Standard Audit Trail</a></p> </div> </div> <!-- class="sect2" --> <!-- Start Footer --> <div class="footer"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="86%" /> <col width="*" /> <tr> <td align="left"><span class="copyrightlogo">Copyright © 2006, 2009, Oracle and/or its affiliates. All rights reserved.</span><br /> <a href="./dcommon/html/cpyr.htm"><span class="copyrightlogo">Legal Notices</span></a></td> <td align="center"><a href="tdpsg_auditing005.htm"><img src="./dcommon/gifs/leftnav.gif" alt="Previous" /><br /> <span class="icon">Previous</span></a> </td> <td align="center"><a href="tdpsg_auditing007.htm"><img src="./dcommon/gifs/rightnav.gif" alt="Next" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </div> <!-- class="footer" --> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de