Q
Manage Learn to apply best practices and optimize your operations.

ORA-29858 error after upgrade to Oracle 10g

When we try to sync up a text index we get the error "ORA-29858: error occurred in the execution of ODCIINDEXALTER routine ORA-04063: type body 'CTXSYS.TEXTINDEXMETHODS' has errors."

We have upgraded our Oracle 9i instance to Oracle 10g. We are now having problems with the Oracle text. For instance when we try to sync up a text index we get the error "ORA-29858: error occurred in the execution of ODCIINDEXALTER routine ORA-04063: type body 'CTXSYS.TEXTINDEXMETHODS' has errors." Is it possible that we missed an installation step?
Are there invalid objects in the CTXSYS schema? It is possible that objects may have been left invalid after the upgrade. Did you also review the upgrade log files to determine if errors were reported? There are some reported issues with Intermedia (or Oracle Text) and upgrading to 9.2 but I have not found anything specific with respect to upgrading to 10g. The suggested solution in these cases is to uninstall and reinstall Oracle Text. My recommendation would be to open an Oracle TAR and report this problem.

Dig Deeper on Oracle database installation, upgrades and patches

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close