arcSDE9.3.1 repository upgrade to arcSDE10.1 failed

[SunilKelkar]

We have arcSDE9.3.1 in Oracle11g 64 bit. We are attempting to upgrade arcSDE9.3.1 to 10.1 using ArcMAP's upgrade geodatabase tool and attempt is failing with following errors.

/*************/
Finished checking prerequisites.
Server tables and stored procedures are up to date.
The geodatabase system table could not be created. [ORA-00942: table or view does not exist
] [GDB_Items : Error (-218)]
The geodatabase system table could not be created. [GDB_Items : Error (-218)]
Unpaused the database.
Failed to execute (UpgradeGDB).
/************/

any ideas

[VinceAngelo]

The -218 error is SE_TABLE_REGISTERED, with a description "Table already registered".

Have you attempted an upgrade and had it fail?  Did you create a GDB_ITEMS table
on your own?  Is there a table named GDB_ITEMS owned by user SDE?

Did you make a complete (and verified) backup of the SDE user tables before attempting
upgrade?

- V

[SunilKelkar]

There is no GDB_ITEMS table in SDE schema. How do I create them? I thought this table is created as a part of upgrade.

[VinceAngelo]

There *shouldn't* be such a table until after an upgrade.  Is a reference to GDB_Items
present in the ArcSDE table registry?  Did someone attempt and clean up after a
failed database upgrade?

Tracking down exotic upgrade problems is more in the realm of Tech Support than
these Forums.

- V

[SunilKelkar]

TABLE_REGISTRY as well as COLUMN_REGISTRY does not have any reference of the GDB_ITEMS table.

If this table is a part of ***Upgrade*** then why it is failing on "Table does not exists"?

OK, I will open a trouble ticket with ESRI Support.

Thanks