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

Extracting Data from Oracle SaaS to Onprem or Other Clouds through Private High Speed Connection via Service Gateway | Part One


BI Cloud Extract is a standard tool for extracting data from SaaS (ERP, ...) either incremental or fully approaches. Data is exported to Object Storage as zipped files. Files stored in object storage are encrypted by a key provided by OCI Object Storage administrator role o keys managed by Oracle. Additionally Oracle encrypts data at … Continue reading Extracting Data from Oracle SaaS to Onprem or Other Clouds through Private High Speed Connection via Service Gateway | Part One

Oracle Autonomous Database: Configuring SQL Developer Web Access to 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 “xxxxxxxxxx“; 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 … Continue reading Oracle Autonomous Database: Configuring SQL Developer Web Access to Database Users

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

Experiencing JSON in Oracle Autonomous Database for Cloud Native Geeks in less than 15 Minutes


Oracle DB has been supporting JSON for quite some time, but you probably didn't know it! Let's se how easy is to start puting and geting json data in it. The most quick way to get a JSON db up and running is creating an Autonomous Transaction Processing instance. Create the instance and forget there … Continue reading Experiencing JSON in Oracle Autonomous Database for Cloud Native Geeks in less than 15 Minutes

oke-cluster-start-stop, a kubectl Plugin for starting/stopping all the Compute Nodes of an OKE Cluster


If you want to start or stop all of your OKE data plane cluster nodes you must go to all the nodes and execute the action one by one. The current post depicts a kubectl plugin extension created for helping you to start/stop your oke clusters. NOTES: The tool has been developed and tested in … Continue reading oke-cluster-start-stop, a kubectl Plugin for starting/stopping all the Compute Nodes of an OKE Cluster

Oracle SaaS | Analysing the Structure and Morphology of the REST API Methods


Oracle SaaS API's have a structure that is equal for all the "business entities" across the different modules (Finance, Loyalty, Supply Chain, …) such as invoices, expenses, loyalty transactions and so on. Let's analyze the pattern. In this episode, we are focusing on the "Get all xxx" methods because it conforms a pattern that we'll … Continue reading Oracle SaaS | Analysing the Structure and Morphology of the REST API Methods

Set Up an Ingress Controller in OKE Cluster


Here a recipe to create a ingresscontroller. Step 1: setting up the nginx ingress controller kubectl apply -f https://raw.githubusercontent.com/kubernetes/ingress-nginx/master/deploy/static/mandatory.yaml Step 2: exposing the ingress as a service of type LoadBalancer (as a public IP) kubectl apply -f https://raw.githubusercontent.com/javiermugueta/rawcontent/master/cloud-generic.yaml Step 3: Execute this command several times until the external-ip appears as non <pending>, grab the IP … Continue reading Set Up an Ingress Controller in OKE Cluster