We use the below procedure to ping hosts and based on availability send SMS to our team. The SMS is…
Tag Email
The Below Script will generate output if percentage of tablespace space left free is less tan 20%. You can easily…
First Install UTL_MAIL ### To install UTL_MAIL: [code language=”sql”] sqlplus sys/**** @$ORACLE_HOME/rdbms/admin/utlmail.sql @$ORACLE_HOME/rdbms/admin/prvtmail.plb [/code] ### Create a Reporting User ###…
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…