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