Oracle Critical Patch Update - Oct 2014

[ABHISHEKSINDAL1]

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.

[RobertHart]

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.

[VinceAngelo]

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).

[MelissaJarman]

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

[chrisbusskohl]

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

[AsrujitSengupta]

Can you please confirm the exact patch that was installed.

[chrisbusskohl]

Oracle® Database Server Version 11.2.0.3 Patch 34

Oracle bundle patch for windows x64:

p19618575_112030_MSWIN-x86-64

[AsrujitSengupta]

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

[chrisbusskohl]

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.

[AsrujitSengupta]

Recently released technical Article:

43293 - ArcGIS cannot connect to an Oracle database after installing the Oracle Critical Patch Updat...