topic ArcCatalog 10.2: inconsistent connections to Oracle DB in Data Management Questions https://community.esri.com/t5/data-management-questions/arccatalog-10-2-inconsistent-connections-to-oracle/m-p/604256#M34051 <HTML><HEAD></HEAD><BODY><SPAN>Hi all. I recently installed ArcGIS 10.2 for Desktop on a desktop PC that previously ran ArcGIS 10.0 for Desktop. The install completed without error. Unfortunately, I have experienced issues connecting to our databases using ArcCatalog.</SPAN><BR /><BR /><SPAN>I tried using several different 32-bit Oracle clients. The full client (v. 11.2.0.1.0) was installed initially, but I also tried three other versions including two versions of the instant client. In each instance, ArcCatalog was unable to establish a database connection, but I could connect using SQL*Plus. At this point I ruled out a TNS problem, especially since ArcGIS 10.0 and 10.1 worked fine.</SPAN><BR /><SPAN>Next, I uninstalled ArcGIS 10.2 for Desktop and installed ArcGIS 10.1 for Desktop. Making no other changes I was able to successfully establish a connection in ArcCatalog.</SPAN><BR /><BR /><SPAN>Finally, I upgraded ArcGIS 10.1 for Desktop back to ArcGIS 10.2 for Desktop. I have been able to establish a few database connections using 10.2, but if I close and re-open ArcCatalog the connections hang. On some occasions I can reconnect if I reboot the PC, but this does not always seem to be the case. Moreover, I have experienced this problem on two desktops and a laptop so it does not appear to be isolated in my environment.</SPAN><BR /><BR /><SPAN>Has anyone else encountered this issue? Thanks!</SPAN><BR /><BR /><STRONG>Server Configuration</STRONG><BR /><SPAN>�?� Windows Server 2008 R2 Enterprise Service Pack 1</SPAN><BR /><SPAN>�?� Oracle Enterprise Database 11gR2 v. 11.2.0.1.0 (64-bit)</SPAN><BR /><SPAN>�?� ArcGIS ArcSDE for Oracle11g for Windows 64 version 10.0.2400 (direct connection)</SPAN><BR /><SPAN>�?� Geodatabase version = ArcGIS 10.0 Service Pack 5</SPAN><BR /><BR /><STRONG>Client Configuration</STRONG><BR /><SPAN>�?� Windows 7 Enterprise Service Pack 1</SPAN><BR /><SPAN>�?� ArcGIS 10.2 for Desktop</SPAN><BR /><BR /><STRONG>Oracle 32-bit Clients Tested</STRONG><BR /><SPAN>�?� Oracle Client 11.2.0.1.0</SPAN><BR /><SPAN>�?� Oracle Client 11.2.0.3.0</SPAN><BR /><SPAN>�?� Oracle Instant Client 11.2.0.1.0</SPAN><BR /><SPAN>�?� Oracle Instant Client 11.2.0.3.0</SPAN></BODY></HTML> Mon, 30 Sep 2013 22:11:02 GMT CraigBooth 2013-09-30T22:11:02Z ArcCatalog 10.2: inconsistent connections to Oracle DB https://community.esri.com/t5/data-management-questions/arccatalog-10-2-inconsistent-connections-to-oracle/m-p/604256#M34051 <HTML><HEAD></HEAD><BODY><SPAN>Hi all. I recently installed ArcGIS 10.2 for Desktop on a desktop PC that previously ran ArcGIS 10.0 for Desktop. The install completed without error. Unfortunately, I have experienced issues connecting to our databases using ArcCatalog.</SPAN><BR /><BR /><SPAN>I tried using several different 32-bit Oracle clients. The full client (v. 11.2.0.1.0) was installed initially, but I also tried three other versions including two versions of the instant client. In each instance, ArcCatalog was unable to establish a database connection, but I could connect using SQL*Plus. At this point I ruled out a TNS problem, especially since ArcGIS 10.0 and 10.1 worked fine.</SPAN><BR /><SPAN>Next, I uninstalled ArcGIS 10.2 for Desktop and installed ArcGIS 10.1 for Desktop. Making no other changes I was able to successfully establish a connection in ArcCatalog.</SPAN><BR /><BR /><SPAN>Finally, I upgraded ArcGIS 10.1 for Desktop back to ArcGIS 10.2 for Desktop. I have been able to establish a few database connections using 10.2, but if I close and re-open ArcCatalog the connections hang. On some occasions I can reconnect if I reboot the PC, but this does not always seem to be the case. Moreover, I have experienced this problem on two desktops and a laptop so it does not appear to be isolated in my environment.</SPAN><BR /><BR /><SPAN>Has anyone else encountered this issue? Thanks!</SPAN><BR /><BR /><STRONG>Server Configuration</STRONG><BR /><SPAN>�?� Windows Server 2008 R2 Enterprise Service Pack 1</SPAN><BR /><SPAN>�?� Oracle Enterprise Database 11gR2 v. 11.2.0.1.0 (64-bit)</SPAN><BR /><SPAN>�?� ArcGIS ArcSDE for Oracle11g for Windows 64 version 10.0.2400 (direct connection)</SPAN><BR /><SPAN>�?� Geodatabase version = ArcGIS 10.0 Service Pack 5</SPAN><BR /><BR /><STRONG>Client Configuration</STRONG><BR /><SPAN>�?� Windows 7 Enterprise Service Pack 1</SPAN><BR /><SPAN>�?� ArcGIS 10.2 for Desktop</SPAN><BR /><BR /><STRONG>Oracle 32-bit Clients Tested</STRONG><BR /><SPAN>�?� Oracle Client 11.2.0.1.0</SPAN><BR /><SPAN>�?� Oracle Client 11.2.0.3.0</SPAN><BR /><SPAN>�?� Oracle Instant Client 11.2.0.1.0</SPAN><BR /><SPAN>�?� Oracle Instant Client 11.2.0.3.0</SPAN></BODY></HTML> Mon, 30 Sep 2013 22:11:02 GMT https://community.esri.com/t5/data-management-questions/arccatalog-10-2-inconsistent-connections-to-oracle/m-p/604256#M34051 CraigBooth 2013-09-30T22:11:02Z