How to Find the Public IP Used by Oracle Database for REST Calls
When making outbound REST calls from Oracle Database using UTL_HTTP or APEX's MAKE_REST_REQUEST, developers may not know which public IP address is used, which becomes a problem when a vendor requires IP whitelisting. A simple solution involves calling the ipify API directly from the database, which returns the public IP in use. On Autonomous Database, the request must use HTTPS instead of HTTP. If permission errors occur, a DBA must grant network access to the ipify domain using Oracle's DBMS_NETWORK_ACL_ADMIN package. Once the public IP is identified, it can be shared with the vendor for firewall whitelisting.
This is an AI-generated summary. ShortSingh links to the original source for the complete article.
Discussion (0)
Log in to join the discussion and vote.
Log in