Start Journaling Internal Tables
Oracle keeps an audit trail of all data changes in some of its internal metadata tables in shadow journaling tables. However, you must explicitly turn this feature on. Journaling tables help to satisfy regulatory requirements.
- Set AuditTrail:Activate Profile to Yes
- Define the Audit Installation
- Prevent Error
- Run the Audit Trail Update Tables Concurrent Program
Parent topic: Installing Oracle Life Sciences Data Hub
Set AuditTrail:Activate Profile to Yes
Set the AuditTrail:Activate profile to Yes at the Oracle LSH Application level.
Parent topic: Start Journaling Internal Tables
Define the Audit Installation
To start journaling, do the following:
-
Log on as sysadmin; see Log on as sysadmin for details.
-
Click the System Administrator responsibility link. A new column of links appears.
-
In the new column of links, scroll down to Security: Audit Trail. In this section, click Install.
If you receive a message asking if you want to install an applet, do so.
The Audit Installations window appears.
-
Click the Search icon (flashlight/torch) in the toolbar. The Find Audit Installations pop-up appears.
Note:
If the icon is inactive, the wrong window is in focus. If necessary, retrieve the Audit Installations window:
-
In the Navigator - System Administrator window, Functions tab, expand the Security node.
-
Expand the Audit Trail node.
-
Click Install.The Audit Installations window appears.
Then click the Search icon in the toolbar.
-
-
Click in the Oracle Username field to display the ellipsis (...), then click the ellipsis to display the list of values. Find and select
CDR
. -
Click Find. The system returns you to the Audit Installation window with
CDR
displayed in the Oracle Username column -
Select the Audit Enabled checkbox and click Save.
Parent topic: Start Journaling Internal Tables
Prevent Error
For the most current information, see My Oracle Support article 727208.1, AuditTrail Update Tables fails on View AP_SYSTEM_PARAMETERS_ALL_AC1.
To follow Step 1 in the article, do the following:
-
Log in to Oracle LSH as sysadmin.
-
Navigate to System Administrator, then Security, then Audit Trail, and then Groups.
-
Confirm anything necessary to get the application to run and a form appears.
-
Press F11.
-
In the Audit Group line enter
SQLAP.AP_SYSTEM_PARAMETERS_ALL
and press Ctrl+F11. The Audit Group SQLAP.AP_SYSTEM_PARAMETERS_ALL appears. -
Proceed with Step 2 in the MOS article.
Step 2 in the article is:
- Set the Group state to "Disable - Purge Table" for AP_SYSTEM_PARAMETERS_ALL. This option Disable - Purge Table Drops the auditing triggers and views and deletes all data from the shadow table.
- Be sure to Save before exiting.
Step 3 in the article is Run the Audit Trail Update Tables Concurrent Program.
Parent topic: Start Journaling Internal Tables
Run the Audit Trail Update Tables Concurrent Program
After you have defined CDR as the audit installation, run the Audit Trail Concurrent Program to enable auditing.
-
From the View menu, select Requests. The Find Requests pop-up appears.
-
Click Submit a New Request. The Submit a New Request pop-up appears.
-
Select Single Request and click OK. The Submit Request pop-up appears.
-
From the Name drop-down list, select AuditTrail Update Tables and click OK. The system returns you to the Submit Request window with AuditTrail Update Tables displayed in the Name field.
-
Click Submit. A window pops up with the Request ID and asks if you want to submit another request.
-
Make a note of the Request ID and click No.
Monitor the Job: To monitor the job's progress:
Parent topic: Start Journaling Internal Tables