Enabling Default Auditing

This section explains how to use Database Configuration Assistant to enable default auditing.

To enable the default profile security settings using Database Configuration Assistant: 

1. Start Database Configuration Assistant:

   • UNIX: Enter the following command at a terminal window:

     dbca
     

     Typically, dbca is in the $ORACLE_HOME/bin directory.

   • Windows: From the Start menu, click All Programs. Then click Oracle - ORACLE_HOME, Configuration and Migration Tools, and then Database Configuration Assistant.

     Alternatively, you can start Database Configuration assistant at a command prompt:

     dbca
     

     As with UNIX, typically, dbca is in the ORACLE_BASE\ORACLE_HOME\bin directory.

2. In the Welcome window, click Next.

   The Operations window appears.

3. From the list, select the current database instance, and then click Next.

   The Management Options page appears.

4. Select Keep the database configured with Database Control.

   The Security Settings page appears.

5. Select the security option you prefer, and then click Next.

   Oracle recommends that you take advantage of the enhanced security settings for this release.

   The Database Components page appears.

6. Click Next.

   The Connection Mode page appears.

7. Select either Dedicated Server Mode or Shared Server Mode (depending on the selection you made when you created this database), click Finish, and then click OK in the confirmation prompts.