Error "ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE" appears in the Archive Agent log file - WKB14516
Article number: 14516
SYMPTOMS
- Oracle Database was moved to a different server
- Archive Agent does not start
ENVIRONMENT
- NuGenesis 8 SDMS
- Oracle 11.2.0.4
CAUSE
Oracle Temp Table Space is insufficient to create the Advanced Search Index.
FIX or WORKAROUND
Contact NuGenesis Technical Support for information on diagnosing this error and rebuilding the index.
ADDITIONAL INFORMATION
Complete error in the NuGenesis Archive Agent activity log:
- NGAdmin.CreateEntry: [NG14529] ODBC driver reports error: : [Oracle][ODBC][Ora]ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE