English

ArcSDE 9.3.1 Service Pack 2 General Update Patch for DB2, Informix, and Oracle

Summary

This patch contains general performance improvements, maintenance fixes and several mandatory fixes for users of geodatabase replication. Please download and install this patch at your earliest convenience.

Description

Introduction

ESRI® announces the ArcSDE 9.3.1 Service Pack 2 General Update Patch for DB2, Informix, and Oracle. This patch contains general performance improvements, maintenance fixes and several mandatory fixes for users of geodatabase replication. Please download and install this patch at your earliest convenience. It deals specifically with the issues listed below under Issues Addressed with this Patch.


Issues Addressed with this Patch



    DB2, Informix, Oracle:

    • NIM058031 - Synchronizing geodatabase replicas using ArcSDE for Oracle, DB2 or Informix in ArcGIS 9.3.1 SP2, or ArcGIS 10.0 can corrupt data or returns an error. Please see technical article 38462 for more information.

    DB2, Informix:

    • NIM057521 - Post failed with error "The current version does not support editing (base, consistent, or closed)".

    Oracle:

    • NIM058199 - If sde.version_user_ddl.edit_version('t1',1) call errors out due to lock conflict, it will issue a commit which can affect other pending transactions.
    • NIM059748 - Add CARDINALITY hint to SELECT statements using the TABLE (CAST (:numtab AS SDE.sdenumtab)) subquery to improve performance of queries.
    • NIM060032 - Add a new check release function to sde.version_user_ddl that returns DEFAULT when the sde.version_user_ddl package is present.
    • NIM060955 - Provide the ability to directly edit a multi-versioned view in the DEFAULT version.
    • NIM061091 - a certain SQL query involving st_intersect uses much more memory and is much slower after ArcSDE 9.3.1 SP2 is applied.

Files Installed in this Patch

Windows (Server):

    bin:
      gsrvr.exe
      gsrvr<db2|db2zos|inf|ora10g|ora11g>93.dll
      sde.dll
      sde<db2|db2zos|inf|ora10g|ora11g>srvr93.dll
      sdetable.exe
      st_shapelib.dll (ora10g and ora11g only)
    lib: (ora10g and ora11g only)

      pinfo_util.spb
      pinfo_util.sps
      sde_util.sps
      version_user_ddl.spb
      version_user_ddl.sps
      version_util.spb
      version_util.sps

Windows (SDK & Client)

    bin:
      gsrvr<db2|db2zos|inf|ora10g|ora11g>93.dll
      sde.dll
      sde<db2|db2zos|inf|ora10g|ora11g>srvr93.dll

    lib: (SDK only)
      Sde.lib

Unix (Server)

    bin:
      gsrvr
      sdetable
    lib:
      libgsrvr<db2|inf|ora10g|ora11g>93.so (.sl for HP64, _64.so for IBM64)
      libsde.so (.sl for HP64, _64.so for IBM64)
      libsde<db2|inf|ora10g|ora11g>srvr93.so (.sl for HP64, _64.so for IBM64)

    lib: (ora10g and ora11g only)
      libst_shapelib.so (.sl for HP64, _64.so for IBM64)
      pinfo_util.spb
      pinfo_util.sps
      sde_util.sps
      version_user_ddl.spb
      version_user_ddl.sps
      version_util.spb
      version_util.sps

Unix (SDK & Client)

    lib:
      libgsrvr<db2|inf|ora10g|ora11g>93.so (.sl for HP64, _64.so for IBM64)
      libpe.a (_64.a for IBM64) libsde.so (.sl for HP64, _64.so for IBM64)
      libsde<db2|inf|ora10g|ora11g>srvr93.so (.sl for HP64, _64.so for IBM64)

Installing the Patch

ArcSDE 9.3.1 Service Pack 2 must be installed before you can install this Patch. It is strongly recommended that you back up your database including all ArcSDE geodatabase system tables and user layer data before upgrading your ArcSDE geodatabase. Install this Patch using your SDE user account.

