ORA-24328: illegal attribute value – XDB component upgrade error

During the upgrade from 11.2.0.4 to 12.1.0.2 we received an error.

In the created logfile located in /u01/app/oracle/cfgtoollogs/dbua/logs the following was reported:

 

UPGRADE_PROGRESS : 36%

XDB component upgrade error:

ORA-24328: illegal attribute value

When checking out the details in the /u01/app/oracle/cfgtoollogs/dbua/EDBA7_01/upgrade1/catupgrd0.log

 

It reports:

15:29:21 SQL> Rem Ensure that all XDB$RESOURCE dependencies are validated

15:29:21 SQL> Rem before any packages that depend on it are compiled below

15:29:21 SQL> desc XDB.XDB$RESOURCE_T;

ERROR:

ORA-24328: illegal attribute value
The problem seems to be caused by the fact the New Feature 12c, invisilbe columns

As we have set in the glogin.sql added: set colinvisible on

 

When you remove this line, the above error is not reported during the upgrade.

The problem seems to be reported in bug: 25602907

 

Hope this helps.

16 maart 2017|12c, rdbms|

Leave A Comment