English

ArcGIS 10.2.2 for (Desktop, Engine, Server) Spatial Reference Consistency Patch

Summary

This patch corrects inconsistencies between a feature class’s spatial reference and the geodatabase’s metadata. This patch should be applied to all ArcGIS client applications that are connecting to geodatabases using Oracle. Running the geodatabase upgrade command is mandatory after applying the patch. Additional steps must be taken to create any spatial indexes that were previously dropped.

Description

Introduction

Esri® announces the ArcGIS 10.2.2 for (Desktop, Engine, Server) Spatial Reference Consistency Patch. This patch addresses critical issues introduced into spatial reference metadata after upgrading Oracle enterprise geodatabases. Full explanations of the issues that are resolved with the patch are available in the following knowledge base articles:

Bug: Invalid spatial reference (4326) set when inserting/updating the sde gdb_items table when modifying the content for upgraded ArcGIS 10.0 geodatabases (ID 000012015)

Bug: Unable to insert or update Oracle st_geometry feature classes, encountering ORA-20085 errors (ID 000012037)

After applying the patch upgrading the geodatabase is mandatory. Failure to do so will result in inconsistent metadata and behavior. Upgrading the geodatabase will correct the metadata inconsistencies and prevent additional inconsistencies from being introduced by unpatched ArcGIS clients. After the upgrade is complete, additional steps must be performed to create missing or invalid spatial indexes. See the following article for more information:

HowTo: Perform post upgrade operations after installing the Spatial Reference Consistency Patch (ID 000012086)

Upgrading all ArcGIS clients is strongly recommended. Failure to apply the patch will result in certain operations from succeeding because the upgraded geodatabase will prevent any new inconsistencies. See the following article for more information:

Error: Spatial Reference Consistency Patch - unpatched client behavior (ID 000012087)


Issues Addressed with this patch


  • NIM095988 - After dropping the spatial index on a feature class in a geodatabase that was upgraded to ArcGIS 10.1 or later, insert or update operations return an ORA-20085 error
  • NIM099594 - The following Oracle errors: ORA-29877, ORA-20085 and ORA-06512, are encountered when attempting to make object schema changes, spatial index changes, or create Raster Dataset in ArcCatalog after upgrading certain ArcSDE 10.0 Oracle geodatabases.
  • NIM100823 - Rebuild the spatial index on a versioned feature class fails with an SRID mismatch error.
  • NIM101030 - When copy/pasting feature classes with the same spatial reference to Oracle SDO_GEOMETRY, new entries are created in the sde.spatial_references table instead of using an existing one.
  • NIM101204 - SDEBINARY/SDELOB layers are incorrectly referencing/sharing SPATIAL_REFERENCES entries from ST/SDO layers that have AUTH_SRID, AUTH_NAME.

Files Installed with this patch


Under the <ArcGIS for Desktop, Engine, Server Windows Installation >\bin folder or the <ArcGIS for Server Linux> /bin folder:
    sdeora11gsrvr102.dll
    sg.dll
Under the Windows <ArcGIS for Desktop, Engine, Server Windows Installation >\lib folder or the <ArcGIS for Server Linux>/lib folder:
    st_geom_cols_util.spb
    st_geom_cols_util.sps
    libsg.so (Linux only)
Linux Engine files

Under the <ArcGIS Engine for Linux Installation Directory>/bin folder:
    libsdeora11gsrvr102.so
    st_geom_cols_util.spb
    st_geom_cols_util.sps
    libsg.so

Installing this patch on Windows


Installation Steps:


ArcGIS 10.2.2 for Desktop, Engine or Server must be installed before installing this patch.

  1. Download the appropriate file to a location other than your ArcGIS installation location.

  2.     Checksum (Md5)
    ArcGIS Desktop Background Geoprocessing (64-bit) ArcGIS-1022-BGDT-SRC-Patch.msp 5D9137E159568B51E9CFD7A2EDE78708
         
    ArcGIS Engine Background Geoprocessing (64-bit) ArcGIS-1022-BGE-SRC-Patch.msp 8AC443030E1500A331320DC8F704D846
         
    ArcGIS for Desktop ArcGIS-1022-DT-SRC-Patch.msp BD3D7BDA99141B927914CA3EE25CF718
         
    ArcGIS Engine ArcGIS-1022-E-SRC-Patch.msp B235A9B39F880D7787B97D1749533CD4
         
    ArcGIS for Server ArcGIS-1022-S-SRC-Patch.msp C31036FF41762D152FE034001281BFAD
         

  3. Make sure you have write access to your ArcGIS installation location.

  4. Double-click ArcGIS-1022-<Product>-SRC-Patch.msp to start the setup process.

    NOTE: If double clicking on the MSP file does not start the setup installation, you can start the setup installation manually by using the following command:

    msiexec.exe /p [location of Patch]\ArcGIS-1022-<Product>-SRC-Patch.msp

  5. After the installation procedure has finished, complete Upgrade a geodatabase in Oracle section.


Installing this patch on Linux


Installation Steps:


Complete the following install steps as the ArcGIS Install owner. The Install owner is the owner of the arcgis folder.

ArcGIS 10.2.2 for Engine or Server must be installed before installing this patch.

  1. Download the appropriate file to a location other than your ArcGIS installation location.


        Checksum (Md5)
    ArcGIS Engine ArcGIS-1022-E-SRC-Patch-lx.tar B68E09CEB19D080E2BDDB6FA2712B99E
         
    ArcGIS for Server ArcGIS-1022-S-SRC-Patch-lx.tar C8C2F427AC43163E033CCC3A104B1CC4

  2. Make sure you have write access to your ArcGIS installation location, and that no one is using ArcGIS.

  3. Extract the specified tar file by typing:

    % tar -xvf ArcGIS-1022-<Product>-SRC-Patch-lx.tar

  4. Start the installation by typing:

    % ./applypatch

    This will start the dialog for the menu-driven installation procedure. Default selections are noted in parentheses ( ). To quit the installation procedure, type 'q' at any time.

  5. After the installation procedure has finished, complete the Upgrade a geodatabase in Oracle section.

Upgrade a geodatabase in Oracle


Running geodatabase upgrade is mandatory after applying this patch. To upgrade the geodatabase follow these instructions.

  1. Open ArcCatalog or ArcMap.
  2. Make a direct connection to your your geodatabase as the geodatabase administrator user.
  3. Right-click the geodatabase connection and click Properties.
  4. Navigate to the General tab and check the Upgrade Status section.
  5. Click the Upgrade Geodatabase button.

Please go to the ArcGIS Web help topics for more information on upgrading:

"Preparing to upgrade a geodatabase in Oracle"

Patch Updates

Check the Patches and Service Packs page periodically for the availability of additional patches. New information about this patch will be posted here.

How to identify which ArcGIS products are installed

To determine which ArcGIS products are installed, choose the appropriate version of the PatchFinder utility for your environment and run it from your local machine. PatchFinder will list all products, hot fixes, and patches installed on your local machine.

Getting Help

Domestic sites, please contact Esri Technical Support at 1-888-377-4575, if you have any difficulty installing this patch. International sites, please contact your local Esri software distributor.