Community
Select to view content in your preferred language

ArcGIS Desktop 10.2.2 Database Connection to Oracle 12c Database

10731
12
10-22-2014 03:28 AM
KareemMorsy
by
Emerging Contributor
‎10-22-2014 03:28 AM

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

Tags (1)
0 Kudos
12 Replies
Vara_PrasadM_S
by
Frequent Contributor
‎11-24-2014 02:34 AM

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.

0 Kudos
TobiasFimpel1
by
Frequent Contributor
‎11-24-2014 07:28 AM

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.