Oracle Cloud Infrastructure (OCI) has an Internet Scale Storage called Oracle Cloud Infrastructure Object Storage Service. S3 is Amazon’s Cloud Scale Storage. OCI Object storage has Amazon S3 compatible API’s using which you can access your OCI Object Storage from any Tools or SDK’s which supports Amazon S3. This is quite a handy feature to have if you are building Apps which are Multi-cloud in nature.
The AWS Python SDK is called BOTO3. Boto3 can be used for multiple AWS Services but in this blog post we will focus on S3. …
Migrate an On-Premise Two-node Oracle RAC DB to Oracle Cloud Infrastructure RAC DB using OCI Database Migration Tools Community Image
In a previous post, we demonstrated how you can deploy a ZDM 21c Migration Tooling Instance as a Migration Hub from OCI Community Marketplace. In this blog post we will do an actual migration of a On-Premise RAC Database to Oracle Cloud Infrastructure (OCI) using the OCI Community Image which has ZDM 21c pre-installed.
ZDM 21c Supports 4 Types of Migration of Oracle Database :
2. Physical Offline using Backup Restore vis Object Storage
I have been using Amazon Route53 for the last few years as my Primary DNS service to manage my custom domain. I run most of my development instances and API Servers using that custom domain and manage the DNS with Route 53.
Last year I got my OCI Always Free resources and migrated most of my instances and databases to the Always free tier but I continued to use AWS DNS for my domain management. I was not brave enough to touch the DNS part of it and break my apps. While the services I was running were not a…
What is Sentiment Analysis ?
Sentiment analysis (SA) in the context of Data Science is analysis of text to define the customer sentiment on a topic or product. Broadly speaking sentiment analysis extracts information on Polarity (Feels Good/ No Thankyou/ Umm ok!) & Context — Subjectivity (Influenced by a personal opinion/feeling) or Objectivity (without being influenced by a personal opinion/feeling). Definition of ‘Sentiment Analysis’ according to the Data Science website towardsdatascience.com is as below :
“Sentiment analysis is contextual mining of text which identifies and extracts subjective information in source material, and helping a business to understand the social sentiment…
Oracle’s Autonomous Database recently scored highest in all four Use Cases in the 2020 Gartner “Critical Capabilities for Cloud Database Management Systems for Operational Use Cases” report. Oracle’s fully cloud native Autonomous Database comes in three flavours — Autonomous Transaction Processing (ATP), Autonomous Datawarehouse (ADW) & Autonomous JSON Database (AJD). With ATP being the database of choice for transactional OLTP like systems.
In this blog post we will test the Transaction Processing Autonomous instance using a PL/SQL loop of inserting 1 Billion rows by selecting records from ALL_OBJECTS table. Our test will be inserting about half a terabyte of transactional…
Oracle Autonomous Database now supports capturing of Data as Source using an Extract and applying it to another Autonomous Database in another region. Previously with Goldengate you could only replicate to an Autonomous Database as a target Database but with the recently released feature you can now capture transactions at Source and replicate it to another Autonomous Database. So Autonomous DB’s can now act as Upstream Databases.
This is useful in scenarios where you need to build Geographically distributed Apps using Autonomous database and Goldengate. …
Update : 29 April 2021
The Oracle Database Migration Tools Image is now available as a Community Marketplace Image with ZDM upgraded to Version 21c in following OCI regions
NORTH AMERICA :
US East — Ashburn
US West — Phoenix
Germany — Frankfurt
UK — London
Australia — Sydney
Australia — Melbourne
India West — Mumbai
SOUTH AMERICA :
Brazil — Sao Paolo
To deploy go to OCI Console > Create Compute Instance > Image & Shape, Change Shape > Select “Community Images” > App Name ‘Oracle Database Migration Tools Image : ZDM 21c +…
Principal Cloud Solutions Architect, Oracle Cloud Infrastructure