The core set of Spatial features have been enabled on both Oracle Autonomous Data Warehouse (ADW) and Autonomous Transaction processing (ATP). These autonomous databases are self-driving, self-securing, self-repairing cloud services that eliminate the overhead and human errors associated with traditional database administration.
For details, please see the following:
I have a question ... howto connect to oracle spatial on oacle autonomous transaccion processing database using qgis ?, that is because all connection to ATP database have to use wallet info
Please see info on connecting client tools here: https://docs.oracle.com/en/cloud/paas/autonomous-data-warehouse-cloud/user/connect-preparing.html
As it describes, you unzip the wallet and make some file edits. Please post again if you have any trouble.