This Article first appeared in a Medium blog post Oracle Container Database (CDB) is a multi-tenant architecture that allows you…
Category Bash
After searching on the internet long and hard I couldn’t find a quick shell script to access Oracle Autonomous Database…
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 :…
#!/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…
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…
Sometimes to have a funky time on the BASH shell you can run the below shell script [code language=”bash”] #!/bin/bash…
export MMSG=/tmp/$$.mail export ADDR=”shadab@easyoradba.com” export ORACLE_HOME=/u01/app/oracle/product/12.1.0/dbhome_1 export ORACLE_SID=orcl file=/tmp/${$}_`date +%Y%m%d` sqlplus -s “/as sysdba” << .eof > $file set pages…
The below simple shell script will check all filesystems and create output file for only filesystems which are more than…
The Below Shell Script checks the Filesystem mount points and using AWK outputs all filesystem exceeding 90% space to a…
Script to check no. of cores being utilized by a process in linux. Save the script below as a shell…
So you are an Oracle DBA and have got used to the luxury of BASH shell in nix systems. Where…
For running a single SQL Command via sqlplus on multiple servers, we have to first do a few pre-requisites 1.…
Below is the Solaris user profiles for “grid” and “oracle” user. If you have followed Oracles official documentation for installation…