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

Near Real Time Data Driven SaaS Integration with Streaming | Part 1: Overview


File based approaches File-based data exchange comfort a large percentage of the integrations between SaaS and other ERP solutions in the past and today. The approach is robust and allows a large number of transactions to be executed in batch without affecting the online systems, but it has an inconvenience: the information is not updated … Continue reading Near Real Time Data Driven SaaS Integration with Streaming | Part 1: Overview

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

Deploying a Coherence Cluster in Kubernetes


Coherence-Operator is a Kubernetes opeartor for deploying Oracle Coherence in k8s. Let's see how to do it. 1 Clean previous setup intents: helm del --purge sample-coherence helm del --purge sample-coherence-operator kubectl delete namespace sample-coherence-ns 2 Execute the following: kubectl config set-context $(kubectl config current-context) --namespace=sample-coherence-ns helm repo add coherence https://oracle.github.io/coherence-operator/charts helm repo update helm --debug … Continue reading Deploying a Coherence Cluster in Kubernetes

BucketNotEmpty – Bucket named ‘xxxx’ is not empty. Delete all objects first


Oracle OCI object storage "buckets" can't be deleted from OCI dashboard unless they are empty... and no empty option menu exists at all (at least at the time of this post). Anyway, you can do it using the CLI... Follow these steps: If you don't have OCI CLI installed follow this post oci os object … Continue reading BucketNotEmpty – Bucket named ‘xxxx’ is not empty. Delete all objects first