ArcSDE 8.2 Oracle Patch 2

ESRI is pleased to announce ArcSDE 8.2 Oracle Patch 2. This patch contains fixes from previous patches required for all ArcSDE customers using Oracle Spatial as their geometry storage type. We highly recommend that customers download and install this required patch at their earliest convenience.

ESRI is pleased to announce ArcSDE 8.2 Oracle Patch 2. This patch contains fixes from previous patches required for all ArcSDE customers using Oracle Spatial as their geometry storage type. We highly recommend that customers download and install this required patch at their earliest convenience. This patch includes all the fixes from the first ArcSDE 8.2 Oracle Patch as well as several improvements and maintenance fixes.

The fixes deal specifically with the problems listed below under Bugs Fixed with this Patch.

Disk Space Requirements

During installation, you can either save the original 8.2 files or overwrite them. If you choose to save them, make sure you have enough disk space. The estimated disk space requirements are:

Bugs Fixed with this Patch

Oracle 8i & 9i

• CQ00169749: SeShape.generateBuffer(...) is generating a buffer with wrong offset at certain locations.
  
  CQ00171952: random network i/o error when validating topology.
  
  CQ00173200: Reconcile fatals ArcMap (inside network engine) diff query returns duplicate rows.
  
  CQ00174815: Invalid lob locator corrupting lob storage.

  CQ00159351: Pyramid construction fails for some raster layers that have lz77 compression.

  CQ00159822: sde2shp re-arranges attributes to incorrect features if a feature is dropped and added with the same row id and column id. When an Oracle Spatial feature class is edited outside of ArcGIS, and then exported to a shapefile using sde2shp or ArcGIS, the association between ageometry and its set of attributes is jumbled, with attributes from one geometry becoming associated with another geometry. This problem is restricted to Oracle Spatial feature classes.

  CQ00160588: Cannot see geometry when Oracle Spatial layer's spatial column is named "areal".

  CQ00161532: 'sderaster -o export' does not work correctly when using a extraction window.

  CQ00161722: Building geometric network with snapping and Oracle Spatial fails. This problem only occurs with maintaining geometric networks stored in Oracle Spatial and which has snapping enabled.

  CQ00161868: Reconciling child with parent using oracle spatial data (8i and 9i) throws inconsistent data error. Important because it could potentially prevent the use of versioning with some or all Oracle Spatial layers where more than one child version exists.

  CQ00162368: Fix dbms_get_release function to work with all 8.x, 9.x and future Oracle releases - Found while testing against Oracle 9.2 beta. This change simplifies our handling of new Oracle releases.

  CQ00162382: ArcMap creates invalid features for Oracle Spatial Linear Reference System ( LRS ) - Oracle Spatial LRS does not allow measure values both increase and decrease along the path of a feature. (ArcSDE measures do not have this requirement.) Further, the starting and ending vertices must have non-NULL values, and intervening missing values must be set to NULL.

  CQ00162916: Oracle Spatial: New defaults for tolerance and extent with shp2sde and ArcToolbox - This change was predicated on new suggestions from Oracle on default tolerances for geodetic and projected features.

  CQ00162917: Oracle Spatial: Don't create a spatial index during auto-registration if one doesn't exist - If an Oracle Spatial table is loaded through SQL or a third party application, we will not presume to guess the type of spatial index desired, and build one, if one does not exist when the table is auto-registered. The table without a spatial index can be previewed, but spatial queries (and the zoom and pan operations that depend on spatial queries) will not work.

  CQ00162920: Oracle Spatial: shp2sde placing SRID in metadata, but not in geometries. This became a problem with Oracle 9i, which requires that Oracle Spatial SRID's appear in each geometry and in USER_SDO_GEOM_METADATA for features in geodetic coordinate space.

  CQ00162921: Oracle Spatial: Zooming fails for geodetic data at 9i if spatial filter not smaller than half Earth's area - This problem is introduced due to Oracle 9i Spatial's limitation on the size of a single polygon in geodetic coordinate space to less than ½ the area of the Earth's surface. Oracle 9.0.1.3 is required to fully realize this fix.

  CQ00162923: Oracle Spatial: Do not fetch SE_ANNO_CAD_DATA unless necessary. This problem can reduce fetch performance from Oracle Spatial tables where the column SE_ANNO_CAD_DATA exists. This is not the case with tables loaded with third party applications or with shp2sde.

  CQ00163624: Spatially Enabled View - selected set performance terrible when selected set accesses logfiles - This problem occurs with attribute and logfile queries on Oracle 8i, causing full table scans when querying views with spatial columns. (Does not affect Oracle 9i.).

  CQ00164501: Geometric network featureclasses stored in oracle spatial format produces ORA-00932 - Occurs when attempting to add an edge to a geometric network feature class stored in oracle spatial format when using the ArcSDE 8.1.2 Patch.

  CQ00164654: sdeexport errors with 8.1.2 patch when exporting layers that have FID specified as their shape column.

  CQ00164538: Oracle Spatial: Cannot create spatially-enabled view from feature class joined with business table.

  CQ00167636: When trying to create new domains, this error could occur: "This operation is not supported by this implementation. Table has no associated locator[]". This problem only occurred when using direct connect.
  

  CQ00167228: Getting "Invalid Parameter (-66)" from SE_Stream_get_blob, when joining multiple columns. This affects our ArcIMS Users.

