nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Desktop 10.2.2 Database Connection to Oracle 12c Database

KareemMorsy

Hello There

I am trying to connect from ArcGIS Desktop 10.2.2 to Oracle 12c database but the ArcCatlog just crashes every time. here are my environment settings

ArcGIS Machine :

ArcGIS Deskop 10.2.2

Oracle client 12c R1 32 bit

Instance :myserver:1522/orcl ( I have tried using all the usernames and passwords but still fails not only sde)

Oracle machine

Oracle Database 64bit 12c

Oracle client 12c R1 32bit

ArcSDE 10.2.2 ( only installation but the schema is not upgraded to 10.2.2, the whole exercise is to upgrade it from ArcCatlog)

Please not that i am able to connect through command prompt to the oracle database without any problems in the ArcGIS Machine.

I have even tried using Oracle client 11g.

Can you please take a look into that and I could not know if ArcGIS 10.2.2 is supporting 12c or not.

Thanks a lot

Find more posts tagged with

Accepted answers

All comments

AsrujitSengupta

Please check whether granting the SELECT_CATALOG_ROLE to the users helps in resolving the issue.

KareemMorsy

It is already there Asrujit. but is Oracle 12c client is the right client or shall i use the instant client ?

Is 10.2.2 supporting Oracle 12c and Oracle 12c client ?

Thanks

Kareem

AsrujitSengupta

Both the Instant Client and Admin Client should work. Also Oracle 12C Client should work.

Yes, Oracle 12C is a supported database version for ArcSDE 10.2.x

System Requirements

Did you recently install any Oracle patches?

Are you the only user facing the crash? can other users connect to this database from there machine?

KareemMorsy

I have tested it from other machines but the same problem on all the machines.

but which Oracle client do i need on ArcGIS machine and Oracle machine for it to work ?

Which one have you tested and know for sure it is working?

AsrujitSengupta

If the Oracle Client was an issue, the Desktop interface should not crash...it should rather give you an error.

So I don't think that is the issue here. Still if you want to test this further, try a machine where you have Oracle 11gR2 client installed and check if the connection works.

Did you recently install any Oracle patches?

KareemMorsy

I also tried it with Oracle 11gR2 and the same issue . now it is only hanging for along time more than 15 minutes if you are using client 12c and crashing if you have client 11g. no i did not install any patches. it is an upgrade of Oracle 11gR2 was migrated to 12c.

KellyLittle

I am having the exact same issue, except that I am trying to connect to an ArcGIS 10.2.1 Desktop client. Has there been any progress made on troubleshooting this issue?

JoshuaBixby

I think what is being asked is whether your DBAs have fully patched the 12c database, including the latest October 2014 patches from Oracle. If so, that could be what is preventing you from connecting.

Critical Information Regarding Oracle Update and ArcGIS - See more at: http://blogs.esri.com/esri/supportcenter/2014/10/23/critical-information-regarding-oracle-update-and-arcgis/

Vara_PrasadM_S

Hi All,

We are facing the same issue with the same configuration given by Kareem. Could you please let me know how to fix this issue.

Thanks & Regards,

Vara Prasad.

I can connect to oracle 12c from arccatalog/arcmap 10.1 SP1 and 10.2.2 . The description of arcmap crashing is exactly what we faced after the patches were installed. If your DBA has installed these patches (and he probably has) he needs to grant SELECT_CATALOG_ROLE to the users. See the esri post linked to above. Please disregard if you already excluded this as a possible source of the issue.

AsrujitSengupta

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

ArcGIS 'Oracle Critical Patch Update - October 2014' Connection Issue Patch | Samples and Utilities

AsrujitSengupta

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

ArcGIS 'Oracle Critical Patch Update - October 2014' Connection Issue Patch | Samples and Utilities

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.