I regularly work with my colleagues and customers based out in multiple time zones. Referencing time converter websites or doing…
Category Shell Scripts
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…
Being a DBA requires us many a times to step outside our role and solve a problem in a smart…
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…
Sometimes on a system it is important to know the maximum user processes does not increase so much that it…
A small shell script to check instance status of oracle database. $vi instanceup.sh #!/bin/sh SERVICE=’ora_pmon_orcl’ #replace ‘orcl’ with your sid…