We are currently facing a problem with ArcGIS Server that concerns a connection to an Oracle Database without "SDE or Enterprise GDB" functionalities. This means we have an Oracle 19c DB with tables that use SDO geometries. We are able to use these tables with ArcGIS Desktop (10.7.1).
But here is the problem: How to publish these maps to an ArcGIS Server (Linux)?
Do I still need to create a ".sde" connection file (or register a data item with the Rest API directly)? This seems to only make sense with enterprise geo databases.
Is is even possible to use ArcGIS Server without an Enterprise GDB but data from Oracle (SDO)?
Yes, you still publish from a non-geodatabase to ArcGIS Server. You also still need to create the .sde file. That is the file that ArcGIS Server will need to make the connection to the Oracle DB.
Make sure that you have installed the following so that the ArcGIS Server can access and read the Oracle data:
Hopefully that will get you going!