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.
Solved! Go to Solution.
The issue has been solved after applying the following steps:
Thank you All for your cooperation and support.
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.
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.
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.
Greetings @ElieRizk
Could this be due to an expired license? No ArcGIS server license found...
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.
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.
The issue has been solved after applying the following steps:
Thank you All for your cooperation and support.
@ElieRizk - FYI
For more best practices visit.
Mapping and Charting Solutions (MCS) Enterprise Databases Best Practices
How to Install Database Clients for ArcGIS