ArcSDE 9.1 Oracle10gR2 Patch

This patch works around an issue with Oracle 10gR2, Long Raw based ESRI Binary, and cached cursors. Investigation with Oracle is in progress. If you are experiencing ORA-03106 errors when using LongRaw data and Oracle 10gR2 you should download this patch and follow the instructions provided. This patch also includes a fix for a compress issue. See the Issues Fixed with this Patch section for details.

• Issues Fixed with this Patch
• Files Installed in this Patch
• Installing this Patch
        Server
        UNIX
        Windows
        ArcSDE SDK
        UNIX
        Windows
        ESRI Products connecting to ArcSDE (Application and Direct Connect connections)
        UNIX
        Windows
  
• How to identify which Patch is installed
• Patch Updates
• Getting Help

 

Important Notes

This patch allows users to turn off the internal spatial cursor cache to alleviate ORACLE two-task communication errors with Oracle10g. Do not install this patch on top of an Oracle9i installation. The ORA-03106 error is only displayed when using an Oracle10g server.

The errors can be seen in the sde error log (with SDEVERBOSE turned on).
[Thu Jul 06 12:39:27 2006] [1360] [olive] db_sda_execute_stmt::OCIStmtExecute (3106)
[Thu Jul 06 12:39:27 2006] [1360] [olive] SDE_Oracle Error: 3106 ORA-03106: fatal two-task communication protocol error
[Thu Jul 06 12:39:27 2006] [1360] [olive] db_array_fetch_spix_recs OCI Fetch Error (3106)
[Thu Jul 06 12:39:27 2006] [1360] [olive] SDE_Oracle Error: 3106 ORA-03106: fatal two-task communication protocol error
[Thu Jul 06 12:39:27 2006] [1360] [olive] db_get_spix_fidlist Fetch Error

 

Performance and scalability impact

The spatial cursor cache is a performance optimization to hold cursors open and avoid re-parsing sql statements (spatial queries). Disabling the cache will increase the parsing on the Oracle server thus increases CPU usage and can impact scalability with systems showing high CPU contentions.

 

How to turn off the spatial cache

The cache can be turned off by setting an environment variable DISABLE_SPATIAL_CACHE. This variable needs to be set when ArcSDE is started. Add the following line to your dbinit.sde file:

set DISABLE_SPATIAL_CACHE=TRUE

Then restart ArcSDE and make sure it has the environment set, e.g. sdemon -o info -I vars

 

Installing the Patch

ArcSDE 9.1 for Oracle10gR2 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.

REQUIRED INSTALL STEP: If you connect to ArcSDE 9.1 via an Application Server and Direct Connect connections using ArcGIS 9.1, ArcIMS 9.1, or ArcView GIS 3.3 with DBA 2.1g make sure you also see ESRI Products connecting to ArcSDE (Application and Direct Connect connections).

Server Install for UNIX

During installation, you can either save the original 9.1 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. HP-UX 64 sde91-ora10gpatch-ora10g-hp64.tar	11 MB
   IBM64 sde91-ora10gpatch-ora10g-ibm64.tar	9 MB
   Linux sde91-ora10gpatch-ora10g-lx.tar	8 MB
   Solaris64 sde91-ora10gpatch-ora10g-slrs64.tar	10 MB

   
   
3. Stop your current ArcSDE service.

   % 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.

4. Extract the specified tar file by typing:

   % tar -xvf sde91-ora10gpatch-<Database>-<Platform>.tar

5. 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.

6. Start your service again.
   

   % sdemon -o start

7. Download the appropriate sdesetupora10g file to the bin directory under your ArcSDE 9.1 installation location:

8. HP-UX 64 sde91-ora10gpatch-sdesetupora10g-hp64.tar	1 MB
   IBM64 sde91-ora10gpatch-sdesetupora10g-ibm64.tar	1 MB
   Linux sde91-ora10gpatch-sdesetupora10g-lx.tar	1 MB
   Solaris64 sde91-ora10gpatch-sdesetupora10g-slrs64.tar	1 MB

   
   

   Use the tar command to extract the specified tar file for your platform. At the UNIX/Linux prompt type:
   
   %cd <installation_directory>/bin (i.e. cd $SDEHOME/bin)
%tar xvf sde91-ora10gpatch-sdesetupora10g-<Platform>.tar
   

 

Server Install for Windows

Windows Installation Notes:

• ArcSDE 9.1 for Oracle10gR2 must be installed on the server and your client applications before you install this Patch.
  

 

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.
2. Download the appropriate files to a location other than the ArcSDE installation folder:

3. sde91-ora10gpatch-ora10g-win.exe

   2 MB

   
   
4. Double-click the appropriate executable to start the install process.
5. When Setup starts, follow the instructions on your screen.
6. As the SDE user, run the following command to restart the ArcSDE service:
   

   sdemon -o start

7. Use WinZip to extract the new file from sde91-ora10gpatch-sdesetupora10g-win.zip to the bin folder under your ArcSDE 9.1 installation location.

 

