Problem: Applying Oracle Patch 9.2.0.5 incorrectly causes ArcSDE to stop working

Description

Upgrading to Oracle Patch 9.2.0.5 incorrectly may cause problems affecting ArcSDE usage.

Cause

Investigation has revealed the following causes in the majority of cases:

-- Workflow issues when installing the Oracle patch.
-- Oracle issues in relation to the install of the patch. See the listing of Metalink documents in the Solution below.

If the patch is installed correctly, it should work with ArcSDE. ESRI's has confirmed this.

Solution or Workaround

The following is the recommended upgrade path for applying database patches.

1. Setup ArcSDE at the accepted base version of the database; for example, ArcSDE 9.0 = Oracle 9.2.0.3.
   
2. Test to verify the functionality needed works as desired.
3. Take a full backup of the database.
4. Apply the database patch.
5. Restart ArcSDE and test to verify it functions as it did before DBMS patch was applied.
   
   If a problem is encountered, contact an assigned Oracle representative. If need be, return to the previous version of the database.
   
   Related Metalink Documents:
   Oracle Metalink Note: 263792.1 : 9.2.0.5 Patch Set - Known Issues
   Oracle Metalink Note: 271828.1 : Upgrade To 9.2.0.5 Hangs When Running Catpatch.Sql
   Note: 271084.1 ALERT: ORA-600[KSLAWE:!PWQ] RAISED IN V92040 OR V92050 ON SUN 64BIT ORACLE
   Oracle Metalink Note: 273506.1 : Errors While Applying 9.2.0.5 Patchset
   Bug 3527674 HPUX: 9.2.0.5 install fails on HP 11.00
   Bug 3544619 Solaris: UDLM 3.3.4.6 is missing 9.2.0.5 Patch Set for Solaris 32bit
   Bug 3583686 : Oracle Spatial : SDO_FILTER against partitioned table

Related Information

• Will ArcSDE work with Oracle patches?
• ESRI Online Support Center - ArcSDE