Oracle patchset for ArcGIS 10.1

05-22-2014 01:24 AM
New Contributor III

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

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

Oracle Database 11g Enterprise Edition Release - 64bit Production
PL/SQL Release - Production
CORE      Production
TNS for Linux: Version - Production
NLSRTL Version - 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.
0 Kudos
2 Replies
Esri Esteemed Contributor
The System Requirements documentation also says

Oracle database patch support

Oracle,, and, 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
0 Kudos
Esri Contributor
I would recommend using Oracle version - to avoid Oracle Bug 14026888 when using ST_GEOMETRY and Datapump.

Hope this helps.

0 Kudos