Install fails @ aw_indexes

Document ID : KB000089646
Last Modified Date : 14/04/2018
Show Technical Document Details
Install fails @ aw_indexes
Detailed Description and Symptoms
The following error shows up in the aw_install.log.

Starting at 04/05/11 17:00:59 script aw_indexes

Finished at 04/05/11 17:00:59 Elapsed Time 00:00:00 script aw_indexes

errors=ORA-06550: line 27, column 5: ORA-02158: invalid CREATE INDEX option ORA-02158:Fatal error trying to execute script aw_indexes

Fatal error trying to execute script aw_indexes

Fatal Error occurred - check the log /evnapwl1/apps/appwxl1/install/aw_install.log


stopso all

Duplicated the problem in house using Oracle, and upgrading from to 8.0 P6.

The problem looks like an Oracle bug 9474259. Put the following workaround in place to finish the upgrade.

alter system set "_optimizer_enable_extended_stats"=false scope=both ;