English

ArcSDE 8.1 for Oracle TRIM Patch

Summary

This patch repairs a Timeout error when making multiple connections to ArcSDE as the same user. It also repairs a row ordering problem that occurs during a TRIM operation, where valid states would occasionally be removed from a version state lineage.

Description

Introduction

ESRI® is pleased to announce the ArcSDE 8.1 for Oracle® TRIM operation Patch. This patch repairs a Timeout error when making multiple connections to ArcSDE as the same user. It also repairs a row ordering problem that occurs during a TRIM operation, where valid states would occasionally be removed from a version state lineage. This can occur randomly during an edit/save and compress TRIM operations. It deals specifically with the problems listed below under Bugs Fixed with this Patch.

Hardware Environment

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

Platform
Oracle 8i
HP® PA-RISC HP-UX® 8 MB
IBM® RS/6000® and AIX®
11 MB
Sun Solaris2
9 MB
Tru64 UNIX 13 MB
Windows NT®/2000®-Intel® 4 MB
 
Platform
Oracle 8.0.6
SGI IRIX 9 MB (Added 11/13/01)
HP PA-RISC HP-UX 9 MB (Added 2/8/02)
Windows NT/2000-Intel 2 MB (Added 6/25/02)

Bugs Fixed with this Patch

CQ00115222: Timeout error when connecting to SDE from ArcIMS and ArcMap.

The client will see the following error:
SDE Code (-288): Unable to create logfile system tables. User perhaps lacks permissions or resources to create tables.
On the server the following error will appear in the $SDEHOME/etc/sde.errlog.
Unable to create the .SDE_LOGFILE_DATA_IDX2 index, error = -51.
SQL:
CREATE INDEX sde_logfile_data_idx2 ON sde_logfile_data (sde_row_id) PCTFREE 10 INITRANS 4
STORAGE (FREELISTS 4 MINEXTENTS 1 PCTINCREASE 0) NOLOGGING
DBMS error code: 54
ORA-00054: resource busy and acquire with NOWAIT specified

CQ00147117: TRIM process possibly deleting corrupting states table.

CQ00149935: Missing states during TRIM operation causing orphaned STATE_LINEAGES rows

Files Installed in this Patch

Oracle 8i

UNIX
  • Under the $SDEHOME/bin directory:
    gsrvr.static
    gsrvr.shared
  • Under the $SDEHOME/lib directory:
    libgsrvrora8i81.so (.sl for HP)
    libsdeora8isvrvr81.so (.sl for HP)

Windows

  • Under the %SDEHOME%\bin directory:
    gsrvr.exe
    gsrvrora8i81.dll
    sdeora8isrvr81.dll

Oracle 8.0.6

UNIX
  • Under the $SDEHOME/bin directory:
    gsrvr.static
  • Under the $SDEHOME/lib directory:
    libgsrvrora81.so (.sl for HP)
    libsdeorasvrvr81.so (.sl for HP)
Windows
  • Under the %SDEHOME%\bin directory:
    gsrvr.exe
    gsrvrora81.dll
    sdeorasrvr81.dll

Updates for Oracle 8.0.6 on other platforms will be provided on a per-request basis. E-mail your request to support@esri.com.Please specify platform.

Installing the Patch

Since this patch replaces several ArcSDE 8.1 for Oracle files, ArcSDE 8.1 for Oracle SP1 must be installed before you can install this patch.

This Patch installation requires the SDE user account.

On UNIX

