I was helping troubleshoot an Agile 9.3.3 environment when I ran into an issue attaching a file. The error was: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE.
I must say that while I was a bit surprised to see the error, it didn’t send me into panic mode. I figured I would just open SQL Developer, go to the indexes and rebuild the indexes associated with FILES or FOLDERS since those were the object types I was working with in Agile. The first index was FILES_CONTENT_IDX which I tried to rebuild that produced the following error:
The last line in the error dialog was a dead giveaway. If you head to http://support.oracle.com (or google) and search on DRG-11446 you get the root cause almost immediately. The examples cd was never installed! The Oracle note is “Drg-11446: Supplied Knowledge Base File Not Installed (Doc ID 1268560.1).” Here is what I did next:
- Shut down Agile PLM
- Shut down the listener and Oracle
- Installed/updated any missing Linux dependencies for the examples cd
- Ran the examples cd installer
- Started Oracle
- Started the Listener
- Cleared out the nohup.out
- Started Agile PLM
- Went into SQL Developer and rebuilt the FILE_CONTENT_IDX index
- Tailed nohup.out
- Logged into Agile and attached a file!
All appears to be working now though I will still go ahead and reorganize the database (export, recreate agile, import). I have run into this before, usually with experienced DBAs that perform the database portion of the Agile stack installation. Because the product is labeled as a companion or example product its value is usually dismissed; don’t make the same mistake.