ArcSDE Server Install for UNIX


Installation Steps:

During installation, you can either save the original 9.3.1 Service Pack 2 files or overwrite them. If you choose to save them, make sure you have enough disk space. The disk space requirements, for each platform, are displayed during the installation process.

  1. Download the appropriate tar file to a location other than $SDEHOME:
  2. DB2    
    HP-UX 64 sde931sp2-gup-db2-hp64.tar
    6 MB
    IBM 64 sde931sp2-gup-db2-ibm64.tar
    6 MB
    Linux sde931sp2-gup-db2-lx.tar
    4 MB
    Solaris 64 sde931sp2-gup-db2-slrs64.tar
    6 MB
       
    Informix  
    HP-UX sde931sp2-gup-inf-hp.tar
    6 MB
    IBM sde931sp2-gup-inf-ibm.tar
    6 MB
    Linux sde931sp2-gup-inf-lx.tar
    4 MB
    Solaris sde931sp2-gup-inf-slrs.tar
    5 MB
       
    Oracle 10gR2  
    HP-UX 64 sde931sp2-gup-ora10g-hp64.tar
    7 MB
    HP-UX Itanium 64 sde931sp2-gup-ora10g-hpia64.tar
    14 MB
    IBM 64 sde931sp2-gup-ora10g-ibm64.tar
    7 MB
    Linux 64 sde931sp2-gup-ora10g-lx64.tar
    5 MB
    Linux sde931sp2-gup-ora10g-lx.tar
    5 MB
    Solaris 64 sde931sp2-gup-ora10g-slrs64.tar
    7 MB
       
    Oracle 11g  
    HP-UX Itanium 64 sde931sp2-gup-ora11g-hpia64.tar
    14 MB
    IBM64 sde931sp2-gup-ora11g-ibm64.tar
    7 MB
    Linux 64 sde931sp2-gup-ora11g-lx64.tar
    5 MB
    Linux sde931sp2-gup-ora11g-lx.tar
    5 MB
    Solaris64 sde931sp2-gup-ora11g-slrs64.tar
    7 MB

  3. Stop your current ArcSDE service, if one is running.
  4. % sdemon -o shutdown

    NOTE (AIX only): You must remove any inactive libraries that are loaded into memory before proceeding to the next step. Not doing so will result in an installation error. To remove them, as ROOT user, type:

    # /usr/sbin/slibclean

    (Optional) To list the libraries loaded into memory, as ROOT user, type:

    # /usr/sbin/genkld

    For further information on the slibclean and genkld commands please refer to your AIX system administrator documentation.

  5. Extract the specified tar file by typing:
  6. % tar -xvf sde931sp2-gup-<Database>-<Platform>.tar

  7. Start the installation by typing:
  8. % ./applypatch

    This starts 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. (Oracle only) Before upgrading your Oracle instance, you must grant the following additional permissions to the SDE user in Oracle:

      ADMINISTER DATABASE TRIGGER
      ALTER ANY INDEX
      ALTER ANY TABLE
      ANALYZE ANY
      CREATE ANY INDEX
      CREATE ANY PROCEDURE
      CREATE ANY SEQUENCE
      CREATE ANY TRIGGER
      CREATE ANY VIEW
      CREATE INDEXTYPE
      CREATE LIBRARY
      CREATE OPERATOR
      CREATE PROCEDURE
      CREATE PUBLIC SYNONYM
      CREATE SESSION
      CREATE SEQUENCE
      CREATE TABLE
      CREATE TRIGGER
      CREATE TYPE
      DROP ANY INDEX
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      DROP ANY TABLE
      DROP ANY VIEW
      DROP PUBLIC SYNONYM
      EXECUTE ANY PROCEDURE
      SELECT ANY SEQUENCE
      SELECT ANY TABLE
  10. To upgrade, run sdesetup. Failure to do so may cause problems in starting the service or with connecting to the service. Please go to the admin command guide under the $SDEHOME/documentation directory for more information on using this command:
  11. %sdesetup -o upgrade -d <ORACLE9I|ORACLE10G|ORACLE11G|SQLSERVER|DB2|INFORMIX> –u <DB_Admin_User> –p <DB_Admin_password> [-D <database>]

    (Oracle only) After the upgrade completes, you may revoke the following permissions from the SDE user account:

      ADMINISTER DATABASE TRIGGER
      ALTER ANY INDEX
      ALTER ANY TABLE
      ANALYZE ANY
      CREATE ANY INDEX
      CREATE ANY SEQUENCE
      CREATE ANY TRIGGER
      CREATE ANY VIEW
      CREATE INDEXTYPE
      CREATE LIBRARY
      CREATE OPERATOR
      CREATE TYPE
      DROP ANY INDEX
      DROP ANY VIEW
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      EXECUTE ANY PROCEDURE
      SELECT ANY SEQUENCE

  12. Start your service again.
  13. % sdemon -o start

  14. Only for users who have Oracle and ArcSDE installed on separate machines. If any of the files in the table below appear in the list of files installed, copy those specific files per the instructions and only those files.

    If you are installing ArcSDE on a different server than Oracle, you must copy the shared libraries used by EXTPROC to the Oracle server. These libraries include st_shapelib plus the Geometry library and the Projection Engine library. (The names of these files vary depending on what operating system (OS) you are using.) Be sure the files copied to the Oracle server are designed to run on the operating system of the Oracle server. For example, if ArcSDE is installed on a Linux machine, but Oracle is installed on a Solaris machine, the library files you copy to the Oracle server must be for Solaris. To get the files for different operating system, you can install the software files of the ArcSDE component on the Oracle server, creating the SDEHOME files, and delete everything but the three required library files.

    Library Name OS-dependent file names
    st_shapelib st_shapelib.dll, libst_shapelib.so (.sl for HP64, _64.so for IBM64)
    Projection Engine pe.dll, libpe.so (.sl for HP64, _64.so for IBM64)
    Geometry sg.dll, libsg.so (.sl for HP64, _64.so for IBM64)

    These files can be found in the bin (Windows) or lib (UNIX/Linux) directory of SDEHOME after you've installed the ArcSDE component. You can copy these files to the %ORACLE_HOME%\lib (Windows) or $ORACLE_HOME/lib (UNIX/Linux) directory on the Oracle server, which is the default location that Oracle looks in for shared libraries. Or, you can leave these files where they were installed or move them into any directory that is accessible to the user that owns ORACLE_HOME.

  15. If you have more than one ArcSDE service, perform steps 1 through 8 for each of your ArcSDE services.

