Author: team@solution250.com

  • Lift to Cloud – Nodejs oracledb application to OCI

    Lift to Cloud – Nodejs oracledb application to OCI

    Our journey to cloud – We had NodeJS apps running on windows servers connecting to the enterprise database. We moved them to an OCI hosted windows server and ATP database. Here is a rundown of how to do that move. Requirements Initial Steps At this point we could run the application – but it would…

  • Use Private Functions with ATP

    We wanted to limit the use of certain functions to a database on a private subnet. Ref: https://docs.oracle.com/en/cloud/paas/autonomous-database/serverless/adbsb/call-web-services.html#GUID-844FCA1B-3619-4B94-8164-00A89484DEB3 Ref: https://dba.stackexchange.com/questions/115807/oracle-viewing-settings-for-dbms-network-acl-admin-acl https://docs.oracle.com/en/database/oracle/oracle-database/19/arpls/DBMS_NETWORK_ACL_ADMIN.html#GUID-D70BE754-F21E-4C74-8D26-25258C6F4FE1 You can use this query to see your ACL privileges. Set the CONTAINS_HOST to the host name of your end point. Note:If you set ROUTE_OUTBOUND_CONNECTIONS to PRIVATE_ENDPOINT, setting the private_target parameter to TRUE is not required in this API. See Enhanced Security…

  • Create OCI Function with ADB client embeded

    Create OCI Function with ADB client embeded

    We want to create a serverless nodeJs function which interacts with our ATP database via a wallet. We found a blog by Tom Sharp from Oracle. Lets change it up, update and thank him for his insight! 1. Create Application To start with you will need this information: Or use the interactive console to automaticall…

  • Oracle Cloud Infrastructure

    How we moved our applications and services to OCI