Step 4: Optionally, Remove the Components for This Tutorial

Optionally, remove the audit settings that you created earlier.

To remove the audit settings in Database Control:  

1. Log in to Database Control as user SYS with the SYSDBA privilege.

2. Click Server to display the Server subpage.

3. In the Security section, click Audit Settings.

   The Audit Settings page appears.

4. Select the Audited Objects subpage.

5. Under Schema, enter OE.

6. Under Object Name, enter CUSTOMERS.

7. Click Search.

8. Select the box next to the OE.CUSTOMERS audited schema, and then click Remove.

   A Confirmation dialog box appears.

9. Select Yes.

10. Click the Database Instance link to return to the Database home page.

11. Select the Server subpage, and then under Database Configuration, select Initialization Parameters.

12. Select the SPFile subpage.

13. Find the AUDIT_TRAIL parameter and then set it to the original value. Click Apply.

14. Exit Database Control.

15. Restart the database:

    sqlplus sys as sysoper
    Enter password: password
    
    SQL> SHUTDOWN IMMEDIATE
    SQL> RESTART