ORA-01408 such column list already indexed 11.2.0.2 to 11.2.0.4 Upgrade error   Leave a comment

During the Upgrade from 11.2.0.2 to 11.2.0.4 on OEL5.5 64-bit for EBS R12.1.3 I faced below issue

upgrade_error

 

Solution:

Ora-01408 Error Upgrading to 11g using Dbua (and manual upgrade) (Doc ID 737400.1)

1. Remove the offending index:

drop index system.REPCAT$_AUDIT_COLUMN_IDX1;

2.

2.1 -If the upgrade has finished without any other error, create the following index:

create index system.repcat$_audit_column_f2_idx
on system.repcat$_audit_column
(base_sname,base_oname,base_conflict_type_id, base_reference_name);

2.2.- If the upgrade was cancelled or more errors were reported, retry the upgrade manually (see Note 429825.1) :

$ cd $ORACLE_HOME/rdbms/admin
$ sqlplus “/ as sysdba”
SQL> startup UPGRADE
SQL> set echo on
SQL> SPOOL upgrade.log
SQL> @catupgrd.sql
SQL> spool off

Advertisements

Posted March 25, 2014 by balaoracledba.com in Upgrade

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: