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
Duplicated the problem in house using Oracle 22.214.171.124, and upgrading from 126.96.36.199 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 ;