This Article first appeared in a Medium blog post Oracle Container Database (CDB) is a multi-tenant architecture that allows you…
Category Script
After searching on the internet long and hard I couldn’t find a quick shell script to access Oracle Autonomous Database…
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…
1. Install Brew on your Mac How to Install Homebrew on Mac 2. Install AWSCLI using Homebrew on Mac Make…
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…
$ ssh-add -k /home/oracle/wha.pem Error : Could not open a connection to your authentication agent To solve this issue :…
If you want to exclude certain filetypes from the directory when creating a tar archive use the –exclude parameter for…
In one of the largest software M&A ever, IBM has paid US$34 billion in cash to acquire the Enterprise opensource…
Linux Version : CentOS 7.5 Oracle Version : 18c (18.3.0.0) 1. Download the Zip file from Oracle Website and create…
#!/bin/bash read -p ‘Enter the Files to be Send to Remote Host: ‘ files destination_directory=’/home/oracle’ scp -i /Users/shadab/wha.pem $files oracle@192.168.1.200:$destination_directory…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…
# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific…
It is always good practice to lock down password based logins and SSH using keys. We can use pem files…
This error occurred in my environment when i tried to create a user in MySQL, most likely you have upgraded…
This error you would usually see when you login to phpMyAdmin after an upgrade. This is related to your MySQL…
Install Latest NodeJS on CentOS 6 or 7 ————————————– 1. Add Repo and Install NodeJS For Stable Release:- $ yum…
Upgrade from Exadata X4-2 11g (11.2.0.4) to Exadata X7-2 12CR1 (12.1.0.2.0) : ASM to ASM Oracle Database 11.2.0.3and 11.2.0.4 to…
Winexe – is a software on Linux which uses RPC to run remote commands and might even come with your…
1. Generate RPM list on Old Server rpm -qa –queryformat=’%{NAME}\n’ | sort > serverold.txt 2. Generate RPM list on New…
We use the below procedure to ping hosts and based on availability send SMS to our team. The SMS is…
Below Shell Script will append Date to all FileNames in Directory with extension .TXT. Also it will create a folder…
Being a DBA requires us many a times to step outside our role and solve a problem in a smart…