Executing OCI object storage operations (rename, copy, move, …) from an Autonomous Database with PL/SQL code


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

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

Setting OCI privileges to users federated in external Identity Provider


In this post we are explaining how to grant OCI privileges to users federated with IDCS or other identity provider. OCI policies can be granted to OCI groups, not federated groups, therefore we need a mechanism to do that. Let's suppose we have a group of developers called xxxx-developers that need full access to all … Continue reading Setting OCI privileges to users federated in external Identity Provider

Automating Audit Trails Archive to Object Storage with Oracle Developer Cloud Service


Oracle Cloud provides out the box audit records that can be obtained by tools such the dashboard portal, the APIs like rest/go/java/phy and the CLI. In this post we are explaining how to automate the archiving of the trails to an object storage bucket using the CLI inside DevCS, the CI/CD and DevOps tool provided … Continue reading Automating Audit Trails Archive to Object Storage with Oracle Developer Cloud Service

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

Establishing a Software VPN Tunnel between OCI and AWS


In this post we are setting up a tunnel between OCI and AWS following the steps explained here and similar to what we did here. Step 1 Follow this post to set up a VPN headend in OCI. Step 2 Create a VPC in AWS with one public and one private subnet. Step 3 Create … Continue reading Establishing a Software VPN Tunnel between OCI and AWS

Establishing a Software VPN Tunnel between OCI and Google Cloud


In this episode we are crating a tunnel between OCI and Google Cloud using the solution posted here Step 1 Follow this post for the OCI side and grab the value of the public IP endpoint and network encryption domain configured. Step 2 Create a vpn tunnel in google cloud, put the values of public … Continue reading Establishing a Software VPN Tunnel between OCI and Google Cloud

Creating a Software VPN Headend in OCI with Terraform


Shall you need to tune the bits of a VPN connection because the complexities of the left, right or both sides of the tunnel, one cheap option is to build a software solution. In this particular case we are utilising Libreswan. Terraform The current construct has been done with terraform, which provides automation and reduces … Continue reading Creating a Software VPN Headend in OCI with Terraform

Oracle Autonomous Database: Configuring SQL Developer Web Access for Database Users


Connect to SQL Developer Web as admin user Create a new user, give privileges quotas and the like... create user MYUSER identified by "xxxxxxxxx"; grant connect to MYUSER; GRANT DWROLE TO MYUSER; execute DBMS_CLOUD_ADMIN.GRANT_TABLESPACE_QUOTA('MYUSER','1G'); BEGIN ORDS_ADMIN.ENABLE_SCHEMA(p_enabled => TRUE,p_schema => 'MYUSER', p_url_mapping_type => 'BASE_PATH', p_url_mapping_pattern =>'MYUSER', p_auto_rest_auth => TRUE); COMMIT; END; / Copy the link of … Continue reading Oracle Autonomous Database: Configuring SQL Developer Web Access for Database Users