000022469 - How to resolve rollback segment errors that occur when using Oracle as RSA ClearTrust datastore

Document created by RSA Customer Support Employee on Jun 16, 2016Last modified by RSA Customer Support Employee on Apr 21, 2017
Version 2Show Document
  • View in full screen mode

Article Content

Article Number000022469
Applies ToRSA ClearTrust 5.0.1
Sun Solaris 2.8
Oracle 8.1
IssueHow to resolve rollback segment errors that occur when using Oracle as RSA ClearTrust datastore
During periods of heavy volume, the following Oracle errors occur:

ORA-01595:  error freeing extent (1) of rollback segment (14)
ORA-01594:  attempt to wrap into rollback segment (14) extent (1) which is being freed

These errors halt all RSA ClearTrust operations.
CauseThe Oracle database rollback segments are not set to a sufficiently large size
ResolutionTo correct this issue, increase the OPTIMAL parameter on each rollback segment. The value should be large enough so Oracle does not have to shrink and allocate extents frequently. Also, the value should be large enough to prevent "snapshot too old" errors.
Legacy Article IDa30114

Attachments

    Outcomes