Date Submitted: 07-09-2010
Last Modified: 07-09-2010
This Service Pack contains performance improvements and maintenance fixes. Please download and install this required Service Pack at your earliest convenience.
A DVD of this Service Pack will be made available in the next several weeks
for users who experience difficulties downloading the Service Pack from the
web site. Simply fill out the Request
a Service Pack DVD order form.
Support for Oracle 11gR2 on IBM AIX begins with ArcSDE 9.3.1 SP2. To perform an install of ArcSDE 9.3.1 SP2 for Oracle11gR2 on AIX do the following:
ArcSDE 9.3.1 or 9.3.1 Service Pack 1 must be installed before you can install ArcSDE 9.3.1 Service Pack 2. Service Pack 2 is cumulative and contains the fixes from all previous 9.3.1 patches and Service Packs. If you have a previous patch or Service Pack installed, you may apply Service Pack 2 over it to update the required files.
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.
During installation, you can either save the original 9.3.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.
Install this Service Pack using an administrator account, and then upgrade your geodatabase using your ArcSDE administrator account.
% 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.
% tar -xvf sde931-sp2-<Database>-<Platform>.tar
% ./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.
%sdesetup -o upgrade -d <ORACLE9I|ORACLE10G|ORACLE11G|SQLSERVER|DB2|INFORMIX|POSTGRESQL> -D <database_name> -s <datasource> -u <DB_Admin_User> -p <DB_Admin_password>
% sdemon -o start
For Oracle:
If you have the ArcSDE component and Oracle installed on separate servers, there are three shared libraries used by EXTPROC that must be copied to the Oracle server. Check the list of files altered by this patch. If any of the following files are on this list, new versions of the file must be copied to the Oracle server. Be sure the files copied to the Oracle server are designed to run on the operating system of the Oracle server. See the ArcSDE for Oracle installation guide for instructions.
If the file is not in the list, new versions of it do not need to be copied to the Oracle server.
| Library Name | OS-dependent file names |
| st_shapelib | st_shapelib.dll (Windows), libst_shapelib.so (Solaris, Linux, and HP-UX Itanium), libst_shapelib.sl (HP-UX PA-RISC), libst_shapelib_64.so (IBM) |
| Projection Engine | pe.dll (Windows), libpe.so (Solaris, Linux, and HP-UX Itanium), libpe.sl (HP-UX PA-RISC), libpe_64.so (IBM) |
| Geometry | sg.dll (Windows), libsg.so (Solaris, Linux, and HP-UX Itanium), libsg.sl (HP-UX PA-RISC), libsg_64.so (IBM) |
For PostgreSQL:
If you have the ArcSDE component and PostgreSQL installed on separate servers, there are three libraries that must be copied to the PostgreSQL server. Check the list of files altered by this patch. If any of the following files are on this list, new versions of the file must be copied to the PostgreSQL server. Be sure the files copied to the PostgreSQL server are designed to run on the operating system of the PostgreSQL server. See the ArcSDE for PostgreSQL installation guide for instructions.
If the file is not in the list, new versions of it do not need to be copied to the PostgreSQL server.
| Library Name | OS-dependent file names |
| st_geometry | st_geometry (Linux and Windows) |
| Projection Engine | pe.dll (Windows), libpe.so (Linux) |
| Geometry | sg.dll (Windows), libsg.so (Linux) |
| DB2 | SDE931sp2-DB2.msp | 3 MB |
| DB2 z OS | SDE931sp2-DB2zOS.msp | 3 MB |
| Informix | SDE931sp2-Informix.msp | 3 MB |
| Oracle 9iR2 | SDE931sp2-Oracle9i.msp | 3 MB |
| Oracle 10gR2 | SDE931sp2-Oracle10g.msp | 3 MB |
| Oracle 10gR2 64 | SDE931sp2-Oracle10g-64.msp | 4 MB |
| Oracle 11g | SDE931sp2-Oracle11g.msp | 3 MB |
| Oracle 11g 64 | SDE931sp2-Oracle11g-64.msp | 4 MB |
| PostGreSQL | SDE931sp2-PG.msp | 3 MB |
| SQL Server | SDE931sp2-SqlServer.msp | 3 MB |
| SQL Server 64 | SDE931sp2-SqlServer-64.msp | 3 MB |
c:\msiexec.exe /p [location of service pack]\SDE931sp2-<Database>.msp
c:\ sdesetup -o upgrade -d <ORACLE9I|ORACLE10G|ORACLE11G|SQLSERVER|DB2|DB2ZOS|INFORMIX|POSTGRESQL> -D <database_name> -s <datasource> -u <DB_Admin_User> -p <DB_Admin_password>
Or, as a Windows Administrator, start the service from the Windows Services menu.
c:\sdemon -o start
For Oracle:
If you have the ArcSDE component and Oracle installed on separate servers, there are three shared libraries used by EXTPROC that must be copied to the Oracle server. Check the list of files altered by this patch. If any of the following files are on this list, new versions of the file must be copied to the Oracle server. Be sure the files copied to the Oracle server are designed to run on the operating system of the Oracle server. See the ArcSDE for Oracle installation guide for instructions.
If the file is not in the list, new versions of it do not need to be copied to the Oracle server.
| Library Name | OS-dependent file names |
| st_shapelib | st_shapelib.dll (Windows), libst_shapelib.so (Solaris, Linux, and HP-UX Itanium), libst_shapelib.sl (HP-UX PA-RISC), libst_shapelib_64.so (IBM) |
| Projection Engine | pe.dll (Windows), libpe.so (Solaris, Linux, and HP-UX Itanium), libpe.sl (HP-UX PA-RISC), libpe_64.so (IBM) |
| Geometry | sg.dll (Windows), libsg.so (Solaris, Linux, and HP-UX Itanium), libsg.sl (HP-UX PA-RISC), libsg_64.so (IBM) |
For PostgreSQL:
If you have the ArcSDE component and PostgreSQL installed on separate servers, there are three libraries that must be copied to the PostgreSQL server. Check the list of files altered by this patch. If any of the following files are on this list, new versions of the file must be copied to the PostgreSQL server. Be sure the files copied to the PostgreSQL server are designed to run on the operating system of the PostgreSQL server. See the ArcSDE for PostgreSQL installation guide for instructions.
If the file is not in the list, new versions of it do not need to be copied to the PostgreSQL server.
| Library Name | OS-dependent file names |
| st_geometry | st_geometry (Linux and Windows) |
| Projection Engine | pe.dll (Windows), libpe.so (Linux) |
| Geometry | sg.dll (Windows), libsg.so (Linux) |
| All Databases (32 bit Operating System) | ||
| HP-UX | sde931-sp2-sdk-hp.tar | 14 MB |
| IBM | sde931-sp2-sdk-ibm.tar | 14 MB |
| Linux | sde931-sp2-sdk-lx.tar | 20 MB |
| Solaris | sde931-sp2-sdk-slrs.tar | 13 MB |
| All Databases (64 bit Operating System) | ||
| HP-UX 64 | sde931-sp2-sdk-hp64.tar | 20 MB |
| HP-UX Itanium 64 (See NOTE below) | sde931-sp2-sdk-hpia64.tar | 40 MB |
| IBM64 | sde931-sp2-sdk-ibm64.tar | 23 MB |
| Linux 64 | sde931-sp2-sdk-lx64.tar | 18 MB |
| Solaris64 | sde931-sp2-sdk-slrs64.tar | 26 MB |
Included are new Oracle 11g connection files that were not released with the initial release of ArcSDE 9.3.1 on HP-UX Itanium 64. To install them, follow the install Steps below.
% tar -xvf sde931-sp2-sdk-<Platform>.tar
% ./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 64 SDE931sp2-CApiSDK-64.msp | 5 MB |
| ArcSDE SDK SDE931sp2-CApiSDK.msp | 9 MB |
| ArcSDE Java SDK SDE931sp2-JavaSDK.msp | 10 MB |
| ArcSDE Java SDK SDE931sp2-JavaSDK-64.msp | 7 MB |
If you connect to ArcSDE 9.3.1 Service Pack 2 from ArcGIS 9.3.1, you must install the corresponding 9.3.1 Service Pack 2 for your client product. The client updates contained in ArcSDE 9.3.1 Service Pack 2 are also included in ArcGIS 9.3.1 Service Pack 2. This is necessary to maintain version compatibility between the client and the server applications.
If you make a direct connection from a 9.3.1 client to an earlier release ArcSDE geodatabase, you need to install the ArcGIS Pre-9.3 geodatabase direct connect drivers.
If you connect to ArcSDE 9.3.1 using ArcInfo Workstation 9.3.1 please follow the steps below to install this Service
Pack to your ArcInfo Workstation 9.3.1 software installation location:
| HP-UX | sde931-sp2-esri-hp.tar.gz | 10 MB |
| IBM | sde931-sp2-esri-ibm.tar.gz | 9 MB |
| Linux | sde931-sp2-esri-lx.tar.gz | 13 MB |
| Solaris | sde931-sp2-esri-slrs.tar.gz | 9 MB |
% cd <Workstation Installation Directory>/lib(i.e. cd $ARCHOME)
% gunzip sde931-sp2-esri-<Platform>.tar.gz
% tar xvf sde931-sp2-esri-<Platform>.tar
| sde931-sp2-esri-win.zip | 12 MB |
To find out what ArcGIS products are currently installed on your machine, download the PatchFinder utility and run it from your local machine.
To find out what ArcGIS products are currently installed on your machine, download and extract the PatchFinder utility and run it from your local machine.
Check Online Support Center periodically for the availability of additional Service Packs. New information about this Service Pack will be posted here.
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.