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

During the upgrade from to we received an error.

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



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;


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