English

ArcSDE 9.3.1 Service Pack 2 Register as Versioned using Oracle Spatial Data Patch

Summary

This patch resolves an issue with Oracle 11gR2 (11.2.0.2) associated with registering feature classes as versioned using Oracle Spatial data. Esri recommends that all Oracle 11gR2 (11.2.0.2) users that are also using Oracle Spatial for their feature geometry apply this patch at their earliest convenience to resolve this issue.

Description

Introduction

Esri® announces the ArcSDE 9.3.1 Service Pack 2 Register as Versioned using Oracle Spatial Data Patch. This patch addresses an issue caused by an undocumented change in the Oracle 11.2.0.2 release. The Oracle 11.2.0.2 release now has a new constraint on SDO_DIMNAME which causes the "register feature classes as versioned" operation to fail if the feature geometry is Oracle Spatial (sdo_geometry type). It deals specifically with the issue listed below under Issues Addressed with this Patch.


Issues Addressed with this Patch


    • NIM065101 - Oracle 11.2.0.2 has a new constraint on SDO_DIMNAME, which causes current register sdo_geometry feature classes as versioned operation to fail. Please see technical article 38713 for more details.

Files Installed in this Patch

Windows (Server):

    <ArcSDE installation directory>\bin:
      gsrvr.exe
      gsrvrora11g93.dll
      pe.dll
      sde.dll
      sdeexport.exe
      sdeimport.exe
      sdeora11gsrvr93.dll
      sdetable.exe
      sdexinfo.exe
      st_shapelib.dll

    <ArcSDE installation directory>\lib:

      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)

    <ArcSDE installation directory>\bin or <ArcGIS installation directory>\bin:
      gsrvrora11g93.dll
      pe.dll
      sde.dll
      sdeora11gsrvr93.dll

    <ArcSDE installation directory>\lib: (SDK only)
      sde.lib

Unix (Server)

    <ArcSDE installation directory>\bin:
      gsrvr
      sdeexport
      sdeimport
      sdexinfo
      sdetable


    <ArcSDE installation directory>\lib:
      libgsrvrora11g93.so
      libpe.so
      libsde.so
      libsdeora11gsrvr93.so
      libst_shapelib.so
      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)

    <ArcSDE installation directory>\lib:
      libgsrvrora11g93.so
      libpe.a
      libpe.so
      libsde.so
      libsde.a
      libsdeora11gsrvr93.so

Installing the 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.

ArcSDE Server Install for UNIX


Installation Steps:


ArcSDE 9.3.1 Service Pack 2 or ArcSDE 9.3.1 Service Pack 2 General Update Patch for DB2, Informix, and Oracle must be installed before you can install this Patch.

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. Oracle 11g  
    HP-UX Itanium 64 sde931sp2-osv11g-ora11g-hpia64.tar
    18 MB
    Solaris 64 sde931sp2-osv11g-ora11g-slrs64.tar
    9 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-osv11g-Ora11g-<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. 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 OPERATOR
      CREATE SESSION
      CREATE TYPE
      DROP ANY INDEX
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      DROP ANY TABLE
      DROP ANY VIEW
      EXECUTE ANY PROCEDURE
      SELECT ANY SEQUENCE
      SELECT ANY TABLE
      UNLIMITED TABLESPACE

  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 folder for more information on using this command:
  11. %sdesetup -o upgrade -d ORACLE11G u <DB_Admin_User> p <DB_Admin_password>

    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 TRIGGER
      CREATE ANY VIEW
      CREATE INDEXTYPE
      CREATE OPERATOR
      CREATE TYPE
      DROP ANY INDEX
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      DROP ANY TABLE
      DROP ANY VIEW
      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 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
    Projection Engine pe.dll, libpe.so
    Geometry sg.dll, libsg.so

    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.

ArcSDE Server Install for Windows


Installation Steps


ArcSDE 9.3.1 Service Pack 2 or ArcSDE 9.3.1 Service Pack 2 General Update Patch for DB2, Informix, and Oracle must be installed before you can install this Patch.

  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:

    Oracle 11g 32-bit SDE931SP2-osv11g-ora11g-win.EXE 4 MB
    Oracle 11g 64-bit SDE931SP2-osv11g-ora11g-win64.msp 3 MB

  3. Double-click sde931sp2-osv11g-Ora11g-win.exe to start the install process.


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


  5. 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 OPERATOR
      CREATE SESSION
      CREATE TYPE
      DROP ANY INDEX
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      DROP ANY TABLE
      DROP ANY VIEW
      EXECUTE ANY PROCEDURE
      SELECT ANY SEQUENCE
      SELECT ANY TABLE
      UNLIMITED TABLESPACE

  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 ORACLE11G u <DB_Admin_User> p <DB_Admin_password>
  7. 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 TRIGGER
      CREATE ANY VIEW
      CREATE INDEXTYPE
      CREATE OPERATOR
      CREATE TYPE
      DROP ANY INDEX
      DROP ANY PROCEDURE
      DROP ANY SEQUENCE
      DROP ANY TABLE
      DROP ANY VIEW
      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 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
    Projection Engine pe.dll, libpe.so
    Geometry sg.dll, libsg.so

    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 64-bit  
    HP Itanium 64 sde931sp2-osv11g-sdk-hpia64.tar
    29 MB
    Solaris64 sde931sp2-osv11g-sdk-slrs64.tar
    12 MB

  3. Extract the specified tar file by typing:
  4. % tar -xvf sde931sp2-osv11g-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-bit SDE931sp2-osv11g-sdk-win.exe 3 MB
    ArcSDE C SDK 64-bit SDE931SP2-OSV11g-CSDK-Win64.msp 3 MB
    ArcSDE Java SDK 64-bit SDE931SP2-OSV11g-JavaSDK-Win64.msp 3 MB

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


  5. 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, ArcGIS Reader 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 sde931sp2-e-osv11g-linux.tar 5 MB
    Solaris sde931sp2-e-osv11g-slrs.tar 4 MB
         
    ArcGIS Reader
    Linux sde931sp2-r-osv11g-linux.tar 5 MB
    Solaris sde931sp2-r-osv11g-slrs.tar 4 MB
         
    ArcGIS Server
    Linux sde931sp2-s-osv11g-linux.tar 5 MB
    Solaris sde931sp2-s-osv11g-slrs.tar 4 MB

  2. Extract the client tar file by typing:
  3. % tar -xvf sde931sp2-Ora11g-osv11g-<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 Engine, ArcGIS Reader 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, Reader, Server
    GIS931SP2-OSV11g-win.exe 3 MB

  2. Double-click GIS931SP2-OSV11g-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 Service Pack. International sites, please contact your local Esri software distributor.