topic Re: Oracle Critical Patch Update - Oct 2014 in Geodatabase Questions

Oracle Critical Patch Update - Oct 2014

ABHISHEKSINDAL1 — Mon, 20 Oct 2014 04:31:09 GMT

After applying patch, we cannot establish connection with oracle database from Arc-Catalogue.

Whenever we tries to establish connection with oracle database, ArcCatalogue is getting crashed. Also map services which uses SDE connection has stopped functioning.

Is there any update from esri for the same? please suggest.

Re: Oracle Critical Patch Update - Oct 2014

RobertHart — Mon, 20 Oct 2014 17:50:24 GMT

I can confirm we have just experienced the same thing after applying the Oracle October 2014 Patch Set Update. We have temporarily rolled back to the previous previous patch set update and it is working again. We have raised a ticket with ESRI.

ArcGIS 10.1

Oracle 11.2.0.4 (linux x86_64)

Glad i found your post (though not glad you're also experiencing problems) as that way we know it isn't something unique to our setup/environment.

Re: Oracle Critical Patch Update - Oct 2014

VinceAngelo — Tue, 21 Oct 2014 01:33:32 GMT

Please post "In a Place" like Managing Data or Enterprise Geodatabase instead of in your own discussion corner. You can move posts to a place by clicking on the title, then using the "Move" menu choice to the right. It would also help to add keyword tags ("Oracle" and "Geodatabase" would seem to be useful ones).

Re: Oracle Critical Patch Update - Oct 2014

MelissaJarman — Tue, 21 Oct 2014 18:59:34 GMT

Support is investigating some of these cases, so I would recommend you contact Esri Support Services as well as Oracle Support in parallel.

Are you able to connect in sqlplus to Oracle and it is just Esri products where you can't connect to Oracle with?

Also, is the issue specific to a certain user(s)? eg: Admin and non-admin

Re: Oracle Critical Patch Update - Oct 2014

chrisbusskohl — Wed, 22 Oct 2014 17:10:10 GMT

Melissa.

Our application is experiencing the same crashes after applying the October Database Patch.

Here are our findings.

Connections via sqlplus as all users (admin and non-admin alike) succeeds

Connection via ArcCatalog (10.0/10.1/10.2) crash when attempted with any user from GDB Owner down the line to accounts with only view access.

Connection via ArcCatalog (10.0/10.1/10.2) will only succeed if attempted with elevated (DBA or near-DBA RDBMS privs) account

environment:

Oracle 11.2.0.3

Win2k8 R2 64bit

ArcSDE 10.2.2

ArcGIS Client (10.0 / 10.1 / 10.2)

thanks

Re: Oracle Critical Patch Update - Oct 2014

AsrujitSengupta — Wed, 22 Oct 2014 17:43:16 GMT

Can you please confirm the exact patch that was installed.

Re: Oracle Critical Patch Update - Oct 2014

chrisbusskohl — Wed, 22 Oct 2014 17:50:49 GMT

Oracle® Database Server Version 11.2.0.3 Patch 34

Oracle bundle patch for windows x64:

p19618575_112030_MSWIN-x86-64

Re: Oracle Critical Patch Update - Oct 2014

AsrujitSengupta — Wed, 22 Oct 2014 17:54:22 GMT

chris busskohl‌ Can you contact Esri Support Services and report this behaviour. We would like to investigate these crashes further if possible.

Re: Oracle Critical Patch Update - Oct 2014

chrisbusskohl — Wed, 22 Oct 2014 17:58:22 GMT

roger that.

The support request will likely have to be initiated through our SDE Administrator but once opened I can assist on any back-end Oracle ops or information you need.

v/r

Chris.

Re: Oracle Critical Patch Update - Oct 2014

AsrujitSengupta — Thu, 23 Oct 2014 15:40:27 GMT

Recently released technical Article:

43293 - ArcGIS cannot connect to an Oracle database after installing the Oracle Critical Patch Update for October 2014