SCP and Pass Variable in Bash Script

#!/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 ## SAMPLE USAGE ## # shadabs-MacBook-Pro:~ shadab$ ./scp_files.sh #Enter the Files to be Send to Remote Host: *.sh #scp_files.sh 100% 344 39.1KB/s 00:00 #scp_files_gone.sh 100% 344 52.3KB/s 00:00 # # #shadabs-MacBook-Pro:~ shadab$ ./scp_files.sh #Enter the … Continue reading SCP and Pass Variable in Bash Script

Multiple Homes and Instances Oracle Database Bash Profile

# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs export CATALINA_HOME=/home/oracle/apache-tomcat PATH=/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:$HOME/bin:/usr/bin/X11:/sbin:/bin/bash:$CATALINA_HOME/bin. export PATH EDITOR=vi export EDITOR=vi if [ -s "$MAIL" ] # This is at Shell startup. In normal then echo "$MAILMSG" # operation, the Shell checks fi # … Continue reading Multiple Homes and Instances Oracle Database Bash Profile

A Very Cool Oracle Bash Profile

# .bash_profile # Get the aliases and functions if [ -f ~/.bashrc ]; then . ~/.bashrc fi # User specific environment and startup programs PATH=$PATH:$HOME/.local/bin:$HOME/bin export PATH # Oracle Settings export TMP=/tmp export ORACLE_HOSTNAME=easyoradba.com export ORACLE_UNQNAME=ora12c export ORACLE_BASE=/u01/app/oracle export ORACLE_HOME=$ORACLE_BASE/product/12.2.0/dbhome_1 export ORACLE_SID=ora12c export CATALINA_HOME=/home/oracle/apache-tomcat PATH=/usr/sbin:$PATH:$ORACLE_HOME/bin:$CATALINA_HOME/bin export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; alias ob='cd $ORACLE_BASE' alias oh='cd $ORACLE_HOME' … Continue reading A Very Cool Oracle Bash Profile

Shell Script to Ping Hostnames and Send SMS if Host is not Available

We use the below procedure to ping hosts and based on availability send SMS to our team. The SMS is send by calling a web service from the BASH Shell script using curl  The hosts are defined in a file called hosts.txt -- Shell Script -- #!/bin/bash current_time=$(date "+%Y%m%d%H%M%S%3N") #### Above Date Format is in … Continue reading Shell Script to Ping Hostnames and Send SMS if Host is not Available

Shell Script to Add Date to Filenames

Below Shell Script will append Date to all FileNames in Directory with extension .TXT. Also it will create a folder with the Date and move the files to it. #!/bin/bash FILE="$(date +%Y%m%d)" cd /bi_dataload mkdir -p /bi_dataload/BI_$FILE for f in *.TXT do mv -n "$f" /bi_dataload/BI_$FILE/"${f%%.*}"_"$FILE".TXT done

Linux Matrix Effects Shell Script

Sometimes to have a funky time on the BASH shell you can run the below shell script [code language="bash"] #!/bin/bash clear virtcent=$((`tput lines`/2)) horcent=$((`tput cols`/2-10)) tput setf 6 tput cup $virtcent $horcent && echo "entering the matrix" sleep 1 tput cup $virtcent $horcent && echo " " sleep 1 tput cup $virtcent $horcent && echo … Continue reading Linux Matrix Effects Shell Script

Shell Script to Monitor Oracle Tablespace and Send Email Alert Only If Threshold Exceeds

[code language="bash"] export MMSG=/tmp/$$.mail export ADDR="email address here" export ORACLE_HOME=/u02/app/oracle/product/11.2.0/dbhome_1 export ORACLE_SID=appdev1 file=/tmp/${$}_`date +%Y%m%d` sqlplus -s system/password << .eof > $file set pages 0 select df.tablespace_name tspace, round(sum(fs.bytes)/(df.bytes) * 100) "%_free", round(sum(fs.bytes)/(1024*1024)) free_ts_size, df.bytes/(1024*1024) tot_ts_size from dba_free_space fs, (select tablespace_name, sum(bytes) bytes from dba_data_files group by tablespace_name ) df where fs.tablespace_name = df.tablespace_name group by … Continue reading Shell Script to Monitor Oracle Tablespace and Send Email Alert Only If Threshold Exceeds

Simple Shell Script to Check Diskspace and Send Email on AIX

The below simple shell script will check all filesystems and create output file for only filesystems which are more than 80% full and send the log by email. The below has been checked on AIX7.1 , not too Sure if it works on Solaris. I suppose the -P flag does not work on Solaris. [code language="bash"] … Continue reading Simple Shell Script to Check Diskspace and Send Email on AIX

Shell Script to Monitor AIX Filesystem and Send Email

The Below Shell Script checks the Filesystem mount points and using AWK outputs all filesystem exceeding 90% space to a file called diskspacepoll. Once that is done the sed command removes any special character like '%' from the output file and cleans it to a file called output.log The next important logic is in the … Continue reading Shell Script to Monitor AIX Filesystem and Send Email

How many cores is a process using in Linux

Script to check no. of cores being utilized by a process in linux. Save the script below as a shell script and execute: [root@~]#  sh check_cpu_cores.sh  1111 #!/bin/bash pids=() while [ $# != 0 ]; do pids=("${pids[@]}" "$1") shift done if [ -z "${pids[0]}" ]; then echo "Usage: $0 <pid1> [pid2] ..." exit 1 fi for … Continue reading How many cores is a process using in Linux