ArcSDE SDK Install for UNIX

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

   HP-UX 64 sde91-ora10gpatch-sdk-hp64.tar	4 MB
   IBM64 sde91-ora10gpatch-sdk-ibm64.tar	4 MB
   Linux sde91-ora10gpatch-sdk-lx.tar	3 MB
   Solaris64 sde91-ora10gpatch-sdk-slrs64.tar	4 MB

   
   
2. Extract the specified tar file by typing:
   

   % tar -xvf sde91-ora10gpatch-sdk-<Platform>.tar

3. 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.

 

ArcSDE SDK Install for Windows

1. Make sure you have write access to the ArcSDE SDK installation folder:.
2. 
   
   
3. Download the appropriate files to a location other than the ArcSDE SDK installation folder:

4. ArcSDE SDK sde91-ora10gpatch-sdk-win.exe	2 MB
   ArcSDE Java SDK sde91-ora10gpatch-javasdk-win.exe	1 MB

   
   
5. Double-click the appropriate executable to start the install process.
6. 
   
   
7. When Setup starts, follow the instructions on your screen.
8.  

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

• UNIX

  • If you connect to ArcSDE 9.1 using ArcInfo Workstation 9.1 or ArcIMS 9.1, please follow the steps below to install this Patch to your ArcInfo Workstation 9.1 installation directory under $ARCHOME, or ArcIMS 9.1 installation directory under $AIMSHOME:
    
    
    • Before you start, make sure you have write access to the (ArcInfo or ArcIMS) installation directory then download the appropriate compressed tar file to that location:
      
      

      Linux sde91-ora10gpatch-esri-lx.tar.Z

      3 MB

      
      

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

    • 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. At the UNIX prompt type:
      
      %cd <installation_directory> (i.e. cd $ARCHOME)
%uncompress sde91-ora10gpatch-esri-<Platform>.tar.Z
%tar xvf sde91-ora10gpatch-esri-<Platform>.tar
      

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

  Windows

  • If you connect to ArcSDE 9.1 using ArcGIS 9.1, ArcIMS 9.1, ArcInfo Workstation 9.1, or ArcView GIS 3.3 with DBA 2.1g, please follow the steps below to install this Patch to your ArcGIS 9.1, ArcIMS 9.1, ArcInfo Workstation 9.1, or ArcView GIS 3.3 with DBA 2.1g installation folder:
    
    
  • Before you start, make sure you have write access to the installation folder, then download the zip file to that location:
    
    

    sde91-ora10gpatch-esri-win.zip

    2 MB

    
    

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

  • Use WinZip to extract the new file from sde91-ora10gpatch-esri-win.zip to the appropriate installation folder, see list below:
    
    
    • ArcGIS Desktop, Server, Engine, Reader, or ArcView 9 - <installation-folder>\arcgis\bin
      
    • ArcGIS Workstation - <installation-folder>\arcexe9x\bin
      
    • ArcView GIS - <installation-folder>\av_gis30\arcview\(bin32 & DCONNECT\LIB)
      
    • Depending on the ArcIMS Setup features installed, the SDE client file could be located in one or more of the following locations:
      
      • C:\Program Files\ArcGIS\bin
        
      • C:\Program Files\ArcGIS\ArcIMS\IndexBuilder
        
      • C:\Program Files\ArcGIS\ArcIMS\Metadata\Commands
        
      • C:\Program Files\ArcGIS\ArcIMS\Server\bin
        
      
      

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

 

How to identify which Patch is installed

1. 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. This utility provides a report detailing which ArcGIS products and which servicepacks have been installed. The PatchFinder utility searches for thefollowing ArcGIS products.

   • ArcGIS Engine Runtime
     
   • ArcGIS Reader
     
   • ArcGIS Server
     
   • ArcIMS
     
   • ArcInfo Workstation
     
   • ArcSDE
     

   Extract the tar file by typing:

   % tar xvf PatchFinder.tar

   
   

   Run the utility by typing:

   % ./PatchFinder

   Windows
   

   To check for the presence of a Patch, for each file examine the unique identification information provided (right click, properties, version tab, item name, QFE Version). With only a few exceptions, all files modified as part of a Patch distribution can be uniquely identified in this manner. The identification string for this Patch should read:

   • QFE-SDE-91-CQ00293138

 

Patch Updates

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

• UPDATE 8/4/2006 - Updated:

  • Added step number 6 to the ArcSDE Oracle10g Server install steps for all platforms.

• UPDATE 8/4/2006 - Now Available:

  • The ArcSDE Oracle10g and SDK downloads for HP-UX 64.

• UPDATE 8/2/2006 - Updated:

  • The ArcSDE SDK for IBM64 download now contains libsg91_64.a.

• UPDATE 06/01/2007 - Text update:

  • Operating System for HP is now listed as HP-UX to alleviate any confusion between HP-UX and HP TRU64.

 

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.

Download ID:1170