Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3


Following up the previous post, we are explaining today how to make same thing using Amazon S3. The procedure and steps are quite similar, let's go and try! Amazon side setup Create a S3 bucket with no public access: Upload datafile: Grab the object URL for later: Bucket located in Frankfurt Create a user in … Continue reading Offloading Oracle Data to Object Storage and Mounting as External Table in an Autonomous Database | Part Two: AWS S3

Deploying an Oracle Database with Persistence Enabled in Oracle Kubernetes Engine in Ten Minutes or Less


In a previous post I explained how to create the same thing using an image published in docker registry under my user. Well... that post is not working anymore because I deleted the image for some reasons. The method exposed here is better because the deployment file pulls the official image published here. Therefore you … Continue reading Deploying an Oracle Database with Persistence Enabled in Oracle Kubernetes Engine in Ten Minutes or Less

Microservices and SODA: JSON Data Stored in an Oracle Database Accessed through​ REST or Java


Simple Oracle Document Access SODA (Simple Oracle Document Access) is a non-SQL style of storing/retrieving JSON data in an Oracle database. It's so easy to work with SODA! Let's get started. First, enable ORDS schema in your database. Second, deploy ORDS in K8s (you can also deploy ORDS standalone in your laptop or in a container … Continue reading Microservices and SODA: JSON Data Stored in an Oracle Database Accessed through​ REST or Java

Setup ORDS in a PDB


ORDS utilizes several schemas for working properly. Follow these steps just in case your database hasn't been set up. NOTE: you need DBA privileges as well as 2 tablespaces created before proceeding, ask your dba or get this info before starting (although you can also manage it on the fly if you have a few … Continue reading Setup ORDS in a PDB

Deploy ORDS (Oracle Rest Data Services) to Kubernetes Cluster


ORDS is a piece of software that acts as an intermediary between Oracle Database and the layers where business logic is implemented and/or consumed. NOTE: If your database hasn't been set up for ORDS just google for it or take a look at this post. With ORDS you expose database objects as REST. ORDS can be … Continue reading Deploy ORDS (Oracle Rest Data Services) to Kubernetes Cluster

Deploying an Oracle Database with Persistence in Oracle Kubernetes Engine


UPDATE: Follow this post for the deployment part, as it has been updated, the rest of the content is still valid, thanks. Today we are deploying an Oracle database instance in a K8s cluster making them persistent so that data is not lost after container/pod restarts. Please follow this link to get the yaml file … Continue reading Deploying an Oracle Database with Persistence in Oracle Kubernetes Engine