English

Problem: ArcSDE Post Installation fails if alter default geometry storage type is selected

Description

When installing or upgrading ArcSDE for Oracle using the Windows Post Installation wizard, and choosing to alter the default geometry storage type and select Long Raw on the DBTune configuration dialog box as shown below,
[O-Image] ArcSDE_Postinstall
the Post Installation fails with an error in the sde_setup.log:

"Error Invalid dbtune Parameter found in dbtune file:
Config keyword: DATA_DICTIONARY
Parameter name: XML_TAGS_TABLE

Config String : INITRANS 4 STORAGE (INITIAL 1M)
ERROR in loading dbtune table.
Error: -429
DBMS error code: 29833
ORA-29833: indextype does not exist

Parameter XML_TAGS_TABLE of keyword DATA_DICTIONARY failed to load.
Config Keyword: DATA_DICTIONARY
Parameter_name: XML_TAGS_TABLE
Config_string : INITRANS 4 STORAGE (INITIAL 1M)

SDE schema object install not completed.
ERROR installing/upgrading ArcSDE, Error = -1"

Cause

The dbtune.lr file in the %SDEHOME%\etc folder is outdated and contains some obsolete storage parameters.

Solution or Workaround

Follow the steps below:

  1. Download the dbtune.lr and dbtune.sde files from the links in Related Information below. Save them to your %SDEHOME%\etc directory. Make sure the new files replace the old ones with the same file name.
  2. When the updated dbtune files are saved, rerun the Post Installation wizard:

    A. Go to Start > All Programs > ArcGIS > ArcSDE.
    B. Launch the ArcSDE for Oracle Post Installation.

Related Information