Problem: ArcSDE 9.3 for Oracle upgrade may fail during SDE_LOGFILES table upgrade due to insufficient permissions (ORA-01031)
Upgrading to ArcSDE 9.3 for Oracle may fail if ArcSDE was configured to use shared ArcSDE log files.
The sdesetup -o upgrade fails with the following messages in the command output,
Upgrading ArcSde schema.....
Error: Insufficient permissions (-25).
Error: SDE release upgrade not completed.
and the sde_setup.log has the following error message entries (where XXX can be any data owner name):
[Date Time] SQL Stmt: <ALTER TABLE XXX.sde_logfiles MODIFY LOGFILE_NAME NVARCHAR2(256)>
[Date Time] Unable to upgrade registered tables, error = -25.
[Date Time] DBMS error code: 1031
ORA-01031: insufficient privileges
Under certain situations when shared ArcSDE log files are used, there may be orphaned entries left in the SDE_LOGFILES table for the data owner schema.
Solution or Workaround
If there are orphaned entries in SDE_LOGFILES tables during upgrade, two additional database privileges are needed for the ArcSDE admin user to upgrade these tables. Those permissions are not included in the list of required upgrade privileges.
- Grant the following privileges to the SDE user:
lock any table
update any table
These privileges can be revoked after the upgrade completes successfully.