Category: Journey
-
OTBI – ERROR ORA-64204: encountered partial multibyte character
We encountered a mysterious error during processing. Here is how we investigated it using sqlXtract, and resolve the issue. Here is the error report Using sqlXtract we investigate the table where the data is being fetched: In the first SQL statement we hunt down the multi byte characters, with the help of ASK TOM https://asktom.oracle.com/ords/asktom.search?tag=identify-multi-byte-characters…
-
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
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…