topic connect oracle 12c from arcgis for desktop and server 10.3.1 in Geodatabase Questions

connect oracle 12c from arcgis for desktop and server 10.3.1

ÖmerÜNSAL — Fri, 23 Jun 2017 06:43:01 GMT

Hi,

Problem: We can not connect to oracle 12c db from ArcGIS desktop and server 10.3.

db server info: Oracle 12c installed on Red Hat Enterprise Linux Server 7.3 OS

GIS Server: arcgis for desktop and server 10.3.1 Installed on the same machine (windows server 2012 r2)

Oracle client info: oracle 12c 64x and 32x client installed on gis server. Oracle 12c 64x client before 32x oracle client on windows PATH Variable.

Other info

- Oracle DB and listener running, we connected oracle db from sql developer.

- We have moved oracle 11g db (with full backup) to new oracle 12c.

arcgis for desktop and server Connection errors attached.

"Database Connection

Failed to connect to the specified server. underlying DBMS error [unknown errorNo extended error.]

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

shan_sarkar — Fri, 23 Jun 2017 08:12:35 GMT

Omer,

Have you tried to telnet?

I assume port 1521 is open for both the machines?

Have you tried to do an TNS entry for the Oracle client?

~Shan

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

ÖmerÜNSAL — Fri, 23 Jun 2017 12:17:59 GMT

Shantonu,

Yes, I did telnet connection to oracle db server.

its ok. tnsping and TNS entry for oracle client

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

JayantaPoddar — Fri, 23 Jun 2017 12:49:32 GMT

What happens if you just type GIS as your Oracle instance in Database Connection dialog box?

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

Asrujit_SenGupta — Fri, 23 Jun 2017 16:51:59 GMT

The successful connection using SQL Developer that you mentioned. Is the SQL Developer on the GIS Server?
Were you able to connect using SQLPlus in Command Prompt on the GIS Server?

Considering you are using the default 1521 port, you don't need to mention that in the connection string. Just try IP/GIS.

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

ÖmerÜNSAL — Mon, 14 Aug 2017 11:56:33 GMT

Our Oracle version 12.2

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

VinceAngelo — Mon, 14 Aug 2017 12:55:55 GMT

The system requirements for 10.3 do not mention Oracle 12.2, just 12.1. In fact, ArcGIS 10.5.1 doesn't mention Oracle 12.2 either. I wouldn't expect the latest builds of Oracle to operate with an old version of ArcGIS.

- V

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

PrasadAmujuri — Wed, 31 Jan 2018 12:28:08 GMT

Omer,

I too got the similar issue. This is the problem with user credentials. You might have installed and configured the database with one user and now trying to access the database with another user or same or other domain. In this case you have to give permissions or share the oracle client folder with the new user.

-Prasad Amujuri

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

GangWang — Wed, 23 Jan 2019 16:21:44 GMT

I had a similar issue - couldn't connect oracle 12.2 from 10.4.1 ArcGIS desktop. I have verified correct version of oracle client got installed and other requirements were met. I can TNSPING and connect successfully in SQL developer. Can anybody please confirm the issue is with unsupported version/release?

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

AlexandraDubovis2 — Wed, 13 Mar 2019 15:39:57 GMT

We have similar Issues:

I can connect to the Oracle database( not a geodatabase) from SQL Developer or ARCCatalog 10.2.2,

but can't connect using ArcCatalog 10.6.1.

Have no issues to connect from ArcCatalog 10.6.1. to the Oracle Geodatabases.

All our databases are 11g.

Thanks,

Alex

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

VinceAngelo — Fri, 15 Mar 2019 13:35:07 GMT

Since this is a new question in a different environment, it really ought to be asked as a new question.

Re: connect oracle 12c from arcgis for desktop and server 10.3.1

DivakarChennareddy — Wed, 10 Apr 2019 17:32:40 GMT

We have the same issue, did you find solution for your problem?