@Dhruv Dalsania Thanks for reaching out. Unfortunately, standard logic app will also not help in your case as the communication over private endpoint only works with the built-in connectors in standard logic app and not with azure connectors. As there is no built-in connector for Oracle so you cannot communicate it over private endpoint.
As you are using a consumption logic app you need to use the azure connector with OPDG having internet access.
For OPDG to work you should have the internet on the machine where you are installing the OPDG as mentioned in the Related considerations here. The OPDG machine can be the same or a different machine on the same network as documented here in FAQ.
For more details you can refer to this article on Connecting to Oracle Database from PowerApps, Flow and Logic Apps
Install the gateway on a local computer that's on a wired network, connected to the internet.