Tag: ORACLE CLOUD

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 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 →