Following the work started here, we continue depicting how easy is to execute operations in OCI Object Storage buckets. Credential Credential is needed for the api signing: -- for oci rest api's we need a credential for signing api BEGIN DBMS_CLOUD.CREATE_CREDENTIAL ( credential_name => 'DEVCSCRED', user_ocid => 'ocid1.user.oc1..aaaaa...yw77q', tenancy_ocid => 'ocid1.tenancy.oc1..aaaaaaa...6jj5ruqqq', private_key => 'MIIEogIBAA...hGuCkA=', fingerprint … Continue reading Executing OCI object storage operations (rename, copy, move, …) from an Autonomous Database with PL/SQL code
Tag: AUTONOMOUS DATABASE
Listing the content of an object storage bucket in OCI from an autonomous database with PL/SQL code
This post explains a specific use case, but it can be used for calling whatever existing OCI REST API fron the database. DBMS_CLOUD DBMS_CLOUD provides all you need to handle requests to OCI REST API's. What you need Create and grab a private and public keys and also grab your tenancy ocid, get help from … Continue reading Listing the content of an object storage bucket in OCI from an autonomous database with PL/SQL code
Calling an Endpoint with Untrusted Certificate from Autonomous Database PL/SQL Program via API Gateway
Oracle Autonomous Database is a cloud Oracle service offered in two infrastructure modes (shared and dedicated) and two types of workloads (OLTP or DSS). Since the user does not have access to the underlying infrastructure, several features are restricted, for instance, you can't manage wallets to add remote endpoint untrusted certificates: the database comes with … Continue reading Calling an Endpoint with Untrusted Certificate from Autonomous Database PL/SQL Program via API Gateway
Moving a 15-year-old Java 1.4 Application from Oracle AS 10g to WebLogic 12g on Kubernetes in Record Timeframe not Dying in the Intent nor Losing any Line of Code
Not all monoliths should be killed because they are! This is the true story about migration and modernisation of a travel sector solution based on ADF, Java 1.4, Struts, Jac¡vaScript and PHP running on Oracle Application Server 10 and Oracle 10g database. Perhaps old people in town can remember things such as OAS, OC4J, jHeadStart, … Continue reading Moving a 15-year-old Java 1.4 Application from Oracle AS 10g to WebLogic 12g on Kubernetes in Record Timeframe not Dying in the Intent nor Losing any Line of Code
Offloading Oracle Data to Object Storage and Loading as External Table in an Autonomous Database | Part 3: Oracle OCI Object Storage
Following up the posts here and here, we are explaining today how to make same thing using Oracle OCI Object Storage. The procedure and steps are quite similar so, let’s go and try! Steps Create a bucket Upload file to bucket Create an Auth Token for your user as follows: In a sql editor, execute … Continue reading Offloading Oracle Data to Object Storage and Loading as External Table in an Autonomous Database | Part 3: Oracle OCI Object Storage
Connecting Visual Builder to an Autonomous Database
Oracle Visual Builder is a visual development tool that comes with its own database. It allows you to create objects for storing data. Those objects are also exposed as REST, making the data model of your application accesible from/to other peers. Visual builder allows the configuration change consisting in connecting to an "external" database, either … Continue reading Connecting Visual Builder to an Autonomous Database
Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3
Following up the previous post, we are explaining today how to make same thing using Amazon S3. The procedure and steps are quite similar, let's go and try! Amazon side setup Create a S3 bucket with no public access: Upload datafile: Grab the object URL for later: Bucket located in Frankfurt Create a user in … Continue reading Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3
Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part One: Azure Object Storage
Oracle autonomous database (ADW/ATP) offers several approaches for storing the data: data online stored in the database internal storagedata nearline as external tables in object storagedata offline in object storage The autonomous database supports object storage provided by Oracle OCI, Amazon S3 and Azure, with them you can create external tables, external partitioned tables and … Continue reading Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part One: Azure Object Storage
Creating a Connection between Oracle Integration (OIC) and Autonomous Database
Connect to ATP and create a new user Grab the ATP connection details and download the wallet(give it a password): TNS Name in connection details is the value to provide in the OIC connection wizzard Create the connection in OIC providing the values previously gathered Service Name is the value of TNS Name in the … Continue reading Creating a Connection between Oracle Integration (OIC) and Autonomous Database
