English

Bug: Upgrading an ArcSDE geodatabase for Oracle fails when the Upgrade Geodatabase tool is executed from a Linux platform

Description

When upgrading an ArcSDE Oracle geodatabase, the Upgrade Geodatabase tool fails if executed from a Linux platform. The failure also occurs if the Upgrade Geodatabase tool is run as a script or a model.

The following error message displays in the output of the tool:

"File "<stdin>", line 1, in <module>
File ../python26/lib/python2.6/site-packages/arcpy/arcpy/management.py", line 532, in
UpgradeGDB
raise e
arcgisscripting.ExecuteError: Could not update ArcSDE server tables and stored procedures.
Failed to execute (UpgradeGDB)."

The following error message displays in the sde_setup.log file, after the first time the upgrade is attempted:

"Unable to load package pinfo_util, file ../lib/pinfo_util.sps not found or badly formatted.
ERROR in creating system stored procedures.
Error: -79"

Cause

Oracle geodatabase object definition files are missing from the Linux installations of ArcGIS Server and Engine RT.

Workaround

Option 1:

Use ArcCatalog to upgrade the geodatabase to version 10, or run the Upgrade Geodatabase tool from a Windows platform that either has ArcGIS 10 Desktop, Server, or Engine RT installed.

Option 2:
On the Linux platform, apply ArcGIS 10 Service Pack 1 to ArcGIS Server or Engine RT, and then run the Upgrade Geodatabase Python script.


For more information on upgrading, see the Upgrading an ArcSDE geodatabase in Oracle topic in ArcGIS 10 Web Help.