Install fails @ aw_indexes

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Install fails @ aw_indexes

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

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 ;