English

ArcGIS 10.2.1 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.1 for (Desktop, Engine, Server) Spatial Reference Consistency Patch. This patch addresses critical issues introduced into spatial reference metadata after upgrading Oracle enterprise geodatabases. A full explanation of the issues resolved with this 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 42335)

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


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:
    gsrvrora11g102.dll
    sde.dll
    sdeora11gsrvr102.dll
Under the Windows <ArcGIS for Desktop, Engine, Server Windows Installation >\lib folder or the <ArcGIS for Server Linux>/lib folder:
    spx_util.spb
    spx_util.sps
    spx_util_10g.spb
    spx_util_10g.sps
    st_geom_cols_util.spb
    st_geom_cols_util.sps
Linux Engine files

Under the <ArcGIS Engine for Linux Installation Directory>/bin folder:
    libgsrvrora11g102.so
    libsde.so
    libsdeora11gsrvr102.so
    spx_util.spb
    spx_util.sps
    spx_util_10g.spb
    spx_util_10g.sps
    st_geom_cols_util.spb
    st_geom_cols_util.sps
    st_spref_util.spb
    st_spref_util.sps
    st_type_export.spb
    st_type_export.sps

Installing this patch on Windows


Installation Steps:


ArcGIS 10.2.1 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-1021-BGDT-SRC-Patch.msp 0766D4C0DBB56FB2EDF0020BB1F76D98
         
    ArcGIS Engine Background Geoprocessing (64-bit) ArcGIS-1021-BGE-SRC-Patch.msp 07624268FCA92C7FEB1FF3270F805835
         
    ArcGIS for Desktop ArcGIS-1021-DT-SRC-Patch.msp 8C0AE9D4D925103FD9EFC03896FC9078
         
    ArcGIS Engine ArcGIS-1021-E-SRC-Patch.msp B44949B64C1E0E5B29F50A522B8467DF
         
    ArcGIS for Server ArcGIS-1021-S-SRC-Patch.msp DF6243E306E5C66AB2BE5D94B299F4E1
         

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

  4. Double-click ArcGIS-1021-<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-1021-<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.1 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-1021-E-SRC-Patch-lx.tar C205B4B81682E4C3C40E6F828993F10E
         
    ArcGIS for Server ArcGIS-1021-S-SRC-Patch-lx.tar 994344A6B4FE6AAB85E872ED551CACED

  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-1021-<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 ArcSDE geodatabase as the ArcSDE administrative 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.