Server Install for Windows

Installation Steps

  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.

    NOTE: If you do not shut down the ArcSDE service before installing this Service Pack, you will be prompted and required to reboot your server machine in order to successfully complete the Service Pack installation.

  2. Download the appropriate files to a location other than the ArcSDE installation folder:

    DB2 SDE931SP2-GUP-db2-win.EXE 2 MB
    DB2 zOS SDE931SP2-GUP-db2zos-win.EXE 2 MB
    Informix SDE931SP2-GUP-inf-win.EXE 3 MB
    Oracle 10g SDE931SP2-GUP-ora10g-win.EXE 3 MB
    Oracle 10g 64-bit SDE931SP2-GUP-Ora10g-Win64.msp 3 MB
    Oracle 11g SDE931SP2-GUP-ora11g-win.EXE 3 MB
    Oracle 11g 64-bit SDE931SP2-GUP-Ora11g-Win64.msp 3 MB

  3. Double-click the appropriate setup to start the install process.


  4. When Setup starts, follow the instructions on your screen.


  5. (Oracle only) Before upgrading your Oracle instance, you must grant the following additional permissions to the SDE user in Oracle:

      ADMINISTER DATABASE TRIGGER
      ALTER ANY INDEX
      ALTER ANY TABLE
      ANALYZE ANY
      CREATE ANY INDEX
      CREATE ANY PROCEDURE
      CREATE ANY SEQUENCE
      CREATE ANY TRIGGER
      CREATE ANY VIEW
      CREATE INDEXTYPE
      CREATE LIBRARY
      CREATE OPERATOR
      CREATE PROCEDURE
      CREATE PUBLIC SYNONYM
      CREATE SESSION
      CREATE SEQUENCE
      CREATE TABLE
      CREATE TRIGGER
      CREATE TYPE
      DROP ANY INDEX
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      DROP ANY TABLE
      DROP ANY VIEW
      DROP PUBLIC SYNONYM
      EXECUTE ANY PROCEDURE
      SELECT ANY SEQUENCE
      SELECT ANY TABLE

  6. To upgrade, run sdesetup. Failure to do so may cause problems in starting the service or with connecting to the service. Please go to the admin command guide under the %SDEHOME%\documentation folder for more information on using this command:
    c:\ sdesetup -o upgrade -d <ORACLE9I|ORACLE10G|ORACLE11G|SQLSERVER|DB2|INFORMIX> –u <DB_Admin_User> –p <DB_Admin_password> [-D <database>
  7. (Oracle only) After the upgrade completes, you may revoke the following permissions from the SDE user account:

      ADMINISTER DATABASE TRIGGER
      ALTER ANY INDEX
      ALTER ANY TABLE
      ANALYZE ANY
      CREATE ANY INDEX
      CREATE ANY SEQUENCE
      CREATE ANY TRIGGER
      CREATE ANY VIEW
      CREATE INDEXTYPE
      CREATE LIBRARY
      CREATE OPERATOR
      CREATE TYPE
      DROP ANY INDEX
      DROP ANY VIEW
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      EXECUTE ANY PROCEDURE
      SELECT ANY SEQUENCE


  8. As the SDE user, run the following command to restart the ArcSDE service:
    c:\sdemon -o start
  9. Only for users who have Oracle and ArcSDE installed on separate machines. If any of the files in the table below appear in the list of files installed, copy those specific files per the instructions and only those files.

    If you are installing ArcSDE on a different server than Oracle, you must copy the shared libraries used by EXTPROC to the Oracle server. These libraries include st_shapelib plus the Geometry library and the Projection Engine library. (The names of these files vary depending on what operating system (OS) you are using.) Be sure the files copied to the Oracle server are designed to run on the operating system of the Oracle server. For example, if ArcSDE is installed on a Windows machine, but Oracle is installed on a Solaris machine, the library files you copy to the Oracle server must be for Solaris. To get the files for different operating system, you can install the software files of the ArcSDE component on the Oracle server, creating the SDEHOME files, and delete everything but the three required library files.

    Library Name OS-dependent file names
    st_shapelib st_shapelib.dll, libst_shapelib.so (.sl for HP64, _64.so for IBM64)
    Projection Engine pe.dll, libpe.so (.sl for HP64, _64.so for IBM64)
    Geometry sg.dll, libsg.so (.sl for HP64, _64.so for IBM64)

    These files can be found in the bin (Windows) or lib (UNIX/Linux) directory of SDEHOME after you've installed the ArcSDE component. You can copy these files to the %ORACLE_HOME%\lib (Windows) or $ORACLE_HOME/lib (UNIX/Linux) directory on the Oracle server, which is the default location that Oracle looks in for shared libraries. Or, you can leave these files where they were installed or move them into any directory that is accessible to the user that owns ORACLE_HOME.

  10. If you have more than one ArcSDE service, perform steps 2 through 9 for each of your ArcSDE services.

ArcSDE SDK Install for UNIX


Installation Steps

  1. Download the appropriate tar file to a location other than ArcSDE SDK installation location:


  2. ArcSDE SDK for 32-bit    
    HPUX sde931sp2-gup-sdk-hp.tar
    4 MB
    IBM sde931sp2-gup-sdk-ibm.tar
    3 MB
    Linux sde931sp2-gup-sdk-lx.tar
    2 MB
    Solaris sde931sp2-gup-sdk-slrs.tar
    5 MB
       
    ArcSDE SDK for 64-bit  
    HP64 sde931sp2-gup-sdk-hp64.tar
    4 MB
    HP Itanium 64 sde931sp2-gup-sdk-hpia64.tar
    4 MB
    IBM64 sde931sp2-gup-sdk-ibm64.tar
    4 MB
    Linux 64 sde931sp2-gup-sdk-lx64.tar
    2 MB
    Solaris64 sde931sp2-gup-sdk-slrs64.tar
    4 MB

  3. Extract the specified tar file by typing:
  4. % tar -xvf sde931sp2-gup-sdk-<Platform>.tar
  5. Start the installation by typing:
  6. % ./applypatch

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

ArcSDE SDK Install for Windows


Installation Steps

  1. Make sure you have write access to the ArcSDE SDK installation folder.


  2. Download the appropriate files to a location other than the ArcSDE SDK installation folder:

  3. ArcSDE SDK (C and Java) 32 and 64-bit SDE931SP2-GUP-sdk-win.EXE 8 MB
    ArcSDE SDK ArcSDE C SDK 64-bit SDE931SP2-GUP-CSDK-Win64.msp 4 MB
    ArcSDE SDK ArcSDE Java SDK 64-bit SDE931SP2-GUP-JavaSDK-Win64.msp 4 MB


  4. (Server for .Net Installation Only) From your Services control panel, stop the ArcGIS Server Object Manager and ArcGIS SOC Monitor.

  5. (Server for Java Installation Only) From your Services control panel, stop the ArcGIS Server Manager Service, ArcGIS Server Object Manager and ArcGIS SOC Monitor.

  6. Double-click the appropriate executable to start the install process.


  7. When Setup starts, follow the instructions on your screen.

ESRI Products connecting to ArcSDE (Application and Direct Connect connections)

UNIX

If you connect to ArcSDE 9.3.1 SP2 using ArcGIS Engine or ArcGIS Server, please follow the steps below to install this Patch to your client library folder:

  1. Before you start, make sure you have write access to the installation directory then download the appropriate compressed tar file to that location:

    ArcGIS Engine
    Linux gis931sp2-e-sdegup-linux.tar 9 MB
    Solaris gis931sp2-e-sdegup-slrs.tar 4 MB
         
    ArcGIS Server
    Linux gis931sp2-s-sdegup-linux.tar 9 MB
    Solaris gis931sp2-s-sdegup-slrs.tar 4 MB

  2. Extract the client tar file by typing:
  3. % tar -xvf gis931sp2-<Product>-sdegup-<Platform>.tar
  4. Start the installation by typing:
  5. % ./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.


Windows

    If you connect to ArcSDE 9.3.1 SP2 using ArcGIS Desktop, ArcGIS Engine or ArcGIS Server, please follow the steps below to install this Patch to your client library folder:


  1. Before you start, make sure you have write access to the installation folder, then download the setup to the client machine:

    ArcGIS Desktop, Engine, Server
    GIS931SP2-SDEGUP-win.EXE 2 MB

  2. Double-click GIS931SP2-SDEGUP-win.EXE to start the install process.


  3. When Setup starts, follow the instructions on your screen.

How to identify which Patch is installed


    UNIX

    To find out what ArcGIS products are currently installed on your machine, download and extract the PatchFinder.tar and run PatchFinder utility from your local machine.

    Windows

    To find out what ArcGIS products are currently installed on your machine, download the PatchFinder.exe utility and run it from your local machine.

Patch Updates

Check the ArcGIS Resource Center periodically for the availability of additional Patches or Service Packs. New information about this Patch will be posted here.

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.