ArcSDE 8.2 Oracle 9.2 Patch for Sun Solaris

ESRI is pleased to announce the ArcSDE 8.2 Oracle 9.2 Patch for Sun Solaris. Install this patch only if you plan to use ArcSDE 8.2 with Oracle 9i Release 2 (Oracle Version 9.2) on a Sun Solaris machine.

Disk Space Requirements

During installation, you can either save the original 8.2 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 9.2
Sun Solaris2	1 MB

Files Installed in this Patch

Under the $SDEHOME/bin directory:
sdesetupora9i

Installing the Patch

You must install the ArcSDE 8.2 Oracle Patch 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.

You can install this Patch to a clean installation of ArcSDE 8.2 for Oracle 9.2 or to an upgrade from a previous version of Oracle (i.e., Oracle 9.0.1.2.0).

Clean install (assuming ArcSDE 8.2 is already installed and the Oracle 9.2 database is setup according to ArcSDE and Oracle install documentation):

Download the compressed tar file to your $SDEHOME:

Oracle 9.2
Sun Solaris sde82_ora92fix_ora9i_slrs.tar.Z	276 kb

In the $SDEHOME/bin directory, rename the following file:

sdesetupora9i to sdesetupora9i.old
Uncompress and extract the tar file by typing:
% uncompress sde82_ora92fix_ora9i_slrs.tar.Z % tar -xvf sde82_ora92fix_ora9i_slrs.tar
Run the updated version of sdesetupora9i:
% sdesetupora9i -o install
Start your service:
% sdemon -o start

Upgrading from a previous version of Oracle (assuming upgrade of Oracle database on which ArcSDE 8.2 was installed previously has been upgraded to Oracle 9.2 successfully - ie. Oracle 9.0.1.2.0 to Oracle 9.2):

Download the compressed tar file to your $SDEHOME:

Oracle 9.2
Sun Solaris sde82_ora92fix_ora9i_slrs.tar.Z	276 kb

Stop your current ArcSDE service.
% sdemon -o shutdown
In the $SDEHOME/bin directory, rename the following file:

sdesetupora9i to sdesetupora9i.old
Uncompress and extract the tar file by typing:
% uncompress sde82_ora92fix_ora9i_slrs.tar.Z % tar -xvf sde82_ora92fix_ora9i_slrs.tar
Before upgrading your Oracle instance, you must grant the following additional permissions to the SDE user in Oracle:
ALTER ANY INDEX
ALTER ANY TABLE
ANALYZE ANY
CREATE ANY INDEX
CREATE ANY PROCEDURE
CREATE ANY SEQUENCE
CREATE ANY TRIGGER
CREATE ANY VIEW
CREATE SESSION
DROP ANY INDEX
DROP ANY VIEW
DROP ANY PROCEDURE
DROP ANY SEQUENCE
EXECUTE ANY PROCEDURE
SELECT ANY SEQUENCE
SELECT ANY TABLE
UNLIMITED TABLESPACE

After the upgrade completes, you may revoke the following permissions from the SDE user account:

ALTER ANY INDEX
ALTER ANY TABLE
ANALYZE ANY
CREATE ANY INDEX
CREATE ANY TRIGGER
CREATE ANY VIEW
DROP ANY INDEX
DROP ANY VIEW
DROP ANY PROCEDURE
DROP ANY SEQUENCE
EXECUTE ANY PROCEDURE
SELECT ANY SEQUENCE
To upgrade, run the updated version of sdesetupora9i. Failure to do so may cause problems in starting the service or with connecting to the service:
% sdesetupora9i -o upgrade
Start your service:
% sdemon -o start

Identifying QFE files on your machine

Any modified UNIX executables (or libraries) being sent out as part of a Quick Fix will return the unique identification number for that fix when checked with the "what" command for UNIX and the "strings" command for Linux. For example, to display the identification string for this Patch on UNIX, type:

%what sdesetupora9i | grep QFE QFE-SDE-82-CQ00172604 (08/02/2002)

Patch Updates

Check the Online Support Center periodically for the availability of additional patches. New information about this patch will be posted here.

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.

Download ID:152