Install fails @ aw_indexes

Document ID : KB000089646
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Install fails @ aw_indexes
Resolution:
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

set_path=/evnapwl1/apps/appwxl1/bin/stopso

stopso all


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

Solution
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 ;