Files Installed in this Patch

UNIX

• Under the $SDEHOME/bin directory:

  giomgr
  gsrvr.shared
  gsrvr.static
  sderaster
  sde2shp (9i on HP only)

• Under the $SDEHOME/lib directory:

  Oracle 8i
  libgsrvrora8i82.so (.sl for HP)
  libsde82.so (.sl for HP)
  libsdeora8isrvr82.so (.sl for HP)
  libsg82.so (.sl for HP)
  libtiff.so (SGI only)

• Oracle 9i
  libgsrvrora9i82.so (.sl for HP)
  libsde82.so (.sl for HP)
  libsdeora9isrvr82.so (.sl for HP)
  libsg82.so (.sl for HP)
  libtiff.sl (HP only)

Windows

• Under the %SDEHOME%\bin folder:

• Oracle 8i
  giomgr.exe
  gsrvr.exe
  gsrvrora8i82.dll
  sde82.dll
  sdeora8isrvr82.dll
  sderaster.exe
  sg82.dll

  Oracle 9i
  giomgr.exe
  gsrvr.exe
  gsrvrora9i82.dll
  sde82.dll
  sdeora9isrvr82.dll
  sderaster.exe
  sg82.dll

Installing the Patch

Since this Patch replaces several ArcSDE 8.2 files, ArcSDE 8.2 must be installed before you can install this Patch. It is strongly recommended that you back up your database including all previous ArcSDE system tables and user layer data before upgrading your ArcSDE installation. Install this patch using your SDE user account.

NOTE: If you use direct -connect without setting up the ArcSDE application server, please skip to step number eight.

On UNIX -

1. Download the appropriate tar file to a location other than $SDEHOME:

2. Oracle 8i
   HP sde82_p2_ora8i_hp.tar	11 MB
   IBM sde82_p2_ora8i_ibm.tar	11 MB
   Sun Solaris sde82_p2_ora8i_slrs.tar	9 MB
   SGI sde82_p2_ora8i_sgi.tar	11 MB
   Tru64 sde82_p2_ora8i_tru64.tar	13 MB
   Oracle 9i
   HP sde82_p2_ora9i_hp.tar	13 MB
   Sun Solaris sde82_p2_ora9i_slrs.tar	9 MB
   Linux sde82_p2_ora9i_lx.tar	7 MB

   
   
3. Stop your current ArcSDE service.

4. % sdemon -o shutdown

5. Extract the specified tar file by typing:

6. % tar -xvf sde82_p2_<Database>_<Platform>.tar

7. Start the installation by typing:

8. % ./apply_patch

   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.

9. Before upgrading your Oracle instance, you must grant the following additional permissions to the SDE user in Oracle:

10. ALTER ANY INDEX
    ALTER ANY TABLE
    ANALYZE ANY
    CREATE ANY INDEX
    CREATE ANY PROCEDURE
    CREATE ANY SEQUENCE
    CREATE ANY TRIGGER
    CREATE ANY VIEW
    CREATE SESSION
    DROP ANY INDEX
    DROP ANY VIEW
    DROP ANY PROCEDURE
    DROP ANY SEQUENCE
    EXECUTE ANY PROCEDURE
    SELECT ANY SEQUENCE
    SELECT ANY TABLE
    UNLIMITED TABLESPACE
    
    After the upgrade completes, you may revoke the following permissions from the SDE user account:
    
    ALTER ANY INDEX
    ALTER ANY TABLE
    ANALYZE ANY
    CREATE ANY INDEX
    CREATE ANY TRIGGER
    CREATE ANY VIEW
    DROP ANY INDEX
    DROP ANY VIEW
    DROP ANY PROCEDURE
    DROP ANY SEQUENCE
    EXECUTE ANY PROCEDURE
    SELECT ANY SEQUENCE
    
    

    • To upgrade, run the updated version of sdesetup<dbms>. Failure to do so may cause problems in starting the service or with connecting to the service. Using Oracle 8i as an example:

    • % sdesetupora8i -o upgrade

    • Start your service again.

    • % sdemon -o start

    • If you use Direct Connect, please follow the steps below to install this patch to your ArcGIS 8.2 Workstation installation directory under $ARCHOME/lib, or ArcIMS 4.0 installation directory under $AIMSHOME/lib:
      
      
      • Before you start, make sure you have write access to the (ArcGIS or ArcIMS) installation directory then download the appropriate compressed tar file to that location:
        
        

        Oracle 8i
        HP sde82_p2_dc_ora8i_hp.tar.Z	4 MB
        IBM sde82_p2_dc_ora8i_ibm.tar.Z	6 MB
        Sun Solaris sde82_p2_dc_ora8i_slrs.tar.Z	4 MB
        SGI sde82_p2_dc_ora8i_sgi.tar.Z	7 MB
        Tru64 sde82_p2_dc_ora8i_tru64.tar.Z	7 MB
        Oracle 9i
        HP sde82_p2_dc_ora9i_hp.tar.Z	4 MB
        Sun Solaris sde82_p2_dc_ora9i_slrs.tar.Z	4 MB
        Linux sde82_p2_dc_ora9i_lx.tar.Z	3 MB

        
        

      • ArcIMS only, stop the ArcIMS Tasker, ArcIMS Monitor, ArcIMS Application Server (in that order).

      • Install the patched files, at the UNIX prompt type:
        
        %cd <installation_directory> (i.e. cd $ARCHOME)
