List all crons and database links with scripts

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):

for fle in `ls /var/spool/cron/* | grep -v tmp`
    echo $fle ===============
    grep -v '^#' $fle
echo Root crons
for fle in `ls /etc/cron.d/*`
    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):

go () {
export ORACLE_SID=$1
sqlplus -s '/ as sysdba' <<e1
set pages 0 doc off lines 112 feed off
select lower('$ORACLE_SID '||owner||' '||host||' '||username||' '||db_link)
from dba_db_links
order by 1
go SID1
go SID2

Paste the output into excel, and then use ‘data’ > ‘text to columns’ to turn it into readable content that can be sorted and filtered.

February 14, 2012

Leave a Reply

Your email address will not be published. Required fields are marked *