Oracle patchset for ArcGIS 10.1

Question

Hi,

(1) ESRI online documentation says that ArcGIS 10.1 supports Oracle 11g R2 (64-bit) 11.2.0.1.

(2) I am using following Oracle with ArcGIS / ArcSDE 10.1

Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
PL/SQL Release 11.2.0.1.0 - Production
CORE    11.2.0.1.0      Production
TNS for Linux: Version 11.2.0.1.0 - Production
NLSRTL Version 11.2.0.1.0 - Production

(3) I want to know whether i can apply Oracle patchsets in the case of any requirement, if yes to what patchset ?

Please give me your suggestions.

ShawnThorne · Answer

I would recommend using Oracle version 11.2.0.4.0 - to avoid Oracle Bug 14026888 when using ST_GEOMETRY and Datapump.

http://support.esri.com/en/knowledgebase/techarticles/detail/41252

Hope this helps.

-Shawn

VinceAngelo · Answer

The System Requirements documentation also says Oracle database patch support

Oracle 10.2.0.3, 11.1.0.7, and 11.2.0.1, or higher Oracle Patch. This includes Oracle patch set levels and Oracle Interim (One-Off) Patch as per Oracle Corporation's Patch Set Overview and Interim Patch documentation.

See Oracle Support for all Oracle patch set (and Interim Patch) documentation and installation instructions. Esri recommends making a full backup of your Oracle database prior to applying any Oracle patch sets or interim patch. If functionality that was working prior to applying the Oracle patch set or interim patch stops working, return to the previous version of Oracle. Contact Oracle support as needed.

I would strongly suggest you NOT use ArcGIS 10.1 without first applying SP1 and then
the Quality Improvement Patch (QIP) before creating the Oracle geodatabase.

- V