You have essentially 2 options if you want to replicate data from on-premise Oracle database to Redshift : Option 1…
Category Database
Architecture: Source : DBCS on Classic 12.1 Enterprise Edition Target : OCI gen2 Autonomous Data Warehouse 19c Pre-Req:———1. Install and…
https://docs.cloud.oracle.com/iaas/Content/Compute/Tasks/managingkeypairs.htm https://docs.cloud.oracle.com/iaas/Content/Compute/Tasks/accessinginstance.htm Generate a local private and public keyfile on the client machine $ ssh-keygen -o $ cd .ssh/ $…
Create Oracle Autonomous Transaction Processing Database(ATP) in your Oracle Cloud Account. Create wallet and down the wallet to your bastion…
Amazon Web Services has been gaining popularity in the last few years since cloud computing has been in the spotlight.…
If you want to do migration of databases, the first and foremost thing is you must be able to connect…
1. Install Brew on your Mac http://osxdaily.com/2018/03/07/how-install-homebrew-mac-os/ 2. Install AWSCLI using Homebrew on Mac Make sure you have Python3 installed…
DynamoDB is one of the hidden gems of the NoSQL world. It is true serverless database. It is amazing that…
Oracle 19c is now available to use on Oracle Live SQL
One of my readers today send me an error they got while restoring a database via RMAN RMAN> startup mount;…
In my previous article we had fun with Shell Scripts by automating birthday alerts via email. Using the same logic…
Shell scripting is one of the most entertaining ways to learn programming. Shell scripting is infact a programming language in…
In my previous article I showed you how to use Letsencrypt to secure a production Apex instance. This is specially…
Download the client credentials from your Oracle Cloud account for your Autonomous Data Warehouse Instance. Make sure you note down…
Oracle has been an incumbent to the cloud space having lost a lot of ground to Amazon and Microsoft.But that…
— Replace duplicate values only in consecutive records with NULL [duplicate]– SELECT CASE WHEN lag(tran_id) over(order by NULL) = tran_id…
Linux Version : CentOS 7.5 Oracle Version : 18c (18.3.0.0) 1. Download the Zip file from Oracle Website and create…