topic Re: Connection to Oracle Database using ArcGIS pro (Enterprise) in ArcGIS Enterprise Questions

Connection to Oracle Database using ArcGIS pro (Enterprise)

ElieRizk — Tue, 30 Jan 2024 05:45:59 GMT

we are trying to connect to an Oracle database using the database connection dialog in ArcGIS Pro (enterprise) but we are getting the following error as shown in the attached snapshot even from ArcCatalog.

noting that this Oracle database was reachable from a previous standalone ArcGIS server and desktop installation before moving to ArcGIS Enterprise 11.2

kindly advise.

Re: Connection to Oracle Database using ArcGIS pro (Enterprise)

MiguelParedes — Tue, 30 Jan 2024 08:08:00 GMT

Greetings @ElieRizk

Have you installed the appropriate Oracle Client software?

Please, have a look at Connect to Oracle from ArcGIS for instructions on what you need and how to do it.

I hope the above helps.

Re: Connection to Oracle Database using ArcGIS pro (Enterprise)

George_Thompson — Tue, 30 Jan 2024 11:51:43 GMT

What version of Oracle are you connecting to?

Is the Oracle DB an Enterprise Geodatabase?

Can you verify that you are using Pro 3.2.x to make the connection to the Oracle DB?
The error indicates that it is looking for a geodatabase, but could be incorrect.

Re: Connection to Oracle Database using ArcGIS pro (Enterprise)

ElieRizk — Tue, 30 Jan 2024 12:05:48 GMT

we are using Arcgispro 3.2.0 and oracle 19c. the connection was working fine with a standalone installation of ArcGIS desktop and server. but now it shows this warning which is new for us.

yes, it is an enterprise db but not created with SDE privileges.

Elie.

Re: Connection to Oracle Database using ArcGIS pro (Enterprise)

MiguelParedes — Wed, 31 Jan 2024 07:18:59 GMT

Greetings @ElieRizk

Could this be due to an expired license? No ArcGIS server license found...

Re: Connection to Oracle Database using ArcGIS pro (Enterprise)

ElieRizk — Wed, 31 Jan 2024 08:21:26 GMT

with SQL we do not have any problem in changing the Authorization.

but with Oracle databases, we are facing this issue. even we are using the tool "update enterprise geodatabase license".

kindly do you have any alternative to change the authorization? or where Oracle databases store the authorization keycodes.

thank you for your prompt support.

Re: Connection to Oracle Database using ArcGIS pro (Enterprise)

George_Thompson — Wed, 31 Jan 2024 11:36:20 GMT

do you have any tables in an SDE schema within that database?

I usually only see that message when there is an EGDB that has an expired license. I noticed that you mentioned it was "not created with SDE privileges", but could be an SDE schema.

If there is an SDE schema, look at the SDE.Server_Config table and the AUTHKEY (I think) field.

Re: Connection to Oracle Database using ArcGIS pro (Enterprise)

ElieRizk — Mon, 05 Feb 2024 10:45:55 GMT

The issue has been solved after applying the following steps:

Deleting all the old ArcGIS license files (in case of the existence of any old licenses)
Installation for Oracle Instant client and ODBC driver compatible with the latest installed ArcGIS version
Creation of oracle Database from the oracle server (using the oracle net manager tool)
Using the above connection in the TNS admin path in the environment variable
Creating a connection to the Oracle instance from ArcGIS Pro using the sde user and password (HERE the connection asks for the authorization file (.ECP) a copy of the keycode file after renaming it to ECP
Restart the Oracle Windows service on the Oracle server
Finally, create a connection to the desired Oracle database.
Connection Succeeded

Thank you All for your cooperation and support.

Re: Connection to Oracle Database using ArcGIS pro (Enterprise)

MarceloMarques — Mon, 05 Feb 2024 20:22:37 GMT

@ElieRizk - FYI

Database Connections Best Practices

For more best practices visit.

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

How to Install Database Clients for ArcGIS