Make sure you have write access to $SDEHOME, that no one is using ArcSDE, and that the ArcSDE service is down.

  1. In the $SDEHOME/bin directory, rename the following files:
    gsrvr.static to gsrvr.static.orig
    gsrvr.shared to gsrvr.shared.orig
  2. In the $SDEHOME/lib directory, rename the following files:
    libgsrvrora8i81.so to libgsrvrora8i81.so.orig (.sl for HP)
    libsdeora8isvrvr81.so to libsdeora8isvrvr81.so.orig (.sl for HP)
    libgsrvrora81.so to libgsrvrora81.so.orig (for 8.0.6 only, .sl for HP)
    libsdeorasvrvr81.so to libsdeorasvrvr81.so.orig (for 8.0.6 only, .sl for HP)
  3. Download the appropriate files to your $SDEHOME:
    Oracle 8i  
    sde81sp1_ora8i_hp.tar.Z 5 MB
    sde81sp1_ora8i_ibm.tar.Z 6 MB   (Updated 10/4/01)
    sde81sp1_ora8i_slrs.tar.Z 5 MB
    sde81sp1_ora8i_tru64.tar.Z 8 MB
     
    Oracle 8.0.6  
    sde81sp1_ora806_intel_nt.zip (2 MB) (Added 6/25/02)
    sde81sp1_ora806_sgi.tar.Z (9 MB) (Added 11/13/01)
    sde81sp1_ora806_hp.tar.Z (6 MB) (Added 2/8/02)
  4. Uncompress and extract the specified tar file for your platform. Ensure that the last letter of the file name is a capital Z. Otherwise, the uncompress command will not work.
    % uncompress sde81sp1_ora<version>_<platform>.tar.Z 
    % tar xvf sde81sp1_ora<version>_<platform>.tar
  5. As the SDE user, run the following command to restart the ArcSDE service:
    % sdemon-o start [[-i<service>] [-s <server_name>] |[-H <sde_directory>]] [-p <DB_Admin_password>]

ArcSDE Application Server for Windows (Updated 6/25/02)

Make sure you have write access to %SDEHOME% and that no one is using ArcSDE.

  1. In the %SDEHOME%\bin folder, rename the following files:
    gsrvr.exe to gsrver.exe.orig

    Oracle 8i
    gsrvrora8i81.dll to gsrvrora8i81.dll.orig
    libsdeora8isvrvr81.dll to libsdeora8isvrvr81.dll.orig

    Oracle 8.0.6
    gsrvrora81.dll to gsrvrora81.dll.orig
    libsdeorasvrvr81.dll to libsdeorasvrvr81.dll.orig

  2. Download the appropriate files to a location other than %SDEHOME%:
    sde81sp1_ora8i_intel_nt.zip      2MB
  3. Use WinZip to extract the files to your %SDEHOME%\bin folder.

  4. As the SDE user, run the following command to restart the ArcSDE service:
    C:\> sdemon-o start [[-i<service>] [-s <server_name>] |[-H <sde_directory>]] [-p<DB_Admin_password>]

Direct Connect Drivers for Windows (Updated 6/25/02)

To install the Trim Patch in to a ArcSDE Direct Connect client installation such as ArcGIS Desktop:

  1. In the %ARCHOME%\bin folder, rename the following files:

    Oracle 8i
    gsrvrora8i81.dll to gsrvrora8i81.dll.orig
    libsdeora8isvrvr81.dll to libsdeora8isvrvr81.dll.orig

    Oracle 8.0.6
    gsrvrora81.dll to gsrvrora81.dll.orig
    libsdeorasvrvr81.dll to libsdeorasvrvr81.dll.orig

  2. Download the appropriate files to a location other than %ARCHOME%:
    sde81sp1_ora8i_intel_nt.zip      2MB
    sde81sp1_ora806_intel_nt.zip   2MB
  3. Use WinZip to extract the files to your %ARCHOME%\bin folder.

Patch Updates

Check periodically for the availability of additional patches. New information about this or other patches will be posted here.

UPDATE 6/25/02: The Oracle 8.0.6 update for NT is now available.

UPDATE 2/8/02: The Oracle 8.0.6 update for HP is now available.

UPDATE 11/13/01: The Oracle 8.0.6 update for SGI is now available. Also, instructions for Direct Connect drivers has been provided.

UPDATE 10/4/01: The Oracle 8i update for IBM has been updated. Please download this file again.

UPDATE 10/1/01: Oracle 8i updates for HP and Tru64 are now available.

UPDATE 9/19/01: Further updates have been made to the Oracle 8i files that were posted here previously.

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.