I regularly work with my colleagues and customers based out in multiple time zones. Referencing time converter websites or doing…
Category Database
In OCI-C ORDS and Apex is installed by default but in OCI to keep things lightweight ORDS and Apex is…
After searching on the internet long and hard I couldn’t find a quick shell script to access Oracle Autonomous Database…
Error : The request could not be mapped to any database. Check the request URL is correct, and that URL…
1. Create Customer Secret Key from OCI User settings. S3 compatibility key is now called “customer secret key” Link :…
— Go to Directory location for Statspack Install scripts on the VMDB host —cd /u01/app/oracle/product/12.2.0.1/dbhome_1/rdbms/admin — From cdb$root — sqlplus…
You have essentially 2 options if you want to replicate data from on-premise Oracle database to Redshift : Option 1…
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…