Troubleshooting guide

6 — 5620 SAM database management
Alcatel-Lucent 5620 Service Aware Manager 6-3
5620 SAM
System Administrator Guide
5620 SAM auxiliary database cluster
A 5620 SAM auxiliary database cluster is an optional component group that extends
the database throughput and storage for demanding operations such as statistics data
collection. This distributed database relieves the central database processing load.
Each database in an auxiliary cluster is installed on a separate physical or virtual
station to allow load balancing and fault tolerance.
You can use the 5620 SAM client GUI to perform the following operations:
view the status of each auxiliary database in a cluster
manually create, schedule, and delete snapshots for data restoration in the event
of a failure
Auxiliary database cluster safeguards
The 5620 SAM monitors each auxiliary database in a cluster and raises alarms for
the following events:
database or database proxy state change
database or database proxy unavailability
6.2 Workflow for 5620 SAM database management
1 As a security precaution, configure the number of failed Oracle database user
login attempts that the 5620 SAM allows before a user is locked out; see
Procedure 6-9.
2 As required, unlock the Oracle database user account due to multiple login
failures; see Procedure 6-10.
3 Configure how the 5620 SAM responds to Oracle database errors; see
Procedure 6-11.
4 Configure size constraint policies to regulate the number of records retained in
the 5620 SAM database; see Procedure 6-12.
5 Configure ageout constraint policies to define a configurable ageout time for a
specific object type in the 5620 SAM database; see Procedure 6-13.
6 Manage 5620 SAM database disk usage by configuring database file policies to
manage the file size and number of archives for stored alert, listener, trace, audit
log, and core dump files; see Procedure 6-14.
7 Configure the statistics data retention period for the 5620 SAM database; see
Procedure 6-15.
8 Configure a scheduled 5620 SAM database backup and auxiliary database cluster
snapshot; see Procedure 6-8.
Release 12.0 R6 | November 2014 | 3HE 08861 AAAF TQZZA Edition 01