%uncompress sde82_p2_dc_<Database>_<platform>.tar.Z
%tar xvf sde82_p2_dc_<Database>_<platform>.tar
        

      • ArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor and ArcIMS Tasker (in that order).
        

On Windows -

1. Make sure you have write access to the ArcSDE installation folder, that no one is using ArcSDE, and that the ArcSDE service is down.
2. 
   
   
3. Download the appropriate files to a location other than the ArcSDE installation folder:

4. Oracle 8i
   sde82_p2_ora8i.exe	3 MB
   Oracle 9i
   sde82_p2_ora9i.exe	3 MB

   
   
5. Double-click the sde82_p2_<Database>.exe to start the install process.
6. 
   
   
7. When Setup starts, follow the instructions on your screen.
8. 
   
   
9. Before upgrading your Oracle instance, you must grant the following additional permissions to the SDE user in Oracle:

10. ALTER ANY INDEX
    ALTER ANY TABLE
    ANALYZE ANY
    CREATE ANY INDEX
    CREATE ANY PROCEDURE
    CREATE ANY SEQUENCE
    CREATE ANY TRIGGER
    CREATE ANY VIEW
    CREATE SESSION
    DROP ANY INDEX
    DROP ANY VIEW
    DROP ANY PROCEDURE
    DROP ANY SEQUENCE
    EXECUTE ANY PROCEDURE
    SELECT ANY SEQUENCE
    SELECT ANY TABLE
    UNLIMITED TABLESPACE
    
    After the upgrade completes, you may revoke the following permissions from the SDE user account:
    
    ALTER ANY INDEX
    ALTER ANY TABLE
    ANALYZE ANY
    CREATE ANY INDEX
    CREATE ANY TRIGGER
    CREATE ANY VIEW
    DROP ANY INDEX
    DROP ANY VIEW
    DROP ANY PROCEDURE
    DROP ANY SEQUENCE
    EXECUTE ANY PROCEDURE
    SELECT ANY SEQUENCE
    
    

    • To upgrade, run the updated version of sdesetup<dbms>. Failure to do so may cause problems in starting the service or with connecting to the service. Using Oracle 8i as an example:

      % sdesetupora8i -o upgrade

    • As the SDE user, run the following command to restart the ArcSDE service:

      C:\> sdemon -o start

    • If you use Direct Connect, please follow the steps below to install this patch to your ArcGIS 8.2, ArcIMS 4.0, or ArcView GIS 3.3 with DBA 2.1d installation folder:
      
      
      • Before you start, make sure you have write access to the installation folder, then download the appropriate file to that location:
        
        

        Oracle 8i
        sde82_p2_dc_ora8i.zip	2 MB
        Oracle 9i
        sde82_p2_dc_ora9i.zip	2 MB

        
        

      • ArcIMS only, stop the ArcIMS Tasker, ArcIMS Monitor, ArcIMS Application Server (in that order).

      • Use WinZip to extract the new files from sde82_p2_dc_<database>.zip to the apprpriate installation folder, see list below:
        
        
        • ArcGIS Desktop, Workstation, or ArcView 8 - <installation_folder>\arcexe82\bin
          
        • ArcView GIS - <installation_folder>\arcview3\bin
          
        • ArcIMS - <installation_folder>\server\bin
          
          

      • ArcIMS only, restart ArcIMS Application Server, ArcIMS Monitor and ArcIMS Tasker (in that order).
        

Identifying QFE files on your machine

1. UNIX
   

   Any modified UNIX executables (or libraries) being sent out as part of a Quick Fix will return the unique identification number for that fix when checked with the "what" command for UNIX and the "strings" command for Linux. For example, to display the identification string for this Patch on UNIX, type:

   %what giomgr | grep QFE


   QFE-SDE-82-CQ00176121 (09/11/2002)

   Windows
   

   To check for the presence of Quick Fixes, examine the unique identification information by a (right click, properties, version tab) action under Explorer. With only a few exceptions, all files modified as part of a QFE distribution can be uniquely identified in this manner. Under Windows 2000, select 'Product Version' under the 'Item name' column to see the unique identifier.

Patch Updates

Check the Online Support Center periodically for the availability of additional patches. New information about this patch will be posted here.

UPDATE 10/08/02: The Oracle 8i download file for SGI download is now available.

UPDATE 10/29/02: The Oracle 8i download file for SGI has been updated. Please download this file again.

Getting Help

Domestic sites, please contact ESRI Technical Support at 909.793.3774, if you have any difficulty installing this patch. International sites, please contact your local ESRI software distributor.

Download ID:156