This patch resolves a critical issue where users are unable to create new feature classes or modify their existing schema on Oracle geodatabases that have existed at 10.0 at some point: Oracle geodatabases that were upgraded from a previous release to ArcGIS 10.0, or Oracle geodatabases created with the ArcGIS 10.0 release.

Introduction

Esri® announces the ArcSDE 10.2.2 Oracle Geodatabase Object Schema Update and Editing Patch. This patch resolves a critical issue where users are unable to create new feature classes or modify their existing schema on Oracle geodatabases that have existed at 10.0 at some point: Oracle geodatabases that were upgraded from a previous release to ArcGIS 10.0, or Oracle geodatabases created with the ArcGIS 10.0 release. Please see Knowledge Base - Technical Article 42335 for more information. It deals specifically with the issues listed below under Issues Addressed with this Patch.

Installing this patch on Windows

Installation Notes:

System Administrators: A technical paper is available that discusses the enterprise deployment of ArcGIS 10.2.2 setups using Microsoft Systems Management Server (SMS), System Center Configuration Manager (SCCM), and Group Policy, including additional system requirements, suggestions, known issues, and Microsoft Software Installation (MSI) command line parameters. Deployment in a lockdown environment is also covered.
ArcGIS 10.2.2 Enterprise Deployment.

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 to successfully complete the Service Pack installation. Stopping the ArcSDE service allows you to avoid rebooting the server machine.

Double-click the ArcGIS-1022-SDE-OGOSUE-Patch-<Database>.msp to start the install process.

NOTE: If double clicking on the MSP file does not start the setup installation, you can start the setup installation manually by using the following command:

NOTE (IBM 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.

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.

Start your service again.

% sdemon -o start

If you have more than one ArcSDE Application Server, perform steps 2, 3, 4 and 5 for each one.

Patch Updates

Check the Patches and Service Packs page
periodically for the availability of additional patches. New information about
this patch will be posted here.

How to identify which ArcGIS products are installed

To determine which ArcGIS products are installed, choose the appropriate version of the PatchFinder utility for your environment and run it from your local machine. PatchFinder will list all products, hot fixes, and patches installed on your local machine.