Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

ORA:29861 - domain index is markled LOADING/FAILED/UNUASBLE

user222828Jun 13 2011 — edited Jun 13 2011

Hi all.
Oracle 8.
Solaris 10

Just need some suggestions on how to troubleshoot this error or if anyone has seen it before.

We run a Perl script that basically updates a table:

UPDATE SOLUTION
SET text = :p1, lastupdate = sysdate
WHERE wstr = 5102

And are seeing:

DBD::Oracle::db prepare failed: ORA-29861: domain index is marked LOADING/FAILED/UNUSABLE (DBD: error possibly near <*> indicator at char 13 in '
UPDATE <*>SOLUTION
SET text = :p1, lastupdate = sysdate
WHERE wstr = 5102
') at .//append_str_comment.pl line 118, <IFILE> line 1.

This has always worked before and just stopped recently.
Any help on where to look for issues or what i can try to do to fix would be appreciated

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 11 2011

Added on Jun 13 2011

#general-database-discussions

1 comment

1,536 views