Select to view content in your preferred language

Connection to Oracle Database using ArcGIS pro (Enterprise)

1071
8
Jump to solution
01-29-2024 09:45 PM
ElieRizk
Occasional Contributor

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.

ElieRizk_0-1706593310711.png

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.

0 Kudos
1 Solution

Accepted Solutions
ElieRizk
Occasional Contributor

The issue has been solved after applying the following steps:

  1. Deleting all the old ArcGIS license files (in case of the existence of any old licenses)
  2. Installation for Oracle Instant client and ODBC driver compatible with the latest installed ArcGIS version
  3. Creation of oracle Database from the oracle server (using the oracle net manager tool)
  4. Using the above connection in the TNS admin path in the environment variable
  5. 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
  6. Restart the Oracle Windows service on the Oracle server
  7. Finally, create a connection to the desired Oracle database.
  8. Connection Succeeded

Thank you All for your cooperation and support.

View solution in original post

8 Replies
MiguelParedes
Esri Contributor

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.

Miguel
0 Kudos
George_Thompson
Esri Frequent Contributor

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.

--- George T.
0 Kudos
ElieRizk
Occasional Contributor

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.

0 Kudos
MiguelParedes
Esri Contributor

Greetings @ElieRizk 

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

 

Miguel
0 Kudos
ElieRizk
Occasional Contributor

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".

ElieRizk_0-1706689178817.png

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

thank you for your prompt support.

0 Kudos
George_Thompson
Esri Frequent Contributor

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.

--- George T.
0 Kudos
ElieRizk
Occasional Contributor

The issue has been solved after applying the following steps:

  1. Deleting all the old ArcGIS license files (in case of the existence of any old licenses)
  2. Installation for Oracle Instant client and ODBC driver compatible with the latest installed ArcGIS version
  3. Creation of oracle Database from the oracle server (using the oracle net manager tool)
  4. Using the above connection in the TNS admin path in the environment variable
  5. 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
  6. Restart the Oracle Windows service on the Oracle server
  7. Finally, create a connection to the desired Oracle database.
  8. Connection Succeeded

Thank you All for your cooperation and support.

MarceloMarques
Esri Regular Contributor

@ElieRizk - FYI

For more best practices visit.

Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices

How to Install Database Clients for ArcGIS

| Marcelo Marques | Principal Product Engineer | Esri |
| Cloud & Database Administrator | OCP - Oracle Certified Professional |
I work with Enterprise Geodatabases since 1997.
“ I do not fear computers. I fear the lack of them." Isaac Isimov