Do you have a DirectConnect or IPSec VPN connectivity from your on-prem data center to an AWS VPC?
Also is there an application that is running in your on-prem that interacts with the Oracle database in your on-prem data center and exposes APIs.
If the answer to both is yes, then you can expose the APIs over AWS API Gateway.
You will need to use API Gateway Private Integration, for which you will need to create a Network Load Balancer and a VPCLink in your AWS VPC. There is a good tutorial that demonstrates how private integration can be configured, although the example does not specifically talk about connecting to on-prem resources - https://docs.aws.amazon.com/apigateway/latest/developerguide/getting-started-with-private-integration.html
You can have your on-prem resources as targets for an AWS Network Load Balancer. There are some restrictions in terms of permitted IP ranges as target for the AWS Network Load Balancer and the details are available here - https://docs.aws.amazon.com/elasticloadbalancing/latest/network/load-balancer-target-groups.html. Read up the Target Type section.
The reason I asked the second question about an application is because AWS API Gateway cannot directly connect to an Oracle database, without an application in between. If you don't have an application, you can use AWS Lambda functions or create your own microservices in AWS ECS or EKS or even on EC2, that can connect to your on-prem database, although you have to run tests to make sure the latency is acceptable to your API consumers.
API Gateway to Oracle database in private cloudasked 22 days ago
RDS Oracle 19c database - Grant DBMS_XAasked 3 months ago
Oracle db link from aws cloud to on-premisesasked 4 months ago
What's the fastest way to move a 2TB Oracle Database to EC2?Accepted Answerasked 2 years ago
How to migrate DB on premise Oracle to Microsoft SQL Server DB in AWS. We see SCT will not allow MS SQL Server as Target when source is Oracle. Looking for tools like SCT to move Schema from Oracle.asked 5 months ago
RDS for Oracle: Bring Your Own License with No LicenseAccepted Answerasked 3 months ago
On AWS RDS for Oracle how to install Oracle Database Gateway for SQL Serverasked 2 months ago
What operating system can I use to run SAP on Oracle database on AWS ?*Accepted Answerasked 4 months ago
AWS Backup of RDS managed Oracle or MS-SQL databaseasked 4 months ago
Looking for guidance/documentation to migration Oracle Fusion Middleware applications from Oracle Cloud to AWSasked 8 months ago