IBM Support

Maximo install/upgrade can fail with error ORA-29861

Troubleshooting


Problem

Installing a Maximo fixpack can fail during upgrade of the Oracle database with error: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Symptom

Upgrade fails. UpdateDB log shows:

BMXAA7025E -- Script failed while running.;
sql#29861;
ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE

Cause

This error message occurs when a corrupt index exists in the database associated with one of the tables that is being upgraded when the error occurs.

Environment

Oracle database platforms only

Diagnosing The Problem

The following statement will list any invalid indexes:

Select index_name,index_type,status,domidx_status,domidx_opstatus From
user_indexes Where index_type like '%DOMAIN%' And (domidx_status <> 'VALID' Or
domidx_opstatus <> 'VALID');

Resolving The Problem

If the results of the SQL return any indexes, rebuild the invalid indexes with an SQL command of this type:
Alter Index <indexname> Rebuild;
e.g. Alter Index ACTCI_T1DX REBUILD

After rebuilding the invalid indexes, again try to upgrade the database. If this fails to resolve the problem, then it may be necessary to rebuild all the text indexes. This technote explains how to rebuild Oracle text indexes http://www-01.ibm.com/support/docview.wss?uid=swg21298705. Rebuild the text indexes, then again launch the upgrade of the database.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU055","label":"Cognitive Applications"},"Component":"Upgrade Programs","Platform":[{"code":"PF033","label":"Windows"}],"Version":"Version Independent","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSLKTY","label":"Maximo Asset Management for IT"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SSKTXT","label":"Tivoli Change and Configuration Management Database"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}},{"Product":{"code":"SS6HJK","label":"Tivoli Service Request Manager"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"","label":""}],"Version":"","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21695147

Page Feedback