I’m currently listing all interfaces – database links and cron jobs – into excel, and used these two scripts to automate the process.
Shell script to list all crons (note that this assumes crons in /etc/cron.d run as root):
01 | for fle in `ls /var/spool/cron/* | grep -v tmp` |
03 | echo $fle =============== |
07 | for fle in `ls /etc/cron.d/*` |
09 | grep -v '^#' $fle | sed -e 's/root//' |
And another shell script to check database links (here, change oracle_sid names at end to match names of your databases):
03 | sqlplus -s '/ as sysdba' <<e1 |
04 | set pages 0 doc off lines 112 feed off |
05 | select lower('$ORACLE_SID '||owner||' '||host||' '||username||' '||db_link) |
Paste the output into excel, and then use ‘data’ > ‘text to columns’ to turn it into readable content that can be sorted and filtered.
Leave a Reply