Your question is very vague. The fact that you are using Oracle is not important as long as you are aware that you need ArcGIS Server to publish the data from Oracle so that you can access the rest endpoint. ArcGIS Server can also handle the user based access by securing the service. But the GeoNet space is not the correct space to discuss the standard details of ArcGIS Server configuration.
Retrieving data ...