Troubleshooting guide

7 — 5620 SAM database management
7-8 Alcatel-Lucent 5620 Service Aware Manager
5620 SAM
System Administrator Guide
Completed changing the Oracle database user settings
8 Close the console window.
Procedure 7-5 To configure Oracle database error monitoring
You can configure how the 5620 SAM handles Oracle database errors to provide
monitoring information that may help with troubleshooting or the detection of security
violations such as SQL injection attacks. When database error monitoring is enabled,
the 5620 SAM raises an alarm when the Oracle software reports an error, for example,
an invalid SQL statement.
1 Choose Administration→Database from the 5620 SAM main menu. The Database
Manager (Edit) form opens.
2 To enable database error monitoring, select the Enable Database Error Monitoring
parameter.
3 To disable database error monitoring, deselect the Enable Database Error
Monitoring parameter.
4 Save your changes and close the form.
Procedure 7-6 To configure a size constraint policy
Size constraint policies regulate the number of historical records that the 5620 SAM
database retains before they are purged. The scheduling of tasks through the 5620 SAM
can generate a large volume of archived result information if left unchecked. Size
constraint policies control the volume of information stored by defining thresholds for
various record classes. When the number of records for a specific class or group of
classes reaches a threshold specified in the policy, the 5620 SAM deletes a specified
number of the oldest objects that are associated with the class or group of classes.
1 Choose Administration→Constraint Policies→Size Constraint Policies from the
5620 SAM main menu. The Size Constraint Policies form opens.
2 Click Create or choose a policy and click Properties. The Size Constraint Policy
(Create|Edit) form opens.
Note — The 5620 SAM is preconfigured with the following default size
constraint policies for various record classes:
• Script Management Results
• Clear Requests
• CPAM Protocol Data
• Work Order Import Logs
• LTE User Stats Query Output Snapshots
Release 13.0 R2 | May 2015 | 3HE 09815 AAAB TQZZA Edition 01