search cancel

Install fails @ aw_indexes

book

Article ID: 89646

calendar_today

Updated On:

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 ;